2 rows where IsActive = "N", Name = "River Fire" and PercentContainedDisplay = "100%"

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
81 2457 58e5665a-7aff-4f14-8ebe-490e73d3d37a River Fire River Road and Creston Road, West of Paso Robles 35.62906 -120.68326 15 100% San Luis Obispo 2020-06-25 09:05:06 2020-06-22   Wildfire https://www.fire.ca.gov/incidents/2020/6/22/river-fire/ N
184 2563 ff4d7735-a5d6-452f-8775-3b208eb046b2 River Fire Pine Canyon and River Rd, east of Salinas 36.60239 -121.62161 48,088 100% Monterey 2020-09-04 19:08:39 2020-08-16 CAL FIRE San Benito-Monterey Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/16/river-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
);