servicemap

Custom SQL query returning 60 rows (hide)

select name_fi, name_sv, name_en, id, period_enabled, clarification_enabled, keywords, root_service_node, 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_null, [unit_count_municipality_nurmijärvi], unit_count_municipality_virolahti, unit_count_municipality_pornainen, [unit_count_municipality_hämeenlinna], unit_count_municipality_salo, [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_kotka, unit_count_municipality_askola, [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_karkkila, [unit_count_municipality_järvenpää], unit_count_municipality_kerava, [unit_count_municipality_pyhtää] from service where "root_service_node" = :p0 order by id limit 101

Query parameters

This data as json, CSV

name_fi	name_sv	name_en	id	keywords	root_service_node	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_null	unit_count_municipality_nurmijärvi	unit_count_municipality_virolahti	unit_count_municipality_pornainen	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_kotka	unit_count_municipality_askola	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_karkkila	unit_count_municipality_järvenpää	unit_count_municipality_kerava	unit_count_municipality_pyhtää
aikuisten terveyskeskuspäivystys ja päivystyspoliklinikka	hälsocentraljour och jourpoliklinik för vuxna	health centre on-call service and emergency outpatient clinic for adults	43	{"fi": ["p\u00e4ivystys"]}	986		3																		1				1			1
akuuttipsykiatria	akutpsykiatri	acute psychiatry	46	{}	986	1	4																						3
apteekit	apotek	pharmacies	57	{}	986	1	8																						7
ensihoito	akutvård	emergency care	154	{}	986		0
fysiatria	fysiatri	physiatrics	171	{}	986		0
fysioterapia	fysioterapi	physiotherapy	172	{"fi": ["kuntoutus"]}	986	11	21																		4				5			1
hallinto (terveyspalvelut)	förvaltning (hälsovårdstjänster)	administration (health care)	182	{}	986		0
hammashoito	tandvård	dental care	184	{"fi": ["hammashoitola", "hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto"]}	986	36	98																		20				41			1
ikääntyvien neuvonta	rådgivning för äldre	information and advice for elderly people	199	{}	986		4																		2				2
jalkaterapia	fotterapi	podiatry	206	{}	986	7	10																						2			1
kaupungin tai kunnan psykiatriset sairaalat	stadens eller kommunens psykiatriska sjukhus	city or municipal psychiatric hospitals	263	{}	986	2	2
kaupungin tai kunnan sairaalat	stads- eller kommunalsjukhus	city or municipal hospitals	264	{}	986	9	11																		1				1
kohdunkaulan syövän seulontatutkimukset	screeningar för livmoderhalscancer	cervical cancer screening	316	{}	986		0
kotisairaalat	hemsjukhus	home hospitals	336	{}	986	3	4																						1
kouluterveydenhuolto	skolhälsovård	school health care	339	{}	986	160	236												1						1				68	1		5
kuntoutuksen apuvälinepalvelut	hjälpmedelstjänster inom rehabilitering	rehabilitation medical aid services	352	{}	986	5	10																		1				3			1
kuntoutuksen vuodeosastopalvelut	bäddavdelningstjänster inom rehabilitering	rehabilitation inpatient care	353	{}	986		3																		2				1
kuntoutuspsykiatria	rehabiliteringspsykiatri	rehabilitation psychiatry	354	{}	986	2	3																		1
kuntoutussuunnittelu ja -ohjaus	rehabiliteringsplanering och -handledning	rehabilitation planning and guidance	355	{}	986		4																		1				1			2
kuulontutkimus	hörselundersökning	audiometric test	357	{}	986		1																						1
laboratoriot	laboratorier	laboratories	366	{}	986	22	88		3	1	1		3	1	1	1	1	2	6	3	3	1	7	1	10	3	1	1	8	1	1	2	1	1	1	1
lasten terveyskeskuspäivystys ja päivystyspoliklinikka	hälsocentraljour och jourpoliklinik för barn	health centre on-call service and emergency outpatient clinic for children	378	{}	986		3																		1				1			1
lastenneuvolat	barnrådgivningar	child health clinics	379	{}	986	22	47																		14				10			1
lääkinnällinen kuntoutus	medicinsk rehabilitering	medical rehabilitation	416	{}	986	1	5																		2				1			1
lääkärin vastaanotto	läkarmottagning	doctor's appointments	417	{"fi": ["mielenterveys", "terveysasemat"]}	986	26	50																		11				12			1
mielenterveyden erikoissairaanhoito	psykiatrisk specialsjukvård	mental health specialised medical care	440	{}	986	2	2
myrkytystietoa	giftinformation	poison information	461	{}	986		1					1
neurologia	neurologi	neurology	462	{}	986		6																						6
neuvolat	rådgivningar	maternity and child health clinics	463	{}	986	1	5																		4
omahoitotarvikejakelu	utdelning av egenvårdsartiklar	distribution of self-treatment products	477	{"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]}	986	1	6																						3			2
perhesuunnittelu- ja ehkäisyneuvolat	familjeplanerings- och preventivrådgivningar	family planning clinics	507	{}	986		5																		4							1
potilasasiamiehet	patientombudsmän	patient representatives	520	{}	986		1																						1
psykiatrian poliklinikat	psykiatriska polikliniker	psychiatric outpatient clinics	521	{}	986	19	19
psykiatrinen asumiskuntoutus	psykiatrisk boenderehabilitering	psychiatric residential rehabilitation	522	{}	986	3	6																		1				2
psykiatrinen perhehoito	psykiatrisk familjevård	psychiatric family care	523	{}	986	2	2
psykiatriset päiväsairaalat	psykiatriska dagsjukhus	psychiatric day hospitals	524	{}	986	2	2
psykologitoiminta	psykologverksamhet	psychologists	525	{}	986	4	10																		1				4			1
psykoterapia	psykoterapi	psychotherapy	526	{}	986	2	2
puheterapia	talterapi	speech therapy	527	{"fi": ["kuntoutus"]}	986	2	13																		5				5			1
päihdehuollon päivätoiminta	dagverksamhet inom missbrukarvården	substance abuse services, daytime activities	547	{}	986	4	5																						1
päivystyksen vuodeosastot	bäddavdelningar inom jourverksamheten	emergency care outpatient wards	550	{}	986		4																		4
päiväsairaalat	dagsjukhus	day hospitals	553	{}	986		2																		1				1
ravitsemusterapia	näringsterapi	nutritional therapy	579	{}	986		1																						1
rintamavetaraanien kuntoutus	rehabilitering av frontveteraner	front-line veteran rehabilitation	583	{}	986	1	6																						4			1
rintasyövän seulontatutkimukset	bröstcancerscreeningar	breast cancer screening	584	{}	986		0
röntgenit	röntgen	x-rays	606	{}	986	11	42	1	1		1		1					2	1	1	1	1	1	1	6	1		1	6	1	1		1	1	1
sairaaloiden poliklinikat	sjukhuspolikliniker	hospital outpatient clinics	610	{}	986	3	3
selviämishoitoasemat	tillnyktringsstationer	detoxification centres	618	{}	986	1	2																		1
silmätaudit	ögonsjukdomar	eye diseases	622	{}	986	1	2																						1
synnytyssairaalat	förlossningssjukhus	maternity hospitals	667	{}	986	1	2																		1
tartuntataudit	smittsamma sjukdomar	infectious diseases	693	{"fi": ["tartuntatauti", "tartuntataudit"]}	986	1	3																						2
terveydenhoitajan vastaanotto	hälsovårdarmottagning	nurse's appointments	702	{}	986	26	50																		11				12			1
terveysasemat	hälsostationer	health stations	703	{"fi": ["mielenterveys", "terveysasemat"]}	986	25	49																		12				11			1
terveyspalvelujen sähköinen asiointi ja lomakkeet	elektroniska tjänster och formulär inom hälso- och sjukvården	electronic services and forms related to health services	704	{}	986		2					1																	1
toimintaterapia	ergoterapi	occupational therapy	712	{"fi": ["kuntoutus"]}	986	9	13																		1				3
työterveyshuolto	företagshälsovård	occupational health care	726	{}	986	1	2																		1
yliopistolliset sairaalat	universitetssjukhus	university hospitals	820	{}	986	18	31											1	1						4	2			3	2
äitiysneuvolat	mödrarådgivningar	maternity clinics	835	{}	986	22	47																		14				10			1
palliatiivinen hoito	palliativ vård	palliative care	858	{}	986	1	1
terveys- ja hyvinvointikeskukset	centraler för hälsa och välbefinnande	health and well-being centres	876	{}	986	2	11																		1				8