2 rows where PercentContainedDisplay = "100%" and "StartedDate" is on date 2020-08-20

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
205 2598 c57a1d32-216b-443e-bb67-87be3232bf8b Moc Fire Hwy 49 and Hwy 120, Moccasin 37.813779 -120.312565 2,857 100% Tuolumne 2020-08-30 19:14:52 2020-08-20 CAL FIRE Tuolumne-Calaveras Unit and Central California District Wildfire https://www.fire.ca.gov/incidents/2020/8/20/moc-fire/ N
206 2599 d09da426-ed85-4909-892b-2505c4813d93 Volcano Fire De Luz Rd and Tenaja Truck Trail, west of Temecula City 33.454896 -117.328234 45 100% San Diego 2020-08-22 21:22:19 2020-08-20 CAL FIRE /San Diego County Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/8/20/volcano-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
);