servicemap

Custom SQL query returning 15 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_porvoo" = :p0 order by last_modified_time 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_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ää
231	[232, 233, 238, 239, 240, 241, 242, 243, 244, 245, 253, 254, 255]	Kiinteistöt ja rakennetut tilat	Fastigheter	Real estate		2018-08-07T14:00:22.059452+03:00	2	221	{}	[]	1400	311	427				1	1				1		1			2			2				48				55			5
255	[256, 257, 258, 265]	Tilojen vuokraus ja varaus	Uthyrning och reservering av lokaler	Renting out and reservation of facilities		2018-08-07T14:00:22.202500+03:00	3	231	{}	[]	1400	294	380				1	1				1		1			2			2				42				32			4
258	[2210, 259, 261, 260, 263, 264]	Vapaa-ajan tilojen vuokraus	Uthyrning av fritidslokaler	Renting recreational spaces		2018-08-07T14:00:22.220951+03:00	4	255	{}	[]	1400	292	375				1	1				1		1			2			2				40				31			4
260	[]	Kokouspaikat	Möteslokaler	Meeting places	326	2018-08-07T14:00:22.232800+03:00	5	258	{}	[326]	1400	247	293				1	1				1					2			2				17				22
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	{}	[]	1403	1745	2452				1	1	1			1	8	1			2		4	2				382				286	1		13	4
505	[2208, 506, 508, 507, 510, 511]	Vapaa-ajan tilojen vuokraus	Uthyrning av fritidslokaler	Renting recreational spaces		2018-08-07T14:00:22.797039+03:00	2	343	{}	[]	1403	292	375				1	1				1		1			2			2				40				31			4
507	[]	Kokouspaikat	Möteslokaler	Meeting places	326	2018-08-07T14:00:22.812763+03:00	3	505	{}	[326]	1403	247	293				1	1				1					2			2				17				22
742	[]	Kokouspaikat	Möteslokaler	Meeting places	326	2018-08-07T14:00:24.534199+03:00	3	718	{}	[326]	1403	247	293				1	1				1					2			2				17				22
1017	[]	Laboratorio	Laboratorium	Laboratory	366	2018-08-07T14:00:29.386729+03:00	1	986	{}	[366]	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]	986	11	42	1	1		1		1								2	1	1	1	1	1	1	6		1	1	6	1	1		1	1	1
122	[123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167]	Elinkeino, työ ja verotus	Näringar, arbete och beskattning	Entrepreneurship, work and taxation		2018-08-07T14:00:29.995212+03:00	1	1401	{}	[]	1401	322	452				2	1				1	2	1			2			2				51				62			5		1
146	[147, 148, 149, 156]	Tilojen vuokraus ja varaus	Uthyrning och reservering av lokaler	Renting out and reservation of facilities		2018-08-07T14:00:30.157480+03:00	2	122	{}	[]	1401	294	380				1	1				1		1			2			2				42				32			4
149	[2209, 150, 152, 151, 154, 155]	Vapaa-ajan tilojen vuokraus	Uthyrning av fritidslokaler	Renting recreational spaces		2018-08-07T14:00:30.179684+03:00	3	146	{}	[]	1401	292	375				1	1				1		1			2			2				40				31			4
151	[]	Kokouspaikat	Möteslokaler	Meeting places	326	2018-08-07T14:00:30.193967+03:00	4	149	{}	[326]	1401	247	293				1	1				1					2			2				17				22
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	0		{}	[]	1401	448	629				2	1				1	2	1			2			3				88				74			6		1