3 rows where "UpdatedDate" is on date 2020-09-06

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
187 2570 dae6355c-6a97-4031-a0cb-b34448bc41dc Beach Fire Hwy 120 and Forest Road 1N23, south of Mono Lake 37.919382 -119.010655     Mono 2020-09-06 20:23:17 2020-08-17 USFS Inyo National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/17/beach-fire/ N
195 2585 3fa74cb0-3c6d-49b1-bb20-3d7fba0c0249 Bell Fire Emigrant Wilderness, East of Pinecrest 38.183 -119.869     Tuolumne 2020-09-06 14:32:46 2020-08-18 Stanislaus National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/18/bell-fire/ N
199 2590 1eadad68-344e-4728-8390-b0d31b96333d Creek Fire Covelo, Highway 162 and Short Creek Rd 39.8174372 -123.2111007 820 100% Mendocino 2020-09-06 14:09:34 2020-08-18 CAL FIRE Mendocino Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/18/creek-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
);