servicemap

Custom SQL query returning 29 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 "unit_count_municipality_hyvinkää" = :p0 order by id 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	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_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ää
343	[344, 345, 350, 351, 352, 361, 362, 491, 504, 505, 2006, 503]	Kulttuuri ja vapaa-aika	Kultur och fritid	Culture and leisure		2018-08-07T14:00:22.539281+03:00	1	1403	{}	[]	0	1403	1745	2452				1	1	1			1	8	1			2		4	2				382				286	1		13	4
362	[363, 364]	Museot	Museer	Museums		2018-08-07T14:00:22.665582+03:00	2	343	{}	[]	0	1403	64	96						1										4	1				13				8	1			4
363	[]	Kulttuurihistoriallinen museo	Kulturhistoriska museer	Cultural history museums	344	2018-08-07T14:00:22.670926+03:00	3	362	{}	[344]	0	1403	42	58																					9				5	1			1
364	[]	Taidemuseo	Konstmuseer	Art museums	672	2018-08-07T14:00:22.677535+03:00	3	362	{}	[672]	0	1403	61	88						1										4	1				10				6	1			4
717	[754, 718, 2173, 2028]	Matkailu ja tapahtumat	Turism och evenemang	Things to do		2020-03-06T18:32:07.102459+02:00	1	1403	{}	[]	0	1403	1973	2155				1	1	1			1	2	1	1		3		5	3				87				67	1	1	3	4
718	[2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753]	Matkailu	Turism	Tourism		2018-08-07T14:00:24.401683+03:00	2	717	{}	[]	0	1403	1880	2050				1	1	1			1	1	1	1		3		5	3				79				64	1	1	3	4
745	[746, 747]	Museot	Museer	Museums		2018-08-07T14:00:24.555720+03:00	3	718	{}	[]	0	1403	64	96						1										4	1				13				8	1			4
746	[]	Kulttuurihistoriallinen museo	Kulturhistoriska museer	Cultural history museums	344	2018-08-07T14:00:24.561434+03:00	4	745	{}	[344]	0	1403	42	58																					9				5	1			1
747	[]	Taidemuseo	Konstmuseer	Art museums	672	2018-08-07T14:00:24.568656+03:00	4	745	{}	[672]	0	1403	61	88						1										4	1				10				6	1			4
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	0		{}	[]	0	783	397	718				2						1					1						129				175	1		7		5
787	[789, 790, 788]	Lastensuojelu	Barnskydd	Child welfare		2018-10-25T08:00:09.006369+03:00	1	783	{}	[]	0	783	37	81															1						17				24	1		1
789	[]	Lastensuojelun laitospalvelu	Institutionstjänster inom barnskyddet	Institutional service for child welfare	380	2018-08-07T14:00:27.738722+03:00	2	787	{}	[380]	0	783	12	37															1						7				16	1
997	[2164, 2166]	Koulu- ja opiskeluterveydenhuolto	Skol- och studenthälsovård	School and student health services		2018-10-25T08:00:09.578039+03:00	1	986	{}	[]	0	986	241	320															1						2				68	1		7
1017	[]	Laboratorio	Laboratorium	Laboratory	366	2018-08-07T14:00:29.386729+03:00	1	986	{}	[366]	0	986	22	88		3	1	1		3	1	1				1	1	2	6	3	3	1	7	1	10	1	3	1	8	1	1	2	1	1	1	1
1018	[]	Röntgen	Röntgen	X-rays	606	2018-08-07T14:00:29.396972+03:00	1	986	{}	[606]	0	986	11	42	1	1		1		1								2	1	1	1	1	1	1	6		1	1	6	1	1		1	1	1
1097	[1187, 1255, 1098]	Perusopetus	Grundläggande utbildning	Basic education		2018-08-07T14:00:25.451107+03:00	1	1087	{}	[]	0	1087	414	568															1						97				55	1
1098	[1173, 1181, 1177, 1120, 1119, 1099, 1109, 1174, 1169, 2014, 2215, 2216]	Suomen- ja vieraskielinen perusopetus	Grundläggande utbildning på finska och främmande språk	Basic education in Finnish, English and other languages		2020-03-06T18:32:07.543511+02:00	2	1097	{}	[]	0	1087	368	504															1						84				50	1
1099	[1101, 1102, 2170, 1103, 1100, 1104]	Luokkien 1-6 perusopetus	Grundläggande utbildning, årskurserna 1-6	Basic education, grades 1-6		2018-10-25T08:00:07.589100+03:00	3	1098	{}	[]	0	1087	110	212																					62				39	1
1100	[]	suomenkielinen opetus	undervisning på finska	education in Finnish	661	2018-10-25T08:00:07.595003+03:00	4	1099	{}	[661]	1	1087	104	205																					62				38	1
1109	[1111, 1112, 2171, 1113, 1110, 1114]	Luokkien 7-9 perusopetus	Grundläggande utbildning, årskurserna 7-9	Basic education, grades 7-9		2018-10-25T08:00:07.629842+03:00	3	1098	{}	[]	0	1087	69	121															1						27				23	1
1110	[]	suomenkielinen opetus	undervisning på finska	education in Finnish	662	2018-10-25T08:00:07.635959+03:00	4	1109	{}	[662]	1	1087	63	114															1						27				22	1
1120	[1123, 1124, 1127, 1129, 1122, 1130, 1131, 1135, 1136, 1139, 1141, 1134, 1142, 1143, 1147, 1146, 1160, 1162, 1163, 1164, 1165, 1166, 1167, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234]	Kieliohjelma	Språkprogram	Language programme		2018-08-07T14:00:25.674488+03:00	3	1098	{}	[]	0	1087	109	213															1						73				29	1
1123	[]	A1-englanti	A1-engelska	A1-English	14915+15015+16215+16315+30115+30215+38415+38515+56715+56815+61215+61315+66115+66215+77115+77215+79315+79415+86515+86615	2018-10-25T08:00:07.696168+03:00	4	1120	{}	[866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 15]	1	1087	108	211															1						73				28	1
1146	[]	B1-ruotsi	B1-svenska	B1-Swedish	149108+150108+162108+163108+301108+302108+384108+385108+567108+568108+612108+613108+661108+662108+771108+772108+793108+794108+865108+866108	2018-10-25T08:00:07.912218+03:00	4	1120	{}	[866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 108]	1	1087	107	205															1						72				24	1
1372	[1373, 1374, 1375]	Oppilas- ja opiskelijahuolto	Elevvård	Pupil and student care		2018-08-07T14:00:27.603403+03:00	1	1087	{}	[]	0	1087	241	388															1						2				136	1		7
1373	[2165, 2167]	Koulu- ja opiskeluterveydenhuolto	Skol- och studenthälsovård	School and student health services		2018-10-25T08:00:08.960295+03:00	2	1372	{}	[]	0	1087	241	320															1						2				68	1		7
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	0		{}	[]	0	1403	5769	8871	1			18	1	1			1	12	1	20		3	1	6	14				1685			1	1238	1	37	57	4
2164	[]	Kouluterveydenhuolto	Skolhälsovård	School health care	339	2018-08-07T14:00:29.207544+03:00	2	997	{}	[339]	0	986	160	236															1						1				68	1		5
2165	[]	Kouluterveydenhuolto	Skolhälsovård	School health care	339	2018-08-07T14:00:27.619794+03:00	3	1373	{}	[339]	0	1087	160	236															1						1				68	1		5