servicemap

Custom SQL query returning 11 rows (hide)

select 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ää] from service_node where date("last_modified_time") = :p0 order by [unit_count_municipality_miehikkälä] limit 101

Query parameters

This data as json, CSV

id	children	name_fi	name_sv	name_en	service_reference	last_modified_time	level	parent	keywords	related_services	root	unit_count_municipality_helsinki	unit_count_total	unit_count_municipality_espoo	unit_count_municipality_vantaa	unit_count_municipality_kauniainen
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]	1400	69	80	8	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]	1403	69	80	8	3
870	[875, 879, 872, 877, 876, 880, 871, 874]	Suomenkielinen päivähoito	Finskspråkig dagvård	Day care in Finnish	663	2019-03-05T14:30:09.339119+02:00	3	869	{"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]}	[663]	1405	389	847	278	174	6
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]	1405	389	845	277	173	6
881	[886, 887, 883, 882]	Ruotsinkielinen päivähoito	Svenskspråkig dagvård	Day care in Swedish	603	2019-03-05T14:30:09.379492+02:00	3	869	{"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]}	[603]	1405	77	128	33	10	8
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]	1405	77	128	33	10	8
976	[]	Avoin toiminta	Öppen verksamhet	Open family activities	86	2019-03-05T14:30:09.650822+02:00	3	975	{"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]}	[86]	1405	2	31	13	15	1
978	[]	Kerhotoiminta	Klubbverksamhet	Club activities	288	2019-03-05T14:30:09.661194+02:00	3	975	{"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]}	[288]	1405	94	143	20	28	1
981	[]	Ohjattu leikkipuistotoiminta	Ledd lekparksverksamhet	Supervised playground activities	475	2019-03-05T14:30:09.677599+02:00	3	975	{"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]}	[475]	1405	69	80	8	3
982	[]	Puistotäti	Parktant	Park aunt	528	2019-03-05T14:30:09.685579+02:00	3	975	{"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]}	[528]	1405	2	2
2191	[]	Hitas-asunnot	Hitas-bostäder	Hitas owner-occupied housing	877	2019-03-05T14:30:06.194077+02:00	2	2	{}	[877]	1400	399	399