incidents

2 rows where PercentContainedDisplay = "100%" and "UpdatedDate" is on date 2020-06-07

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
32 32 2408 3837f75a-208d-41d0-8d89-5719a11912ef Colleen Fire Colleen Dr, South San Jose 37.229703 -121.851895 126 100% Santa Clara 2020-06-07 07:43:06 2020-06-04 Unified Command: CAL FIRE Santa Clara Unit and City of San Jose Wildfire https://www.fire.ca.gov/incidents/2020/6/4/colleen-fire/ N
38 38 2414 b5527f83-ebbe-4b09-a701-4b4fe6d37b45 Willow Fire Willow Pass Court and Evora Road, Northeast of Concord 37.994368 -122.002811 100 100% Contra Costa 2020-06-07 07:55:42 2020-06-06 CALFIRE Santa Clara Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/6/willow-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
);