service_node
1,140 rows sorted by unit_count_municipality_espoo descending
This data as json, CSV (advanced)
Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||
633 | [634, 639, 646, 654, 663] | Ulkokentät ja liikuntapuistot | Utomhusplaner och idrottsparker | Outdoor fields and sports parks | 2018-08-07T14:00:23.790680+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 1261 | 2383 | 1 | 1 | 636 | 457 | 4 | 23 | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
526 | [527, 528, 2207, 529, 530, 2204, 532] | Pysäköinti | Parkering | Parking | 2018-08-07T14:00:25.093849+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 559 | 1023 | 460 | 2 | 2 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
532 | [] | Yleiset pysäköintialueet | Allmänna parkeringsområden | Public parking lot | 814 | 2018-08-07T14:00:25.132843+03:00 | 3 | 526 | {} | [814] | 0 | 1402 | 1 | 346 | 343 | 2 | |||||||||||||||||||||||||||||||
869 | [897, 905, 913, 921, 929, 881, 889, 937, 870, 945, 2238, 953] | Päiväkotihoito | Daghemsvård | Day care centres | 2018-08-07T14:00:28.258090+03:00 | 2 | 868 | {} | [] | 0 | 1405 | 497 | 1020 | 329 | 184 | 10 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
654 | [655, 656, 657, 658, 659, 660, 661, 662] | Pallokentät | Bollplaner | Ball games courts | 2018-08-07T14:00:23.947305+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 697 | 1266 | 1 | 283 | 273 | 1 | 11 | |||||||||||||||||||||||||||||
601 | [602, 606, 608, 614, 624] | Sisäliikuntatilat | Anläggningar för inomhusidrott | Indoor sports facilities | 2018-08-07T14:00:23.557871+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 795 | 1314 | 278 | 229 | 12 | |||||||||||||||||||||||||||||||
870 | [875, 879, 872, 877, 876, 880, 871, 874] | Suomenkielinen päivähoito | Finskspråkig dagvård | Day care in Finnish | 663 | 2019-03-05T14:30:09.339119+02:00 | 3 | 869 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [663] | 0 | 1405 | 389 | 847 | 278 | 174 | 6 | ||||||||||||||||||||||||||||||
871 | [] | päivähoito | dagvård | day care | 663 | 2019-03-05T14:30:09.346786+02:00 | 4 | 870 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [663] | 0 | 1405 | 389 | 845 | 277 | 173 | 6 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
60 | [61, 62, 68, 2236, 71, 72] | Puistot ja viheralueet | Parker och grönområden | Parks and green areas | 2018-08-07T14:00:21.354530+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 520 | 967 | 1 | 268 | 173 | 5 | ||||||||||||||||||||||||||||||
491 | [492, 493, 499, 2237, 502, 2235] | Puistot ja viheralueet | Parker och grönområden | Parks and green areas | 2018-08-07T14:00:22.684763+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 520 | 967 | 1 | 268 | 173 | 5 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||
5 | [6] | Asumisoikeusasuminen | Bostadsrättsbostäder | Right-of-occupancy housing | 76 | 2018-08-07T14:00:21.249052+03:00 | 2 | 2 | {} | [76] | 0 | 1400 | 331 | 1108 | 15 | 23 | 1 | 27 | 51 | 40 | 242 | 3 | 253 | 35 | 10 | 37 | 40 | ||||||||||||||||||||
68 | [70, 69] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:21.413441+03:00 | 3 | 60 | {} | [] | 0 | 1400 | 293 | 647 | 201 | 148 | 5 | |||||||||||||||||||||||||||||||
499 | [501, 500] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:22.748801+03:00 | 3 | 491 | {} | [] | 0 | 1403 | 293 | 647 | 201 | 148 | 5 | |||||||||||||||||||||||||||||||
646 | [578, 647, 648, 649, 650, 651, 652, 653] | Lähiliikunta ja liikuntapuistot | Närmotion och idrottsparker | Neighbourhood sports facilities and parks | 2018-08-07T14:00:23.877348+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 345 | 650 | 1 | 196 | 95 | 3 | 10 | |||||||||||||||||||||||||||||
70 | [] | Leikkipaikat (ei ohjattua toimintaa) | Lekplatser (ingen handledd verksamhet) | Play areas (no supervised activities) | 389 | 2018-08-07T14:00:21.425954+03:00 | 4 | 68 | {} | [389] | 0 | 1400 | 224 | 567 | 193 | 145 | 5 | ||||||||||||||||||||||||||||||
501 | [] | Leikkipaikat (ei ohjattua toimintaa) | Lekplatser (ingen handledd verksamhet) | Play areas (no supervised activities) | 389 | 2018-08-07T14:00:22.761746+03:00 | 4 | 499 | {} | [389] | 0 | 1403 | 224 | 567 | 193 | 145 | 5 | ||||||||||||||||||||||||||||||
608 | [609, 610, 611, 612, 613] | Kuntoilukeskukset ja liikuntasalit | Konditionsidrottscentra och idrottssalar | Fitness centres and sports halls | 2018-08-07T14:00:23.602837+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 576 | 949 | 188 | 177 | 8 | |||||||||||||||||||||||||||||||
659 | [] | Pallokenttä | Bollplan | Ball field | 495 | 2018-08-07T14:00:23.987386+03:00 | 4 | 654 | {} | [495] | 0 | 1403 | 408 | 743 | 169 | 161 | 5 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
34 | [35, 36, 37, 38, 2211, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51] | Keräyspisteet | Insamlingsplatser | Collection points | 2018-08-07T14:00:21.780177+03:00 | 2 | 31 | {} | [] | 0 | 1400 | 210 | 565 | 150 | 185 | 20 | |||||||||||||||||||||||||||||||
694 | [695, 706] | Virkistyskohteet ja palvelut | Rekreationsanläggningar och tjänster | Recreational destinations and services | 2018-08-07T14:00:24.231367+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 235 | 442 | 11 | 1 | 13 | 11 | 143 | 1 | 7 | 19 | 1 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
45 | [] | Paperinkeräys | Insamling av papper | Paper recycling | 496 | 2018-08-07T14:00:21.867001+03:00 | 3 | 34 | {} | [496] | 0 | 1400 | 166 | 466 | 125 | 156 | 19 | ||||||||||||||||||||||||||||||
695 | [696, 697, 698, 699, 700, 701, 702, 703, 704, 705] | Retkeilyn palvelut | Utflyktstjänster | Hiking facilities | 2018-08-07T14:00:24.236641+03:00 | 3 | 694 | {} | [] | 0 | 1403 | 224 | 404 | 10 | 11 | 8 | 125 | 7 | 18 | 1 | |||||||||||||||||||||||||||
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 | ||||||
558 | [559, 564, 567, 572, 575, 577, 592, 597] | Maastoliikuntapaikat | Anläggningar för terrängidrott | Cross-country sports facilities | 2018-08-07T14:00:23.281875+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 151 | 443 | 5 | 1 | 1 | 118 | 153 | 9 | 5 | |||||||||||||||||||||||||||
639 | [641, 642, 643, 644, 645] | Jääurheilualueet ja luonnonjäät | Isidrottsområden och naturisar | Ice sports areas and sites with natural ice | 2018-08-07T14:00:23.829697+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 165 | 358 | 114 | 77 | 2 | |||||||||||||||||||||||||||||||
577 | [579, 580, 581, 582, 583, 584, 585, 586, 590] | Liikunta- ja ulkoilureitit | Idrotts- och friluftsleder | Sports and outdoor recreation routes | 2018-08-07T14:00:23.400833+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 132 | 401 | 3 | 1 | 1 | 105 | 147 | 9 | 3 | |||||||||||||||||||||||||||
642 | [] | Luistelukenttä | Skridskobana | Ice-skating field | 406 | 2018-08-07T14:00:23.848959+03:00 | 4 | 639 | {} | [406] | 0 | 1403 | 136 | 308 | 100 | 70 | 2 | ||||||||||||||||||||||||||||||
653 | [] | Ulkokuntoiluvälineet | Konditionspark för utomhusaktiviteter | Fitness training park | 737 | 2018-08-07T14:00:23.939410+03:00 | 4 | 646 | {} | [737] | 0 | 1403 | 168 | 320 | 100 | 43 | 3 | 6 | |||||||||||||||||||||||||||||
612 | [] | Liikuntasali | Idrottssal | Gymnastics hall | 402 | 2018-08-07T14:00:23.630490+03:00 | 4 | 608 | {} | [402] | 0 | 1403 | 308 | 512 | 97 | 102 | 5 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2207 | [] | Esteettömät autopaikat kadulla | P-plats för personer med rörelsehinder bredvid gatan | Accessible parking space along street | 887 | 2020-02-12T09:30:09.092906+02:00 | 3 | 526 | {} | [887] | 0 | 1402 | 94 | 94 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||
1098 | [1173, 1181, 1177, 1120, 1119, 1099, 1109, 1174, 1169, 2014, 2215, 2216] | Suomen- ja vieraskielinen perusopetus | Grundläggande utbildning på finska och främmande språk | Basic education in Finnish, English and other languages | 2020-03-06T18:32:07.543511+02:00 | 2 | 1097 | {} | [] | 0 | 1087 | 368 | 504 | 1 | 84 | 50 | 1 | ||||||||||||||||||||||||||||||
718 | [2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753] | Matkailu | Turism | Tourism | 2018-08-07T14:00:24.401683+03:00 | 2 | 717 | {} | [] | 0 | 1403 | 1880 | 2050 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 5 | 3 | 79 | 64 | 1 | 1 | 3 | 4 | ||||||||||||||||||
1089 | [1090] | Suomen- ja vieraskielinen esiopetus | Förskoleundervisning på finska och främmande språk | Pre-primary education in Finnish, English and other languages | 861 | 2020-03-06T18:32:07.479235+02:00 | 2 | 1088 | {} | [861] | 1 | 1087 | 289 | 484 | 78 | 117 | |||||||||||||||||||||||||||||||
1090 | [] | Päivähoidon järjestämä esiopetus | Förskoleundervisning som ordnas av dagvården | Pre-primary education organised by day care | 58*160+151*160+164*160+188*160+195*160+569*160+607*160+614*160+663*160+773*160+861*160 | 2019-06-20T11:30:19.029713+03:00 | 3 | 1089 | {} | [861, 773, 663, 614, 607, 569, 195, 188, 164, 160, 151, 58] | 1 | 1087 | 289 | 483 | 78 | 116 | |||||||||||||||||||||||||||||||
2122 | [2125] | Suomen- ja vieraskielinen esiopetus | Förskoleundervisning på finska och främmande språk | Pre-primary education in Finnish, English and other languages | 861 | 2020-03-06T18:32:09.045855+02:00 | 2 | 2118 | {} | [861] | 1 | 1405 | 289 | 484 | 78 | 117 | |||||||||||||||||||||||||||||||
2125 | [] | Päivähoidon järjestämä esiopetus | Förskoleundervisning som ordnas av dagvården | Pre-primary education organised by day care | 58*160+151*160+164*160+188*160+195*160+569*160+607*160+614*160+663*160+773*160+861*160 | 2019-06-20T11:30:22.256470+03:00 | 3 | 2122 | {} | [861, 773, 663, 614, 607, 569, 195, 188, 164, 160, 151, 58] | 1 | 1405 | 289 | 483 | 78 | 116 | |||||||||||||||||||||||||||||||
1120 | [1123, 1124, 1127, 1129, 1122, 1130, 1131, 1135, 1136, 1139, 1141, 1134, 1142, 1143, 1147, 1146, 1160, 1162, 1163, 1164, 1165, 1166, 1167, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234] | Kieliohjelma | Språkprogram | Language programme | 2018-08-07T14:00:25.674488+03:00 | 3 | 1098 | {} | [] | 0 | 1087 | 109 | 213 | 1 | 73 | 29 | 1 | ||||||||||||||||||||||||||||||
1123 | [] | A1-englanti | A1-engelska | A1-English | 149*15+150*15+162*15+163*15+301*15+302*15+384*15+385*15+567*15+568*15+612*15+613*15+661*15+662*15+771*15+772*15+793*15+794*15+865*15+866*15 | 2018-10-25T08:00:07.696168+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 15] | 1 | 1087 | 108 | 211 | 1 | 73 | 28 | 1 | |||||||||||||||||||||||||||||
1146 | [] | B1-ruotsi | B1-svenska | B1-Swedish | 149*108+150*108+162*108+163*108+301*108+302*108+384*108+385*108+567*108+568*108+612*108+613*108+661*108+662*108+771*108+772*108+793*108+794*108+865*108+866*108 | 2018-10-25T08:00:07.912218+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 108] | 1 | 1087 | 107 | 205 | 1 | 72 | 24 | 1 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
879 | [] | esiopetus | förskoleundervisning | pre-primary education | 663*160+861*160 | 2018-10-24T23:30:08.464088+03:00 | 4 | 870 | {} | [861, 663, 160] | 1 | 1405 | 266 | 448 | 66 | 116 | |||||||||||||||||||||||||||||||
648 | [] | Lähiliikuntapaikka | Näridrottsplats | Neighbourhood sports area | 415 | 2018-08-07T14:00:23.898085+03:00 | 4 | 646 | {} | [415] | 0 | 1403 | 134 | 229 | 1 | 64 | 26 | 4 | |||||||||||||||||||||||||||||
657 | [] | Koripallokenttä | Basketplan | Basketball court | 331 | 2018-08-07T14:00:23.971455+03:00 | 4 | 654 | {} | [331] | 0 | 1403 | 153 | 256 | 64 | 37 | 2 | ||||||||||||||||||||||||||||||
1099 | [1101, 1102, 2170, 1103, 1100, 1104] | Luokkien 1-6 perusopetus | Grundläggande utbildning, årskurserna 1-6 | Basic education, grades 1-6 | 2018-10-25T08:00:07.589100+03:00 | 3 | 1098 | {} | [] | 0 | 1087 | 110 | 212 | 62 | 39 | 1 | |||||||||||||||||||||||||||||||
1100 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 661 | 2018-10-25T08:00:07.595003+03:00 | 4 | 1099 | {} | [661] | 1 | 1087 | 104 | 205 | 62 | 38 | 1 | ||||||||||||||||||||||||||||||
614 | [615, 616, 617, 618, 619, 620, 621, 622, 623] | Liikuntahallit | Idrottshallar | Sports halls | 2018-08-07T14:00:23.644666+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 149 | 233 | 60 | 22 | 2 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||||
684 | [685, 690] | Vesiliikuntapaikat | Anläggningar för vattenidrott | Water sports facilities | 2018-08-07T14:00:24.163817+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 78 | 153 | 4 | 51 | 15 | 4 | 1 | |||||||||||||||||||||||||||||
961 | [962, 2145] | Perhepäivähoito | Familjedagvård | Family day care | 2018-08-07T14:00:28.863138+03:00 | 2 | 868 | {} | [] | 0 | 1405 | 71 | 134 | 51 | 11 | 1 | |||||||||||||||||||||||||||||||
2145 | [964, 963, 972] | Ryhmäperhepäivähoito | Gruppfamiljedagvård | Group family day care | 2018-08-07T14:00:28.879106+03:00 | 3 | 961 | {} | [] | 0 | 1405 | 57 | 118 | 51 | 9 | 1 | |||||||||||||||||||||||||||||||
71 | [] | Viheralueet | Grönområden | Green areas | 786 | 2018-08-07T14:00:21.432517+03:00 | 3 | 60 | {} | [786] | 0 | 1400 | 51 | 102 | 1 | 50 | |||||||||||||||||||||||||||||||
502 | [] | Viheralueet | Grönområden | Green areas | 786 | 2018-08-07T14:00:22.769184+03:00 | 3 | 491 | {} | [786] | 0 | 1403 | 51 | 102 | 1 | 50 | |||||||||||||||||||||||||||||||
1142 | [] | A2-saksa | A2-tyska | A2-German | 149*35+150*35+162*35+163*35+301*35+302*35+384*35+385*35+567*35+568*35+612*35+613*35+661*35+662*35+771*35+772*35+793*35+794*35+865*35+866*35 | 2018-10-25T08:00:07.877676+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 35] | 1 | 1087 | 58 | 124 | 50 | 16 | |||||||||||||||||||||||||||||||
1359 | [] | Yliopistot | Universitet | Universities | 822 | 2018-08-07T14:00:27.510881+03:00 | 1 | 1087 | {} | [822] | 0 | 1087 | 10 | 60 | 50 | ||||||||||||||||||||||||||||||||
231 | [232, 233, 238, 239, 240, 241, 242, 243, 244, 245, 253, 254, 255] | Kiinteistöt ja rakennetut tilat | Fastigheter | Real estate | 2018-08-07T14:00:22.059452+03:00 | 2 | 221 | {} | [] | 0 | 1400 | 311 | 427 | 1 | 1 | 1 | 1 | 2 | 2 | 48 | 55 | 5 | |||||||||||||||||||||||||
963 | [] | Suomenkielinen ryhmäperhepäivähoito | Gruppfamiljedagvård på finska | Group family day care in Finnish | 664 | 2018-10-25T08:00:09.441773+03:00 | 4 | 2145 | {"fi": ["suomi"]} | [664] | 0 | 1405 | 50 | 107 | 47 | 9 | 1 | ||||||||||||||||||||||||||||||
38 | [] | Kartonginkeräys | Insamling av kartong | Cardboard recycling | 246 | 2018-08-07T14:00:21.813795+03:00 | 3 | 34 | {"fi": ["kartonki"]} | [246] | 0 | 1400 | 54 | 140 | 46 | 36 | 4 | ||||||||||||||||||||||||||||||
40 | [] | Lasinkeräys | Glasåtervinning | Glass recycling | 374 | 2018-08-07T14:00:21.831316+03:00 | 3 | 34 | {} | [374] | 0 | 1400 | 50 | 138 | 46 | 37 | 5 | ||||||||||||||||||||||||||||||
41 | [] | Metallinkeräys | Metallavfall | Small metal waste | 436 | 2018-08-07T14:00:21.839149+03:00 | 3 | 34 | {} | [436] | 0 | 1400 | 50 | 137 | 46 | 37 | 4 | ||||||||||||||||||||||||||||||
541 | [542, 547] | Vesiliikenne | Sjötrafik | Water traffic | 2018-08-07T14:00:25.190941+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 223 | 279 | 1 | 4 | 2 | 1 | 2 | 45 | 1 | |||||||||||||||||||||||||||
547 | [548, 2199, 549, 2143, 2142] | Veneily | Båtsport | Boating | 2018-08-07T14:00:25.237133+03:00 | 3 | 541 | {} | [] | 0 | 1402 | 206 | 262 | 1 | 4 | 2 | 1 | 2 | 45 | 1 | |||||||||||||||||||||||||||
611 | [] | Kuntosali | Gym | Gym | 350 | 2018-08-07T14:00:23.623495+03:00 | 4 | 608 | {} | [350] | 0 | 1403 | 151 | 237 | 45 | 39 | 2 | ||||||||||||||||||||||||||||||
624 | [625, 626, 627, 628, 629, 630, 631, 632] | Yksittäiset lajikohtaiset sisäliikuntapaikat | Enstaka grenspecifika anläggningar för inomhusidrott | Indoor venues for various sports | 2018-08-07T14:00:23.722887+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 118 | 186 | 43 | 24 | 1 | |||||||||||||||||||||||||||||||
146 | [147, 148, 149, 156] | Tilojen vuokraus ja varaus | Uthyrning och reservering av lokaler | Renting out and reservation of facilities | 2018-08-07T14:00:30.157480+03:00 | 2 | 122 | {} | [] | 0 | 1401 | 294 | 380 | 1 | 1 | 1 | 1 | 2 | 2 | 42 | 32 | 4 | |||||||||||||||||||||||||
255 | [256, 257, 258, 265] | Tilojen vuokraus ja varaus | Uthyrning och reservering av lokaler | Renting out and reservation of facilities | 2018-08-07T14:00:22.202500+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 294 | 380 | 1 | 1 | 1 | 1 | 2 | 2 | 42 | 32 | 4 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
149 | [2209, 150, 152, 151, 154, 155] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:30.179684+03:00 | 3 | 146 | {} | [] | 0 | 1401 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
258 | [2210, 259, 261, 260, 263, 264] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:22.220951+03:00 | 4 | 255 | {} | [] | 0 | 1400 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
505 | [2208, 506, 508, 507, 510, 511] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:22.797039+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
583 | [] | Latu | Skidspår | Ski track | 191 | 2018-08-07T14:00:23.433650+03:00 | 4 | 577 | {} | [191] | 0 | 1403 | 45 | 208 | 2 | 1 | 39 | 117 | 3 | 1 | |||||||||||||||||||||||||||
685 | [686, 687, 688, 689] | Maauimalat ja uimarannat | Utebassänger och badstränder | Open air pools and beaches | 2018-08-07T14:00:24.169221+03:00 | 3 | 684 | {} | [] | 0 | 1403 | 43 | 98 | 4 | 39 | 8 | 4 | ||||||||||||||||||||||||||||||
1134 | [] | A2-ruotsi | A2-svenska | A2-Swedish | 149*34+150*34+162*34+163*34+301*34+302*34+384*34+385*34+567*34+568*34+612*34+613*34+661*34+662*34+771*34+772*34+793*34+794*34+865*34+866*34 | 2018-10-25T08:00:07.804809+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 34] | 1 | 1087 | 57 | 117 | 39 | 21 | |||||||||||||||||||||||||||||||
50 | [] | Tekstiilien keräys | Textilåtervinning | Textile recycling | 696 | 2018-08-07T14:00:21.906229+03:00 | 3 | 34 | {} | [696] | 0 | 1400 | 40 | 108 | 37 | 29 | 2 | ||||||||||||||||||||||||||||||
542 | [543, 544, 545, 2198, 546, 2144] | Satamat ja laiturit | Hamn och bryggor | Harbours, piers and quays | 2018-08-07T14:00:25.196186+03:00 | 3 | 541 | {} | [] | 0 | 1402 | 168 | 209 | 2 | 1 | 1 | 36 | 1 | |||||||||||||||||||||||||||||
546 | [] | Venesatamat | Båthamnar | Marinas | 769 | 2018-08-07T14:00:25.230897+03:00 | 4 | 542 | {} | [769] | 0 | 1402 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
617 | [] | Monitoimihalli / areena | Allaktivitetshall/multiarena | Multipurpose hall/arena | 444 | 2018-08-07T14:00:23.665496+03:00 | 4 | 614 | {} | [444] | 0 | 1403 | 97 | 133 | 36 | ||||||||||||||||||||||||||||||||
705 | [] | Venesatama | Serviceplats för båtfarare | Boating services | 769 | 2018-08-07T14:00:24.310541+03:00 | 4 | 695 | {} | [769] | 0 | 1403 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
825 | [] | Vanhusten palveluasuminen | Serviceboende för äldre | Service residence for the elderly | 760 | 2018-08-07T14:00:27.984445+03:00 | 2 | 819 | {} | [760] | 0 | 783 | 30 | 103 | 1 | 36 | 32 | 3 | 1 | ||||||||||||||||||||||||||||
2142 | [] | Venesatamat | Båthamnar | Marinas | 769 | 2018-08-07T14:00:25.242377+03:00 | 4 | 547 | {} | [769] | 0 | 1402 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
701 | [] | Ruoanlaittopaikka | Matlagningsplats | Cooking facilities | 586 | 2018-08-07T14:00:24.282789+03:00 | 4 | 695 | {} | [586] | 0 | 1403 | 17 | 77 | 6 | 8 | 4 | 33 | 9 | ||||||||||||||||||||||||||||
881 | [886, 887, 883, 882] | Ruotsinkielinen päivähoito | Svenskspråkig dagvård | Day care in Swedish | 603 | 2019-03-05T14:30:09.379492+02:00 | 3 | 869 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [603] | 0 | 1405 | 77 | 128 | 33 | 10 | 8 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );