servicemap

Custom SQL query returning 9 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_hyvinkää" = :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_lohja	unit_count_municipality_espoo	unit_count_municipality_vantaa	unit_count_municipality_hyvinkää	unit_count_municipality_kauniainen
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
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
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
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
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