1 row where "StartedDate" is on date 2020-08-18 and "UpdatedDate" is on date 2020-10-01

✎ 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
192 2580 22c6ea3c-304c-4b3b-bfba-7c9dfc63d9da SCU Lightning Complex Multiple locations throughout Santa Clara County, Alameda County, Contra Costa County, San Joaquin County, Merced and Stanislaus County 37.439437 -121.30435 396,624 100% Santa Clara, Alameda, Contra Costa, San Joaquin, Stanislaus 2020-10-01 10:29:40 2020-08-18 CAL FIRE Santa Clara Unit Wildfire https://www.fire.ca.gov/incidents/2020/8/18/scu-lightning-complex/ 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
);