incidents
3 rows where AdminUnit = "CAL FIRE Sonoma Lake Napa Unit " and PercentContainedDisplay = "100%"
This data as json, CSV (advanced)
Suggested facets: CountiesList, UpdatedDate (date), StartedDate (date)
Link | rowid ▼ | IncidentId | UniqueId | Name | Location | Latitude | Longitude | AcresBurnedDisplay | PercentContainedDisplay | CountiesList | UpdatedDate | StartedDate | AdminUnit | IncidentTypeDisplay | Url | IsActive |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19 | 19 | 2395 | adbbc326-9f9a-434d-b18b-67a44f3906e5 | Spanish Fire | Spanish Valley Trail and Stagecoach Canyon, Northwest of Lake Berryessa | 38.697834 | -122.403634 | 20 | 100% | Napa | 2020-05-23 14:42:38 | 2020-05-22 | CAL FIRE Sonoma Lake Napa Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/5/22/spanish-fire/ | N |
34 | 34 | 2410 | db5ad2e7-dc3d-41f2-91b4-4019857ee51e | Lakeville Fire | Lakeville Highway and Stage Gulch Road, Southeast of Petaluma | 38.224849 | -122.549816 | 141 | 100% | Sonoma | 2020-06-06 18:39:42 | 2020-06-05 | CAL FIRE Sonoma Lake Napa Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/5/lakeville-fire/ | N |
36 | 36 | 2412 | e3e89516-4647-44bf-bd24-3293303f0776 | Gulch Fire | Stage Gulch Road and Lakeville Highway, North of Lakeville | 38.216134 | -122.536406 | 107 | 100% | Sonoma | 2020-06-08 18:33:16 | 2020-06-06 | CAL FIRE Sonoma Lake Napa Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/6/gulch-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 );