servicemap: department: 1 row where where address_postal_full_en = "P.O.Box 38, 00014 University of Helsinki"

1 row where address_postal_full_en = "P.O.Box 38, 00014 University of Helsinki"

descending

id ▼	parent	business_id	name_fi	abbr	street_address	address_city	address_postal_full	www	phone	address_zip	oid	organization_type	level	municipality	www_sv	street_address_sv	street_address_en	address_postal_full_en	address_city_fi	name_en	www_en	address_postal_full_sv	abbr_fi	address_postal_full_fi	abbr_sv	abbr_en	address_city_en	name_sv	street_address_fi	address_city_sv	www_fi
acf5cd5b-f1cc-48ee-9526-2390e2d5bdbc	3afbf1eb-4593-4f64-ad6f-8cb629a877f7	0201256-6	Helsingin normaalilyseo						+358 29 419 11	00120	#10	GOVERNMENT	3		https://www.helsinki.fi/sv/ovningsskolor/helsingin-normaalilyseo	Bangatan 6	Ratakatu 6	P.O.Box 38, 00014 University of Helsinki	Helsinki	Helsinki Normal Lyceum	https://www.helsinki.fi/en/training-schools/helsingin-normaalilyseo	PB 38, 00014 Helsingfors universitet	Norssi	PL 38, 00014 Helsingin yliopisto			Helsinki	Normallyceum i Helsingfors	Ratakatu 6	Helsingfors	https://www.helsinki.fi/fi/harjoittelukoulut/helsingin-normaalilyseo

Advanced export

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

CREATE TABLE [department] (
   [id] TEXT PRIMARY KEY,
   [parent] TEXT,
   [business_id] TEXT,
   [name_fi] TEXT,
   [abbr] TEXT,
   [street_address] TEXT,
   [address_city] TEXT,
   [address_postal_full] TEXT,
   [www] TEXT,
   [phone] TEXT,
   [address_zip] TEXT,
   [oid] TEXT,
   [organization_type] TEXT,
   [level] INTEGER,
   [municipality] TEXT,
   [www_sv] TEXT,
   [street_address_sv] TEXT,
   [street_address_en] TEXT,
   [address_postal_full_en] TEXT,
   [address_city_fi] TEXT,
   [name_en] TEXT,
   [www_en] TEXT,
   [address_postal_full_sv] TEXT,
   [abbr_fi] TEXT,
   [address_postal_full_fi] TEXT,
   [abbr_sv] TEXT,
   [abbr_en] TEXT,
   [address_city_en] TEXT,
   [name_sv] TEXT,
   [street_address_fi] TEXT,
   [address_city_sv] TEXT,
   [www_fi] TEXT
);