servicemap

Custom SQL query returning 23 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_kerava" = :p0 order by unit_count_municipality_karkkila 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ää
4	[]	Asumisen tuet	Bostadsbidrag	Housing allowances	75	2018-08-07T14:00:21.243003+03:00	2	2	{}	[75]	1400	3	9				1																	2				2					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
130	[]	Eläkkeet	Pensioner	Pension matters	143	2018-08-07T14:00:30.054750+03:00	2	122	{}	[143]	1401	4	10				1																	2				2					1
171	[2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219]	Hallinto ja talous	Förvaltning och ekonomi	Administration and economy		2018-08-07T14:00:30.363012+03:00	1	1401	{}	[]	1401	124	163				1													1				17				17			2		1
187	[188, 189]	Maahanmuutto	Invandring	Immigration		2018-08-07T14:00:30.506450+03:00	2	171	{}	[]	1401	17	29				1																	4				5			1		1
188	[]	Kelan etuudet	FPA:s förmåner	Kela benefits	286	2018-08-07T14:00:30.511334+03:00	3	187	{}	[286]	1401	3	9				1																	2				2					1
797	[]	Lapsiperheen tuet	Förmåner för barnfamiljer	Benefits for families with children	370	2020-08-20T14:00:09.399199+03:00	1	783	{}	[370]	783	3	9				1																	2				2					1
798	[805, 803, 807, 808, 806, 802, 801, 799, 800, 804, 809]	Vammaispalvelut	Handikapptjänster	Services for the disabled		2018-08-07T14:00:27.804536+03:00	1	783	{}	[]	783	14	59				2																	7				34			1		1
809	[]	Vammaistuet ja -palvelut	Handikappbidrag och -tjänster	Disability benefits and services	755	2018-08-07T14:00:27.876348+03:00	2	798	{}	[755]	783	3	15				1																	2				7			1		1
813	[]	Kehitysvammahuollon päivätoiminta	Dagverksamhet inom vård av utvecklingsstörda	Care of the developmentally disabled, daytime activities	278	2018-08-07T14:00:27.899777+03:00	2	810	{}	[278]	783	10	18																					3				4					1
815	[]	Kehitysvammahuollon asumispalvelut	Boendetjänster inom vård av utvecklingsstörda	Care of the developmentally disabled, residential services	275	2018-08-07T14:00:27.912869+03:00	2	810	{}	[275]	783	39	71																					9				21			1		1
819	[829, 827, 821, 820, 828, 824, 826, 825, 823, 822]	Vanhuspalvelu	Äldreomsorg	Service for the elderly		2018-08-07T14:00:27.946229+03:00	1	783	{}	[]	783	142	261				1																	67				44			6		1
825	[]	Vanhusten palveluasuminen	Serviceboende för äldre	Service residence for the elderly	760	2018-08-07T14:00:27.984445+03:00	2	819	{}	[760]	783	30	103				1																	36				32			3		1
839	[2011, 841, 843, 2012]	Toimeentulotuki	Utkomststöd	Social assistance		2018-08-07T14:00:28.080690+03:00	1	783	{}	[]	783	11	20				1																	3				3			1		1
843	[]	Perustoimeentulotuki	Grundläggande utkomststöd	Basic social assistance	711	2018-08-07T14:00:28.092481+03:00	2	839	{}	[711]	783	3	9				1																	2				2					1
845	[848, 846, 847, 851, 857, 2160, 849, 852, 853, 854, 856, 858, 850, 855]	Muu sosiaalihuolto	Övrig socialvård	Other social welfare		2018-08-07T14:00:28.112184+03:00	1	783	{}	[]	783	105	239				1																	11				118			3		1
847	[]	Alueellinen kumppanuustyö	Områdesvist partnerskapsarbete	Regional partnership work	49	2018-08-07T14:00:28.124411+03:00	2	845	{}	[49]	783	19	119				1																	1				96			1		1
1007	[]	Kehitysvammapoliklinikka	Handikapprådgivning	Developmental disability clinic	284	2018-10-25T08:00:09.092312+03:00	2	810	{}	[284]	783	4	6																									1					1
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	0		{}	[]	1087	1214	1867				1											2						274				362	2		11		1
1377	[]	Oppilaan ja opiskelijan tuet	Förmåner för elever och studerande	Pupil and student benefits	485	2018-08-07T14:00:27.654181+03:00	1	1087	{}	[485]	1087	4	15				1																	7				2					1
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
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