3 rows where "StartedDate" is on date 2020-06-06

View and edit SQL

Suggested facets: UpdatedDate (date), StartedDate (date)

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
36 2412 e3e89516-4647-44bf-bd24-3293303f0776 Gulch Fire Stage Gulch Road and Lakeville Highway, North of Lakeville 38.216134 -122.536406 107 100% Sonoma 2020-06-08 18:33:16 2020-06-06 CAL FIRE Sonoma Lake Napa Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/6/gulch-fire/ N
37 2413 74b04a44-7cc1-4c8e-bd9e-9f3efa631df4 Quail Fire Quail Canyon Road and Pleasants Valley Road, Southwest of Winters 38.470809 -122.038208 1,837 100% Solano 2020-08-13 11:22:09 2020-06-06 CALFIRE Sonoma Lake Napa Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/6/quail-fire/ N
38 2414 b5527f83-ebbe-4b09-a701-4b4fe6d37b45 Willow Fire Willow Pass Court and Evora Road, Northeast of Concord 37.994368 -122.002811 100 100% Contra Costa 2020-06-07 07:55:42 2020-06-06 CALFIRE Santa Clara Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/6/willow-fire/ N

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [incidents] (
   [IncidentId] INTEGER,
   [UniqueId] TEXT,
   [Name] TEXT,
   [Location] TEXT,
   [Latitude] FLOAT,
   [Longitude] FLOAT,
   [AcresBurnedDisplay] TEXT,
   [PercentContainedDisplay] TEXT,
   [CountiesList] TEXT,
   [UpdatedDate] TEXT,
   [StartedDate] TEXT,
   [AdminUnit] TEXT,
   [IncidentTypeDisplay] TEXT,
   [Url] TEXT,
   [IsActive] TEXT
);