incidents

2 rows where PercentContainedDisplay = "100%" and "StartedDate" is on date 2020-06-02

✎ 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
27 27 2403 0eca3343-e9f9-4d09-9fc3-95ab90b153ae Horn Fire Horn Road and Mail Route Road, east of Ravendale in Lassen County. 40.809323 -120.288882 37 100% Lassen 2020-06-02 18:33:56 2020-06-02 Northern California District - Susanville Wildfire https://www.fire.ca.gov/incidents/2020/6/2/horn-fire/ N
28 28 2404 94b147a7-68ac-4e60-ba42-81fce8facd30 Smoketree Fire East Murray Canyon Dr and S Toledo Ave 33.782532 -116.524014 129 100% Riverside 2020-06-17 08:35:01 2020-06-02 City of Palm Springs City Fire/ California Desert District Wildfire https://www.fire.ca.gov/incidents/2020/6/2/smoketree-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
);