service_node
360 rows where level = 4 sorted by name_en descending
This data as json, CSV (advanced)
Suggested facets: children, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen
last_modified_time (date) ✖
- 2018-08-07 271
- 2018-10-25 61
- 2018-10-24 8
- 2020-06-22 8
- 2019-03-05 4
- 2020-10-02 3
- 2019-05-08 2
- 2019-10-22 1
- 2020-12-02 1
- 2020-12-15 1
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
207 | [] | täsmäykset | avstämningar | synchronisation | 682 | 2018-08-07T14:00:30.636668+03:00 | 4 | 198 | {} | [682] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
875 | [] | erityisryhmä | specialgrupp | special group | 663*156 | 2018-08-07T14:00:28.291078+03:00 | 4 | 870 | {} | [663, 156] | 0 | 1405 | 49 | 77 | 28 | ||||||||||||||||||||||||||||||||
886 | [] | erityisryhmä | specialgrupp | special group | 603*156 | 2018-08-07T14:00:28.367894+03:00 | 4 | 881 | {} | [603, 156] | 0 | 1405 | 3 | 3 | |||||||||||||||||||||||||||||||||
1172 | [] | 7. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 7 | special emphasis starting from 7th grade | 150*3+163*3+302*3+385*3+568*3+613*3+662*3+772*3+794*3+866*3 | 2018-10-25T08:00:08.139111+03:00 | 4 | 1169 | {} | [866, 794, 772, 662, 613, 568, 385, 302, 163, 150, 3] | 1 | 1087 | 28 | 28 | |||||||||||||||||||||||||||||||||
1245 | [] | 7. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 7 | special emphasis starting from 7th grade | 602*3 | 2018-08-07T14:00:26.681590+03:00 | 4 | 1242 | {} | [602, 3] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1171 | [] | 3. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 3 | special emphasis starting from 3rd grade | 149*2+162*2+301*2+384*2+567*2+612*2+661*2+771*2+793*2+865*2 | 2018-10-25T08:00:08.131695+03:00 | 4 | 1169 | {} | [865, 793, 771, 661, 612, 567, 384, 301, 162, 149, 2] | 1 | 1087 | 11 | 15 | 4 | ||||||||||||||||||||||||||||||||
1244 | [] | 3. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 3 | special emphasis starting from 3rd grade | 601*2 | 2018-08-07T14:00:26.674416+03:00 | 4 | 1242 | {} | [601, 2] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1170 | [] | 1. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 1 | special emphasis starting from 1st grade | 149*1+162*1+301*1+384*1+567*1+612*1+661*1+771*1+793*1+865*1 | 2018-10-25T08:00:08.124175+03:00 | 4 | 1169 | {} | [865, 793, 771, 661, 612, 567, 384, 301, 162, 149, 1] | 1 | 1087 | 10 | 10 | |||||||||||||||||||||||||||||||||
208 | [] | yleisökassa | kassa för allmänheten | public fund | 269 | 2018-08-07T14:00:30.645432+03:00 | 4 | 198 | {} | [269] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
758 | [] | Kaupunginhallituksen ja kaupunginvaltuuston valmistelutehtävät | stadsstyrelsens och stadsförvaltningens beredningsuppgifter | preparatory assignments for City Government and City Council | 274 | 2018-08-07T14:00:30.769165+03:00 | 4 | 757 | {} | [274] | 0 | 1401 | 1 | 2 | 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 | |||||||||||||||||||||||||||||||
887 | [] | esiopetus | förskoleundervisning | pre-primary education | 603*160+862*160 | 2018-10-24T23:30:08.488969+03:00 | 4 | 881 | {} | [862, 603, 160] | 1 | 1405 | 27 | 36 | 9 | ||||||||||||||||||||||||||||||||
895 | [] | esiopetus | förskoleundervisning | pre-primary education | 607*160 | 2018-08-07T14:00:28.423737+03:00 | 4 | 889 | {} | [607, 160] | 1 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
903 | [] | esiopetus | förskoleundervisning | pre-primary education | 58*160 | 2018-08-07T14:00:28.468345+03:00 | 4 | 897 | {} | [160, 58] | 1 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
911 | [] | esiopetus | förskoleundervisning | pre-primary education | 151*160 | 2018-08-07T14:00:28.512259+03:00 | 4 | 905 | {} | [160, 151] | 1 | 1405 | 26 | 39 | 12 | 1 | |||||||||||||||||||||||||||||||
919 | [] | esiopetus | förskoleundervisning | pre-primary education | 164*160 | 2018-08-07T14:00:28.559368+03:00 | 4 | 913 | {} | [164, 160] | 1 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
935 | [] | esiopetus | förskoleundervisning | pre-primary education | 569*160 | 2018-08-07T14:00:28.657653+03:00 | 4 | 929 | {} | [569, 160] | 1 | 1405 | 3 | 3 | |||||||||||||||||||||||||||||||||
959 | [] | esiopetus | förskoleundervisning | pre-primary education | 795*160 | 2018-08-07T14:00:28.844971+03:00 | 4 | 953 | {} | [795, 160] | 1 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
2243 | [] | esiopetus | förskoleundervisning | pre-primary education | 913*160 | 2020-10-02T12:00:13.998958+03:00 | 4 | 2238 | {} | [913, 160] | 1 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
211 | [] | henkilöstökassa | personalkassa | personnel fund | 262 | 2018-08-07T14:00:30.669740+03:00 | 4 | 209 | {} | [262] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
205 | [] | palkanlaskenta | löneräkning | payroll administration | 680 | 2018-08-07T14:00:30.620039+03:00 | 4 | 198 | {} | [680] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
206 | [] | suoritukset | betalningar | payments | 681 | 2018-08-07T14:00:30.628457+03:00 | 4 | 198 | {} | [681] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
203 | [] | maksuliikenne | penningrörelse | payment transactions | 678 | 2018-08-07T14:00:30.605414+03:00 | 4 | 198 | {} | [678] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
880 | [] | osapäiväryhmä | halvdagsgrupp | part-time day care | 663*489 | 2018-08-07T14:00:28.322654+03:00 | 4 | 870 | {} | [663, 489] | 0 | 1405 | 33 | 33 | |||||||||||||||||||||||||||||||||
2244 | [] | osapäiväryhmä | halvdagsgrupp | part-time day care | 913*489 | 2020-10-02T12:00:14.017784+03:00 | 4 | 2238 | {} | [913, 489] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
876 | [] | kielikylpy ruotsi | språkbad, svenska | language immersion, Swedish | 663*294 | 2018-08-07T14:00:28.297483+03:00 | 4 | 870 | {} | [663, 294] | 0 | 1405 | 9 | 19 | 5 | 3 | 2 | ||||||||||||||||||||||||||||||
877 | [] | kielikylpy englanti | språkbad, engelska | language immersion, English | 663*292 | 2018-08-07T14:00:28.303776+03:00 | 4 | 870 | {} | [663, 292] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
202 | [] | maksukattoasiat | betalningstakärenden | issues regarding payment limits | 677 | 2018-08-07T14:00:30.597368+03:00 | 4 | 198 | {} | [677] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
201 | [] | laskutus | fakturering | invoicing | 676 | 2018-08-07T14:00:30.590863+03:00 | 4 | 198 | {} | [676] | 0 | 1401 | 4 | 4 | |||||||||||||||||||||||||||||||||
204 | [] | ostolaskut | köpfakturor | incoming invoices | 679 | 2018-08-07T14:00:30.612437+03:00 | 4 | 198 | {} | [679] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
872 | [] | iltahoito 17:30-22:00 | kvällsvård 17.30-22.00 | evening care 5:30pm-10:00pm | 663*200 | 2018-08-07T14:00:28.278055+03:00 | 4 | 870 | {} | [663, 200] | 0 | 1405 | 6 | 14 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||
883 | [] | iltahoito 17:30-22:00 | kvällsvård 17.30-22.00 | evening care 5:30pm-10:00pm | 603*200 | 2018-08-07T14:00:28.354237+03:00 | 4 | 881 | {} | [603, 200] | 0 | 1405 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
1189 | [] | ruotsinkielinen opetus | undervisning på svenska | education in Swedish | 601 | 2018-08-07T14:00:26.265483+03:00 | 4 | 1188 | {} | [601] | 1 | 1087 | 21 | 37 | 12 | 4 | |||||||||||||||||||||||||||||||
1191 | [] | ruotsinkielinen opetus | undervisning på svenska | education in Swedish | 602 | 2018-08-07T14:00:26.281144+03:00 | 4 | 1190 | {} | [602] | 1 | 1087 | 7 | 12 | 4 | 1 | |||||||||||||||||||||||||||||||
2170 | [] | saamenkielinen opetus | undervisning på samiska | education in Sami | 865 | 2018-08-07T14:00:25.510062+03:00 | 4 | 1099 | {} | [865] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
2171 | [] | saamenkielinen opetus | undervisning på samiska | education in Sami | 866 | 2018-08-07T14:00:25.605807+03:00 | 4 | 1109 | {} | [866] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1104 | [] | venäjänkielinen opetus | undervisning på ryska | education in Russian | 771 | 2018-08-07T14:00:25.524519+03:00 | 4 | 1099 | {} | [771] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1114 | [] | venäjänkielinen opetus | undervisning på ryska | education in Russian | 772 | 2018-08-07T14:00:25.622338+03:00 | 4 | 1109 | {} | [772] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1103 | [] | saksankielinen opetus | undervisning på tyska | education in German | 612 | 2018-08-07T14:00:25.517491+03:00 | 4 | 1099 | {} | [612] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1113 | [] | saksankielinen opetus | undervisning på tyska | education in German | 613 | 2018-08-07T14:00:25.613385+03:00 | 4 | 1109 | {} | [613] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1102 | [] | ranskankielinen opetus | undervisning på franska | education in French | 567 | 2018-08-07T14:00:25.502701+03:00 | 4 | 1099 | {} | [567] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1112 | [] | ranskankielinen opetus | undervisning på franska | education in French | 568 | 2018-08-07T14:00:25.599261+03:00 | 4 | 1109 | {} | [568] | 1 | 1087 | 1 | 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 | ||||||||||||||||||||||||||||||
1110 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 662 | 2018-10-25T08:00:07.635959+03:00 | 4 | 1109 | {} | [662] | 1 | 1087 | 63 | 114 | 1 | 27 | 22 | 1 | |||||||||||||||||||||||||||||
1101 | [] | englanninkielinen opetus | undervisning på engelska | education in English | 149 | 2018-10-25T08:00:07.601071+03:00 | 4 | 1099 | {} | [149] | 1 | 1087 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
1111 | [] | englanninkielinen opetus | undervisning på engelska | education in English | 150 | 2018-10-25T08:00:07.642003+03:00 | 4 | 1109 | {} | [150] | 1 | 1087 | 6 | 7 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
882 | [] | päivähoito | dagvård | day care | 603 | 2019-03-05T14:30:09.386238+02:00 | 4 | 881 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [603] | 0 | 1405 | 77 | 128 | 33 | 10 | 8 | ||||||||||||||||||||||||||||||
890 | [] | päivähoito | dagvård | day care | 607 | 2018-08-07T14:00:28.398158+03:00 | 4 | 889 | {} | [607] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
898 | [] | päivähoito | dagvård | day care | 58 | 2018-08-07T14:00:28.442943+03:00 | 4 | 897 | {} | [58] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
906 | [] | päivähoito | dagvård | day care | 151 | 2018-08-07T14:00:28.486872+03:00 | 4 | 905 | {} | [151] | 0 | 1405 | 39 | 62 | 21 | 1 | 1 | ||||||||||||||||||||||||||||||
914 | [] | päivähoito | dagvård | day care | 164 | 2018-08-07T14:00:28.533814+03:00 | 4 | 913 | {} | [164] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
922 | [] | päivähoito | dagvård | day care | 188 | 2018-08-07T14:00:28.579608+03:00 | 4 | 921 | {} | [188] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
930 | [] | päivähoito | dagvård | day care | 569 | 2018-08-07T14:00:28.629796+03:00 | 4 | 929 | {} | [569] | 0 | 1405 | 6 | 6 | |||||||||||||||||||||||||||||||||
938 | [] | päivähoito | dagvård | day care | 614 | 2018-08-07T14:00:28.681434+03:00 | 4 | 937 | {} | [614] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
946 | [] | päivähoito | dagvård | day care | 773 | 2018-08-07T14:00:28.740210+03:00 | 4 | 945 | {} | [773] | 0 | 1405 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
954 | [] | päivähoito | dagvård | day care | 795 | 2018-08-07T14:00:28.802386+03:00 | 4 | 953 | {} | [795] | 0 | 1405 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2239 | [] | päivähoito | dagvård | day care | 913 | 2020-10-02T12:00:13.926103+03:00 | 4 | 2238 | {} | [913] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
200 | [] | laskutuksen asiakasmaksut | faktureringens kundavgifter | customer payments for invoicing | 674 | 2018-08-07T14:00:30.584039+03:00 | 4 | 198 | {} | [674] | 0 | 1401 | 4 | 4 | |||||||||||||||||||||||||||||||||
213 | [] | konserniohjaus | koncernstyrning | consolidated corporation guidance | 227 | 2018-08-07T14:00:30.685091+03:00 | 4 | 209 | {} | [227] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
210 | [] | antolainat | utlåning | advances | 260 | 2018-08-07T14:00:30.661409+03:00 | 4 | 209 | {} | [260] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
199 | [] | kirjanpito | bokföring | accounting | 675 | 2018-08-07T14:00:30.577311+03:00 | 4 | 198 | {} | [675] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
154 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:30.213017+03:00 | 4 | 149 | {} | [803] | 0 | 1401 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
687 | [] | Talviuintipaikka | Vinterbadplats | Winter swimming area | 684 | 2018-08-07T14:00:24.182493+03:00 | 4 | 685 | {} | [684] | 0 | 1403 | 13 | 23 | 8 | 2 | |||||||||||||||||||||||||||||||
549 | [] | Veneiden talvisäilytys | Vinterförvaring av båtar | Winter storage for boats | 768 | 2018-08-07T14:00:25.255633+03:00 | 4 | 547 | {} | [768] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
724 | [] | Luonnonvaraisten eläinten hoitola | Vårdanstalt för vilda djur | Wildlife home | 411 | 2018-08-07T14:00:24.442228+03:00 | 4 | 719 | {} | [411] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
613 | [] | Voimailusali | Styrketräningssal | Weight training hall | 797 | 2018-08-07T14:00:23.637831+03:00 | 4 | 608 | {} | [797] | 0 | 1403 | 22 | 39 | 5 | 12 | |||||||||||||||||||||||||||||||
299 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:22.497732+03:00 | 4 | 293 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
683 | [] | Vesihiihtoalue | Område för vattenskidåkning | Water ski area | 777 | 2018-08-07T14:00:24.157225+03:00 | 4 | 677 | {} | [777] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
730 | [] | Vesibussilaiturit | Vattenbussbryggor | Water bus platforms | 142*776 | 2018-08-07T14:00:24.485125+03:00 | 4 | 719 | {} | [776, 142] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
2144 | [] | Vesibussilaiturit | Vattenbussbryggor | Water bus platforms | 776 | 2018-08-07T14:00:25.224191+03:00 | 4 | 542 | {} | [776] | 0 | 1402 | 3 | 3 | |||||||||||||||||||||||||||||||||
332 | [] | WLAN-ulkopisteet | WLAN-utomhusstationer | WLAN outlets | 807 | 2018-08-07T14:00:24.889824+03:00 | 4 | 330 | {} | [807] | 0 | 1402 | 10 | 10 | |||||||||||||||||||||||||||||||||
331 | [] | WLAN-sisäpisteet | WLAN-inomhusstationer | WLAN inlets | 806 | 2018-08-07T14:00:24.883321+03:00 | 4 | 330 | {} | [806] | 0 | 1402 | 223 | 230 | 7 | ||||||||||||||||||||||||||||||||
658 | [] | Lentopallokenttä | Volleybollplan | Volleyball court | 392 | 2018-08-07T14:00:23.980139+03:00 | 4 | 654 | {} | [392] | 0 | 1403 | 46 | 86 | 1 | 10 | 28 | 1 | |||||||||||||||||||||||||||||
651 | [] | Pyöräilyrata | Cykelåkningsbana | Velodrome | 539 | 2018-08-07T14:00:23.920549+03:00 | 4 | 646 | {} | [539] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1269 | [] | Yleislinjan lukiokoulutus | Gymnasieutbildning, allmän linje | Upper secondary school education, general programme | 148*816+161*816+300*816+383*816+566*816+611*816+658*816+770*816+792*816 | 2018-10-25T08:00:08.527922+03:00 | 4 | 1268 | {} | [816, 792, 770, 658, 611, 566, 383, 300, 161, 148] | 1 | 1087 | 14 | 30 | 11 | 5 | |||||||||||||||||||||||||||||||
1301 | [] | Yleislinjan lukiokoulutus | Gymnasieutbildning, allmän linje | Upper secondary school education, general programme | 598*816 | 2018-08-07T14:00:27.095367+03:00 | 4 | 1300 | {} | [816, 598] | 1 | 1087 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
1270 | [] | Erityistehtävän mukainen lukiokoulutus | Gymnasieutbildning med särskild uppgift | Upper secondary school education with special curriculum | 148*157+161*157+300*157+383*157+566*157+611*157+658*157+770*157+792*157 | 2018-10-25T08:00:08.535976+03:00 | 4 | 1268 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 157, 148] | 1 | 1087 | 6 | 9 | 3 | ||||||||||||||||||||||||||||||||
1302 | [] | Erityistehtävän mukainen lukiokoulutus | Gymnasieutbildning med särskild uppgift | Upper secondary school education with special curriculum | 598*157 | 2018-08-07T14:00:27.104000+03:00 | 4 | 1300 | {} | [598, 157] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
688 | [] | Uimapaikka | Badplats | Unsupervised beach | 730 | 2018-08-07T14:00:24.189679+03:00 | 4 | 685 | {} | [730] | 0 | 1403 | 14 | 48 | 4 | 22 | 4 | 4 | |||||||||||||||||||||||||||||
603 | [] | Harjoitusjäähalli | Övningsishall | Training ice arena | 187 | 2018-08-07T14:00:23.568317+03:00 | 4 | 602 | {} | [187] | 0 | 1403 | 10 | 17 | 5 | 2 | |||||||||||||||||||||||||||||||
593 | [] | Ampumahiihdon harjoittelualue | Träningsområde för skidskytte | Training area for biathlon | 52 | 2018-08-07T14:00:23.502563+03:00 | 4 | 592 | {} | [52] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
227 | [] | Liikennesuunnittelu | Trafikplanering | Traffic planning | 395 | 2018-08-07T14:00:22.030360+03:00 | 4 | 226 | {} | [395] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
228 | [] | Liikenteen ohjaus, liikennevalot | Trafikstyrning, trafikljus | Traffic control, traffic lights | 396+397 | 2018-10-24T23:30:05.577987+03:00 | 4 | 226 | {} | [397, 396] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
710 | [] | Matkailupalveluiden alue | Område med turisttjänster | Tourist services area | 430 | 2018-08-07T14:00:24.337371+03:00 | 4 | 706 | {} | [430] | 0 | 1403 | 5 | 5 | |||||||||||||||||||||||||||||||||
723 | [] | Lipunmyynti | Biljettförsäljning | Ticket sales | 403 | 2018-08-07T14:00:24.435423+03:00 | 4 | 719 | {} | [403] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
545 | [] | Terminaalit | Terminaler | Terminals | 782 | 2018-08-07T14:00:25.217022+03:00 | 4 | 542 | {} | [782] | 0 | 1402 | 6 | 6 | |||||||||||||||||||||||||||||||||
623 | [] | Tennishalli | Tennishall | Tennis hall | 699 | 2018-08-07T14:00:23.714268+03:00 | 4 | 614 | {} | [699] | 0 | 1403 | 13 | 23 | 7 | 3 | |||||||||||||||||||||||||||||||
662 | [] | Tenniskenttäalue | Område med tennisbanor | Tennis court area | 700 | 2018-10-25T08:00:07.016431+03:00 | 4 | 654 | {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} | [700] | 0 | 1403 | 45 | 83 | 11 | 25 | 2 | ||||||||||||||||||||||||||||||
627 | [] | Pöytätennistila | Utrymme för bordtennis | Table tennis venue | 556 | 2018-08-07T14:00:23.745237+03:00 | 4 | 624 | {} | [556] | 0 | 1403 | 22 | 46 | 22 | 2 | |||||||||||||||||||||||||||||||
692 | [] | Uima-allas | Simbassäng | Swimming pool | 728 | 2018-08-07T14:00:24.217361+03:00 | 4 | 690 | {} | [728] | 0 | 1403 | 21 | 28 | 6 | 1 | |||||||||||||||||||||||||||||||
334 | [335, 337, 338] | Tarjolla oheislaitteita | Kringutrustning finns | Supplementary equipment available | 2018-08-07T14:00:24.905778+03:00 | 4 | 333 | {} | [] | 0 | 1402 | 54 | 56 | 2 | |||||||||||||||||||||||||||||||||
69 | [] | Ohjattu leikkipuistotoiminta | Ledd lekparksverksamhet | Supervised playground activities | 475 | 2019-03-05T14:30:06.276314+02:00 | 4 | 68 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [475] | 0 | 1400 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
500 | [] | Ohjattu leikkipuistotoiminta | Ledd lekparksverksamhet | Supervised playground activities | 475 | 2019-03-05T14:30:06.940551+02:00 | 4 | 499 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [475] | 0 | 1403 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
689 | [] | Uimaranta | Badstrand | Supervised beach | 731 | 2018-08-07T14:00:24.196951+03:00 | 4 | 685 | {} | [731] | 0 | 1403 | 13 | 23 | 8 | 2 | |||||||||||||||||||||||||||||||
159 | [] | Varastotilojen vuokraus | Uthyrning av lagerlokaler | Storage space rental | 765 | 2018-08-07T14:00:30.247429+03:00 | 4 | 156 | {} | [765] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
632 | [] | Yksittäinen yleisurheilun suorituspaikka | Enstaka övningsplats för friidrott | Stand-alone athletics venue | 810 | 2018-08-07T14:00:23.783286+03:00 | 4 | 624 | {} | [810] | 0 | 1403 | 9 | 22 | 12 | 1 | |||||||||||||||||||||||||||||||
621 | [] | Squash-halli | Squashhall | Squash hall | 645 | 2018-08-07T14:00:23.695720+03:00 | 4 | 614 | {} | [645] | 0 | 1403 | 4 | 10 | 5 | 1 | |||||||||||||||||||||||||||||||
647 | [] | Liikuntapuisto | Idrottspark | Sports park | 401 | 2018-08-07T14:00:23.890605+03:00 | 4 | 646 | {} | [401] | 0 | 1403 | 7 | 3 | 2 | 2 | |||||||||||||||||||||||||||||||
616 | [] | Liikuntahalli | Idrottshall | Sports hall | 400 | 2018-08-07T14:00:23.657783+03:00 | 4 | 614 | {} | [400] | 0 | 1403 | 24 | 38 | 7 | 6 | 1 |
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 );