3 rows where "StartedDate" is on date 2020-07-30

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
148 2524 aa193e22-7d46-42fa-8638-8ee1e1cbaa2c Rabbit Fire Hwy 60 and Jack Rabbit Trail 33.934137 -117.034461 104 100% Riverside 2020-07-31 09:04:37 2020-07-30 CAL FIRE Riverside County Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/30/rabbit-fire/ N
149 2525 2806bdb9-c1d2-4ace-b602-734e24282852 Dam Fire San Gabriel Canyon Rd and Silverfish Rd Morris Reservoir 34.17363 -117.889503 220 95% Los Angeles 2020-11-10 14:26:48 2020-07-30 Angeles National Forest Wildfire https://www.fire.ca.gov/incidents/2020/7/30/dam-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
);