4 rows where IsActive = "N", PercentContainedDisplay = "100%" and "StartedDate" is on date 2020-08-16

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
182 2558 f6f24a2c-2072-4736-bca7-9a615af3156d 3-2 Fire Sunrise Ridge Rd and Santa Rita Rd, East of Cayucos 35.519723 -120.801074 20 100% San Luis Obispo 2020-08-17 19:24:20 2020-08-16 CAL FIRE San Luis Obispo Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/16/3-2-fire/ N
183 2560 119469ac-fe6b-4934-ac17-36a73cefe958 Elk Fire west of Willows 39.52452 -122.427358 727 100% Glenn 2020-08-17 21:01:45 2020-08-16 CAL FIRE Tehama-Glenn Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/16/elk-fire/ N
184 2563 ff4d7735-a5d6-452f-8775-3b208eb046b2 River Fire Pine Canyon and River Rd, east of Salinas 36.60239 -121.62161 48,088 100% Monterey 2020-09-04 19:08:39 2020-08-16 CAL FIRE San Benito-Monterey Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/16/river-fire/ N
191 2577 d19ac7c7-c899-4600-82c9-fe24dc29f3c9 CZU Lightning Complex (Including Warnella Fire) Various locations across San Mateo and Santa Cruz Counties 37.17162 -122.22275 86,509 100% Santa Cruz, San Mateo 2020-09-23 15:43:36 2020-08-16 Unified Command Agencies: Santa Cruz Co. Sheriff’s Office, San Mateo Co. Sheriff’s Office, Felton Fire Protection District, Santa Cruz County Fire Department, San Mateo County Fire Department, Boulder Creek Fire Department, Ben Lomond Fire Protection District Wildfire https://www.fire.ca.gov/incidents/2020/8/16/czu-lightning-complex-including-warnella-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
);