servicemap

Custom SQL query returning 24 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_lohja" = :p0 order by children 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_sipoo	unit_count_municipality_janakkala	unit_count_municipality_nurmijärvi	unit_count_municipality_hämeenlinna	unit_count_municipality__unknown	unit_count_municipality_lapinjärvi	unit_count_municipality_inkoo	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_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
1009	[1011, 1012, 1013, 2161, 1014, 1015, 1016, 1010]	Sairaalat	Sjukhus	Hospitals		2018-08-07T14:00:29.308401+03:00	1	986	{}	[]	0	986	35	52										1	1						6	2		5	2
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
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
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
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
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
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
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
551	[552, 2151, 558, 2217, 601, 633, 666, 684, 694]	Liikunta	Idrott och motion	Sports and physical exercise		2018-08-07T14:00:23.220207+03:00	1	1403	{}	[]	0	1403	2590	4872			16				3		19		1	1	11				1260		1	892		36	42
646	[578, 647, 648, 649, 650, 651, 652, 653]	Lähiliikunta ja liikuntapuistot	Närmotion och idrottsparker	Neighbourhood sports facilities and parks		2018-08-07T14:00:23.877348+03:00	3	633	{}	[]	0	1403	345	650											1						196			95		3	10
633	[634, 639, 646, 654, 663]	Ulkokentät ja liikuntapuistot	Utomhusplaner och idrottsparker	Outdoor fields and sports parks		2018-08-07T14:00:23.790680+03:00	2	551	{}	[]	0	1403	1261	2383									1		1						636			457		4	23
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
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
648	[]	Lähiliikuntapaikka	Näridrottsplats	Neighbourhood sports area	415	2018-08-07T14:00:23.898085+03:00	4	646	{}	[415]	0	1403	134	229											1						64			26			4
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
1010	[]	Yliopistolliset sairaalat	Universitetssjukhus	University hospitals	820	2018-08-07T14:00:29.314677+03:00	2	1009	{}	[820]	0	986	18	31										1	1						4	2		3	2
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
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
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
1173	[]	Erityisluokkaopetus	Undervisning i specialklass	Special class education	660	2018-08-07T14:00:26.138862+03:00	3	1098	{}	[660]	1	1087	4	10											1						5
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