incidents
3 rows where CountiesList = "Stanislaus", IsActive = "N" and PercentContainedDisplay = "100%"
This data as json, CSV (advanced)
Suggested facets: Name, AdminUnit, UpdatedDate (date), StartedDate (date)
Link | rowid ▼ | IncidentId | UniqueId | Name | Location | Latitude | Longitude | AcresBurnedDisplay | PercentContainedDisplay | CountiesList | UpdatedDate | StartedDate | AdminUnit | IncidentTypeDisplay | Url | IsActive |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 41 | 2417 | 5a6e0c14-2906-4547-8024-e7b33071104b | Sperry Fire | Diablo Grande Parkway and Del Puerto Canyon Road, West of Patterson | 37.463636 | -121.16483 | 80 | 100% | Stanislaus | 2020-08-13 11:22:26 | 2020-06-08 | CAL FIRE Santa Clara Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/8/sperry-fire/ | N |
86 | 86 | 2462 | 64b9cf19-314a-4986-ae35-cf89f1f8bc2a | Diablo Fire | Del Puerto Canyon and Diablo Grande | 37.46265 | -121.18355 | 202 | 100% | Stanislaus | 2020-06-26 18:32:50 | 2020-06-25 | CAL FIRE Santa Clara Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/25/diablo-fire/ | N |
230 | 230 | 2625 | a7f3e6f3-3e15-4350-a0f7-2a5392e0708d | Sperry Fire | Interstate 5 and Sperry Road, West of Patterson | 37.46377 | -121.18018 | 45 | 100% | Stanislaus | 2020-09-16 07:28:21 | 2020-09-08 | CAL FIRE Santa Clara Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/9/8/sperry-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 );