incidents
2 rows where AdminUnit = "CAL FIRE Nevada-Yuba-Placer Unit", IsActive = "N" and PercentContainedDisplay = "100%"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54 | 54 | 2430 | e86309b6-2223-4448-a7a2-bb83d4bc8352 | Watt Fire | PFE Rd and Watt Ave | 38.733421 | -121.378879 | 40 | 100% | Placer | 2020-06-11 20:51:28 | 2020-06-11 | CAL FIRE Nevada-Yuba-Placer Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/11/watt-fire/ | N |
70 | 70 | 2446 | 2a79a833-693d-4dff-a199-c93b5a3ebe39 | Nelson Fire | Nelson Rd and Rockwell Ln, west of Lincoln | 38.89178 | -121.33956 | 110 | 100% | Placer | 2020-06-18 19:24:38 | 2020-06-18 | CAL FIRE Nevada-Yuba-Placer Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/18/nelson-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 );