unit_connection

4 rows where contact_person = "Halme Outi", name_en = "Leading playground instructor" and section_type = "PHONE_OR_EMAIL"

✖
✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ section_type name_fi www_fi phone contact_person unit www www_sv name_sv name_en www_en name
197821 PHONE_OR_EMAIL Johtava leikkipuisto-ohjaaja   +358 9 310 41358 Halme Outi 327     Ledande lekparksledare Leading playground instructor    
197833 PHONE_OR_EMAIL Johtava leikkipuisto-ohjaaja   +358 9 310 41358 Halme Outi 330     Ledande lekparksledare Leading playground instructor    
197874 PHONE_OR_EMAIL Johtava leikkipuisto-ohjaaja   +358 9 310 41358 Halme Outi 337     Ledande lekparksledare Leading playground instructor    
197898 PHONE_OR_EMAIL Johtava leikkipuisto-ohjaaja   +358 9 310 41358 Halme Outi 346     Ledande lekparksledare Leading playground instructor    

Advanced export

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

CSV options: 

CREATE TABLE [unit_connection] (
   [id] INTEGER PRIMARY KEY,
   [section_type] TEXT,
   [name_fi] TEXT,
   [www_fi] TEXT,
   [email] TEXT,
   [phone] TEXT,
   [contact_person] TEXT,
   [unit] INTEGER,
   [www] TEXT,
   [www_sv] TEXT,
   [name_sv] TEXT,
   [name_en] TEXT,
   [www_en] TEXT,
   [name] TEXT
);