servicemap: department: 1 row where where level = 2 and phone = "+358 50 524 1781"

1 row where level = 2 and phone = "+358 50 524 1781"

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
7ef7b350-bf83-4238-ba1e-a70bbc5c8f65	dffee33d-d6a3-4372-9813-7c871c3b9eb5	1475442-8	Forum Box - Tila taiteelle						+358 50 524 1781	00180		UNKNOWN	2						Helsinki	Forum Box - Tila taiteelle								Forum Box - Tila taiteelle	Ruoholahdenranta 3 a		https://forumbox.fi/

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
);