4 rows where "UpdatedDate" is on date 2020-10-22

View and edit SQL

Suggested facets: AcresBurnedDisplay, PercentContainedDisplay, IsActive, UpdatedDate (date), StartedDate (date)

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
185 2566 b8f267be-9911-44ee-8a73-7a0537fbd6fa August Complex (includes Doe Fire) Mendocino, Humboldt, Trinity, Tehama, Glenn, Lake, & Colusa 39.776 -122.673     Mendocino, Humboldt, Trinity, Tehama, Glenn, Lake, Colusa 2020-10-22 10:48:34 2020-08-16 Mendocino National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/16/august-complex-includes-doe-fire/ Y
208 2601 ef92c8ca-2a96-4ab3-924e-649d91355896 SQF Complex Fire (Includes Castle Fire and Shotgun Fire) East of Giant Sequoia National Monument in Tulare County. 36.14549 -118.47953     Tulare 2020-10-22 10:49:30 2020-08-21 Sequoia National Forest Wildfire https://www.fire.ca.gov/incidents/2020/8/21/sqf-complex-fire-includes-castle-fire-and-shotgun-fire/ Y
222 2617 7e359448-0344-4407-a289-e4fb7823ac3c Creek Fire Both sides of the San Joaquin River near Mammoth Pool, Shaver Lake, Big Creek and Huntington Lake 37.19147 -119.261175     Fresno, Madera 2020-10-22 10:54:37 2020-09-04 Sierra National Forest Wildfire https://www.fire.ca.gov/incidents/2020/9/4/creek-fire/ Y
251 2648 64ea3d93-de8b-41fc-b5eb-af37e8ac1f95 Ferry Fire Montgomery St and Linden Ave, Oroville 39.51694 -121.54475 6 100% Butte 2020-10-22 17:12:47 2020-10-22 City of Oroville Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/10/22/ferry-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
);