servicemap

Custom SQL query returning 16 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 and "unit_count_municipality_lohja" = :p1 order by unit_count_municipality__unknown 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
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
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
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
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
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
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
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
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
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
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
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
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