service_node
360 rows where level = 4 sorted by related_services
This data as json, CSV (advanced)
last_modified_time (date) ✖
- 2018-08-07 175
- 2018-10-25 59
- 2020-06-22 8
- 2018-10-24 7
- 2019-03-05 4
- 2020-10-02 3
- 2019-05-08 2
- 2019-10-22 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
586 | [] | Melontareitti | Paddlingsled | Canoe route | 434 | 2018-08-07T14:00:23.454892+03:00 | 4 | 577 | {} | [434] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
625 | [] | Miekkailutila | Utrymme för fäktning | Fencing venue | 439 | 2018-08-07T14:00:23.729643+03:00 | 4 | 624 | {} | [439] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
711 | [] | Monikäyttöalue, jolla on virkistyspalveluita | Allaktivitetsområde med rekreationstjänster | Multipurpose area with recreational services | 442 | 2018-08-07T14:00:24.344046+03:00 | 4 | 706 | {} | [442] | 0 | 1403 | 1 | 3 | 1 | 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 | ||||||||||||||||||||||||||||||||
672 | [] | Moottoripyöräilyalue | Område för motorcykelsport | Motorcycling area | 448 | 2018-08-07T14:00:24.080942+03:00 | 4 | 667 | {} | [448] | 0 | 1403 | 1 | 4 | 1 | 2 | |||||||||||||||||||||||||||||||
673 | [] | Moottorirata | Motorbana | Formula race track | 449 | 2018-08-07T14:00:24.087804+03:00 | 4 | 667 | {} | [449] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
674 | [] | Moottoriurheilukeskus | Centrum för motorsport | Motor sports centre | 450 | 2018-08-07T14:00:24.095559+03:00 | 4 | 667 | {} | [450] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
296 | [] | Mullan myynti ja toimitus | Försäljning och leverans av mylla | Selling and delivering soil | 453 | 2018-08-07T14:00:22.477143+03:00 | 4 | 293 | {} | [453] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
712 | [] | Muu luonnonsuojelualue, jolla on virkistyspalveluita | Annat naturskyddsområde med rekreationstjänster | Other nature conservation area with recreational services | 458 | 2018-08-07T14:00:24.351095+03:00 | 4 | 706 | {} | [458] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
67 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:21.407013+03:00 | 4 | 62 | {} | [480] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
498 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:22.741237+03:00 | 4 | 493 | {} | [480] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
290 | [] | Kilpipalvelut | Skylttjänster | Sign services | 481 | 2018-08-07T14:00:22.444787+03:00 | 4 | 287 | {} | [481] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
699 | [] | Opastuspiste | Information punkt | Information point | 482 | 2018-08-07T14:00:24.267790+03:00 | 4 | 695 | {} | [482] | 0 | 1403 | 51 | 73 | 1 | 2 | 2 | 14 | 2 | 1 | |||||||||||||||||||||||||||
160 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:30.257660+03:00 | 4 | 156 | {} | [494] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
659 | [] | Pallokenttä | Bollplan | Ball field | 495 | 2018-08-07T14:00:23.987386+03:00 | 4 | 654 | {} | [495] | 0 | 1403 | 408 | 743 | 169 | 161 | 5 | ||||||||||||||||||||||||||||||
773 | [] | Parisuhteen rekisteröinti | Registrering av partnerskap | Registration of partnerships | 498 | 2018-08-07T14:00:30.891417+03:00 | 4 | 770 | {} | [498] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
649 | [] | Parkour- alue | Parkourområde | Parkour area | 499 | 2018-08-07T14:00:23.905280+03:00 | 4 | 646 | {} | [499] | 0 | 1403 | 2 | 11 | 5 | 4 | |||||||||||||||||||||||||||||||
626 | [] | Parkour- Sali | Parkoursal | Parkour hall | 500 | 2018-08-07T14:00:23.737371+03:00 | 4 | 624 | {} | [500] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
660 | [] | Pesäpallostadion | Bobollsstadion | Baseball stadium | 511 | 2018-08-07T14:00:23.995997+03:00 | 4 | 654 | {} | [511] | 0 | 1403 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
618 | [] | Petanque - halli | Petanquehall | Petanque hall | 512 | 2018-08-07T14:00:23.673008+03:00 | 4 | 614 | {} | [512] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
644 | [] | Pikaluistelurata | Bana hastighetsåkning på skridsko | Speed-skating track | 514 | 2018-08-07T14:00:23.862975+03:00 | 4 | 639 | {} | [514] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
292 | [] | Pohja- ja kalliorakennussuunnittelu | Planering av grund- och bergsbyggnad | Foundation and rock engineering | 516 | 2018-08-07T14:00:22.458169+03:00 | 4 | 287 | {} | [516] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
650 | [] | Pyöräilyalue | Cykelåkningsområde | Cycling area | 538 | 2018-08-07T14:00:23.912521+03:00 | 4 | 646 | {} | [538] | 0 | 1403 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
651 | [] | Pyöräilyrata | Cykelåkningsbana | Velodrome | 539 | 2018-08-07T14:00:23.920549+03:00 | 4 | 646 | {} | [539] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
594 | [] | Ampumahiihtokeskus | Skidskyttecentrum | Biathlon centre | 53 | 2018-08-07T14:00:23.509751+03:00 | 4 | 592 | {} | [53] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
560 | [] | Ampumarata | Skjutbana | Open-air shooting range | 54 | 2018-08-07T14:00:23.293024+03:00 | 4 | 559 | {} | [54] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
282 | [] | Rakennus- ja toimenpideluvat | Bygglov och åtgärdstillstånd | Licences for construction and operations | 558 | 2018-08-07T14:00:22.390024+03:00 | 4 | 279 | {} | [558] | 0 | 1400 | 1 | 5 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
283 | [] | Rakennusrasitteet | Byggnadsservitut | Building easements | 559 | 2018-08-07T14:00:22.397931+03:00 | 4 | 279 | {} | [559] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
561 | [] | Ampumaurheilukeskus | Sportskyttecentrum | Shooting sports centre | 55 | 2018-08-07T14:00:23.299465+03:00 | 4 | 559 | {} | [55] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
284 | [] | Rakennustöiden viranomaisvalvonta | Myndighetstillsyn av byggarbeten | Official oversight of construction work | 560 | 2018-08-07T14:00:22.405256+03:00 | 4 | 279 | {} | [560] | 0 | 1400 | 2 | 6 | 1 | 3 | |||||||||||||||||||||||||||||||
281 | [] | Jatkuva valvonta | Kontinuerlig tillsyn | Continuous monitoring | 562 | 2018-08-07T14:00:22.381961+03:00 | 4 | 279 | {} | [562] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
285 | [] | Rakennusvalvontamittaukset | Byggnadstillsynsmätningar | Building control measurements | 563 | 2018-08-07T14:00:22.411827+03:00 | 4 | 279 | {} | [563] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
291 | [] | Materiaalipalvelut | Materialservice | Material services | 564 | 2018-08-07T14:00:22.451320+03:00 | 4 | 287 | {} | [564] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
930 | [] | päivähoito | dagvård | day care | 569 | 2018-08-07T14:00:28.629796+03:00 | 4 | 929 | {} | [569] | 0 | 1405 | 6 | 6 | |||||||||||||||||||||||||||||||||
700 | [] | Rantautumispaikka | Ilandstigningsplats | Boat dock | 571 | 2018-08-07T14:00:24.275183+03:00 | 4 | 695 | {} | [571] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
638 | [] | Ratagolf | Bangolf | Minigolf course | 573 | 2018-08-07T14:00:23.822729+03:00 | 4 | 634 | {} | [573] | 0 | 1403 | 7 | 18 | 7 | 4 | |||||||||||||||||||||||||||||||
555 | [] | Ratsastuskenttä | Ridbana | Equestrian field | 574 | 2018-08-07T14:00:23.243825+03:00 | 4 | 553 | {} | [574] | 0 | 1403 | 8 | 36 | 20 | 8 | |||||||||||||||||||||||||||||||
556 | [] | Ratsastusmaneesi | Ridmanege | Riding manège | 575 | 2018-08-07T14:00:23.250876+03:00 | 4 | 553 | {} | [575] | 0 | 1403 | 8 | 24 | 10 | 6 | |||||||||||||||||||||||||||||||
557 | [] | Ravirata | Travbana | Horse racing track | 578 | 2018-08-07T14:00:23.257255+03:00 | 4 | 553 | {} | [578] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
713 | [] | Retkeilyalue | Utflyktsområde | Hiking area | 581 | 2018-08-07T14:00:24.359089+03:00 | 4 | 706 | {} | [581] | 0 | 1403 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
590 | [] | Retkeilyreitti | Utflyktsled | Hiking route | 582 | 2018-08-07T14:00:23.482263+03:00 | 4 | 577 | {} | [582] | 0 | 1403 | 4 | 19 | 2 | 8 | 5 | ||||||||||||||||||||||||||||||
661 | [] | Rullakiekkokenttä | Inlinehockeyplan | Roller hockey field | 585 | 2018-08-07T14:00:24.003615+03:00 | 4 | 654 | {} | [585] | 0 | 1403 | 2 | 3 | 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 | ||||||||||||||||||||||||||||
898 | [] | päivähoito | dagvård | day care | 58 | 2018-08-07T14:00:28.442943+03:00 | 4 | 897 | {} | [58] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
1251 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 596*229 | 2018-08-07T14:00:26.727399+03:00 | 4 | 1249 | {} | [596, 229] | 1 | 1087 | 18 | 22 | 4 | ||||||||||||||||||||||||||||||||
1250 | [] | Koulun järjestämät ryhmät | Skolornas grupper | Groups organised by schools | 596*342 | 2018-08-07T14:00:26.719650+03:00 | 4 | 1249 | {} | [596, 342] | 1 | 1087 | 4 | 15 | 11 | ||||||||||||||||||||||||||||||||
1312 | [] | A-ranska | A-franska | A-French | 598*10 | 2018-08-07T14:00:27.175551+03:00 | 4 | 1303 | {} | [598, 10] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1313 | [] | A-saksa | A-tyska | A-German | 598*12 | 2018-08-07T14:00:27.183391+03:00 | 4 | 1303 | {} | [598, 12] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1304 | [] | A-suomi | A-finska | A-Finnish | 598*13 | 2018-08-07T14:00:27.116631+03:00 | 4 | 1303 | {} | [598, 13] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1306 | [] | A-englanti | A-engelska | A-English | 598*4 | 2018-08-07T14:00:27.131698+03:00 | 4 | 1303 | {} | [598, 4] | 1 | 1087 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
1317 | [] | B-englanti | B-engelska | B-English | 598*88 | 2018-08-07T14:00:27.214095+03:00 | 4 | 1303 | {} | [598, 88] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1318 | [] | B-espanja | B-spanska | B-Spanish | 598*89 | 2018-08-07T14:00:27.222850+03:00 | 4 | 1303 | {} | [598, 89] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1319 | [] | B-italia | B-italienska | B-Italian | 598*90 | 2018-08-07T14:00:27.230479+03:00 | 4 | 1303 | {} | [598, 90] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1321 | [] | B-kiina | B-kinesiska | B-Chinese | 598*92 | 2018-08-07T14:00:27.245446+03:00 | 4 | 1303 | {} | [598, 92] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1324 | [] | B-ranska | B-franska | B-French | 598*95 | 2018-08-07T14:00:27.267203+03:00 | 4 | 1303 | {} | [598, 95] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1325 | [] | B-saksa | B-tyska | B-German | 598*97 | 2018-08-07T14:00:27.274071+03:00 | 4 | 1303 | {} | [598, 97] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1315 | [] | B-suomi | B-finska | B-Finnish | 598*98 | 2018-08-07T14:00:27.199171+03:00 | 4 | 1303 | {} | [598, 98] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1326 | [] | B-venäjä | B-ryska | B-Russian | 598*99 | 2018-08-07T14:00:27.281070+03:00 | 4 | 1303 | {} | [598, 99] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1218 | [] | B1-suomi | B1-finska | B1-Finnish | 601*110+602*110 | 2018-10-24T20:00:08.767450+03:00 | 4 | 1193 | {} | [602, 601, 110] | 1 | 1087 | 6 | 6 | |||||||||||||||||||||||||||||||||
1232 | [] | B2-englanti | B2-engelska | B2-English | 601*113+602*113 | 2018-10-24T20:30:09.320105+03:00 | 4 | 1193 | {} | [602, 601, 113] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
1233 | [] | B2-espanja | B2-spanska | B2-Spanish | 601*114+602*114 | 2018-10-25T08:00:08.398971+03:00 | 4 | 1193 | {} | [602, 601, 114] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
1236 | [] | B2-kiina | B2-kinesiska | B2-Chinese | 601*117+602*117 | 2018-10-25T08:00:08.422063+03:00 | 4 | 1193 | {} | [602, 601, 117] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1237 | [] | B2-latina | B2-latin | B2-Latin | 601*118+602*118 | 2018-10-25T08:00:08.428837+03:00 | 4 | 1193 | {} | [602, 601, 118] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1238 | [] | B2-ranska | B2-franska | B2-French | 601*119+602*119 | 2018-10-25T08:00:08.435500+03:00 | 4 | 1193 | {} | [602, 601, 119] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
1239 | [] | B2-saksa | B2-tyska | B2-German | 601*121+602*121 | 2018-10-24T20:30:09.358131+03:00 | 4 | 1193 | {} | [602, 601, 121] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
1240 | [] | B2-venäjä | B2-ryska | B2-Russian | 601*123+602*123 | 2018-10-25T08:00:08.445138+03:00 | 4 | 1193 | {} | [602, 601, 123] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1194 | [] | A1-suomi | A1-finska | A1-Finnish | 601*24+602*24 | 2018-10-25T08:00:08.223234+03:00 | 4 | 1193 | {} | [602, 601, 24] | 1 | 1087 | 21 | 26 | 5 | ||||||||||||||||||||||||||||||||
1208 | [] | A2-englanti | A2-engelska | A2-English | 601*27+602*27 | 2018-10-25T08:00:08.293365+03:00 | 4 | 1193 | {} | [602, 601, 27] | 1 | 1087 | 20 | 25 | 5 | ||||||||||||||||||||||||||||||||
1214 | [] | A2-ranska | A2-franska | A2-French | 601*33+602*33 | 2018-10-24T20:00:08.734794+03:00 | 4 | 1193 | {} | [602, 601, 33] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
1215 | [] | A2-saksa | A2-tyska | A2-German | 601*35+602*35 | 2018-10-24T20:00:08.743668+03:00 | 4 | 1193 | {} | [602, 601, 35] | 1 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
886 | [] | erityisryhmä | specialgrupp | special group | 603*156 | 2018-08-07T14:00:28.367894+03:00 | 4 | 881 | {} | [603, 156] | 0 | 1405 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
964 | [] | Ruotsinkielinen ryhmäperhepäivähoito | Gruppfamiljedagvård på svenska | Group family day care in Swedish | 604 | 2018-08-07T14:00:28.896466+03:00 | 4 | 2145 | {} | [604] | 0 | 1405 | 7 | 11 | 4 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
890 | [] | päivähoito | dagvård | day care | 607 | 2018-08-07T14:00:28.398158+03:00 | 4 | 889 | {} | [607] | 0 | 1405 | 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 | |||||||||||||||||||||||||||||||||
938 | [] | päivähoito | dagvård | day care | 614 | 2018-08-07T14:00:28.681434+03:00 | 4 | 937 | {} | [614] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
619 | [] | Salibandyhalli | Innebandyhall | Floorball hall | 616 | 2018-08-07T14:00:23.680694+03:00 | 4 | 614 | {} | [616] | 0 | 1403 | 4 | 12 | 4 | 4 | |||||||||||||||||||||||||||||||
1252 | [] | Seurakuntien ryhmät | Församlingarnas grupper | Groups organised by parishes | 596*620 | 2018-08-07T14:00:26.734846+03:00 | 4 | 1249 | {} | [620, 596] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
628 | [] | Sisäampumarata | Inomhusskjutbana | Indoor shooting range | 623 | 2018-08-07T14:00:23.753170+03:00 | 4 | 624 | {} | [623] | 0 | 1403 | 5 | 7 | 1 | 1 | |||||||||||||||||||||||||||||||
629 | [] | Sisäkiipeilyseinä | Klättervägg inomhus | Indoor climbing wall | 624 | 2018-08-07T14:00:23.760205+03:00 | 4 | 624 | {} | [624] | 0 | 1403 | 14 | 19 | 3 | 2 | |||||||||||||||||||||||||||||||
610 | [] | Kuntokeskus | Konditionsidrottscentrum | Fitness centre | 625 | 2018-08-07T14:00:23.616327+03:00 | 4 | 608 | {} | [625] | 0 | 1403 | 48 | 97 | 28 | 20 | 1 | ||||||||||||||||||||||||||||||
774 | [] | Siviilivihkiminen | Civil vigsel | Civil marriage | 628 | 2018-08-07T14:00:30.898033+03:00 | 4 | 770 | {} | [628] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
273 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:22.333741+03:00 | 4 | 272 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
652 | [] | Skeitti / rullaluistelupaikka | Plats för skejtning/rullskridskoåkning | Skateboarding/roller-blading rink | 630 | 2018-08-07T14:00:23.929996+03:00 | 4 | 646 | {} | [630] | 0 | 1403 | 27 | 51 | 11 | 12 | 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 );