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

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
138 2514 4d799b0d-240a-40fa-9ca7-f64aa1cd4002 Karen Fire Sierra Avenue and Karen Lane in Riverside County. 34.028116 -117.429598 250 100% Riverside 2020-08-01 07:23:51 2020-07-25 San Bernardino County Fire Wildfire https://www.fire.ca.gov/incidents/2020/7/25/karen-fire/ N
145 2521 b7cf91b3-e441-46c7-8214-a2ce84a21a3d Branch Fire Hwy 58 and Soda Lake Rd, California Valley 35.35146 -120.00521 3,022 100% San Luis Obispo 2020-08-01 19:47:20 2020-07-28 CAL FIRE San Luis Obispo Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/28/branch-fire/ N
146 2522 71cf5cd0-78c3-482c-b0d3-148bb24c4853 Brook Fire Keenbrook Rd and Cajon Blvd 34.25143 -117.45479 185 100% San Bernardino 2020-08-01 07:08:05 2020-07-29 San Bernardino National Forest Wildfire https://www.fire.ca.gov/incidents/2020/7/29/brook-fire/ N
150 2526 04013e6f-d207-4043-8d3d-00aa5d332d85 Sheep Fire Comanche Point Rd, south east of Bakersfield 35.14357 -118.7933 233 100% Kern 2020-08-01 09:00:00 2020-07-30 CAL FIRE/ Kern County Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/7/30/sheep-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
);