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 order by id 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_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_espoo	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
717	[754, 718, 2173, 2028]	Matkailu ja tapahtumat	Turism och evenemang	Things to do		2020-03-06T18:32:07.102459+02:00	1	1403	{}	[]	0	1403	1973	2155	1	1	1	1	2	1	1	3		5	3	87	67	1	1	3	4
755	[756, 768, 769]	Oikeusturva ja demokratia	Rättsskydd och demokrati	Justice system and democracy		2020-03-06T18:32:09.608464+02:00	1	1401	{}	[]	0	1401	15	46												28	2			1
829	[]	Kotihoito	Hemvård	Home care	635	2020-03-06T18:32:08.579934+02:00	2	819	{}	[635]	0	783	69	95												19	4			3
868	[2029, 975, 961, 985, 869, 983]	Lasten päivähoito	Barndagvård	Day care		2020-03-06T18:32:08.678128+02:00	1	1405	{}	[]	0	1405	675	1264												365	212			12
995	[]	Hammashoito	Tandvård	Dental care	184	2020-03-06T18:32:09.101816+02:00	1	986	{"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto", "hammashoitola"]}	[184]	0	986	36	98												20	41			1
996	[]	Kotihoito	Hemvård	Home care	635	2020-03-06T18:32:09.105708+02:00	1	986	{}	[635]	0	986	69	95												19	4			3
1048	[1050]	Hallintopalvelut	Förvaltningstjänster	Patient representative services		2020-03-06T18:32:09.249350+02:00	1	986	{}	[]	0	986		1													1
1089	[1090]	Suomen- ja vieraskielinen esiopetus	Förskoleundervisning på finska och främmande språk	Pre-primary education in Finnish, English and other languages	861	2020-03-06T18:32:07.479235+02:00	2	1088	{}	[861]	1	1087	289	484												78	117
1098	[1173, 1181, 1177, 1120, 1119, 1099, 1109, 1174, 1169, 2014, 2215, 2216]	Suomen- ja vieraskielinen perusopetus	Grundläggande utbildning på finska och främmande språk	Basic education in Finnish, English and other languages		2020-03-06T18:32:07.543511+02:00	2	1097	{}	[]	0	1087	368	504									1			84	50	1
1258	[1260, 1271, 1268, 1296, 1259]	Suomen- ja vieraskielinen nuorten lukiokoulutus	Gymnasieutbildning för unga på finska och främmande språk	General upper secondary education for the young in Finnish, English and other languages		2020-03-06T18:32:08.032022+02:00	2	1257	{}	[]	0	1087	31	54												15	8
1298	[1303, 1300, 1328, 1299]	Ruotsinkielinen nuorten lukiokoulutus	Gymnasieutbildning för unga på svenska	General upper secondary education for the young in Swedish		2020-03-06T18:32:08.157237+02:00	2	1257	{}	[]	0	1087	7	10												2	1
1336	[1340, 1337, 1341, 1338, 1342]	Suomen- ja vieraskielinen aikuisten perus- ja lukiokoulutus	Grundläggande utbildning och gymnasieutbildning för vuxna på finska och främmande språk	Comprehensive and upper secondary school education for adults in Finnish, English and other languages		2020-03-06T18:32:08.302751+02:00	2	1335	{}	[]	0	1087	3	8												2	3
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		{}	[]	0	1401	448	629	2	1		1	2	1		2			3	88	74			6		1
1405	[2118, 868, 2163]	Päivähoito ja esiopetus	Barndagvård och förskola	Daycare and pre-primary education		2020-03-06T18:32:08.672148+02:00	0		{}	[]	0	1405	951	1546												367	216			12
2049	[2055, 2053, 2050, 2054]	Suomen- ja vieraskielinen iltapäivätoiminta	Eftermiddagsverksamhet på finska och främmande språk	Afternoon activities in Finnish, English and other languages	656	2020-03-06T18:32:07.503687+02:00	2	2042	{}	[656]	1	1087	184	184
2122	[2125]	Suomen- ja vieraskielinen esiopetus	Förskoleundervisning på finska och främmande språk	Pre-primary education in Finnish, English and other languages	861	2020-03-06T18:32:09.045855+02:00	2	2118	{}	[861]	1	1405	289	484												78	117