7 rows where parent = "6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce"

View and edit SQL

Suggested facets: oid, organization_type

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
2ea35a83-1051-4ba7-81d2-24d9ebebe8c2 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce 0124610-9 Kaupunkistrategian ja johdon toimiala, Vantaa               #11 MUNICIPALITY 1 vantaa           City Strategy and Management, Vantaa     Kajo         Verksamhetsområdet för stadens strategi och ledning, Vanda      
744852ab-9425-4329-9d1d-96fe0f132f63 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce 0124610-9 Kasvatuksen ja oppimisen toimiala, Vantaa               #11 MUNICIPALITY 1 vantaa           Education and Learning Department, Vantaa     Kaso         Verksamhetsområdet för fostran och lärande, Vanda      
8b2aec50-ce18-46f1-8211-446b8a81c187 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce 0124610-9 Konserni- ja asukaspalvelut, Vantaa               #11 MUNICIPALITY 1 vantaa           Group and Citizen Services, Vantaa     Konsas         Koncern- och invånarservice, Vanda      
b4e07809-a34e-4476-b210-2c29c1fd52cb 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce 0124610-9 Kaupunkikulttuurin toimiala, Vantaa           +358 9 839 11   #11 MUNICIPALITY 1 vantaa           Urban Culture Department, Vantaa     Kaku         Stadskulturens verksamhetsområde, Vanda      
cf66aaaa-c219-49b8-b00d-15babc9952a7 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce 0124610-9 Kaupunkiympäristön toimiala, Vantaa               #11 MUNICIPALITY 1 vantaa           Urban Environment Department, Vantaa     Kato         Stadsmiljöns verksamhetsområde, Vanda      
de363a63-45be-487c-bbec-e98accf372a2 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce 0124610-9 Sosiaali- ja terveydenhuollon toimiala, Vantaa               1.2.246.10.1246109.10.200 MUNICIPALITY 1 vantaa           Health and Social Welfare Department, Vantaa     Sote         Verksamhetsområdet för social- och hälsovård, Vanda      
ead5bb5f-235d-4f78-99c8-d5712a143088 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce 0124610-9 Senioriliikunta - Vantaa           +358 9 839 11     UNKNOWN 1                                    

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