service_node
11 rows where root = 783 and unit_count_municipality_sipoo = 1
This data as json, CSV (advanced)
Suggested facets: children, level, parent, related_services, unit_count_municipality_helsinki, unit_count_total, 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||||||||||||||||||||
| 801 | [] | Vammaispalvelun sosiaaliohjaus | Socialhandledning inom handikappservice | Services for the disabled, social care work | 751 | 2018-08-07T14:00:27.822488+03:00 | 2 | 798 | {} | [751] | 0 | 783 | 33 | 1 | 32 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||
| 809 | [] | Vammaistuet ja -palvelut | Handikappbidrag och -tjänster | Disability benefits and services | 755 | 2018-08-07T14:00:27.876348+03:00 | 2 | 798 | {} | [755] | 0 | 783 | 3 | 15 | 1 | 2 | 7 | 1 | 1 | ||||||||||||||||||||||||||||
| 819 | [829, 827, 821, 820, 828, 824, 826, 825, 823, 822] | Vanhuspalvelu | Äldreomsorg | Service for the elderly | 2018-08-07T14:00:27.946229+03:00 | 1 | 783 | {} | [] | 0 | 783 | 142 | 261 | 1 | 67 | 44 | 6 | 1 | |||||||||||||||||||||||||||||
| 825 | [] | Vanhusten palveluasuminen | Serviceboende för äldre | Service residence for the elderly | 760 | 2018-08-07T14:00:27.984445+03:00 | 2 | 819 | {} | [760] | 0 | 783 | 30 | 103 | 1 | 36 | 32 | 3 | 1 | ||||||||||||||||||||||||||||
| 839 | [2011, 841, 843, 2012] | Toimeentulotuki | Utkomststöd | Social assistance | 2018-08-07T14:00:28.080690+03:00 | 1 | 783 | {} | [] | 0 | 783 | 11 | 20 | 1 | 3 | 3 | 1 | 1 | |||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||
| 845 | [848, 846, 847, 851, 857, 2160, 849, 852, 853, 854, 856, 858, 850, 855] | Muu sosiaalihuolto | Övrig socialvård | Other social welfare | 2018-08-07T14:00:28.112184+03:00 | 1 | 783 | {} | [] | 0 | 783 | 105 | 239 | 1 | 11 | 118 | 3 | 1 | |||||||||||||||||||||||||||||
| 847 | [] | Alueellinen kumppanuustyö | Områdesvist partnerskapsarbete | Regional partnership work | 49 | 2018-08-07T14:00:28.124411+03:00 | 2 | 845 | {} | [49] | 0 | 783 | 19 | 119 | 1 | 1 | 96 | 1 | 1 | ||||||||||||||||||||||||||||
| 852 | [] | Muun sosiaalihuollon asumispalvelut | Boendetjänster inom övrig socialvård | Residential services for other social welfare | 637 | 2018-08-07T14:00:28.163665+03:00 | 2 | 845 | {} | [637] | 0 | 783 | 11 | 26 | 1 | 1 | 12 | 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 );