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

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
207 2600 a453303f-cb87-430a-9a3c-d9b2f0b7ceb2 Coyote Fire Monterey Rd and Coyote Creek Golf Dr 37.18725 -121.68465 143 100% Santa Clara 2020-09-08 11:47:36 2020-08-21 Unified command with CAL FIRE and San Jose City Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/8/21/coyote-fire/ N
208 2601 ef92c8ca-2a96-4ab3-924e-649d91355896 SQF Complex Fire (Includes Castle Fire and Shotgun Fire) East of Giant Sequoia National Monument in Tulare County. 36.14549 -118.47953     Tulare 2020-10-22 10:49:30 2020-08-21 Sequoia National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/21/sqf-complex-fire-includes-castle-fire-and-shotgun-fire/ Y
221 2616 99842a99-8d74-4754-b86f-3392f76cd8a5 Moraine Fire South of Palmer Peak , East of Avalanche Pass Trail on the north side of Moraine Creek 36.718 -118.557     Tulare 2020-10-06 09:12:25 2020-08-21 Sequoia & Kings Canyon National Parks Wildfire https://www.fire.ca.gov/incidents/2020/8/21/moraine-fire/ Y

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