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

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
70 2446 2a79a833-693d-4dff-a199-c93b5a3ebe39 Nelson Fire Nelson Rd and Rockwell Ln, west of Lincoln 38.89178 -121.33956 110 100% Placer 2020-06-18 19:24:38 2020-06-18 CAL FIRE Nevada-Yuba-Placer Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/18/nelson-fire/ N
71 2447 0fc1bc5b-7ac5-4a2c-8048-9ed74623b838 Fork Fire South Fork Dr and Salt Creek Fire Control Rd, East of Three Rivers 36.37085 -118.845123 130 100% Tulare 2020-07-24 15:34:43 2020-06-18 CAL FIRE Tulare Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/18/fork-fire/ N
72 2448 036cc8f1-ab4e-488c-8c46-86ebbb176d3e Teddy Fire Teddy Lane and Bangor Park Rd., Bangor 39.37577 -121.45372 13 100% Butte 2020-06-25 08:53:58 2020-06-18 CAL FIRE Butte Unit/Butte County Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/6/18/teddy-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
);