4 rows where CountiesList = "Humboldt", 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
1 2376 94f20083-2412-4058-bc16-afa6b45c3935 Bear Fire Bear Creek Road and Anderson Ford Road, Northwest of Highway 36 at Dinsmore 40.511092 -123.6378411 15 100% Humboldt 2020-02-16 09:24:05 2020-02-15 CAL FIRE Humboldt-Del Norte Unit Wildfire https://www.fire.ca.gov/incidents/2020/2/15/bear-fire/ N
129 2505 1c0e692a-8afc-41e9-8ac7-d27b977f0cdd Milepost 21 Fire Highway 96 and Deerhorn Rd, southeast of Weitchpec 41.1849445 -123.6986222 100 100% Humboldt 2020-08-18 18:09:57 2020-07-20 Hoopa Valley Indian Reservation Wildfire https://www.fire.ca.gov/incidents/2020/7/20/milepost-21-fire/ N
143 2519 4751b58f-771f-4d9c-b742-4aad10ef45eb Lincoln Fire Bendixsen Street and Simpson Private Road, Samoa 40.78804 -124.19954 25 100% Humboldt 2020-08-03 09:44:30 2020-07-27 Samoa Fire Protection District Wildfire https://www.fire.ca.gov/incidents/2020/7/27/lincoln-fire/ N
252 2649 673a098f-d4f2-43c6-96c7-7712dafd20ec Redwood Fire Redwood House Road and Kneeland Road, Northwest of Bridgeville 40.55823 -123.88658 102 100% Humboldt 2020-10-24 18:23:15 2020-10-23 CAL FIRE Humboldt - Del Norte Unit Wildfire https://www.fire.ca.gov/incidents/2020/10/23/redwood-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
);