3 rows where "StartedDate" is on date 2020-08-03

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
162 2538 e2d97d53-bcff-4f0d-8b94-0ccfeb100f15 Elsmere Fire Elsmere Grapevine Rd and Santa Clarita Truck Trail, Newhall 34.3428 -118.49731 200 100% Los Angeles 2020-08-24 14:47:49 2020-08-03 Los Angeles County Fire Department and USFS Angeles National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/3/elsmere-fire/ N
163 2539 e2334135-81c5-44a5-b20d-c3a9b1301531 Stagecoach Fire Stagecoach Drive and Piute Meadow Road South of Lake Isabella in Kern County. 35.43044 -118.53361 7,760 100% Kern 2020-08-18 17:51:29 2020-08-03 Unified Command: Kern County Fire Department, Bureau of Land Management and Sequoia National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/3/stagecoach-fire/ N
164 2540 88172824-3f0b-4b05-a97a-bd2eb7576642 166 Fire Highway 166 and Highway 33, East of Cuyama in San Luis Obispo County 34.93442 -119.5795     San Luis Obispo 2020-11-10 14:24:14 2020-08-03 Bureau of Land Management - California Wildfire https://www.fire.ca.gov/incidents/2020/8/3/166-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
);