incidents
1 row where "StartedDate" is on date 2020-08-16 and "UpdatedDate" is on date 2020-09-23
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 191 | 191 | 2577 | d19ac7c7-c899-4600-82c9-fe24dc29f3c9 | CZU Lightning Complex (Including Warnella Fire) | Various locations across San Mateo and Santa Cruz Counties | 37.17162 | -122.22275 | 86,509 | 100% | Santa Cruz, San Mateo | 2020-09-23 15:43:36 | 2020-08-16 | Unified Command Agencies: Santa Cruz Co. Sheriff’s Office, San Mateo Co. Sheriff’s Office, Felton Fire Protection District, Santa Cruz County Fire Department, San Mateo County Fire Department, Boulder Creek Fire Department, Ben Lomond Fire Protection District | Wildfire | https://www.fire.ca.gov/incidents/2020/8/16/czu-lightning-complex-including-warnella-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 );