service_node
360 rows where level = 4 sorted by unit_count_municipality_helsinki
This data as json, CSV (advanced)
Suggested facets: children, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:30.213017+03:00 | 4 | 149 | {} | [803] | 0 | 1401 | 17 | 16 | 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 | ||||||||||||||||||||||||||||||||
235 | [] | Hankepalvelut | Projekttjänster | Project services | 185 | 2018-08-07T14:00:22.084046+03:00 | 4 | 233 | {} | [185] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
250 | [] | Liike- ja toimistotonttien vuokraus ja myynti | Arrendering och försäljning av affärs- och kontorstomter | Leasing and selling of commercial and office plots | 394 | 2018-08-07T14:00:22.168975+03:00 | 4 | 245 | {} | [394] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
251 | [] | Maa-alueiden vuokraus ja myynti | Uthyrning och försäljning av markområden | Selling or renting land areas | 419 | 2018-08-07T14:00:22.176075+03:00 | 4 | 245 | {} | [419] | 0 | 1400 | 17 | 17 | |||||||||||||||||||||||||||||||||
281 | [] | Jatkuva valvonta | Kontinuerlig tillsyn | Continuous monitoring | 562 | 2018-08-07T14:00:22.381961+03:00 | 4 | 279 | {} | [562] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
283 | [] | Rakennusrasitteet | Byggnadsservitut | Building easements | 559 | 2018-08-07T14:00:22.397931+03:00 | 4 | 279 | {} | [559] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
289 | [] | Kaupungin toimitilojen suunnittelu | Planering av stadens lokaliteter | Planning city premises | 266 | 2018-08-07T14:00:22.438154+03:00 | 4 | 287 | {} | [266] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
557 | [] | Ravirata | Travbana | Horse racing track | 578 | 2018-08-07T14:00:23.257255+03:00 | 4 | 553 | {} | [578] | 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 | |||||||||||||||||||||||||||||||||
561 | [] | Ampumaurheilukeskus | Sportskyttecentrum | Shooting sports centre | 55 | 2018-08-07T14:00:23.299465+03:00 | 4 | 559 | {} | [55] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
562 | [] | Jousiammuntamaastorata | Terrängbana för bågskytte. | Field archery course | 212 | 2018-08-07T14:00:23.305715+03:00 | 4 | 559 | {} | [212] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
573 | [] | Kiipeilykallio | Klätterberg | Climbing rock | 306 | 2018-08-07T14:00:23.375633+03:00 | 4 | 572 | {} | [306] | 0 | 1403 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
585 | [] | Maastopyöräilyreitti | Mountainbikeled | Cross-country biking route | 425 | 2018-08-07T14:00:23.448007+03:00 | 4 | 577 | {} | [425] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
586 | [] | Melontareitti | Paddlingsled | Canoe route | 434 | 2018-08-07T14:00:23.454892+03:00 | 4 | 577 | {} | [434] | 0 | 1403 | 1 | 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 | |||||||||||||||||||||||||||||||||
594 | [] | Ampumahiihtokeskus | Skidskyttecentrum | Biathlon centre | 53 | 2018-08-07T14:00:23.509751+03:00 | 4 | 592 | {} | [53] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
596 | [] | Kilpahiihtokeskus | Skidtävlingscentrum | Ski competition centre | 307 | 2018-08-07T14:00:23.524927+03:00 | 4 | 592 | {} | [307] | 0 | 1403 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
600 | [] | Suunnistusalue | Orienteringsområde | Orienteering area | 666 | 2018-08-07T14:00:23.551634+03:00 | 4 | 597 | {} | [666] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
647 | [] | Liikuntapuisto | Idrottspark | Sports park | 401 | 2018-08-07T14:00:23.890605+03:00 | 4 | 646 | {} | [401] | 0 | 1403 | 7 | 3 | 2 | 2 | |||||||||||||||||||||||||||||||
668 | [] | Jokamies- ja rallicross -rata | Allemans- och rallycrossbana | Everyman racing and rallycross track | 208 | 2018-08-07T14:00:24.052754+03:00 | 4 | 667 | {} | [208] | 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 | |||||||||||||||||||||||||||||||||
691 | [] | Kylpylä | Badinrättning | Spa | 361 | 2018-08-07T14:00:24.210042+03:00 | 4 | 690 | {} | [361] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
697 | [] | Laavu, kota tai kammi | Vindskydd eller kåta | Lean-to, goahti (Lapp tent shelter) or 'kammi' earth lodge | 365 | 2018-08-07T14:00:24.250943+03:00 | 4 | 695 | {} | [365] | 0 | 1403 | 4 | 3 | 1 | ||||||||||||||||||||||||||||||||
703 | [] | Tupa | Stuga | Hut | 721 | 2018-08-07T14:00:24.296823+03:00 | 4 | 695 | {} | [721] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
716 | [] | Virkistysmetsä | Friluftsskog | Recreational forest | 791 | 2018-08-07T14:00:24.380867+03:00 | 4 | 706 | {} | [791] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
972 | [] | Venäjänkielinen ryhmäperhepäivähoito | Gruppfamiljedagvård på ryska | Group family day care in Russian | 774 | 2018-08-07T14:00:28.950155+03:00 | 4 | 2145 | {} | [774] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
1272 | [] | A-suomi | A-finska | A-Finnish | 148*13+161*13+300*13+383*13+566*13+611*13+658*13+770*13+792*13 | 2018-10-25T08:00:08.546784+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 13] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1285 | [] | B-englanti | B-engelska | B-English | 148*88+161*88+300*88+383*88+566*88+611*88+658*88+770*88+792*88 | 2018-10-25T08:00:08.650030+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 88] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
2005 | [] | Valtuustotalot | Fullmäktigehus | Council buildings | 744 | 2018-08-07T14:00:30.401425+03:00 | 4 | 173 | {} | [744] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
65 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:21.393701+03:00 | 4 | 62 | {} | [320] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
155 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:30.219845+03:00 | 4 | 149 | {} | [804] | 0 | 1401 | 1 | 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 | |||||||||||||||||||||||||||||||||
161 | [] | Teurastamotilojen vuokraus | Uthyrning av slakterilokaler | Slaughterhouse rental | 706 | 2018-08-07T14:00:30.270249+03:00 | 4 | 156 | {} | [706] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
162 | [] | Vihertukkutilojen vuokraus | Uthyrning av lokaler för grönsaksgrossister | Green wholesale trade space rental | 788 | 2018-08-07T14:00:30.280128+03:00 | 4 | 156 | {} | [788] | 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 | |||||||||||||||||||||||||||||||||
211 | [] | henkilöstökassa | personalkassa | personnel fund | 262 | 2018-08-07T14:00:30.669740+03:00 | 4 | 209 | {} | [262] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
213 | [] | konserniohjaus | koncernstyrning | consolidated corporation guidance | 227 | 2018-08-07T14:00:30.685091+03:00 | 4 | 209 | {} | [227] | 0 | 1401 | 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 | |||||||||||||||||||||||||||||||
234 | [] | Hallintopalvelut | Förvaltningstjänster | Administrative services | 178 | 2020-12-02T12:30:08.656880+02:00 | 4 | 233 | {} | [178] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
249 | [] | Asuntotonttien vuokraus ja myynti | Uthyrning och försäljning av bostadstomter | Selling or renting residential lots | 78 | 2018-08-07T14:00:22.162414+03:00 | 4 | 245 | {} | [78] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
256 | [] | Kauppahallimyyntipaikkojen vuokraus | Uthyrning av försäljningsplatser i saluhallar | Market hall sales location leasing | 258 | 2018-08-07T14:00:22.208042+03:00 | 4 | 255 | {} | [258] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
257 | [] | Torimyyntipaikkojen vuokraus | Uthyrning av torgförsäljningsplatser | Market square vending stall rental | 713 | 2018-08-07T14:00:22.214641+03:00 | 4 | 255 | {} | [713] | 0 | 1400 | 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 | ||||||||||||||||||||||||||||||||
274 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:22.341217+03:00 | 4 | 272 | {} | [146] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
290 | [] | Kilpipalvelut | Skylttjänster | Sign services | 481 | 2018-08-07T14:00:22.444787+03:00 | 4 | 287 | {} | [481] | 0 | 1400 | 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 | ||||||||||||||||||||||||||||||||
295 | [] | Jäteveden puhdistamo | Avloppsreningsverk | Sewage treatment plant | 233 | 2018-08-07T14:00:22.470442+03:00 | 4 | 293 | {} | [233] | 0 | 1400 | 1 | 2 | 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 | ||||||||||||||||||||||||||||||||
303 | [304] | Aluerakentaminen | Områdesbyggandet | Regional construction | 2018-08-07T14:00:22.515802+03:00 | 4 | 302 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
318 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:24.764164+03:00 | 4 | 2147 | {} | [71] | 0 | 1402 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
496 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:22.725829+03:00 | 4 | 493 | {} | [320] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
565 | [] | Harjoitushyppyrimäki | Träningshoppbacke | Ski jumping hill for training | 186 | 2018-08-07T14:00:23.324523+03:00 | 4 | 564 | {} | [186] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
568 | [] | Curlingrata | Curlingbana | Curling sheet | 129 | 2018-08-07T14:00:23.345064+03:00 | 4 | 567 | {} | [129] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
569 | [] | Hiihtotunneli | Skidtunnel | Ski tunnel | 194 | 2018-08-07T14:00:23.351595+03:00 | 4 | 567 | {} | [194] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
580 | [] | Koirahiihtolatu | Spår för hundspann | Dog skijoring track | 318 | 2018-08-07T14:00:23.413028+03:00 | 4 | 577 | {} | [318] | 0 | 1403 | 1 | 4 | 3 | ||||||||||||||||||||||||||||||||
618 | [] | Petanque - halli | Petanquehall | Petanque hall | 512 | 2018-08-07T14:00:23.673008+03:00 | 4 | 614 | {} | [512] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
626 | [] | Parkour- Sali | Parkoursal | Parkour hall | 500 | 2018-08-07T14:00:23.737371+03:00 | 4 | 624 | {} | [500] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
635 | [] | Golfin harjoitusalue | Träningsområde för golf | Golf training area | 173 | 2018-08-07T14:00:23.802245+03:00 | 4 | 634 | {} | [173] | 0 | 1403 | 1 | 6 | 3 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
651 | [] | Pyöräilyrata | Cykelåkningsbana | Velodrome | 539 | 2018-08-07T14:00:23.920549+03:00 | 4 | 646 | {} | [539] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
656 | [] | Jalkapallostadion | Fotbollsstadion | Football stadium | 205 | 2018-08-07T14:00:23.964244+03:00 | 4 | 654 | {} | [205] | 0 | 1403 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
676 | [] | Urheiluilmailualue | Område för flygsport | Sport aviation area | 739 | 2018-08-07T14:00:24.108363+03:00 | 4 | 675 | {} | [739] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
681 | [] | Soudun ja melonnan sisäharjoittelutila | Inomhusträningsutrymme för rodd och paddling | Indoor training facility for rowing and canoeing | 642 | 2018-08-07T14:00:24.143385+03:00 | 4 | 677 | {} | [642] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
696 | [] | Kalastusalue / -paikka | Område eller plats för fiske | Fishing area/spot | 240 | 2018-08-07T14:00:24.243549+03:00 | 4 | 695 | {} | [240] | 0 | 1403 | 1 | 26 | 19 | 2 | 4 | ||||||||||||||||||||||||||||||
698 | [] | Luontotorni | Naturtorn | Nature observation tower | 414 | 2018-08-07T14:00:24.259792+03:00 | 4 | 695 | {} | [414] | 0 | 1403 | 1 | 12 | 1 | 10 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
761 | [] | Lautakunnat ja johtokunnat | Nämnder och direktioner | Committees and boards | 386 | 2018-08-07T14:00:30.800171+03:00 | 4 | 757 | {} | [386] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
762 | [] | Valtuustoryhmät, kansalaislähetystöt | Stadsfullmäktigegrupper, medborgardelegationer | Council groups, public delegations | 743 | 2018-08-07T14:00:30.809629+03:00 | 4 | 757 | {} | [743] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
764 | [] | Keskusvaalilautakunta | Centralvalnämnd | Central Election Committee | 290 | 2018-08-07T14:00:30.827173+03:00 | 4 | 763 | {} | [290] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
771 | [] | Avioehto | Äktenskapsförord | Prenuptial agreement | 82 | 2018-08-07T14:00:30.878414+03:00 | 4 | 770 | {} | [82] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
774 | [] | Siviilivihkiminen | Civil vigsel | Civil marriage | 628 | 2018-08-07T14:00:30.898033+03:00 | 4 | 770 | {} | [628] | 0 | 1401 | 1 | 2 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
922 | [] | päivähoito | dagvård | day care | 188 | 2018-08-07T14:00:28.579608+03:00 | 4 | 921 | {} | [188] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1162 | [] | B2-italia | B2-italienska | B2-Italian | 149*116+150*116+162*116+163*116+301*116+302*116+384*116+385*116+567*116+568*116+612*116+613*116+661*116+662*116+771*116+772*116+793*116+794*116+865*116+866*116 | 2018-10-25T08:00:08.055251+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 116] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 |
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 );