4 rows where "StartedDate" is on date 2020-07-13

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
116 2492 2865a54c-f7c1-4595-b4b9-1c8082df22ce Elliot Fire Block Elliot Rd, south of Winchester 33.623968 -117.108421 2 100% Riverside 2020-07-15 18:45:16 2020-07-13 CALFIRE Riverside County Fire Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/13/elliot-fire/ N
117 2493 dd705c7f-d18b-49a5-be60-c828d5c047fb Robinson Fire Gold Mountain Rd and Stoney Oaks Blvd, northeast of Bangor 39.43227 -121.37994 33 100% Butte 2020-07-15 19:11:29 2020-07-13 CAL FIRE Butte County Fire Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/13/robinson-fire/ N
118 2494 777f38a7-7d43-4641-998f-8524c692980c Casino Fire Hwy 371 and Santos Rd, south of Anza 33.48429 -116.83552 91 100% Riverside 2020-07-16 07:11:10 2020-07-13 CALFIRE Riverside County Fire Unit/ USFS San Bernardino National Forest Wildfire https://www.fire.ca.gov/incidents/2020/7/13/casino-fire/ N
119 2495 ef5e4d08-bf3f-4df1-90b7-92e4e2a2fc91 Mineral Fire Hwy 198 and S Coalinga Mineral Springs Rd, west of Coalinga 36.09493 -120.52193 29,667 100% Fresno 2020-07-26 19:40:58 2020-07-13 CAL FIRE Fresno-Kings Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/13/mineral-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
);