2 rows where address_city_en = "Helsinki" and organization_type = "JOINT_MUNICIPAL_AUTHORITY"

View and edit SQL

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
84075c47-a8e4-4a45-a109-65221f63b3bf   1567535-0 HUS-kuntayhtymä           +358 9 4711 00290 HUS JOINT_MUNICIPAL_AUTHORITY 0   http://www.hus.fi/sv/Sidor/default.aspx       Helsinki HUS Hospital District http://www.hus.fi/en/Pages/default.aspx   HUS       Helsinki Samkommunen HNS Stenbäckinkatu 9 Helsingfors http://www.hus.fi/Sivut/default.aspx
e34b3a4a-27f1-4ed1-8954-876efcba62ad   2274241-9 Helsingin seudun ympäristöpalvelut HSY           +358 9 1561 2110 00240 1004-HSY JOINT_MUNICIPAL_AUTHORITY 0   https://www.hsy.fi/sv/info/Sidor/kontaktuppgifter.aspx Ilmalatorget 1 Ilmalankatu 1 P.O.Box 100, 00066 HSY Helsinki Helsinki Region Environmental Services Authority https://www.hsy.fi/en/abouthsy/Pages/Contactus.aspx PB 100, 00066 HRM HSY PL 100, 00066 HSY     Helsinki Helsingforsregionens miljötjänster Ilmalantori 1 Helsinfors https://www.hsy.fi/fi/tietoa-hsy/Sivut/yhteystiedot.aspx

Advanced export

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

CSV options:

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