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

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
153 2529 eeb8174a-f5a7-4fb1-b611-45e85c858326 Stump Fire Childs Meadow and Highway 89/36, Northeast of Mineral 40.34659 -121.6415 684 100% Tehama 2020-11-10 14:26:03 2020-08-01 Lassen National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/1/stump-fire/ N
154 2530 00f6ca27-183c-4c2d-99f4-0362ddb522ae Castaic Fire Main Ramp Road and Lake Hughes Road, South of Castaic Lake 34.51853 -118.59699 178 100% Los Angeles 2020-11-10 14:25:24 2020-08-01 Angeles National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/1/castaic-fire/ N
155 2531 5f88019a-39cf-43ff-921f-d5442e47f98d Pond Fire Kata Creek Road and Oak Creek Place, East of Santa Margarita 35.43128 -120.47346 1,962 99% San Luis Obispo 2020-08-09 19:17:38 2020-08-01 Unified Command: United States Forest Service Wildfire https://www.fire.ca.gov/incidents/2020/8/1/pond-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
);