service_node

360 rows where level = 4 sorted by unit_count_municipality_vantaa descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: children, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, last_modified_time (date)

level ✖

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ää
871 [] päivähoito dagvård day care 663 2019-03-05T14:30:09.346786+02:00 4 870 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [663] 0 1405 389 845                                           277       173     6        
659 [] Pallokenttä Bollplan Ball field 495 2018-08-07T14:00:23.987386+03:00 4 654 {} [495] 0 1403 408 743                                           169       161     5        
70 [] Leikkipaikat (ei ohjattua toimintaa) Lekplatser (ingen handledd verksamhet) Play areas (no supervised activities) 389 2018-08-07T14:00:21.425954+03:00 4 68 {} [389] 0 1400 224 567                                           193       145     5        
501 [] Leikkipaikat (ei ohjattua toimintaa) Lekplatser (ingen handledd verksamhet) Play areas (no supervised activities) 389 2018-08-07T14:00:22.761746+03:00 4 499 {} [389] 0 1403 224 567                                           193       145     5        
583 [] Latu Skidspår Ski track 191 2018-08-07T14:00:23.433650+03:00 4 577 {} [191] 0 1403 45 208       2                         1         39       117   3 1        
879 [] esiopetus förskoleundervisning pre-primary education 663*160+861*160 2018-10-24T23:30:08.464088+03:00 4 870 {} [861, 663, 160] 1 1405 266 448                                           66       116              
612 [] Liikuntasali Idrottssal Gymnastics hall 402 2018-08-07T14:00:23.630490+03:00 4 608 {} [402] 0 1403 308 512                                           97       102     5        
642 [] Luistelukenttä Skridskobana Ice-skating field 406 2018-08-07T14:00:23.848959+03:00 4 639 {} [406] 0 1403 136 308                                           100       70     2        
653 [] Ulkokuntoiluvälineet Konditionspark för utomhusaktiviteter Fitness training park 737 2018-08-07T14:00:23.939410+03:00 4 646 {} [737] 0 1403 168 320                                           100       43   3 6        
611 [] Kuntosali Gym Gym 350 2018-08-07T14:00:23.623495+03:00 4 608 {} [350] 0 1403 151 237                                           45       39     2        
1100 [] suomenkielinen opetus undervisning på finska education in Finnish 661 2018-10-25T08:00:07.595003+03:00 4 1099 {} [661] 1 1087 104 205                                           62       38 1            
657 [] Koripallokenttä Basketplan Basketball court 331 2018-08-07T14:00:23.971455+03:00 4 654 {} [331] 0 1403 153 256                                           64       37     2        
258 [2210, 259, 261, 260, 263, 264] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:22.220951+03:00 4 255 {} [] 0 1400 292 375       1 1         1   1     2     2       40       31     4        
658 [] Lentopallokenttä Volleybollplan Volleyball court 392 2018-08-07T14:00:23.980139+03:00 4 654 {} [392] 0 1403 46 86                         1                 10       28   1          
875 [] erityisryhmä specialgrupp special group 663*156 2018-08-07T14:00:28.291078+03:00 4 870 {} [663, 156] 0 1405 49 77                                                   28              
1123 [] A1-englanti A1-engelska A1-English 149*15+150*15+162*15+163*15+301*15+302*15+384*15+385*15+567*15+568*15+612*15+613*15+661*15+662*15+771*15+772*15+793*15+794*15+865*15+866*15 2018-10-25T08:00:07.696168+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 15] 1 1087 108 211                               1           73       28 1            
648 [] Lähiliikuntapaikka Näridrottsplats Neighbourhood sports area 415 2018-08-07T14:00:23.898085+03:00 4 646 {} [415] 0 1403 134 229                               1           64       26     4        
662 [] Tenniskenttäalue Område med tennisbanor Tennis court area 700 2018-10-25T08:00:07.016431+03:00 4 654 {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} [700] 0 1403 45 83                                           11       25     2        
63 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:21.380622+03:00 4 62 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} [317] 0 1400 94 140                                           22       24              
494 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:22.710417+03:00 4 493 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} [317] 0 1403 94 140                                           22       24              
1146 [] B1-ruotsi B1-svenska B1-Swedish 149*108+150*108+162*108+163*108+301*108+302*108+384*108+385*108+567*108+568*108+612*108+613*108+661*108+662*108+771*108+772*108+793*108+794*108+865*108+866*108 2018-10-25T08:00:07.912218+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 108] 1 1087 107 205                               1           72       24 1            
1136 [] A2-espanja A2-spanska A2-Spanish 149*28+150*28+162*28+163*28+301*28+302*28+384*28+385*28+567*28+568*28+612*28+613*28+661*28+662*28+771*28+772*28+793*28+794*28+865*28+866*28 2018-10-25T08:00:07.822843+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 28] 1 1087 45 75                                           7       23              
151 [] Kokouspaikat Möteslokaler Meeting places 326 2018-08-07T14:00:30.193967+03:00 4 149 {} [326] 0 1401 247 293       1 1         1         2     2       17       22              
1110 [] suomenkielinen opetus undervisning på finska education in Finnish 662 2018-10-25T08:00:07.635959+03:00 4 1109 {} [662] 1 1087 63 114                               1           27       22 1            
1134 [] A2-ruotsi A2-svenska A2-Swedish 149*34+150*34+162*34+163*34+301*34+302*34+384*34+385*34+567*34+568*34+612*34+613*34+661*34+662*34+771*34+772*34+793*34+794*34+865*34+866*34 2018-10-25T08:00:07.804809+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 34] 1 1087 57 117                                           39       21              
610 [] Kuntokeskus Konditionsidrottscentrum Fitness centre 625 2018-08-07T14:00:23.616327+03:00 4 608 {} [625] 0 1403 48 97                                           28       20     1        
655 [] Beachvolleykenttä Beachvolleyplan Beach volleyball court 125 2018-08-07T14:00:23.954884+03:00 4 654 {} [125] 0 1403 39 85                                           27       18     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              
1141 [] A2-ranska A2-franska A2-French 149*33+150*33+162*33+163*33+301*33+302*33+384*33+385*33+567*33+568*33+612*33+613*33+661*33+662*33+771*33+772*33+793*33+794*33+865*33+866*33 2018-10-25T08:00:07.868542+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 33] 1 1087 63 101                                           22       16              
1142 [] A2-saksa A2-tyska A2-German 149*35+150*35+162*35+163*35+301*35+302*35+384*35+385*35+567*35+568*35+612*35+613*35+661*35+662*35+771*35+772*35+793*35+794*35+865*35+866*35 2018-10-25T08:00:07.877676+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 35] 1 1087 58 124                                           50       16              
581 [] Kuntorata Konditionsbana Jogging track 348 2018-08-07T14:00:23.419850+03:00 4 577 {} [348] 0 1403 45 82                                           22       14     1        
152 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:30.200626+03:00 4 149 {} [214] 0 1401 218 249       1 1         1   1           1       10       13     3        
613 [] Voimailusali Styrketräningssal Weight training hall 797 2018-08-07T14:00:23.637831+03:00 4 608 {} [797] 0 1403 22 39                                           5       12              
632 [] Yksittäinen yleisurheilun suorituspaikka Enstaka övningsplats för friidrott Stand-alone athletics venue 810 2018-08-07T14:00:23.783286+03:00 4 624 {} [810] 0 1403 9 22                                                   12     1        
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        
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        
963 [] Suomenkielinen ryhmäperhepäivähoito Gruppfamiljedagvård på finska Group family day care in Finnish 664 2018-10-25T08:00:09.441773+03:00 4 2145 {"fi": ["suomi"]} [664] 0 1405 50 107                                           47       9     1        
2209 [] Asukastilat Invånarlokaler Resident facilities 888 2019-10-22T09:30:10.261582+03:00 4 149 {} [888] 0 1401 1 12                                           2       9              
555 [] Ratsastuskenttä Ridbana Equestrian field 574 2018-08-07T14:00:23.243825+03:00 4 553 {} [574] 0 1403 8 36                                           20       8              
578 [] Frisbeegolf-rata Frisbeegolfbana Disc golf course 169 2018-08-07T14:00:23.883764+03:00 4 646 {} [169] 0 1403 8 27                                           10       8     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          
331 [] WLAN-sisäpisteet WLAN-inomhusstationer WLAN inlets 806 2018-08-07T14:00:24.883321+03:00 4 330 {} [806] 0 1402 223 230                                                   7              
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        
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              
556 [] Ratsastusmaneesi Ridmanege Riding manège 575 2018-08-07T14:00:23.250876+03:00 4 553 {} [575] 0 1403 8 24                                           10       6              
616 [] Liikuntahalli Idrottshall Sports hall 400 2018-08-07T14:00:23.657783+03:00 4 614 {} [400] 0 1403 24 38                                           7       6     1        
747 [] Taidemuseo Konstmuseer Art museums 672 2018-08-07T14:00:24.568656+03:00 4 745 {} [672] 0 1403 61 88           1                     4 1       10       6 1     4      
693 [] Uimahalli Simhall Public indoor swimming pool 729 2018-08-07T14:00:24.224255+03:00 4 690 {} [729] 0 1403 14 25                                           5       5     1        
746 [] Kulttuurihistoriallinen museo Kulturhistoriska museer Cultural history museums 344 2018-08-07T14:00:24.561434+03:00 4 745 {} [344] 0 1403 42 58                                           9       5 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              
1269 [] Yleislinjan lukiokoulutus Gymnasieutbildning, allmän linje Upper secondary school education, general programme 148*816+161*816+300*816+383*816+566*816+611*816+658*816+770*816+792*816 2018-10-25T08:00:08.527922+03:00 4 1268 {} [816, 792, 770, 658, 611, 566, 383, 300, 161, 148] 1 1087 14 30                                           11       5              
1273 [] A-ruotsi A-svenska A-Swedish 148*11+161*11+300*11+383*11+566*11+611*11+658*11+770*11+792*11 2018-10-25T08:00:08.554488+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 11] 1 1087 9 25                                           11       5              
1274 [] A-englanti A-engelska A-English 148*4+161*4+300*4+383*4+566*4+611*4+658*4+770*4+792*4 2018-10-25T08:00:08.562076+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 4] 1 1087 12 27                                           10       5              
1284 [] B-ruotsi B-svenska B-Swedish 148*96+161*96+300*96+383*96+566*96+611*96+658*96+770*96+792*96 2018-10-25T08:00:08.642605+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 96] 1 1087 11 27                                           11       5              
1286 [] B-espanja B-spanska B-Spanish 148*89+161*89+300*89+383*89+566*89+611*89+658*89+770*89+792*89 2018-10-25T08:00:08.657538+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 89] 1 1087 9 24                                           10       5              
1292 [] B-ranska B-franska B-French 148*95+161*95+300*95+383*95+566*95+611*95+658*95+770*95+792*95 2018-10-25T08:00:08.707519+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 95] 1 1087 10 26                                           11       5              
1293 [] B-saksa B-tyska B-German 148*97+161*97+300*97+383*97+566*97+611*97+658*97+770*97+792*97 2018-10-25T08:00:08.715851+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 97] 1 1087 10 26                                           11       5              
1294 [] B-venäjä B-ryska B-Russian 148*99+161*99+300*99+383*99+566*99+611*99+658*99+770*99+792*99 2018-10-25T08:00:08.723952+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 99] 1 1087 6 12                                           1       5              
609 [] Kamppailulajien sali Sal för kampsport Martial arts hall 241 2018-08-07T14:00:23.609044+03:00 4 608 {} [241] 0 1403 47 64                                           13       4              
619 [] Salibandyhalli Innebandyhall Floorball hall 616 2018-08-07T14:00:23.680694+03:00 4 614 {} [616] 0 1403 4 12                                           4       4              
622 [] Sulkapallohalli Badmintonhall Badminton hall 647 2018-08-07T14:00:23.705272+03:00 4 614 {} [647] 0 1403 9 18                                           5       4              
631 [] Telinevoimistelutila Utrymme för redskapsgymnastik Artistic gymnastics facility 697 2018-08-07T14:00:23.775695+03:00 4 624 {} [697] 0 1403 6 15                                           5       4              
638 [] Ratagolf Bangolf Minigolf course 573 2018-08-07T14:00:23.822729+03:00 4 634 {} [573] 0 1403 7 18                                           7       4              
645 [] Tekojääkenttä Konstis Mechanically frozen open-air ice rink 695 2018-08-07T14:00:23.870223+03:00 4 639 {} [695] 0 1403 11 25                                           10       4              
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              
688 [] Uimapaikka Badplats Unsupervised beach 730 2018-08-07T14:00:24.189679+03:00 4 685 {} [730] 0 1403 14 48                         4                 22       4   4          
872 [] iltahoito 17:30-22:00 kvällsvård 17.30-22.00 evening care 5:30pm-10:00pm 663*200 2018-08-07T14:00:28.278055+03:00 4 870 {} [663, 200] 0 1405 6 14                                           3       4     1        
1171 [] 3. luokalta alkava soveltuvuuskoepainotus lämplighetstestbetoning från årskurs 3 special emphasis starting from 3rd grade 149*2+162*2+301*2+384*2+567*2+612*2+661*2+771*2+793*2+865*2 2018-10-25T08:00:08.131695+03:00 4 1169 {} [865, 793, 771, 661, 612, 567, 384, 301, 162, 149, 2] 1 1087 11 15                                                   4              
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              
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              
1280 [] A-ranska A-franska A-French 148*10+161*10+300*10+383*10+566*10+611*10+658*10+770*10+792*10 2018-10-25T08:00:08.609701+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 10] 1 1087 7 16                                           5       4              
1281 [] A-saksa A-tyska A-German 148*12+161*12+300*12+383*12+566*12+611*12+658*12+770*12+792*12 2018-10-25T08:00:08.618606+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 12] 1 1087 7 20                                           9       4              
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              
235 [] Hankepalvelut Projekttjänster Project services 185 2018-08-07T14:00:22.084046+03:00 4 233 {} [185] 0 1400   3                                                   3              
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              
339 [340, 341] Tarjolla opastusta Handledning ges Guidance available   2018-10-25T08:00:07.363024+03:00 4 333 {} [] 0 1402 60 64                                           1       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              
573 [] Kiipeilykallio Klätterberg Climbing rock 306 2018-08-07T14:00:23.375633+03:00 4 572 {} [306] 0 1403   4                                           1       3              
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              
615 [] Jalkapallohalli Fotbollshall Football hall 204 2018-08-07T14:00:23.650553+03:00 4 614 {} [204] 0 1403 8 18                                           6       3     1        
623 [] Tennishalli Tennishall Tennis hall 699 2018-08-07T14:00:23.714268+03:00 4 614 {} [699] 0 1403 13 23                                           7       3              
630 [] Tanssitila Utrymme för dans Dance studio 687 2018-08-07T14:00:23.767727+03:00 4 624 {} [687] 0 1403 58 71                                           10       3              
637 [] Golfkenttä Golfbana Golf course 175 2018-08-07T14:00:23.815939+03:00 4 634 {} [175] 0 1403 4 16                                           9       3              
643 [] Luistelureitti Skridskoled Ice-skating route 407 2018-08-07T14:00:23.856181+03:00 4 639 {} [407] 0 1403 4 9                                           2       3              
664 [] Yleisurheilukenttä Friidrottsplan Athletics field 817 2018-08-07T14:00:24.025516+03:00 4 663 {} [817] 0 1403 8 17                                           6       3              
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          
876 [] kielikylpy ruotsi språkbad, svenska language immersion, Swedish 663*294 2018-08-07T14:00:28.297483+03:00 4 870 {} [663, 294] 0 1405 9 19                                           5       3     2        
1143 [] A2-venäjä A2-ryska A2-Russian 149*37+150*37+162*37+163*37+301*37+302*37+384*37+385*37+567*37+568*37+612*37+613*37+661*37+662*37+771*37+772*37+793*37+794*37+865*37+866*37 2018-10-25T08:00:07.886355+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 37] 1 1087 15 19                                           1       3              
1166 [] B2-saksa B2-tyska B2-German 149*121+150*121+162*121+163*121+301*121+302*121+384*121+385*121+567*121+568*121+612*121+613*121+661*121+662*121+771*121+772*121+793*121+794*121+865*121+866*121 2018-10-25T08:00:08.096555+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 121] 1 1087 43 71                                           25       3              
1270 [] Erityistehtävän mukainen lukiokoulutus Gymnasieutbildning med särskild uppgift Upper secondary school education with special curriculum 148*157+161*157+300*157+383*157+566*157+611*157+658*157+770*157+792*157 2018-10-25T08:00:08.535976+03:00 4 1268 {} [792, 770, 658, 611, 566, 383, 300, 161, 157, 148] 1 1087 6 9                                                   3              
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              
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        
334 [335, 337, 338] Tarjolla oheislaitteita Kringutrustning finns Supplementary equipment available   2018-08-07T14:00:24.905778+03:00 4 333 {} [] 0 1402 54 56                                                   2              
596 [] Kilpahiihtokeskus Skidtävlingscentrum Ski competition centre 307 2018-08-07T14:00:23.524927+03:00 4 592 {} [307] 0 1403   3                                           1       2              
603 [] Harjoitusjäähalli Övningsishall Training ice arena 187 2018-08-07T14:00:23.568317+03:00 4 602 {} [187] 0 1403 10 17                                           5       2              
604 [] Kilpajäähalli Tävlingsishall Competition ice arena 308 2018-08-07T14:00:23.575267+03:00 4 602 {} [308] 0 1403 2 7                                           2       2     1        
607 [] Keilahalli Bowlinghall Bowling alley 285 2018-08-07T14:00:23.595829+03:00 4 606 {} [285] 0 1403 7 11                                           2       2              
627 [] Pöytätennistila Utrymme för bordtennis Table tennis venue 556 2018-08-07T14:00:23.745237+03:00 4 624 {} [556] 0 1403 22 46                                           22       2              
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              

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);