incidents
1 row where "StartedDate" is on date 2020-08-18 and "UpdatedDate" is on date 2020-10-01
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192 | 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
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 );