servicemap: service: 8 rows where where root_service_node = 1400 and unit_count_municipality_helsinki = 3 sorted by unit_count_municipality

8 rows where root_service_node = 1400 and unit_count_municipality_helsinki = 3 sorted by unit_count_municipality_porvoo

descending

id	name_fi	name_sv	name_en	keywords	root_service_node	unit_count_municipality_helsinki	unit_count_total	unit_count_municipality_sipoo	unit_count_municipality_kirkkonummi	unit_count_municipality_espoo	unit_count_municipality_vantaa	unit_count_municipality_kauniainen	unit_count_municipality_kerava
75	asumisen tuet	bostadsbidrag	housing allowances	{}	1400	3	9	1		2	2		1
259	kauppahallit	saluhallar	market halls	{}	1400	3	3
298	kierrätyskeskukset	återvinningscentraler	recycling centres	{}	1400	3	7		1	1	1	1
315	kirpputorit	loppisar	flea markets	{}	1400	3	3
393	liike- ja toimistotilojen vuokraus	uthyrning av affärs- och kontorslokaler	commercial and office space rental	{}	1400	3	5			2
564	rakentamisen materiaalipalvelut	materialtjänster för byggande	construction material services	{}	1400	3	3
718	tuotantotilojen vuokraus	uthyrning av produktionslokaler	production facility rental	{}	1400	3	4			1
799	vuokrattavat harrastustilat	fritidslokaler för uthyrning	recreational space for rent	{}	1400	3	8			2	1	2

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [service] (
   [name_fi] TEXT,
   [name_sv] TEXT,
   [name_en] TEXT,
   [id] INTEGER PRIMARY KEY,
   [period_enabled] INTEGER,
   [clarification_enabled] INTEGER,
   [keywords] TEXT,
   [root_service_node] INTEGER,
   [unit_count_municipality_helsinki] INTEGER,
   [unit_count_total] INTEGER,
   [unit_count_municipality_hanko] TEXT,
   [unit_count_municipality_raasepori] TEXT,
   [unit_count_municipality_siuntio] TEXT,
   [unit_count_municipality_sipoo] TEXT,
   [unit_count_municipality_janakkala] TEXT,
   [unit_count_municipality_null] INTEGER,
   [unit_count_municipality_nurmijärvi] TEXT,
   [unit_count_municipality_virolahti] TEXT,
   [unit_count_municipality_pornainen] TEXT,
   [unit_count_municipality_hämeenlinna] TEXT,
   [unit_count_municipality_salo] TEXT,
   [unit_count_municipality_lapinjärvi] TEXT,
   [unit_count_municipality_inkoo] TEXT,
   [unit_count_municipality_miehikkälä] TEXT,
   [unit_count_municipality_porvoo] TEXT,
   [unit_count_municipality_lohja] TEXT,
   [unit_count_municipality_tuusula] TEXT,
   [unit_count_municipality_kirkkonummi] TEXT,
   [unit_count_municipality_hamina] TEXT,
   [unit_count_municipality_kouvola] TEXT,
   [unit_count_municipality_loviisa] TEXT,
   [unit_count_municipality_espoo] INTEGER,
   [unit_count_municipality_kotka] TEXT,
   [unit_count_municipality_askola] TEXT,
   [unit_count_municipality_mäntsälä] TEXT,
   [unit_count_municipality_vantaa] INTEGER,
   [unit_count_municipality_hyvinkää] TEXT,
   [unit_count_municipality_vihti] TEXT,
   [unit_count_municipality_kauniainen] INTEGER,
   [unit_count_municipality_karkkila] TEXT,
   [unit_count_municipality_järvenpää] TEXT,
   [unit_count_municipality_kerava] TEXT,
   [unit_count_municipality_pyhtää] TEXT
);