incidents
2 rows where PercentContainedDisplay = "100%" and "StartedDate" is on date 2020-08-26
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 213 | 213 | 2608 | a89673de-1c0d-43cc-9a96-bd83f632bf65 | R-8 Pinecone Fire | Highway 395 and Termo Grasshopper Road, West of Termo | 40.773 | -120.536 | 567 | 100% | Lassen | 2020-11-10 14:19:52 | 2020-08-26 | BLM Northern CA District Bureau of Land Management | Wildfire | https://www.fire.ca.gov/incidents/2020/8/26/r-8-pinecone-fire/ | N |
| 214 | 214 | 2609 | 3826c0d8-e78d-4608-889c-b7c4f6c37a25 | Perry Fire | Perry Ranch Rd and Werner Rd | 38.8825 | -121.10411 | 9 | 100% | Placer | 2020-08-26 19:35:14 | 2020-08-26 | Unified command: CAL FIRE Nevada-Yuba-Placer Unit and City of Auburn Fire Dept | Wildfire | https://www.fire.ca.gov/incidents/2020/8/26/perry-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 );