3 rows where AdminUnit = "CAL FIRE Sonoma Lake Napa Unit " and PercentContainedDisplay = "100%"

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
19 2395 adbbc326-9f9a-434d-b18b-67a44f3906e5 Spanish Fire Spanish Valley Trail and Stagecoach Canyon, Northwest of Lake Berryessa 38.697834 -122.403634 20 100% Napa 2020-05-23 14:42:38 2020-05-22 CAL FIRE Sonoma Lake Napa Unit Wildfire https://www.fire.ca.gov/incidents/2020/5/22/spanish-fire/ N
34 2410 db5ad2e7-dc3d-41f2-91b4-4019857ee51e Lakeville Fire Lakeville Highway and Stage Gulch Road, Southeast of Petaluma 38.224849 -122.549816 141 100% Sonoma 2020-06-06 18:39:42 2020-06-05 CAL FIRE Sonoma Lake Napa Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/5/lakeville-fire/ N
36 2412 e3e89516-4647-44bf-bd24-3293303f0776 Gulch Fire Stage Gulch Road and Lakeville Highway, North of Lakeville 38.216134 -122.536406 107 100% Sonoma 2020-06-08 18:33:16 2020-06-06 CAL FIRE Sonoma Lake Napa Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/6/gulch-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
);