3 rows where CountiesList = "Mariposa", IsActive = "N" 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
40 2416 876b63ff-62a2-4584-8aa2-d99f027c0e9f Hunters Fire Hunters Valley Road and Detwiler Road in Mariposa County. 37.61955 -120.215454 85 100% Mariposa 2020-06-10 07:03:48 2020-06-07 CAL FIRE Madera-Mariposa-Merced Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/7/hunters-fire/ N
57 2433 44bf7479-689e-4203-9f38-8b05917db66b Cornetts Fire Cornetts Road and Old Highway South 37.40827 -120.08522 191 100% Mariposa 2020-06-16 19:19:03 2020-06-13 CALFIRE Madera-Mariposa-Merced Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/13/cornetts-fire/ N
121 2497 79575aba-0ca4-446e-a28e-39bafbad368e Ben Fire Ben Hur Road and Buckeye Road, South of Mariposa 37.42319 -119.95807 48 100% Mariposa 2020-07-18 07:58:22 2020-07-15 CAL FIRE Madera-Mairposa-Merced Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/15/ben-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
);