servicemap

Custom SQL query returning 25 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 "unit_count_municipality_kauniainen" = :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_raasepori	unit_count_municipality_siuntio	unit_count_municipality_sipoo	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ää
joukkoliikennepysäkit	kollektivtrafikens hållplatser	public transport stops	209	{}	1402		3																1							2
kansanopistot	folkhögskolor	folk high schools	244	{}	1087		3																1							2
kielikylpy suomi-ruotsi (lasten päivähoito)	språkbad finska-svenska (barndagvård)	language immersion Finnish-Swedish (child day care)	294	{}	1405	9	19																5				3			2
koripallokentät	basketplaner	basketball courts	331	{}	1403	155	258																64				37			2
kulttuurin monitoimitalot	allaktivitetshus för kultur	multi-functional culture venues	345	{}	1403	8	18																3				5			2
kuntosalit	gym	gyms	350	{}	1403	151	237																45				39			2
kuntoutussuunnittelu ja -ohjaus	rehabiliteringsplanering och -handledning	rehabilitation planning and guidance	355	{}	986		4																1				1			2
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
laskettelun suorituspaikat	slalombackar	ski slopes and downhill ski resorts	376	{}	1403	2	6																2							2
liikuntapuistot	idrottsparker	sports parks	401	{}	1403		7																3				2			2
luistelukentät	skridskobanor	ice skating fields	406	{}	1403	137	309																100				70			2
muovinkeräys	plastinsamling	plastic recycling	454	{}	1400	23	70																29				16			2
näyttelytilat (kulttuuri)	utställningslokaler (kultur)	exhibition spaces (culture)	474	{}	1403	105	114																7							2
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
pahvinkeräys	insamling av wellpapp	corrugated cardboard recycling	491	{}	1400	2	7																1				2			2
rautatieasemat	järnvägsstationer	railway stations	576	{}	1402	16	41																9				14			2
ruotsinkielinen työväenopisto	svenska arbetarinstitutet	Swedish Adult Education Centre	605	{}	1087	6	9																1							2
suomenkielinen työväenopisto	finska arbetarinstitutet	Finnish Adult Education Centre	665	{}	1087	50	59																7							2
tekstiilien keräys	textilinsamling	textile recycling	696	{}	1400	40	108																37				29			2
tenniskenttäalueet	områden med tennisbanor	tennis court areas	700	{"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]}	1403	45	83																11				25			2
vanhuspalvelun itsenäinen asuminen	självständigt boende inom äldreservicen	services for the elderly, independent living	757	{}	783		4																				2			2
vanhuspalvelun sosiaalityö	socialt arbete inom äldreservicen	services for the elderly, social work	764	{}	783	5	16																1				8			2
vuokrattavat harrastustilat	fritidslokaler för uthyrning	recreational space for rent	799	{}	1400	3	8																2				1			2
yleiset pysäköintialueet	allmänna parkeringsområden	public parking lots	814	{}	1402	1	346																343							2
yleiset väestönsuojat	allmänna befolkningsskyddsrum	general public shelters	815	{}	1061	27	29																							2