2 rows where "StartedDate" is on date 2020-09-05

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
223 2618 5367d20e-b24c-40ef-acd1-93c05e4b73b9 El Dorado Fire Oak Glen Rd Road and Potato Canyon Road, West of Oak Glen 34.08056 -116.98669     San Bernardino, Riverside 2020-10-08 07:06:23 2020-09-05 San Bernardino National Forest, San Bernardino County Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/9/5/el-dorado-fire/ Y
224 2619 9277ab02-734d-4b01-ac35-c27ba62c2af3 Valley Fire Japatul Road and Carveacre Road, Southeast of Alpine 32.765615 -116.692705 16,390 100% San Diego 2020-09-25 07:25:30 2020-09-05 Cleveland National Forest Wildfire https://www.fire.ca.gov/incidents/2020/9/5/valley-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
);