service_node
18 rows where unit_count_municipality_helsinki = 7
This data as json, CSV (advanced)
Suggested facets: children, level, parent, related_services, period_enabled, root, unit_count_total, unit_count_municipality_espoo, unit_count_municipality_vantaa, 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 335 | [] | Multimedialaitteita | Multimediautrustning | Multimedia equipment | 689 | 2018-08-07T14:00:24.911616+03:00 | 5 | 334 | {} | [689] | 0 | 1402 | 7 | 7 | |||||||||||||||||||||||||||||||||
| 490 | [] | Nuorten neuvonta ja ohjaus | Rådgivning och handledning för ungdomar | Advice and guidance for young people | 471 | 2018-08-07T14:00:23.202058+03:00 | 2 | 365 | {} | [471] | 0 | 1403 | 7 | 22 | 3 | 12 | |||||||||||||||||||||||||||||||
| 606 | [607] | Keilahallit | Bowlinghallar | Bowling alleys | 2018-08-07T14:00:23.590235+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 7 | 11 | 2 | 2 | ||||||||||||||||||||||||||||||||
| 607 | [] | Keilahalli | Bowlinghall | Bowling alley | 285 | 2018-08-07T14:00:23.595829+03:00 | 4 | 606 | {} | [285] | 0 | 1403 | 7 | 11 | 2 | 2 | |||||||||||||||||||||||||||||||
| 638 | [] | Ratagolf | Bangolf | Minigolf course | 573 | 2018-08-07T14:00:23.822729+03:00 | 4 | 634 | {} | [573] | 0 | 1403 | 7 | 18 | 7 | 4 | |||||||||||||||||||||||||||||||
| 803 | [] | Vammaispalvelun asumispalvelut | Boendetjänster inom handikappservicen | Services for the disabled, residential services | 746 | 2018-08-07T14:00:27.835887+03:00 | 2 | 798 | {} | [746] | 0 | 783 | 7 | 24 | 1 | 3 | 13 | ||||||||||||||||||||||||||||||
| 964 | [] | Ruotsinkielinen ryhmäperhepäivähoito | Gruppfamiljedagvård på svenska | Group family day care in Swedish | 604 | 2018-08-07T14:00:28.896466+03:00 | 4 | 2145 | {} | [604] | 0 | 1405 | 7 | 11 | 4 | ||||||||||||||||||||||||||||||||
| 1040 | [] | Jalkaterapia | Fotvård | Podiatry | 206 | 2018-08-07T14:00:29.581915+03:00 | 2 | 1028 | {} | [206] | 0 | 986 | 7 | 10 | 2 | 1 | |||||||||||||||||||||||||||||||
| 1147 | [] | B1-englanti | B1-engelska | B1-English | 149*101+150*101+162*101+163*101+301*101+302*101+384*101+385*101+567*101+568*101+612*101+613*101+661*101+662*101+771*101+772*101+793*101+794*101+865*101+866*101 | 2018-10-25T08:00:07.920873+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 101] | 1 | 1087 | 7 | 7 | |||||||||||||||||||||||||||||||||
| 1190 | [1191] | Luokkien 7-9 perusopetus | Grundläggande utbildning, årskurserna 7-9 | Basic education, grades 7-9 | 2018-10-25T08:00:08.207545+03:00 | 3 | 1187 | {} | [] | 0 | 1087 | 7 | 12 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 1191 | [] | ruotsinkielinen opetus | undervisning på svenska | education in Swedish | 602 | 2018-08-07T14:00:26.281144+03:00 | 4 | 1190 | {} | [602] | 1 | 1087 | 7 | 12 | 4 | 1 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 1298 | [1303, 1300, 1328, 1299] | Ruotsinkielinen nuorten lukiokoulutus | Gymnasieutbildning för unga på svenska | General upper secondary education for the young in Swedish | 2020-03-06T18:32:08.157237+02:00 | 2 | 1257 | {} | [] | 0 | 1087 | 7 | 10 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 1362 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 665*66 | 2020-11-18T07:30:12.851359+02:00 | 3 | 1361 | {} | [665, 66] | 0 | 1087 | 7 | 9 | 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 |
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 );