4 rows where "UpdatedDate" is on date 2020-08-24

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
160 2536 8d4fb3c6-8522-491b-a388-afad50660bfb Post Fire NB I-5 and High way 138, South of Gorman in Los Angeles County. 34.04447 -118.21608 120 100% Los Angeles 2020-08-24 14:47:09 2020-08-02 Los Angeles County Fire Wildfire https://www.fire.ca.gov/incidents/2020/8/2/post-fire/ N
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
181 2557 3a48ec04-0297-4561-bb64-e6461acde361 Hills Fire Highway 33 and Sutter Ave, south of Coalinga in Fresno County. 36.09876 -120.427342 2,121 100% Fresno 2020-08-24 21:10:45 2020-08-15 CAL FIRE Fresno-Kings County Fire Wildfire https://www.fire.ca.gov/incidents/2020/8/15/hills-fire/ N
198 2589 ef9d3424-5838-466e-bb92-ac5dc23be5c5 Salt Fire Salt Springs Valley Reservoir 38.027921 -120.763258 1,789 100% Calaveras 2020-08-24 19:55:18 2020-08-18 CAL FIRE Tuolumne-Calaveras Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/18/salt-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
);