6 rows where "StartedDate" is on date 2020-08-02

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
156 2532 dddf569c-7540-4822-8bf4-bd15d5c4473e Sophia Fire Sophia Park Way and Alexandra Dr near El Dorado Hills in El Dorado County. 38.686478 -121.103299 36 100% El Dorado 2020-08-02 09:12:41 2020-08-02 CAL FIRE Amador-El Dorado Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/2/sophia-fire/ N
157 2533 f05306b4-6281-4140-9d63-ea077c080ce9 Water Fire Whitewater Canyon Road at the Whitewater Preserve In Riverside County. 33.924086 -116.641846 52 100% Riverside 2020-08-04 15:13:28 2020-08-02 CAL FIRE/ Riverside County Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/8/2/water-fire/ N
158 2534 91f3f77d-6b4a-47fb-bc79-a0250cded29a North Fire Highway 395 and Highway 70, east of Chilcoot in Lassen County, 40.36764 -120.44811 6,882 100% Lassen 2020-08-13 11:27:37 2020-08-02 Bureau of Land Management Nevada-Carson District Wildfire https://www.fire.ca.gov/incidents/2020/8/2/north-fire/ N
159 2535 7482a8eb-a31c-4556-b8d5-e6f86c4f3904 Sites Fire Sites Lodoga Road and Campground Road, Southeast of Stonyford in Colusa County. 39.31313 -122.48525 560 100% Colusa 2020-08-05 07:16:44 2020-08-02 CAL FIRE Sonoma Lake Napa Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/2/sites-fire/ N
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
161 2537 8b1c928f-99e8-4778-a988-445e154a00e3 Beale Fire Doolittle Dr. and Warren Shingle Road, near Beale Air Force Base in Yuba County. 39.11307 -121.38178 600 100% Yuba 2020-08-13 11:22:58 2020-08-02   Wildfire https://www.fire.ca.gov/incidents/2020/8/2/beale-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
);