incidents
1 row where Location = "Irvine Drive in Moraga ", PercentContainedDisplay = "100%" and "StartedDate" is on date 2020-10-11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
246 | 246 | 2643 | 65b0ce28-b5e6-4dfc-b569-96716e556c90 | Irvine Fire | Irvine Drive in Moraga | 37.821737 | -122.104314 | 30 | 100% | Contra Costa | 2020-10-12 06:12:20 | 2020-10-11 | CALFIRE/ Santa Clara Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/10/11/irvine-fire/ | N |
Advanced export
JSON shape: default, array, newline-delimited
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 );