service_node
939 rows where "last_modified_time" is on date 2018-08-07 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: level, keywords, 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_mäntsälä, unit_count_municipality_hyvinkää, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava, unit_count_municipality_karkkila
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2174 | [] | Baarit ja yöelämä | Barer och nattliv | Bars and nightlife | 869 | 2018-08-07T14:00:24.408116+03:00 | 3 | 718 | {} | [869] | 0 | 1403 | 179 | 181 | 2 | ||||||||||||||||||||||||||||||||
2173 | [] | Tapahtumapaikat | Evenemangsplatser | Venues | 868 | 2018-08-07T14:00:24.624759+03:00 | 2 | 717 | {} | [868] | 0 | 1403 | 195 | 211 | 10 | 6 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2168 | [] | Hyvän olon palvelut | Välbefinnandetjänster | Well-being services | 864 | 2018-08-07T14:00:24.617742+03:00 | 3 | 718 | {} | [864] | 0 | 1403 | 34 | 37 | 1 | 2 | |||||||||||||||||||||||||||||||
2167 | [] | Opiskeluterveydenhuolto | Studenthälsovård | Student health care | 863 | 2018-08-07T14:00:27.627209+03:00 | 3 | 1373 | {} | [863] | 0 | 1087 | 81 | 154 | 2 | 68 | 3 | ||||||||||||||||||||||||||||||
2166 | [] | Opiskeluterveydenhuolto | Studenthälsovård | Student health care | 863 | 2018-08-07T14:00:29.213565+03:00 | 2 | 997 | {} | [863] | 0 | 986 | 81 | 154 | 2 | 68 | 3 | ||||||||||||||||||||||||||||||
2165 | [] | Kouluterveydenhuolto | Skolhälsovård | School health care | 339 | 2018-08-07T14:00:27.619794+03:00 | 3 | 1373 | {} | [339] | 0 | 1087 | 160 | 236 | 1 | 1 | 68 | 1 | 5 | ||||||||||||||||||||||||||||
2164 | [] | Kouluterveydenhuolto | Skolhälsovård | School health care | 339 | 2018-08-07T14:00:29.207544+03:00 | 2 | 997 | {} | [339] | 0 | 986 | 160 | 236 | 1 | 1 | 68 | 1 | 5 | ||||||||||||||||||||||||||||
2163 | [] | Päiväkotiruokailu | Daghem måltider | Day care centre meals | 860 | 2018-08-07T14:00:29.039470+03:00 | 1 | 1405 | {} | [860] | 0 | 1405 | 274 | 274 | |||||||||||||||||||||||||||||||||
2162 | [] | Digitaalinen nuorisotyö | Digital ungdomsarbete | Digital youth work | 859 | 2018-08-07T14:00:23.214339+03:00 | 2 | 365 | {} | [859] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
2161 | [] | Palliatiivinen hoito | Palliativ vård | Palliative care | 858 | 2018-08-07T14:00:29.377630+03:00 | 2 | 1009 | {} | [858] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
2160 | [] | Mielenterveyskuntoutujien asumispalvelut | Boendetjänster för klienter inom psykrehabilitering | Residential services for mental health rehabilitation clients | 857 | 2018-08-07T14:00:28.137962+03:00 | 2 | 845 | {} | [857] | 0 | 783 | 6 | 14 | 8 | ||||||||||||||||||||||||||||||||
2159 | [] | Teknisten ja ympäristöpalvelujen neuvonta | Rådgivning om teknisk och miljötjänster | Information and advice of technical and environmental services | 856 | 2018-08-07T14:00:24.779960+03:00 | 3 | 314 | {} | [856] | 0 | 1402 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2158 | [] | Tuki digipelaamisen ja netin liikakäytön ongelmiin | Stöd för överanvändningsproblem av digitala spel och internet | Support for digital gaming and internet over-use problems | 855 | 2018-08-07T14:00:29.751405+03:00 | 2 | 1051 | {} | [855] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
2157 | [] | Tuki digipelaamisen ja netin liikakäytön ongelmiin | Stöd för överanvändningsproblem av digitala spel och internet | Support for digital gaming and internet over-use problems | 855 | 2018-08-07T14:00:28.074000+03:00 | 2 | 830 | {} | [855] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
2156 | [] | Etsivä nuorisotyö | Uppsökande ungdomsarbete | Detective youth work | 854 | 2018-08-07T14:00:23.208137+03:00 | 2 | 365 | {} | [854] | 0 | 1403 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
2155 | [] | Kasvitarha | Köksträdgård | Kitchen garden | 853 | 2018-08-07T14:00:22.969353+03:00 | 3 | 368 | {} | [853] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2154 | [] | Teatteri | Teater | Theatre | 852 | 2018-08-07T14:00:23.169545+03:00 | 3 | 368 | {} | [852] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2153 | [] | Kosketusnäyttöopasteet | Infokiosker med pekskärm | Touch screen guideposts | 851 | 2018-08-07T14:00:24.869369+03:00 | 3 | 329 | {} | [851] | 0 | 1403 | 21 | 21 | |||||||||||||||||||||||||||||||||
2152 | [] | Julkishallinnon talousarviot | Budgetar inom den offentliga förvaltningen | Public administration budgets | 850 | 2018-08-07T14:00:30.564290+03:00 | 3 | 197 | {} | [850] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
2151 | [] | Liikunnan sähköinen asiointi ja lomakkeet | Elektroniska tjänster och formulär för motion | Electronic services and forms related to sports | 849 | 2018-08-07T14:00:24.387923+03:00 | 2 | 551 | {} | [849] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2150 | [] | Tietotekniikkaneuvonta opiskelijoille | IT rådgivning för studenter | IT consultancy for students | 848 | 2018-08-07T14:00:24.978309+03:00 | 4 | 2149 | {} | [848] | 0 | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
2149 | [2150] | Tietotekniikkaneuvonta | IT rådgivning | IT consultancy | 2018-08-07T14:00:24.972880+03:00 | 3 | 329 | {} | [] | 0 | 1402 | 2 | 2 | ||||||||||||||||||||||||||||||||||
2148 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:24.771984+03:00 | 4 | 2147 | {} | [199] | 0 | 1402 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
2147 | [2148, 318] | 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:24.757653+03:00 | 3 | 314 | {} | [] | 0 | 1402 | 1 | 13 | 1 | 3 | 8 | |||||||||||||||||||||||||||||||
2146 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:29.136711+03:00 | 2 | 988 | {} | [199] | 0 | 986 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2144 | [] | Vesibussilaiturit | Vattenbussbryggor | Water bus platforms | 776 | 2018-08-07T14:00:25.224191+03:00 | 4 | 542 | {} | [776] | 0 | 1402 | 3 | 3 | |||||||||||||||||||||||||||||||||
2143 | [] | Venekerhojen venepaikat | Båtklubbarnas båtplatser | Boat parking for yacht clubs | 847 | 2018-08-07T14:00:25.248772+03:00 | 4 | 547 | {} | [847] | 0 | 1402 | 1 | 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 | ||||||||||||||||||||||||||||
2138 | [] | Ammatillisen koulutuksen neuvonta | Kundbetjäning och rådgivning (yrkesutbildning) | Customer service and information (vocational education and training) | 68 | 2018-08-07T14:00:24.750620+03:00 | 4 | 317 | {} | [68] | 0 | 1402 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
2137 | [] | Lukiokoulutuksen neuvonta | Kundbetjäning och rådgivning (gymnasieutbildning) | Customer service and information (general upper secondary education) | 69 | 2018-08-07T14:00:24.743644+03:00 | 4 | 317 | {} | [69] | 0 | 1402 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2136 | [] | Perusopetuksen neuvonta | Kundbetjäning och rådgivning (grundläggande utbildning) | Customer service and information (basic education) | 70 | 2018-08-07T14:00:24.736470+03:00 | 4 | 317 | {} | [70] | 0 | 1402 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2135 | [] | Lasten päivähoidon neuvonta | Kundbetjäning och rådgivning (barndagvård) | Customer service and information (child day care) | 844 | 2018-08-07T14:00:24.729525+03:00 | 4 | 317 | {} | [844] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
2134 | [] | Leikkipuiston järjestämät ryhmät | Lekparkernas grupper | Groups organised by playgrounds | 341 | 2018-08-07T14:00:26.223904+03:00 | 4 | 1181 | {} | [341] | 1 | 1087 | 54 | 56 | 2 | ||||||||||||||||||||||||||||||||
2126 | [2127, 2128, 2129] | Ruotsinkielinen esiopetus | Förskoleundervisning på svenska | Pre-primary education in Swedish | 862 | 2018-08-07T14:00:29.080400+03:00 | 2 | 2118 | {} | [862] | 1 | 1405 | 31 | 46 | 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 | ||||||||||||||||||||||||||||||||
2080 | [] | Lasten päivähoidon neuvonta | Kundbetjäning och rådgivning (barndagvård) | Customer service and information (child day care) | 844 | 2018-08-07T14:00:27.666416+03:00 | 2 | 1378 | {} | [844] | 0 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
2061 | [] | Seurakuntien ryhmät | Församlingarnas grupper | Groups organised by parishes | 596*620 | 2018-08-07T14:00:25.434875+03:00 | 3 | 2056 | {} | [620, 596] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
2060 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 596*229 | 2018-08-07T14:00:25.427391+03:00 | 3 | 2056 | {} | [596, 229] | 1 | 1087 | 18 | 22 | 4 | ||||||||||||||||||||||||||||||||
2057 | [] | Koulun järjestämät ryhmät | Skolornas grupper | Groups organised by schools | 596*342 | 2018-08-07T14:00:25.406504+03:00 | 3 | 2056 | {} | [596, 342] | 1 | 1087 | 4 | 15 | 11 | ||||||||||||||||||||||||||||||||
2056 | [2060, 2057, 2061] | Ruotsinkielinen iltapäivätoiminta | Eftermiddagsverksamhet på svenska | Afternoon activities in Swedish | 596 | 2018-08-07T14:00:25.399596+03:00 | 2 | 2042 | {} | [596] | 1 | 1087 | 24 | 39 | 11 | 4 | |||||||||||||||||||||||||||||||
2055 | [] | Autististen ja kehitysvammaisten ryhmät | Grupper för autistiska och utvecklingsstörda | Groups for autistic and mentally handicapped | 656*80 | 2018-08-07T14:00:25.392562+03:00 | 3 | 2049 | {} | [656, 80] | 1 | 1087 | 33 | 33 | |||||||||||||||||||||||||||||||||
2054 | [] | Seurakuntien ryhmät | Församlingarnas grupper | Groups organised by parishes | 656*620 | 2018-08-07T14:00:25.385536+03:00 | 3 | 2049 | {} | [656, 620] | 1 | 1087 | 18 | 18 | |||||||||||||||||||||||||||||||||
2053 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 656*229 | 2018-08-07T14:00:25.378466+03:00 | 3 | 2049 | {} | [656, 229] | 1 | 1087 | 105 | 105 | |||||||||||||||||||||||||||||||||
2050 | [] | Koulun järjestämät ryhmät | Skolornas grupper | Groups organised by schools | 656*342 | 2018-08-07T14:00:25.355697+03:00 | 3 | 2049 | {} | [656, 342] | 1 | 1087 | 28 | 28 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2040 | [] | Kirjastoautopalvelut | Bokbussar | Mobile libraries | 312 | 2018-08-07T14:00:24.837192+03:00 | 3 | 324 | {} | [312] | 0 | 1402 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
2029 | [] | Lasten päivähoidon neuvonta | Kundbetjäning och rådgivning (barndagvård) | Customer service and information (child day care) | 844 | 2018-08-07T14:00:28.251638+03:00 | 2 | 868 | {} | [844] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
2028 | [] | Tapahtumien järjestäminen | Anordnande av evenemang | Organising events | 845 | 2018-08-07T14:00:24.640373+03:00 | 2 | 717 | {} | [845] | 0 | 1403 | 2 | 6 | 3 | 1 | |||||||||||||||||||||||||||||||
2026 | [] | Kirjastoautopalvelut | Bokbussar | Mobile libraries | 312 | 2018-08-07T14:00:22.565354+03:00 | 3 | 345 | {} | [312] | 0 | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
2023 | [] | Varastotilojen vuokraus | Uthyrning av lagerlokaler | Storage space rental | 765 | 2018-08-07T14:00:22.286375+03:00 | 5 | 265 | {} | [765] | 0 | 1400 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
2022 | [] | Tuotantotilojen vuokraus | Uthyrning av produktionslokaler | Production facility rental | 718 | 2018-08-07T14:00:22.279273+03:00 | 5 | 265 | {} | [718] | 0 | 1400 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
2021 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:22.272146+03:00 | 5 | 265 | {} | [393] | 0 | 1400 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
2014 | [] | Valmistava opetus luokille 1-2 (maahanmuuttajat) | Förberedande undervisning för årskurserna 1-2 (invandrare) | Preparatory education for grades 1-2 (immigrants) | 843 | 2018-08-07T14:00:25.463637+03:00 | 3 | 1098 | {} | [843] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
2012 | [] | Täydentävä toimeentulotuki | Kompletterande utkomststöd | Supplementary social assistance | 841 | 2018-08-07T14:00:28.105801+03:00 | 2 | 839 | {} | [841] | 0 | 783 | 7 | 9 | 1 | 1 | |||||||||||||||||||||||||||||||
2011 | [] | Ehkäisevä toimeentulotuki | Förebyggande utkomststöd | Preventive social assistance | 840 | 2018-08-07T14:00:28.099014+03:00 | 2 | 839 | {} | [840] | 0 | 783 | 7 | 8 | 1 | ||||||||||||||||||||||||||||||||
2009 | [] | Koiraurheiluhalli | Hundsporthall | Dog sports hall | 323 | 2018-08-07T14:00:23.274980+03:00 | 4 | 2007 | {} | [323] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2008 | [] | Koiraurheilualue | Område för hundsport | Dog sports area | 322 | 2018-08-07T14:00:23.268249+03:00 | 4 | 2007 | {} | [322] | 0 | 1403 | 7 | 10 | 3 | ||||||||||||||||||||||||||||||||
2007 | [2008, 2009] | Koiraurheilu | Hundsport | Dog sports | 2018-08-07T14:00:23.263114+03:00 | 3 | 552 | {} | [] | 0 | 1403 | 8 | 11 | 3 | |||||||||||||||||||||||||||||||||
2006 | [] | Veistokset ja julkinen taide | Skulpturer och offentlig konst | Sculptures and public art | 767 | 2018-08-07T14:00:22.854537+03:00 | 2 | 343 | {"fi": ["patsas", "patsaat", "veistos"]} | [767] | 0 | 1403 | 482 | 488 | 6 | ||||||||||||||||||||||||||||||||
2005 | [] | Valtuustotalot | Fullmäktigehus | Council buildings | 744 | 2018-08-07T14:00:30.401425+03:00 | 4 | 173 | {} | [744] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
2004 | [] | Hallinnolliset toimipisteet | Administrativa ämbetsverk | Administrative offices | 271 | 2018-08-07T14:00:30.391457+03:00 | 4 | 173 | {} | [271] | 0 | 1401 | 55 | 65 | 1 | 1 | 7 | 1 | |||||||||||||||||||||||||||||
2003 | [] | Kaupungintalot | Stadshus | City halls | 270 | 2018-08-07T14:00:30.383310+03:00 | 4 | 173 | {} | [270] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
2002 | [] | Viestintä | Kommunikation | Communications | 488 | 2018-08-07T14:00:30.436273+03:00 | 3 | 172 | {} | [488] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
2001 | [] | Turvallisuus- ja valmiussuunnittelu | Säkerhets- och beredskapsplanering | Safety and preparedness planning | 226 | 2018-08-07T14:00:30.429227+03:00 | 3 | 172 | {} | [226] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | |||||||||||||||||
1382 | [] | Hallinto | Förvaltning | Administration | 179 | 2018-08-07T14:00:27.693663+03:00 | 1 | 1087 | {} | [179] | 0 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
1381 | [] | Ammatillisen koulutuksen neuvonta | Kundbetjäning och rådgivning (yrkesutbildning) | Customer service and information (vocational education and training) | 68 | 2018-08-07T14:00:27.686734+03:00 | 2 | 1378 | {} | [68] | 0 | 1087 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
1380 | [] | Lukiokoulutuksen neuvonta | Kundbetjäning och rådgivning (gymnasieutbildning) | Customer service and information (general upper secondary education) | 69 | 2018-08-07T14:00:27.679921+03:00 | 2 | 1378 | {} | [69] | 0 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1379 | [] | Perusopetuksen neuvonta | Kundbetjäning och rådgivning (grundläggande utbildning) | Customer service and information (basic education) | 70 | 2018-08-07T14:00:27.673059+03:00 | 2 | 1378 | {} | [70] | 0 | 1087 | 1 | 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 | |||||||||||||||||||||||||||||||||
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 | {} | [485] | 0 | 1087 | 4 | 15 | 1 | 7 | 2 | 1 | |||||||||||||||||||||||||||||
1375 | [] | Koulupsykologi | Skolpsykolog | School psychologist | 343 | 2018-08-07T14:00:27.641064+03:00 | 2 | 1372 | {} | [343] | 0 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1374 | [] | Koulukuraattori | Skolkurator | School social worker | 340 | 2018-08-07T14:00:27.634259+03:00 | 2 | 1372 | {} | [340] | 0 | 1087 | 71 | 66 | 5 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
1359 | [] | Yliopistot | Universitet | Universities | 822 | 2018-08-07T14:00:27.510881+03:00 | 1 | 1087 | {} | [822] | 0 | 1087 | 10 | 60 | 50 | ||||||||||||||||||||||||||||||||
1357 | [] | Suomenkielinen ammattikorkeakoulukoulutus | Yrkeshögskoleutbildning på finska | Polytechnic education in Finnish | 654 | 2018-08-07T14:00:27.490338+03:00 | 2 | 1356 | {} | [654] | 0 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1356 | [1357] | Ammattikorkeakoulut | Yrkeshögskolor | Polytechnics | 654 | 2018-08-07T14:00:27.483584+03:00 | 1 | 1087 | {} | [654] | 0 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1355 | [] | Ruotsinkielinen oppisopimuskoulutus | Läroavtalsutbildning på svenska | Apprenticeship training in Swedish | 599 | 2018-08-07T14:00:27.476430+03:00 | 2 | 1353 | {} | [599] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1354 | [] | Suomenkielinen oppisopimuskoulutus | Läroavtalsutbildning på finska | Apprenticeship training in Finnish | 659 | 2018-08-07T14:00:27.469481+03:00 | 2 | 1353 | {} | [659] | 1 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1353 | [1355, 1354] | Oppisopimuskoulutus | Läroavtalsutbildning | Apprenticeship training | 2018-08-07T14:00:27.464000+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 1 | 2 | 1 | |||||||||||||||||||||||||||||||||
1347 | [] | Aikuisten peruskouluaineiden opetus | Undervisning i grundskolans läroämnen för vuxna | Education on comprehensive school subjects for adults | 591 | 2018-08-07T14:00:27.426296+03:00 | 3 | 1343 | {} | [591] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1346 | [] | Aikuisten lukioaineiden opetus | Undervisning i gymnasiets läroämnen för vuxna | Education on upper secondary school subjects for adults | 589 | 2018-08-07T14:00:27.419564+03:00 | 3 | 1343 | {} | [589] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1345 | [] | Aikuisten peruskoulutus | Grundläggande utbildning för vuxna | Basic education for adults | 592 | 2018-08-07T14:00:27.412986+03:00 | 3 | 1343 | {} | [592] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1344 | [] | Aikuisten lukiokoulutus | Gymnasieutbildning för vuxna | Upper secondary school education for adults | 590 | 2018-08-07T14:00:27.406024+03:00 | 3 | 1343 | {} | [590] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1343 | [1346, 1344, 1347, 1345] | Ruotsinkielinen aikuisten perus- ja lukiokoulutus | Grundläggande utbildning och gymnasieutbildning för vuxna på svenska | Comprehensive and upper secondary school education for adults in Swedish | 2018-08-07T14:00:27.400544+03:00 | 2 | 1335 | {} | [] | 0 | 1087 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1342 | [] | Kaksoistutkinto | Dubbel gymnasieexamen | Upper secondary school dual qualification | 408 | 2018-08-07T14:00:27.393475+03:00 | 3 | 1336 | {} | [408] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1341 | [] | Aikuisten peruskouluaineiden opetus | Undervisning i grundskolans läroämnen för vuxna | Education on comprehensive school subjects for adults | 651 | 2018-08-07T14:00:27.386151+03:00 | 3 | 1336 | {} | [651] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1340 | [] | Aikuisten lukioaineiden opetus | Undervisning i gymnasiets läroämnen för vuxna | Education on upper secondary school subjects for adults | 649 | 2018-08-07T14:00:27.379870+03:00 | 3 | 1336 | {} | [649] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1338 | [] | Aikuisten peruskoulutus | Grundläggande utbildning för vuxna | Basic education for adults | 652 | 2018-08-07T14:00:27.364989+03:00 | 3 | 1336 | {} | [652] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1337 | [] | Aikuisten lukiokoulutus | Gymnasieutbildning för vuxna | Upper secondary school education for adults | 650 | 2018-08-07T14:00:27.357192+03:00 | 3 | 1336 | {} | [650] | 1 | 1087 | 2 | 7 | 2 | 3 | |||||||||||||||||||||||||||||||
1335 | [1343, 1336] | Aikuiskoulutus | Vuxenutbildning | Adult education | 2018-08-07T14:00:27.345252+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 5 | 11 | 2 | 3 | 1 | |||||||||||||||||||||||||||||||
1334 | [] | Nuorten työpajatoiminta | Ungdomsverkstäder | Workshops for the young | 472 | 2018-08-07T14:00:27.336955+03:00 | 1 | 1087 | {} | [472] | 1 | 1087 | 9 | 17 | 8 | ||||||||||||||||||||||||||||||||
1328 | [] | Painotettu lukio | Gymnasium med betoning | Specialised upper secondary school | 598*493 | 2018-08-07T14:00:27.295727+03:00 | 3 | 1298 | {} | [598, 493] | 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 | |||||||||||||||||||||||||||||||||
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 |
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 );