3 rows where PercentContainedDisplay = "100%" and "UpdatedDate" is on date 2020-08-17

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
126 2502 fc0b7761-54a3-4275-a550-313d2b604f5e Hog Fire Hog Flat Reservoir, West of Susanville 40.420886 -120.86375 9,564 100% Lassen 2020-08-17 21:07:24 2020-07-18 CAL FIRE Lassen-Modoc Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/18/hog-fire/ N
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

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
);