3 rows where "StartedDate" is on date 2020-07-15

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
120 2496 03459423-a538-4952-ba0c-c020face9151 Coyote Fire Panoche Road and Coyote Creek, West of Panoche 36.653 -121.04401 1,508 100% San Benito 2020-07-18 07:36:18 2020-07-15 CAL FIRE San Benito- Monterey Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/15/coyote-fire/ N
121 2497 79575aba-0ca4-446e-a28e-39bafbad368e Ben Fire Ben Hur Road and Buckeye Road, South of Mariposa 37.42319 -119.95807 48 100% Mariposa 2020-07-18 07:58:22 2020-07-15 CAL FIRE Madera-Mairposa-Merced Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/15/ben-fire/ N
122 2498 d268fd6c-a177-47b2-b13c-2ac26a02289e Valley Fire Spenceville Road and Gandry Drive, Southeast of Beale Air Force base 39.10112 -121.33589 500 100% Yuba 2020-07-15 19:12:02 2020-07-15 Department of Defense Wildfire https://www.fire.ca.gov/incidents/2020/7/15/valley-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
);