3 rows where CountiesList = "Merced", IsActive = "N" and PercentContainedDisplay = "100%"

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
91 2467 a9397846-b830-4a42-a7e6-d2be9684a989 Pass Fire Hwy 152 and Dinosaur Point Rd, near Santa Nella 37.06641 -121.21912 2,192 100% Merced 2020-07-03 07:34:59 2020-06-28 CAL FIRE Madera-Mariposa-Merced Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/28/pass-fire/ N
104 2480 a7138f52-b933-4054-ae63-5f8e1e950be3 Cotton Fire Hwy 152 and Lower Cottonwood Hunting Area, West of Santa Nella 37.091637 -121.086625 100 100% Merced 2020-07-05 07:30:23 2020-07-05 CAL FIRE Madera-Mariposa-Merced Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/5/cotton-fire/ N
140 2516 9810b7b8-b865-4413-a60c-5f47e8945eda Cottonwood Fire Hwy 152 and Romero Visitors Center, west of Santa Nella 37.083806 -121.101634 788 100% Merced 2020-07-29 06:49:54 2020-07-27 CAL FIRE Madera-Mariposa-Merced Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/27/cottonwood-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
);