incidents

2 rows where IsActive = "N" and StartedDate = "2020-07-31"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
151 151 2527 8b9ae457-96ea-4041-912c-6b33e8498d98 Apple Fire off of Oak Glen Road and Apple Tree Lane, North of Cherry Valley 33.99139 -116.9617     Riverside 2020-11-10 14:33:41 2020-07-31 Unified Command: USFS - San Bernardino, and Yucaipa City Fire Wildfire https://www.fire.ca.gov/incidents/2020/7/31/apple-fire/ N
152 152 2528 5b3fa4b0-d0e0-46d3-9ee8-0b4a9ff7c225 Cowhead Fire Off of County Road 1 and County Road 201, Northeast of Bidwell 41.52261 -120.17183     Modoc 2020-08-17 11:05:49 2020-07-31 Bureau Land of Management Northern California District Wildfire https://www.fire.ca.gov/incidents/2020/7/31/cowhead-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
);