6 rows where "modified_at" is on date 2020-03-04

View and edit SQL

modified_at (date)

  • 2020-03-04 · 6
id ▼ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
3582 VALLILA ocd-division/country:fi/kunta:helsinki/neuvola-alue:vallila 11961     2020-03-04T16:51:28.923557+02:00 maternity_clinic_district 32 helsinki Vallila    
3584 MYLLYPURO ocd-division/country:fi/kunta:helsinki/neuvola-alue:myllypuro 32142     2020-03-04T16:51:28.930041+02:00 maternity_clinic_district 32 helsinki Myllypuro    
3585 KANNELMÄKI ocd-division/country:fi/kunta:helsinki/neuvola-alue:kannelmäki 11914     2020-03-04T16:51:28.880951+02:00 maternity_clinic_district 32 helsinki Kannelmäki    
3590 KIVIKKO ocd-division/country:fi/kunta:helsinki/neuvola-alue:kivikko 11945     2020-03-04T16:51:28.856411+02:00 maternity_clinic_district 32 helsinki Kivikko    
3591 KONTULA ocd-division/country:fi/kunta:helsinki/neuvola-alue:kontula 11891     2020-03-04T16:51:28.862168+02:00 maternity_clinic_district 32 helsinki Kontula    
3893 HERTTONIEMI ocd-division/country:fi/kunta:helsinki/neuvola-alue:herttoniemi 11981     2020-03-04T16:51:28.850203+02:00 maternity_clinic_district 32 helsinki Herttoniemi    

Advanced export

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

CSV options:

CREATE TABLE [administrative_division] (
   [id] INTEGER PRIMARY KEY,
   [origin_id] TEXT,
   [ocd_id] TEXT,
   [service_point_id] TEXT,
   [start] TEXT,
   [end] TEXT,
   [modified_at] TEXT,
   [type] TEXT,
   [parent] INTEGER,
   [municipality] TEXT,
   [name_fi] TEXT,
   [name_sv] TEXT,
   [name] TEXT
);