servicemap

Custom SQL query returning 9 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 "level" = :p0 order by unit_count_municipality_askola limit 101

Query parameters

This data as json, CSV

id	children	name_fi	name_sv	name_en	last_modified_time	keywords	related_services	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ää
783	[866, 861, 810, 797, 787, 845, 791, 2189, 830, 784, 860, 839, 798, 819, 859]	Perhe- ja sosiaalipalvelut	Familje- och socialservice	Family and social services	2018-08-07T14:00:27.699133+03:00	{}	[]	783	397	718				2							1					1						129				175	1		7		5
1061	[1062, 1065, 1066, 1070, 1076, 1078, 1079, 1080, 1082, 1083]	Turvallisuus	Säkerhet	Public safety	2018-08-07T14:00:29.767356+03:00	{}	[]	1061	130	163																						17				13			3
1087	[2042, 1335, 2179, 1356, 1088, 1382, 1378, 1376, 1257, 1334, 1377, 1372, 1353, 1097, 1360, 1359]	Opetus ja koulutus	Undervisning och utbildning	Teaching and education	2018-08-07T14:00:25.275863+03:00	{}	[]	1087	1214	1867				1												2						274				362	2		11		1
1400	[2, 1, 14, 24, 31, 221, 85]	Asuminen ja kaupunkiympäristö	Boende och stadsmiljö	Housing and urban environment	2018-08-07T14:00:21.224786+03:00	{}	[]	1400	2311	4077				17	1	23	1			1	4	1			30		53	43				737			3	698	35	10	31	37	41
1401	[122, 171, 755]	Työ, talous ja hallinto	Arbete, ekonomi och förvaltning	Employment and public authorities	2020-03-06T18:32:09.344909+02:00	{}	[]	1401	448	629				2	1					1	2	1			2			3				88				74			6		1
1402	[306, 512]	Liikenne ja kartat	Trafik och kartor	Traffic and maps	2018-08-07T14:00:24.647447+03:00	{}	[]	1402	1567	2238	1			4							1		2		1			2				581				71			8
1403	[343, 551, 717, 365]	Kulttuuri, liikunta ja vapaa-aika	Kultur, motion och fritid	Culture, sports and leisure	2018-08-07T14:00:22.534057+03:00	{}	[]	1403	5769	8871	1			18	1	1				1	12	1	20		3	1	6	14				1685			1	1238	1	37	57	4
1405	[2118, 868, 2163]	Päivähoito ja esiopetus	Barndagvård och förskola	Daycare and pre-primary education	2020-03-06T18:32:08.672148+02:00	{}	[]	1405	951	1546																						367				216			12
986	[990, 1048, 995, 996, 997, 1028, 1042, 1017, 992, 1019, 999, 1004, 1043, 1041, 1051, 1000, 1039, 1018, 1009, 1044, 988, 998, 993, 991, 2190, 1060, 994]	Terveys	Hälsovård	Health care	2018-08-07T14:00:29.110723+03:00	{}	[]	986	556	949	1	4	1	2		4		1	1		3		1	1	5	9	4	4	2	8	2	122	1	6	2	183	5	2	12	2	2	2	1