incidents
2 rows where PercentContainedDisplay = "100%" and "StartedDate" is on date 2020-06-07
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39 | 39 | 2415 | 9247b89a-38f0-4e14-ac4a-59386cf867b4 | Bitterwater Fire | off Bitterwater road, northeast of King City in Monterey County. | 36.2644 | -121.0781 | 211 | 100% | Monterey | 2020-06-08 14:42:39 | 2020-06-07 | CAL FIRE San Benito-Monterey | Wildfire | https://www.fire.ca.gov/incidents/2020/6/7/bitterwater-fire/ | N |
| 40 | 40 | 2416 | 876b63ff-62a2-4584-8aa2-d99f027c0e9f | Hunters Fire | Hunters Valley Road and Detwiler Road in Mariposa County. | 37.61955 | -120.215454 | 85 | 100% | Mariposa | 2020-06-10 07:03:48 | 2020-06-07 | CAL FIRE Madera-Mariposa-Merced Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/7/hunters-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 );