2 rows where CountiesList = "Monterey" and IsActive = "Y"

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
203 2594 a6c0c7b2-cdbe-4fc9-8902-1765ba9385a3 Dolan Fire Dolan Rd and Hwy 1, Ventana Wilderness 36.123 -121.602     Monterey 2020-10-08 07:08:11 2020-08-19 Unified Command: CAL FIRE, Los Padres National Forest, and Fort Hunter Liggett Wildfire https://www.fire.ca.gov/incidents/2020/8/19/dolan-fire/ Y
249 2646 f548cf8d-6412-4403-8992-a32c99cfe302 Coleman Fire Fort Hunter Liggett in Monterey County. 36.1211 -121.3274     Monterey 2020-10-19 08:07:47 2020-10-18 U.S. Army Fort Hunter Liggett Military Base Wildfire https://www.fire.ca.gov/incidents/2020/10/18/coleman-fire/ Y

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
);