5 rows where "StartedDate" is on date 2020-06-08

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
41 2417 5a6e0c14-2906-4547-8024-e7b33071104b Sperry Fire Diablo Grande Parkway and Del Puerto Canyon Road, West of Patterson 37.463636 -121.16483 80 100% Stanislaus 2020-08-13 11:22:26 2020-06-08 CAL FIRE Santa Clara Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/8/sperry-fire/ N
42 2418 8a4b6636-55b6-4999-9de4-7b0cb22390a2 Grand Fire S Main Divide Road near DeCariso Road, West of Lake Elsinore 33.638067 -117.37581 27 100% Riverside 2020-06-09 12:24:46 2020-06-08 CAL FIRE / Riverside County Fire Wildfire https://www.fire.ca.gov/incidents/2020/6/8/grand-fire/ N
43 2419 6b50bab1-7dcf-43c8-b4d1-afada595dd32 Bradley Fire Sargents Canyon and Alvardo Road, North of Bradley 35.94979 -120.81509 230 100% Monterey 2020-06-09 12:24:17 2020-06-08 CAL FIRE San Benito Monterey Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/8/bradley-fire/ N
44 2420 125e30fa-37fb-46ea-86ab-13058518aab6 Sierra Fire La Sierra Avenue and Cajalco Road 33.82925 -117.46036 100 100% Riverside 2020-08-13 11:22:36 2020-06-08 Corona Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/6/8/sierra-fire/ N
45 2421 fdd59b55-6aa2-442f-b788-e1291bb49cb1 Oak Fire 45000 Block of Castile Canyon Road, East of San Jacinto in Riverside County is 15 acres. 33.78275 -116.89655 20 100% Riverside 2020-06-08 20:50:06 2020-06-08 CAL FIRE Riverside County Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/6/8/oak-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
);