service_node
30 rows where unit_count_total = 9
This data as json, CSV (advanced)
Suggested facets: children, name_fi, name_sv, name_en, service_reference, level, parent, related_services, period_enabled, root, unit_count_municipality_helsinki, unit_count_municipality_espoo, unit_count_municipality_vantaa, 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | [] | Asumisen tuet | Bostadsbidrag | Housing allowances | 75 | 2018-08-07T14:00:21.243003+03:00 | 2 | 2 | {} | [75] | 0 | 1400 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
| 103 | [104, 105, 106, 107, 109, 110, 111, 113, 114] | Ympäristöterveydenhuolto | Miljö- och hälsoskydd | Environmental health | 2018-08-07T14:00:21.574018+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 4 | 9 | 2 | 1 | 2 | |||||||||||||||||||||||||||||||
| 188 | [] | Kelan etuudet | FPA:s förmåner | Kela benefits | 286 | 2018-08-07T14:00:30.511334+03:00 | 3 | 187 | {} | [286] | 0 | 1401 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
| 225 | [] | Kaavat ja kaavoitus | Planer och planlägging | Town plans and zoning | 237 | 2018-08-07T14:00:22.018653+03:00 | 3 | 222 | {} | [237] | 0 | 1400 | 5 | 9 | 1 | 2 | 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 | ||||||||||||||||||||||||||||||
| 371 | [] | Askartelu | Hobbyverksamhet | Hobby crafts | 72 | 2018-08-07T14:00:22.898108+03:00 | 3 | 368 | {} | [72] | 0 | 1403 | 3 | 9 | 2 | 4 | |||||||||||||||||||||||||||||||
| 516 | [] | Julkisen liikenteen varikot | Kollektivtrafikens depåer | Public transport depots | 216 | 2018-08-07T14:00:25.022696+03:00 | 3 | 513 | {} | [216] | 0 | 1402 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
| 643 | [] | Luistelureitti | Skridskoled | Ice-skating route | 407 | 2018-08-07T14:00:23.856181+03:00 | 4 | 639 | {} | [407] | 0 | 1403 | 4 | 9 | 2 | 3 | |||||||||||||||||||||||||||||||
| 721 | [] | Eläintarha | Högholmens djurgård | Helsinki Zoo | 142 | 2018-08-07T14:00:24.428725+03:00 | 4 | 719 | {} | [142] | 0 | 1403 | 9 | 9 | |||||||||||||||||||||||||||||||||
| 769 | [770, 775, 776, 777, 778, 779, 780, 2202, 781] | Oikeusturva | Rättsskydd | Legal protection | 2018-08-07T14:00:30.864855+03:00 | 2 | 755 | {} | [] | 0 | 1401 | 5 | 9 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 785 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:27.709008+03:00 | 2 | 784 | {} | [71] | 0 | 783 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
| 794 | [] | Lapsiperheiden kotipalvelu | Hemservice för barnfamiljer | Domestic services for families with children | 371 | 2018-08-07T14:00:27.777393+03:00 | 2 | 791 | {} | [371] | 0 | 783 | 6 | 9 | 3 | ||||||||||||||||||||||||||||||||
| 797 | [] | Lapsiperheen tuet | Förmåner för barnfamiljer | Benefits for families with children | 370 | 2020-08-20T14:00:09.399199+03:00 | 1 | 783 | {} | [370] | 0 | 783 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
| 808 | [] | Vammaispalvelun henkilökohtainen apu | Personlig assistent inom handikappservicen | Service for the disabled, personal assistant | 748 | 2018-08-07T14:00:27.870086+03:00 | 2 | 798 | {} | [748] | 0 | 783 | 4 | 9 | 1 | 4 | |||||||||||||||||||||||||||||||
| 811 | [] | Kehitysvammahuollon sosiaalityö | Socialt arbete inom vård av utvecklingsstörda | Care of the developmentally disabled, social work | 280 | 2018-08-07T14:00:27.887549+03:00 | 2 | 810 | {} | [280] | 0 | 783 | 3 | 9 | 5 | 1 | |||||||||||||||||||||||||||||||
| 837 | [] | Päihdehuollon katkaisuhoito ja kuntoutus | Akutvård och rehabilitering inom missbrukarvården | Care for substance abuse, detoxification and rehabilitation treatment | 544 | 2018-08-07T14:00:28.061184+03:00 | 2 | 830 | {} | [544] | 0 | 783 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
| 843 | [] | Perustoimeentulotuki | Grundläggande utkomststöd | Basic social assistance | 711 | 2018-08-07T14:00:28.092481+03:00 | 2 | 839 | {} | [711] | 0 | 783 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
| 848 | [] | Aikuisten sosiaaliohjaus | Socialhandledning för vuxna | Social care work for adults | 41 | 2018-08-07T14:00:28.131053+03:00 | 2 | 845 | {} | [41] | 0 | 783 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
| 989 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:29.129777+03:00 | 2 | 988 | {} | [71] | 0 | 986 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
| 1058 | [] | Päihdehuollon katkaisuhoito ja kuntoutus | Akutvård och rehabilitering inom missbrukarvården | Care for substance abuse, detoxification and rehabilitation treatment | 544 | 2018-08-07T14:00:29.732968+03:00 | 2 | 1051 | {} | [544] | 0 | 986 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
| 1062 | [1063, 1064] | Maanpuolustus | Försvaret | National defence | 2018-08-07T14:00:29.774255+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 8 | 9 | 1 | |||||||||||||||||||||||||||||||||
| 1095 | [] | Koulun järjestämä esiopetus | Förskoleundervisning som ordnas av skolan | Pre-primary education organised by school | 601*159+862*159 | 2018-10-25T08:00:07.525080+03:00 | 3 | 1093 | {} | [862, 601, 159] | 1 | 1087 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 1365 | [1366, 1368, 1367] | Ruotsinkielinen työväenopisto | Svenska arbetarinstitutet | Swedish adult education centre | 605 | 2020-11-18T07:30:12.874521+02:00 | 2 | 1360 | {} | [605] | 0 | 1087 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 2128 | [] | Koulun järjestämä esiopetus | Förskoleundervisning som ordnas av skolan | Pre-primary education organised by school | 601*159+862*159 | 2018-10-25T08:00:09.534871+03:00 | 3 | 2126 | {} | [862, 601, 159] | 1 | 1405 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
| 2186 | [] | Ammatilliseen peruskoulutukseen valmentava koulutus - VALMA | Handledande utbildning för grundläggande yrkesutbildning - VALMA | Preparatory education for vocational training - VALMA | 470 | 2018-08-31T16:00:09.222841+03:00 | 2 | 2179 | {} | [470] | 1 | 1087 | 8 | 9 | 1 | ||||||||||||||||||||||||||||||||
| 2216 | [] | Valmistava opetus luokille 7-9 | Förbererande undervisning för årskurserna 7-9 | Preparatory education for grades 7-9 | 894 | 2020-05-08T12:30:12.979716+03:00 | 3 | 1098 | {} | [894] | 1 | 1087 | 9 | 9 | |||||||||||||||||||||||||||||||||
| 2229 | [] | Laajamittainen kaksikielinen opetus (suomi-englanti) | Omfattande undervisning på två språk (finska-engelska) | Extensive bilingual education (Finnish-English) | 661*904+662*904 | 2020-06-22T13:30:11.121789+03:00 | 4 | 1120 | {} | [904, 662, 661] | 1 | 1087 | 8 | 9 | 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 );