servicemap

Custom SQL query returning 12 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 "parent" = :p0 order by unit_count_municipality_kotka 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ää
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
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
1119	[]	Lisäopetus (10. luokka)	Påbyggnadsundervisning (10:de klass)	Supplementary education (10th grade)	657	2018-10-25T08:00:07.670545+03:00	3	1098	{}	[657]	1	1087	5	7			2
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
1169	[1170, 1171, 1172]	Soveltuvuuskoepainotus	Intensifierad undervisning, lämplighetstest	Emphasis on aptitude tests		2018-08-07T14:00:26.110528+03:00	3	1098	{}	[]	0	1087	40	44			4
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
1174	[]	Ruotsin kielikylpyopetus	Språkbadsundervisning på svenska	Language immersion education in Swedish	295	2018-08-07T14:00:26.145715+03:00	3	1098	{}	[295]	1	1087	13	18		4	1
1177	[]	Kansainvälinen opetus (IB)	Internationell undervisning (IB)	International education (IB)	510	2018-08-07T14:00:26.169911+03:00	3	1098	{}	[510]	1	1087	4	6		2
1181	[1186, 1183, 1182, 2134, 1184]	Iltapäivätoiminta	Eftermiddagsverksamhet	Afternoon activities	656	2018-08-07T14:00:26.201113+03:00	3	1098	{}	[656]	1	1087	238	240		2
2014	[]	Valmistava opetus luokille 1-2 (maahanmuuttajat)	Förberedande undervisning för årskurserna 1-2 (invandrare)	Preparatory education for grades 1-2 (immigrants)	843	2018-08-07T14:00:25.463637+03:00	3	1098	{}	[843]	1	1087		3			3
2215	[]	Valmistava opetus luokille 3-6	Förbererande undervisning för årskurserna 3-6	Preparatory education for grades 3-6	893	2020-05-08T12:30:12.951754+03:00	3	1098	{}	[893]	1	1087	13	13
2216	[]	Valmistava opetus luokille 7-9	Förbererande undervisning för årskurserna 7-9	Preparatory education for grades 7-9	894	2020-05-08T12:30:12.979716+03:00	3	1098	{}	[894]	1	1087	9	9