Kita facilities Hamburg

Two files are generated daily: 1. Kita_Facilities.csv 2. Kita_Facilities_Performance.csv The file Kita_Einrichtung.csv provides exactly one line with information for each daycare center and is sorted ascendingly according to the first column KITAEinrichtung_EinrNr. The file Kita_Einrichtung_Leistung.csv contains all services offered by the daycare centres and is also sorted ascendingly according to the first column KITAEinrichtung_EinrNr. format The files have been created under the UTF-8 codepage. The end of the line is marked with Carriage Return + Line Feed. The columns are separated by the separator ^ (=hat). Data structure The first line of the files is optimized with the content sep=^ for editing with the program Microsoft Excel. If Excel is not used, this line should be ignored. However, Excel considers all csv files as ANSI-encoded and does not automatically convert to UTF-8, so that, for example, the umlauts are not displayed correctly. Therefore, the use of the excel-internal text conversion wizard is explicitly recommended at this point for the import of the data to Excel, since all necessary settings for an error-free import can be made there. The second line of the files contains the column headings. From the third line to the end of the file, the exported records of the nursery database are located. Column definition of the Kita_Setup.csv file 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. Column definition of the Kita_Setup_Performance.csv file 1. 2.