service_node
383 rows where level = 3 sorted by unit_count_municipality_vantaa
This data as json, CSV (advanced)
Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | [] | Kaupungin asumisoikeusasunnot | stadens bostadsrättsbostäder | City's right of residence apartments | 261 | 2018-08-07T14:00:21.255121+03:00 | 3 | 5 | {} | [261] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 9 | [] | Kaupungin tai kunnan vuokra-asunnot | Stadens eller kommunens hyresbostäder | City's or municipality's rental apartments | 268 | 2018-08-07T14:00:21.273119+03:00 | 3 | 8 | {} | [268] | 0 | 1400 | 9 | 12 | 2 | 1 | |||||||||||||||||||||||||||||||
| 10 | [] | Kaupungin tai kunnan työsuhdeasunnot | Stadens eller kommunens tjänstebostäder | City's or municipality's housing provided by the employer | 267 | 2018-08-07T14:00:21.280357+03:00 | 3 | 8 | {} | [267] | 0 | 1400 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 11 | [] | Opiskelija-asunnot | Studentbostäder | Student housing | 484 | 2018-08-07T14:00:21.287386+03:00 | 3 | 8 | {} | [484] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 18 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:21.700490+03:00 | 3 | 16 | {} | [319] | 0 | 1400 | 5 | 5 | |||||||||||||||||||||||||||||||||
| 19 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:21.707130+03:00 | 3 | 16 | {} | [320] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 21 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:21.719558+03:00 | 3 | 16 | {} | [480] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 61 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:21.361137+03:00 | 3 | 60 | {} | [238] | 0 | 1400 | 49 | 49 | |||||||||||||||||||||||||||||||||
| 71 | [] | Viheralueet | Grönområden | Green areas | 786 | 2018-08-07T14:00:21.432517+03:00 | 3 | 60 | {} | [786] | 0 | 1400 | 51 | 102 | 1 | 50 | |||||||||||||||||||||||||||||||
| 72 | [] | Viheralueiden hoito | Skötsel av grönområden | Green area maintenance | 787 | 2020-12-02T11:30:08.056281+02:00 | 3 | 60 | {} | [787] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 79 | [] | Tierakenteiden tiiviys- ja kantavuusmittaus | Mätning av vägkonstruktioners täthet och bärkraft | Measuring the solidity and bearing capacity of road constructions | 707 | 2018-08-07T14:00:21.481992+03:00 | 3 | 74 | {} | [707] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 81 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:21.499406+03:00 | 3 | 80 | {} | [259] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 82 | [] | Kirpputorit | Lopptorg | Flea markets | 315 | 2018-08-07T14:00:21.505503+03:00 | 3 | 80 | {} | [315] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 83 | [] | Markkinat | Marknader | Markets | 427 | 2018-08-07T14:00:21.511515+03:00 | 3 | 80 | {} | [427] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 84 | [] | Torit | Torg | Market squares | 714 | 2018-08-07T14:00:21.493235+03:00 | 3 | 80 | {} | [714] | 0 | 1400 | 15 | 15 | |||||||||||||||||||||||||||||||||
| 96 | [] | Luontokoulu | Miljöcentralens naturskola | Nature school | 412 | 2018-08-07T14:00:21.529831+03:00 | 3 | 95 | {} | [412] | 0 | 1400 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
| 98 | [] | Metsät | Skogar | Forests | 438 | 2020-12-02T12:30:08.292275+02:00 | 3 | 97 | {} | [438] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 109 | [] | Sisätilojen tuholaiset | Inomhus skadedjur | Interior pests | 626 | 2018-08-07T14:00:21.605181+03:00 | 3 | 103 | {} | [626] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 119 | [] | Sisäympäristö | Inomhusmiljö | Indoor environment | 627 | 2018-08-07T14:00:21.660811+03:00 | 3 | 116 | {} | [627] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 135 | [] | Kaupungin tai kunnan vuokra-asunnot | Stadens eller kommunens hyresbostäder | City's or municipality's rental apartments | 268 | 2018-08-07T14:00:30.087071+03:00 | 3 | 134 | {} | [268] | 0 | 1401 | 9 | 12 | 2 | 1 | |||||||||||||||||||||||||||||||
| 136 | [] | Kaupungin tai kunnan työsuhdeasunnot | Stadens eller kommunens tjänstebostäder | City's or municipality's housing provided by the employer | 267 | 2018-08-07T14:00:30.094025+03:00 | 3 | 134 | {} | [267] | 0 | 1401 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 142 | [] | Elinkeinomarkkinointi | Näringslivmarknadsföring | Business marketing | 133 | 2018-08-07T14:00:30.132324+03:00 | 3 | 141 | {} | [133] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 176 | [] | Postipalvelut | Posttjänster | Postal services | 224 | 2018-08-07T14:00:30.419580+03:00 | 3 | 172 | {} | [224] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 182 | [] | Henkilöstöpolitiikka ja -strategia | Personalpolitik och -strategi | Personnel policy and strategy | 220 | 2018-08-07T14:00:30.473352+03:00 | 3 | 180 | {} | [220] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 185 | [] | Rekrytointi | Rekrytering | Recruitment | 225 | 2018-08-07T14:00:30.493982+03:00 | 3 | 180 | {} | [225] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 192 | [] | 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.528561+03:00 | 3 | 191 | {} | [274] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 198 | [199, 200, 201, 202, 203, 204, 205, 206, 207, 208] | Taloushallinto | Ekonomiförvaltning | Financial administration | 487 | 2018-08-07T14:00:30.570887+03:00 | 3 | 197 | {} | [487] | 0 | 1401 | 8 | 8 | |||||||||||||||||||||||||||||||||
| 209 | [210, 211, 213] | Varainhallinta | Finansförvaltning | Assets management | 2018-08-07T14:00:30.654818+03:00 | 3 | 197 | {} | [] | 0 | 1401 | 3 | 3 | ||||||||||||||||||||||||||||||||||
| 217 | [] | Sisäinen tarkastus | Intern revision | Internal auditing | 176 | 2018-08-07T14:00:30.706266+03:00 | 3 | 216 | {} | [176] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 218 | [] | Ulkoinen tarkastus | Extern revision | External auditing | 177 | 2018-08-07T14:00:30.714388+03:00 | 3 | 216 | {} | [177] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 230 | [] | Viestintä ja vuorovaikutus | Kommunikation och påverkan | Communications and interaction | 785 | 2018-08-07T14:00:22.052241+03:00 | 3 | 222 | {} | [785] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 232 | [] | Energia-avustukset | energiunderstöd | energy grants | 144 | 2018-08-07T14:00:22.065643+03:00 | 3 | 231 | {} | [144] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 238 | [] | Hissiprojekti | Anskaffning av hissar (gamla höghus) | Lift procurement (old residential buildings) | 195 | 2018-08-07T14:00:22.097017+03:00 | 3 | 231 | {} | [195] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 240 | [] | Kiinteistöhuolto ja isännöinti | Fastighetsunderhåll och -förvaltning | Janitorial and landlord services | 303 | 2018-08-07T14:00:22.109816+03:00 | 3 | 231 | {} | [303] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 244 | [] | Lainhuuto | Lagfart | Registration of title to property | 367 | 2018-08-07T14:00:22.136957+03:00 | 3 | 231 | {} | [367] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 253 | [] | Nuohous | Sotning | Chimney sweeping | 467 | 2018-08-07T14:00:22.189946+03:00 | 3 | 231 | {} | [467] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 254 | [] | Siivouspalvelut | Städningsservice | Cleaning services | 621 | 2018-08-07T14:00:22.196172+03:00 | 3 | 231 | {} | [621] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 278 | [] | Korjausrakentaminen | Renovering | Renovation construction | 333 | 2018-08-07T14:00:22.369873+03:00 | 3 | 270 | {} | [333] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 286 | [] | Rakentamisen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter i byggärenden | Electronic services and forms related to construction | 565 | 2018-08-07T14:00:22.418594+03:00 | 3 | 270 | {} | [565] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 293 | [295, 296, 299, 301] | Vesihuolto | Vattenförsörjning | Water services | 2018-08-07T14:00:22.465138+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 30 | 32 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 302 | [303] | Yhdyskuntarakentaminen | Samhällsbyggnad | Civil engineering | 2018-08-07T14:00:22.510499+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
| 308 | [] | Asemakaava-arkisto | Detaljplanearkiv | Town plan archive | 60 | 2018-08-07T14:00:24.662512+03:00 | 3 | 307 | {} | [60] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 312 | [] | Rakennusvalvonnan arkisto | Byggnadstillsynsverkets arkiv | Building Control archive | 561 | 2018-08-07T14:00:24.689378+03:00 | 3 | 307 | {} | [561] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 313 | [] | Katu-, puisto- ja rakennuspiirustusten arkisto | Arkiv för gatu-, park- och byggnadsritningar | Public works department archive | 250 | 2018-08-07T14:00:24.696359+03:00 | 3 | 307 | {} | [250] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 317 | [2138, 2135, 2137, 2136] | Kasvatuksen ja koulutuksen neuvonta | Rådgivning om fostran och utbildning | Day care and education information and advice | 2018-08-07T14:00:24.723868+03:00 | 3 | 314 | {} | [] | 0 | 1402 | 4 | 6 | 2 | |||||||||||||||||||||||||||||||||
| 325 | [] | Erikoiskirjastot | Specialbibliotek | Special libraries | 155 | 2018-08-07T14:00:24.829787+03:00 | 3 | 324 | {"fi": ["kirjastot"]} | [155] | 0 | 1402 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
| 327 | [] | Laitoskirjastot | Anstaltsbibliotek | Institutional libraries | 368 | 2018-08-07T14:00:24.845380+03:00 | 3 | 324 | {} | [368] | 0 | 1402 | 8 | 8 | |||||||||||||||||||||||||||||||||
| 346 | [] | Erikoiskirjastot | Specialbibliotek | Special libraries | 155 | 2018-08-07T14:00:22.558572+03:00 | 3 | 345 | {"fi": ["kirjastot"]} | [155] | 0 | 1403 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
| 348 | [] | Laitoskirjastot | Anstaltsbibliotek | Institutional libraries | 368 | 2018-08-07T14:00:22.571974+03:00 | 3 | 345 | {} | [368] | 0 | 1403 | 8 | 8 | |||||||||||||||||||||||||||||||||
| 356 | [] | Kurssitoiminta | Kursverksamhet | Courses | 356 | 2018-08-07T14:00:22.623521+03:00 | 3 | 352 | {} | [356] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
| 357 | [] | Näyttelytilat | Utställningslokaler | Exhibition spaces | 474 | 2018-08-07T14:00:22.630116+03:00 | 3 | 352 | {} | [474] | 0 | 1403 | 105 | 114 | 7 | 2 | |||||||||||||||||||||||||||||||
| 358 | [] | Ooppera ja baletti | Operan och balett | Opera and ballet | 479 | 2018-08-07T14:00:22.636644+03:00 | 3 | 352 | {} | [479] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 374 | [] | Av- ja leirivälinelainaamo | Utlåning av AV-utrustning och campingutrustning | Loaning service for audiovisual and camping equipment | 81 | 2018-08-07T14:00:22.905139+03:00 | 3 | 368 | {} | [81] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 389 | [] | Fillari- ja moottoripaja | Cykel- och motorverkstad | Workshop for bicycles and mopeds | 168 | 2018-08-07T14:00:22.937466+03:00 | 3 | 368 | {} | [168] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
| 395 | [] | Internet | Internet | Internet | 202 | 2018-08-07T14:00:22.950721+03:00 | 3 | 368 | {} | [202] | 0 | 1403 | 2 | 15 | 13 | ||||||||||||||||||||||||||||||||
| 403 | [] | Keramiikka | Keramik | Pottery | 287 | 2018-08-07T14:00:22.976243+03:00 | 3 | 368 | {} | [287] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
| 418 | [] | Kuvataide | Bildkonst | Visual arts | 359 | 2018-08-07T14:00:23.020022+03:00 | 3 | 368 | {} | [359] | 0 | 1403 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
| 421 | [] | Käsityöt | Handarbeten | Handicrafts | 363 | 2018-08-07T14:00:23.033043+03:00 | 3 | 368 | {} | [363] | 0 | 1403 | 1 | 8 | 7 | ||||||||||||||||||||||||||||||||
| 433 | [] | Media | Media | Media | 433 | 2018-08-07T14:00:23.060583+03:00 | 3 | 368 | {} | [433] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
| 437 | [] | Monistuspalvelu | Kopieringstjänst | Copying service | 443 | 2018-08-07T14:00:23.067329+03:00 | 3 | 368 | {} | [443] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 452 | [] | Puutyö | Slöjd | Woodwork | 534 | 2018-08-07T14:00:23.113213+03:00 | 3 | 368 | {} | [534] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 453 | [] | Pyöräkoulu | Cykelskola | Bicycle school | 541 | 2018-08-07T14:00:23.119521+03:00 | 3 | 368 | {} | [541] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 458 | [] | Retkeily | Camping | Trekking | 580 | 2018-08-07T14:00:23.138224+03:00 | 3 | 368 | {} | [580] | 0 | 1403 | 2 | 7 | 5 | ||||||||||||||||||||||||||||||||
| 481 | [] | Valokuvaus | Fotografering | Photography | 741 | 2018-08-07T14:00:23.182310+03:00 | 3 | 368 | {} | [741] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 485 | [] | Viikonlopputoiminta | Veckoslutsverksamhet | Weekend activities | 789 | 2018-08-07T14:00:23.188643+03:00 | 3 | 368 | {} | [789] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 492 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:22.690959+03:00 | 3 | 491 | {} | [238] | 0 | 1403 | 49 | 49 | |||||||||||||||||||||||||||||||||
| 502 | [] | Viheralueet | Grönområden | Green areas | 786 | 2018-08-07T14:00:22.769184+03:00 | 3 | 491 | {} | [786] | 0 | 1403 | 51 | 102 | 1 | 50 | |||||||||||||||||||||||||||||||
| 510 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:22.836894+03:00 | 3 | 505 | {} | [803] | 0 | 1403 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
| 511 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:22.844464+03:00 | 3 | 505 | {} | [804] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 515 | [] | Joukkoliikennepysäkit | Kollektivtrafikens hållplatser | Public transport stops | 209 | 2018-08-07T14:00:25.015254+03:00 | 3 | 513 | {} | [209] | 0 | 1402 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
| 518 | [] | Matkalippujen tarkastus | Biljettkontroll | Ticket inspection | 431 | 2018-08-07T14:00:25.036866+03:00 | 3 | 513 | {} | [431] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 519 | [] | Metroasemat | Metrostationer | Metro stations | 437 | 2018-08-07T14:00:25.044266+03:00 | 3 | 513 | {} | [437] | 0 | 1402 | 72 | 88 | 16 | ||||||||||||||||||||||||||||||||
| 522 | [] | Liikennesuunnittelu | Trafikplanering | Traffic planning | 395 | 2018-08-07T14:00:25.064660+03:00 | 3 | 521 | {} | [395] | 0 | 1402 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 528 | [] | Asukas- ja yrityspysäköintitunnukset | Boende- och företagsparkering | Residential and corporate parking | 73+834 | 2018-10-24T23:30:06.727092+03:00 | 3 | 526 | {} | [834, 73] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 530 | [] | Pysäköintilippuautomaatit | Parkeringsbiljettautomater | Parking ticket machines | 536 | 2018-08-07T14:00:25.120116+03:00 | 3 | 526 | {} | [536] | 0 | 1402 | 557 | 557 | |||||||||||||||||||||||||||||||||
| 532 | [] | Yleiset pysäköintialueet | Allmänna parkeringsområden | Public parking lot | 814 | 2018-08-07T14:00:25.132843+03:00 | 3 | 526 | {} | [814] | 0 | 1402 | 1 | 346 | 343 | 2 | |||||||||||||||||||||||||||||||
| 539 | [] | Tierakenteiden tiiviys- ja kantavuusmittaus | Mätning av vägkonstruktioners täthet och bärkraft | Measuring the solidity and bearing capacity of road constructions | 707 | 2018-08-07T14:00:25.177483+03:00 | 3 | 534 | {} | [707] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 542 | [543, 544, 545, 2198, 546, 2144] | Satamat ja laiturit | Hamn och bryggor | Harbours, piers and quays | 2018-08-07T14:00:25.196186+03:00 | 3 | 541 | {} | [] | 0 | 1402 | 168 | 209 | 2 | 1 | 1 | 36 | 1 | |||||||||||||||||||||||||||||
| 547 | [548, 2199, 549, 2143, 2142] | Veneily | Båtsport | Boating | 2018-08-07T14:00:25.237133+03:00 | 3 | 541 | {} | [] | 0 | 1402 | 206 | 262 | 1 | 4 | 2 | 1 | 2 | 45 | 1 | |||||||||||||||||||||||||||
| 559 | [560, 561, 562, 563] | Ampumaurheilupaikat | Sportskytteplatser | Shooting sports facilities | 2018-08-07T14:00:23.287538+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 6 | 10 | 1 | 3 | ||||||||||||||||||||||||||||||||
| 564 | [565] | Hyppyrimäet | Hoppbackar | Ski jumping hills | 2018-08-07T14:00:23.318569+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
| 567 | [568, 569] | Katetut talviurheilupaikat | Vintersportplatser under tak | Covered winter sports facilities | 2018-08-07T14:00:23.339639+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 2 | 2 | ||||||||||||||||||||||||||||||||||
| 575 | [576] | Laskettelurinteet ja rinnehiihtokeskukset | Slalombackar och alpina skidcentra | Ski slopes and downhill ski resorts | 2018-08-07T14:00:23.388106+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 2 | 6 | 2 | 2 | ||||||||||||||||||||||||||||||||
| 675 | [676] | Urheiluilmailualueet | Områden för flygsport | Sport aviation areas | 2018-08-07T14:00:24.102541+03:00 | 3 | 666 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
| 677 | [681, 682, 683] | Veneurheilupaikat | Platser för båtsport | Boating sports facilities | 2018-08-07T14:00:24.115410+03:00 | 3 | 666 | {} | [] | 0 | 1403 | 4 | 5 | 1 | |||||||||||||||||||||||||||||||||
| 706 | [710, 711, 712, 713, 714, 716] | Virkistys- ja retkeilyalueet | Rekreations- och friluftsområden | Recreational and outdoor areas | 2018-08-07T14:00:24.316869+03:00 | 3 | 694 | {} | [] | 0 | 1403 | 11 | 38 | 1 | 1 | 2 | 3 | 18 | 1 | 1 | |||||||||||||||||||||||||||
| 719 | [721, 723, 724, 725, 730] | Eläintarhat | Djurparker | Zoos | 2018-08-07T14:00:24.415879+03:00 | 3 | 718 | {} | [] | 0 | 1403 | 13 | 14 | 1 | |||||||||||||||||||||||||||||||||
| 738 | [] | Kahvilat | Caféer | Cafés | 239 | 2018-08-07T14:00:24.505977+03:00 | 3 | 718 | {} | [239] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
| 739 | [] | Kaupat ja myymälät | Butiker och affärer | Shops and outlets | 256 | 2018-08-07T14:00:24.513136+03:00 | 3 | 718 | {} | [256] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 740 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:24.520703+03:00 | 3 | 718 | {} | [259] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 741 | [] | Kioskit | Kiosker | Kiosks | 309 | 2018-08-07T14:00:24.527473+03:00 | 3 | 718 | {} | [309] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 743 | [] | Leirintäalueet | Campingområden | Camping sites | 390 | 2018-08-07T14:00:24.541305+03:00 | 3 | 718 | {} | [390] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 748 | [] | Muut matkailupalvelut | Övriga turisttjänster | Other tourism services | 459 | 2018-08-07T14:00:24.575540+03:00 | 3 | 718 | {} | [459] | 0 | 1403 | 5 | 5 | |||||||||||||||||||||||||||||||||
| 753 | [] | Torit | Torg | Market squares | 714 | 2018-08-07T14:00:24.610283+03:00 | 3 | 718 | {} | [714] | 0 | 1403 | 15 | 15 | |||||||||||||||||||||||||||||||||
| 770 | [771, 773, 774] | Avioliitto ja rekisteröity parisuhde | Äktenskap och registrering av partnerskap | Marriage and registered partnership | 2018-08-07T14:00:30.869982+03:00 | 3 | 769 | {} | [] | 0 | 1401 | 1 | 2 | 1 | |||||||||||||||||||||||||||||||||
| 775 | [] | Edunvalvonta | Intressebevakning | Trusteeship | 131 | 2018-08-07T14:00:30.904881+03:00 | 3 | 769 | {} | [131] | 0 | 1401 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
| 776 | [] | Kotikunta- ja väestötiedot | Uppgifter om hemkommun och befolkningsinformation | Municipality of residence and population information | 335 | 2018-08-07T14:00:30.913192+03:00 | 3 | 769 | {} | [335] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 777 | [] | Kuluttajansuoja ja neuvonta | Konsumentskydd och rådgivning | Consumer protection and advice | 347 | 2018-08-07T14:00:30.921943+03:00 | 3 | 769 | {} | [347] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 778 | [] | Nimiasiat | Namnärenden | Name matters | 465 | 2018-08-07T14:00:30.930146+03:00 | 3 | 769 | {} | [465] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 780 | [] | Perinnönjako | Arvskifte | Distribution of estate | 508 | 2018-08-07T14:00:30.947784+03:00 | 3 | 769 | {} | [508] | 0 | 1401 | 1 | 2 | 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 );