1,140 rows sorted by level

View and edit SQL

Suggested facets: level, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_loviisa, unit_count_municipality_kotka, unit_count_municipality_mäntsälä, unit_count_municipality_hyvinkää, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava, unit_count_municipality_karkkila, last_modified_time (date)

id children name_fi name_sv name_en service_reference last_modified_time level ▼ parent keywords related_services period_enabled root unit_count_municipality_helsinki unit_count_total unit_count_municipality_hanko unit_count_municipality_raasepori unit_count_municipality_siuntio unit_count_municipality_sipoo unit_count_municipality_janakkala unit_count_municipality_nurmijärvi unit_count_municipality_salo unit_count_municipality_virolahti unit_count_municipality_pornainen unit_count_municipality_hämeenlinna unit_count_municipality__unknown unit_count_municipality_lapinjärvi unit_count_municipality_inkoo unit_count_municipality_miehikkälä unit_count_municipality_porvoo unit_count_municipality_lohja unit_count_municipality_tuusula unit_count_municipality_kirkkonummi unit_count_municipality_hamina unit_count_municipality_kouvola unit_count_municipality_loviisa unit_count_municipality_espoo unit_count_municipality_askola unit_count_municipality_kotka unit_count_municipality_mäntsälä unit_count_municipality_vantaa unit_count_municipality_hyvinkää unit_count_municipality_vihti unit_count_municipality_kauniainen unit_count_municipality_järvenpää unit_count_municipality_kerava unit_count_municipality_karkkila unit_count_municipality_pyhtää
783 [866, 861, 810, 797, 787, 845, 791, 2189, 830, 784, 860, 839, 798, 819, 859] Perhe- ja sosiaalipalvelut Familje- och socialservice Family and social services   2018-08-07T14:00:27.699133+03:00 0   {} 0 783 397 718       2             1         1           129       175 1   7   5    
986 [990, 1048, 995, 996, 997, 1028, 1042, 1017, 992, 1019, 999, 1004, 1043, 1041, 1051, 1000, 1039, 1018, 1009, 1044, 988, 998, 993, 991, 2190, 1060, 994] Terveys Hälsovård Health care   2018-08-07T14:00:29.110723+03:00 0   {} 0 986 556 949 1 4 1 2   4   1 1   3   1 1 5 9 4 4 2 8 2 122 1 6 2 183 5 2 12 2 2 2 1
1061 [1062, 1065, 1066, 1070, 1076, 1078, 1079, 1080, 1082, 1083] Turvallisuus Säkerhet Public safety   2018-08-07T14:00:29.767356+03:00 0   {} 0 1061 130 163                                           17       13     3        
1087 [2042, 1335, 2179, 1356, 1088, 1382, 1378, 1376, 1257, 1334, 1377, 1372, 1353, 1097, 1360, 1359] Opetus ja koulutus Undervisning och utbildning Teaching and education   2018-08-07T14:00:25.275863+03:00 0   {} 0 1087 1214 1867       1                       2           274       362 2   11   1    
1400 [2, 1, 14, 24, 31, 221, 85] Asuminen ja kaupunkiympäristö Boende och stadsmiljö Housing and urban environment   2018-08-07T14:00:21.224786+03:00 0   {} 0 1400 2311 4077       17 1 23 1     1 4 1     30   53 43       737     3 698 35 10 31 37 41    
1401 [122, 171, 755] Työ, talous ja hallinto Arbete, ekonomi och förvaltning Employment and public authorities   2020-03-06T18:32:09.344909+02:00 0   {} 0 1401 448 629       2 1         1 2 1     2     3       88       74     6   1    
1402 [306, 512] Liikenne ja kartat Trafik och kartor Traffic and maps   2018-08-07T14:00:24.647447+03:00 0   {} 0 1402 1567 2238 1     4             1   2   1     2       581       71     8        
1403 [343, 551, 717, 365] Kulttuuri, liikunta ja vapaa-aika Kultur, motion och fritid Culture, sports and leisure   2018-08-07T14:00:22.534057+03:00 0   {} 0 1403 5769 8871 1     18 1 1       1 12 1 20   3 1 6 14       1685     1 1238 1 37 57 4      
1405 [2118, 868, 2163] Päivähoito ja esiopetus Barndagvård och förskola Daycare and pre-primary education   2020-03-06T18:32:08.672148+02:00 0   {} 0 1405 951 1546                                           367       216     12        
1 [28, 57, 58, 59, 60, 74, 80, 73, 94, 95, 101, 97, 100, 102, 103, 115, 116] Asumisympäristö Boendemiljön Housing environment   2018-08-07T14:00:21.308151+03:00 1 1400 {} 0 1400 1002 1524                     2           2         294       218     6        
2 [3, 4, 5, 7, 2191, 8] Asuminen Boende Housing   2018-08-07T14:00:21.231002+03:00 1 1400 {} 0 1400 742 1530       16   23 1       1       27   51 40       246     3 256 35 10 1 37 41    
14 [16, 23] Eläimet Djur Animals   2018-08-07T14:00:21.679608+03:00 1 1400 {} 0 1400 103 150                                           22       25              
24 [25, 26, 27] Energia Energi Energy   2018-08-07T14:00:21.738244+03:00 1 1400 {} 0 1400 6 7                                                   1              
31 [32, 33, 34, 52, 53, 54] Jätehuolto ja kierrätys Avfallshantering och återvinning Waste management and recycling   2018-08-07T14:00:21.761620+03:00 1 1400 {} 0 1400 215 572                                   1       150       186     20        
85 [87, 88, 91, 93] Vesihuolto Vattenförsörjning Water services   2018-08-07T14:00:21.953530+03:00 1 1400 {} 0 1400 30 32                             1             1                      
122 [123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167] Elinkeino, työ ja verotus Näringar, arbete och beskattning Entrepreneurship, work and taxation   2018-08-07T14:00:29.995212+03:00 1 1401 {} 0 1401 322 452       2 1         1 2 1     2     2       51       62     5   1    
171 [2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219] Hallinto ja talous Förvaltning och ekonomi Administration and economy   2018-08-07T14:00:30.363012+03:00 1 1401 {} 0 1401 124 163       1                           1       17       17     2   1    
221 [222, 231, 270, 305] Kaavoitus, kiinteistöt ja rakentaminen Planläggning, fastigheter och byggande Planning, real estate and construction   2018-08-07T14:00:21.996119+03:00 1 1400 {} 0 1400 367 506       1 1         1 1 1     3     2       54       69     6        
306 [307, 314, 320, 324, 329, 342] Kartat, tietopalvelut ja viestintä Kartor, informationstjänster och kommunikation Maps, information services and communication   2018-08-07T14:00:24.652419+03:00 1 1402 {} 0 1402 307 389                     1                     42       36     3        
343 [344, 345, 350, 351, 352, 361, 362, 491, 504, 505, 2006, 503] Kulttuuri ja vapaa-aika Kultur och fritid Culture and leisure   2018-08-07T14:00:22.539281+03:00 1 1403 {} 0 1403 1745 2452       1 1 1       1 8 1     2   4 2       382       286 1   13 4      
365 [2162, 2156, 368, 367, 366, 490] Nuoriso Ungdom Youth   2018-08-07T14:00:22.862181+03:00 1 1403 {} 0 1403 82 146 1     1                                   30       29     3        
512 [513, 521, 525, 526, 533, 534, 541] Liikenne Trafik Traffic   2018-08-07T14:00:24.996122+03:00 1 1402 {} 0 1402 1269 1864 1     4                 2   1     2       540       39     6        
551 [552, 2151, 558, 2217, 601, 633, 666, 684, 694] Liikunta Idrott och motion Sports and physical exercise   2018-08-07T14:00:23.220207+03:00 1 1403 {} 0 1403 2590 4872       16             3   19     1 1 11       1260     1 892   36 42        
717 [754, 718, 2173, 2028] Matkailu ja tapahtumat Turism och evenemang Things to do   2020-03-06T18:32:07.102459+02:00 1 1403 {} 0 1403 1973 2155       1 1 1       1 2 1 1   3   5 3       87       67 1 1 3 4      
755 [756, 768, 769] Oikeusturva ja demokratia Rättsskydd och demokrati Justice system and democracy   2020-03-06T18:32:09.608464+02:00 1 1401 {} 0 1401 15 46                                           28       2     1        
784 [786, 785] Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta Rådgivning om social- och hälsovårdstjänster och för äldre Information and advice of social and health services and for elderly people   2018-08-07T14:00:27.703824+03:00 1 783 {} 0 783 1 13                     1                     3       8              
787 [789, 790, 788] Lastensuojelu Barnskydd Child welfare   2018-10-25T08:00:09.006369+03:00 1 783 {} 0 783 37 81                               1           17       24 1   1        
791 [794, 795, 792, 793, 796] Muut perheiden palvelut Övriga tjänster för familjer Other family services   2018-08-07T14:00:27.754089+03:00 1 783 {} 0 783 16 40                                           4       18     2        
797 [] Lapsiperheen tuet Förmåner för barnfamiljer Benefits for families with children 370 2020-08-20T14:00:09.399199+03:00 1 783 {} 0 783 3 9       1                                   2       2         1    
798 [805, 803, 807, 808, 806, 802, 801, 799, 800, 804, 809] Vammaispalvelut Handikapptjänster Services for the disabled   2018-08-07T14:00:27.804536+03:00 1 783 {} 0 783 14 59       2                                   7       34     1   1    
810 [815, 816, 817, 813, 812, 811, 818, 814, 1007] Kehitysvammahuolto Vård av utvecklingsstörda Care for the developmentally disabled   2018-08-07T14:00:27.882619+03:00 1 783 {} 0 783 56 109                                           12       36     2   3    
819 [829, 827, 821, 820, 828, 824, 826, 825, 823, 822] Vanhuspalvelu Äldreomsorg Service for the elderly   2018-08-07T14:00:27.946229+03:00 1 783 {} 0 783 142 261       1                                   67       44     6   1    
830 [836, 837, 834, 833, 835, 832, 831, 838, 2157] Päihdepalvelut Service för missbrukare Services for substance abusers   2018-08-07T14:00:28.016024+03:00 1 783 {} 0 783 29 56                                           12       14     1        
839 [2011, 841, 843, 2012] Toimeentulotuki Utkomststöd Social assistance   2018-08-07T14:00:28.080690+03:00 1 783 {} 0 783 11 20       1                                   3       3     1   1    
845 [848, 846, 847, 851, 857, 2160, 849, 852, 853, 854, 856, 858, 850, 855] Muu sosiaalihuolto Övrig socialvård Other social welfare   2018-08-07T14:00:28.112184+03:00 1 783 {} 0 783 105 239       1                                   11       118     3   1    
859 [] Yhteiset tukipalvelut Gemensamma stödtjänster Shared support services 639 2018-08-07T14:00:28.209104+03:00 1 783 {} 0 783   3                                                   2     1        
860 [] Sosiaali- ja terveyspalvelujen turvapalvelut (asumisen tuki) Stödtjänster inom social- och hälsovården (stöd för boende) Social and health care services' security services (housing support) 636 2018-08-07T14:00:28.215634+03:00 1 783 {} 0 783 1 2                                                   1              
861 [] Hoitoalan ruokapalvelut Mattjänster inom vårdbranschen Meal services in the care sector 196 2018-08-07T14:00:28.222009+03:00 1 783 {} 0 783 12 12                                                                  
866 [] Hallinto Förvaltning Administration 180 2018-08-07T14:00:28.228192+03:00 1 783 {} 0 783   1                                                   1              
868 [2029, 975, 961, 985, 869, 983] Lasten päivähoito Barndagvård Day care   2020-03-06T18:32:08.678128+02:00 1 1405 {} 0 1405 675 1264                                           365       212     12        
988 [2146, 989] Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta Rådgivning om social- och hälsovårdstjänster och för äldre Information and advice of social and health services and for elderly people   2018-08-07T14:00:29.124487+03:00 1 986 {} 0 986 1 13                     1                     3       8              
990 [] Apteekki Apotek Pharmacy 57 2018-08-07T14:00:29.143841+03:00 1 986 {} 0 986 1 8                                                   7              
991 [] Terveysasemat Hälsostationer Health stations 703 2018-08-07T14:00:29.153043+03:00 1 986 {"fi": ["mielenterveys", "terveysasemat"]} 0 986 25 49                                           12       11     1        
992 [] Lääkärin vastaanotto Läkarmottagning Doctor's reception 417 2018-08-07T14:00:29.162295+03:00 1 986 {"fi": ["mielenterveys", "terveysasemat"]} 0 986 26 50                                           11       12     1        
993 [] Terveydenhoitajan vastaanotto Hälsovårdarens mottagning Nurse's reception 702 2018-08-07T14:00:29.169309+03:00 1 986 {} 0 986 26 50                                           11       12     1        
994 [] Työterveyshuolto Företagshälsovård Occupational health care 726 2018-08-07T14:00:29.175755+03:00 1 986 {} 0 986 1 2                                           1                      
995 [] Hammashoito Tandvård Dental care 184 2020-03-06T18:32:09.101816+02:00 1 986 {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto", "hammashoitola"]} 0 986 36 98                                           20       41     1        
996 [] Kotihoito Hemvård Home care 635 2020-03-06T18:32:09.105708+02:00 1 986 {} 0 986 69 95                                           19       4     3        
997 [2164, 2166] Koulu- ja opiskeluterveydenhuolto Skol- och studenthälsovård School and student health services   2018-10-25T08:00:09.578039+03:00 1 986 {} 0 986 241 320                               1           2       68 1   7        
998 [] Tartuntaudit Smittsamma sjukdomar Infectious diseases 693 2018-08-07T14:00:29.221985+03:00 1 986 {"fi": ["tartuntatauti", "tartuntataudit"]} 0 986 1 3                                                   2              
999 [] Myrkytystietoa Giftinformation Poison information 461 2018-08-07T14:00:29.228018+03:00 1 986 {} 0 986   1                     1                                            
1000 [1001, 1002, 1003] Päivystys Jour Emergency services   2018-08-07T14:00:29.234256+03:00 1 986 {} 0 986   6                                           4       1     1        
1004 [1005, 1006, 1008] Neuvolat Rådgivningar Maternity and child health guidance 463 2018-08-07T14:00:29.268764+03:00 1 986 {} 0 986 23 53                                           19       10     1        
1009 [1011, 1012, 1013, 2161, 1014, 1015, 1016, 1010] Sairaalat Sjukhus Hospitals   2018-08-07T14:00:29.308401+03:00 1 986 {} 0 986 35 52                             1 1           6   2   5 2            
1017 [] Laboratorio Laboratorium Laboratory 366 2018-08-07T14:00:29.386729+03:00 1 986 {} 0 986 22 88   3 1 1   3   1 1       1 1 2 6 3 3 1 7 1 10 1 3 1 8 1 1 2 1 1 1 1
1018 [] Röntgen Röntgen X-rays 606 2018-08-07T14:00:29.396972+03:00 1 986 {} 0 986 11 42 1 1   1   1                 2 1 1 1 1 1 1 6   1 1 6 1 1   1 1 1  
1019 [1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027] Mielenterveyspalvelut Psykiatriska tjänster Mental health care   2018-08-07T14:00:29.405061+03:00 1 986 {} 0 986 29 36                                           2       5              
1028 [1029, 1031, 1040, 1032, 1033, 1034, 1035, 1036, 1037, 1038] Kuntoutus Rehabilitering Rehabilitation   2018-08-07T14:00:29.478107+03:00 1 986 {} 0 986 33 67                                           16       16     2        
1039 [] Ravitsemusterapia Näringsterapi Nutrition therapy 579 2018-08-07T14:00:29.591225+03:00 1 986 {} 0 986   1                                                   1              
1041 [] Psykologitoiminta Psykologverksamhet Psychologists 525 2018-08-07T14:00:29.598972+03:00 1 986 {} 0 986 4 10                                           1       4     1        
1042 [] Kuulontutkimus Hörseltester Hearing tests 357 2018-08-07T14:00:29.607627+03:00 1 986 {} 0 986   1                                                   1              
1043 [] Omahoitotarvikejakelu Utdelning av egenvårdsartiklar Distribution of self-care supplies 477 2018-08-07T14:00:29.623935+03:00 1 986 {"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]} 0 986 1 6                                                   3     2        
1044 [] Silmätaudit Ögonsjukdomar Eye diseases 622 2018-08-07T14:00:29.630771+03:00 1 986 {} 0 986 1 2                                                   1              
1048 [1050] Hallintopalvelut Förvaltningstjänster Patient representative services   2020-03-06T18:32:09.249350+02:00 1 986 {} 0 986   1                                                   1              
1051 [1057, 1058, 1055, 1054, 1056, 1053, 1052, 1059, 2158] Päihdepalvelut Service för missbrukare Services for substance abusers   2018-08-07T14:00:29.682313+03:00 1 986 {} 0 986 29 56                                           12       14     1        
1060 [] Terveyspalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter inom hälso- och sjukvården Electronic services and forms related to health services 704 2018-08-07T14:00:29.759443+03:00 1 986 {} 0 986   2                     1                             1              
1062 [1063, 1064] Maanpuolustus Försvaret National defence   2018-08-07T14:00:29.774255+03:00 1 1061 {} 0 1061 8 9                                           1                      
1065 [] Meripelastus Sjöräddningen Sea rescue 435 2018-08-07T14:00:29.800283+03:00 1 1061 {} 0 1061 1 1                                                                  
1066 [1069, 1068, 1067] Muut turvallisuuspalvelut Andra säkerhetstjänster Other safety services   2018-08-07T14:00:29.808816+03:00 1 1061 {} 0 1061 3 5                                           1       1              
1070 [1071, 1072, 1073, 1074, 1075] Pelastustoimi Räddningsväsendet Rescue services   2018-08-07T14:00:29.845529+03:00 1 1061 {} 0 1061 26 46                                           13       6     1        
1076 [1077] Poliisi Polisen Police   2018-08-07T14:00:29.888769+03:00 1 1061 {} 0 1061 1 6                                           1       4              
1078 [] Rajavartiolaitos Gränsbevakningsväsendet Border guard 557 2018-08-07T14:00:29.900790+03:00 1 1061 {} 0 1061 1 1                                                                  
1079 [] Säteilyturva Strålsäkerhet Radiation and nuclear safety 671 2018-08-07T14:00:29.907687+03:00 1 1061 {} 0 1061 1 1                                                                  
1080 [1081] Tulli Tullen Customs   2018-08-07T14:00:29.915254+03:00 1 1061 {} 0 1061 4 7                                           1       2              
1082 [] Väestöhälyttimet Befolkningslarm Public alarm systems 805 2018-08-07T14:00:29.929327+03:00 1 1061 {} 0 1061 38 38                                                                  
1083 [1084, 1086] Väestönsuojat Befolkningsskyddsrum Public shelters   2018-08-07T14:00:29.937480+03:00 1 1061 {} 0 1061 47 49                                                         2        
1088 [1093, 1089] Esiopetus Förskola Pre-primary education   2018-08-07T14:00:25.281111+03:00 1 1087 {} 0 1087 320 530                                           89       121              
1097 [1187, 1255, 1098] Perusopetus Grundläggande utbildning Basic education   2018-08-07T14:00:25.451107+03:00 1 1087 {} 0 1087 414 568                               1           97       55 1            
1257 [1298, 1258] Lukiokoulutus Gymnasier General upper secondary education   2018-08-07T14:00:26.772637+03:00 1 1087 {} 0 1087 37 62                                           16       9              
1334 [] Nuorten työpajatoiminta Ungdomsverkstäder Workshops for the young 472 2018-08-07T14:00:27.336955+03:00 1 1087 {} 1 1087 9 17                                                   8              
1335 [1343, 1336] Aikuiskoulutus Vuxenutbildning Adult education   2018-08-07T14:00:27.345252+03:00 1 1087 {} 0 1087 5 11                                           2       3     1        
1353 [1355, 1354] Oppisopimuskoulutus Läroavtalsutbildning Apprenticeship training   2018-08-07T14:00:27.464000+03:00 1 1087 {} 0 1087 1 2                                                   1              
1356 [1357] Ammattikorkeakoulut Yrkeshögskolor Polytechnics 654 2018-08-07T14:00:27.483584+03:00 1 1087 {} 0 1087 1 2                                                         1        
1359 [] Yliopistot Universitet Universities 822 2018-08-07T14:00:27.510881+03:00 1 1087 {} 0 1087 10 60                                           50                      
1360 [2212, 1371, 1369, 1370, 1365, 1361] Vapaa sivistystyö Fritt bildningsarbete General educational work   2020-11-18T07:30:12.838195+02:00 1 1087 {} 0 1087 56 97                                           9       28     4        
1372 [1373, 1374, 1375] Oppilas- ja opiskelijahuolto Elevvård Pupil and student care   2018-08-07T14:00:27.603403+03:00 1 1087 {} 0 1087 241 388                               1           2       136 1   7        
1376 [] Koulu- ja opiskelijaruokailu Måltider för elever och studerande Meals for pupils and students 338 2020-08-20T14:00:09.319013+03:00 1 1087 {} 0 1087 119 136                                           12       4     1        
1377 [] Oppilaan ja opiskelijan tuet Förmåner för elever och studerande Pupil and student benefits 485 2018-08-07T14:00:27.654181+03:00 1 1087 {} 0 1087 4 15       1                                   7       2         1    
1378 [1381, 2080, 1380, 1379] Kasvatuksen ja koulutuksen neuvonta Rådgivning om fostran och utbildning Day care and education information and advice   2018-08-07T14:00:27.660874+03:00 1 1087 {} 0 1087 4 6                                           2                      
1382 [] Hallinto Förvaltning Administration 179 2018-08-07T14:00:27.693663+03:00 1 1087 {} 0 1087 12 12                                                                  
2042 [2056, 2049] Aamu- ja iltapäivätoiminta Morgon- och eftermiddagsverksamhet Morning and afternoon activities   2018-08-07T14:00:25.343707+03:00 1 1087 {} 0 1087 208 223                                           11       4              
2118 [2126, 2122] Esiopetus Förskola Pre-primary education   2018-08-07T14:00:29.045629+03:00 1 1405 {} 0 1405 320 530                                           89       121              
2163 [] Päiväkotiruokailu Daghem måltider Day care centre meals 860 2018-08-07T14:00:29.039470+03:00 1 1405 {} 0 1405 274 274                                                                  
2179 [2186, 2200, 2181, 2180] Ammatillinen koulutus Yrkesutbildning Vocational education   2018-08-31T16:00:09.179533+03:00 1 1087 {} 0 1087 18 24                                           2       4              
2189 [] Perhekeskukset Familjecentren Family centres 875 2019-02-12T15:30:09.896427+02:00 1 783 {} 0 783 3 3                                                                  
2190 [] Terveys- ja hyvinvointikeskukset Centraler för hälsa och välbefinnande Health and well-being centres 876 2019-02-12T15:30:10.708910+02:00 1 986 {} 0 986 2 11                                           1       8              
3 [] Asumisen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för boendeärenden Electronic housing services and forms 74 2018-08-07T14:00:21.236014+03:00 2 2 {} 0 1400   1                     1                                            
4 [] Asumisen tuet Bostadsbidrag Housing allowances 75 2018-08-07T14:00:21.243003+03:00 2 2 {} 0 1400 3 9       1                                   2       2         1    
5 [6] Asumisoikeusasuminen Bostadsrättsbostäder Right-of-occupancy housing 76 2018-08-07T14:00:21.249052+03:00 2 2 {} 0 1400 331 1108       15   23 1               27   51 40       242     3 253 35 10   37 40    
7 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:21.261214+03:00 2 2 {} 0 1400 1 3                                           1       1              

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [service_node] (
   [id] INTEGER PRIMARY KEY,
   [children] TEXT,
   [name_fi] TEXT,
   [name_sv] TEXT,
   [name_en] TEXT,
   [service_reference] TEXT,
   [last_modified_time] TEXT,
   [level] INTEGER,
   [parent] INTEGER,
   [keywords] TEXT,
   [related_services] TEXT,
   [period_enabled] INTEGER,
   [root] INTEGER,
   [unit_count_municipality_helsinki] INTEGER,
   [unit_count_total] INTEGER,
   [unit_count_municipality_hanko] TEXT,
   [unit_count_municipality_raasepori] TEXT,
   [unit_count_municipality_siuntio] TEXT,
   [unit_count_municipality_sipoo] TEXT,
   [unit_count_municipality_janakkala] TEXT,
   [unit_count_municipality_nurmijärvi] TEXT,
   [unit_count_municipality_salo] TEXT,
   [unit_count_municipality_virolahti] TEXT,
   [unit_count_municipality_pornainen] TEXT,
   [unit_count_municipality_hämeenlinna] TEXT,
   [unit_count_municipality__unknown] TEXT,
   [unit_count_municipality_lapinjärvi] TEXT,
   [unit_count_municipality_inkoo] TEXT,
   [unit_count_municipality_miehikkälä] TEXT,
   [unit_count_municipality_porvoo] TEXT,
   [unit_count_municipality_lohja] INTEGER,
   [unit_count_municipality_tuusula] TEXT,
   [unit_count_municipality_kirkkonummi] TEXT,
   [unit_count_municipality_hamina] TEXT,
   [unit_count_municipality_kouvola] TEXT,
   [unit_count_municipality_loviisa] TEXT,
   [unit_count_municipality_espoo] INTEGER,
   [unit_count_municipality_askola] TEXT,
   [unit_count_municipality_kotka] TEXT,
   [unit_count_municipality_mäntsälä] TEXT,
   [unit_count_municipality_vantaa] INTEGER,
   [unit_count_municipality_hyvinkää] INTEGER,
   [unit_count_municipality_vihti] TEXT,
   [unit_count_municipality_kauniainen] TEXT,
   [unit_count_municipality_järvenpää] TEXT,
   [unit_count_municipality_kerava] TEXT,
   [unit_count_municipality_karkkila] TEXT,
   [unit_count_municipality_pyhtää] TEXT
);