incidents
3 rows where CountiesList = "Merced", IsActive = "N" and PercentContainedDisplay = "100%"
This data as json, CSV (advanced)
Suggested facets: AdminUnit, UpdatedDate (date), StartedDate (date)
Link | rowid ▼ | IncidentId | UniqueId | Name | Location | Latitude | Longitude | AcresBurnedDisplay | PercentContainedDisplay | CountiesList | UpdatedDate | StartedDate | AdminUnit | IncidentTypeDisplay | Url | IsActive |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
91 | 91 | 2467 | a9397846-b830-4a42-a7e6-d2be9684a989 | Pass Fire | Hwy 152 and Dinosaur Point Rd, near Santa Nella | 37.06641 | -121.21912 | 2,192 | 100% | Merced | 2020-07-03 07:34:59 | 2020-06-28 | CAL FIRE Madera-Mariposa-Merced Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/28/pass-fire/ | N |
104 | 104 | 2480 | a7138f52-b933-4054-ae63-5f8e1e950be3 | Cotton Fire | Hwy 152 and Lower Cottonwood Hunting Area, West of Santa Nella | 37.091637 | -121.086625 | 100 | 100% | Merced | 2020-07-05 07:30:23 | 2020-07-05 | CAL FIRE Madera-Mariposa-Merced Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/7/5/cotton-fire/ | N |
140 | 140 | 2516 | 9810b7b8-b865-4413-a60c-5f47e8945eda | Cottonwood Fire | Hwy 152 and Romero Visitors Center, west of Santa Nella | 37.083806 | -121.101634 | 788 | 100% | Merced | 2020-07-29 06:49:54 | 2020-07-27 | CAL FIRE Madera-Mariposa-Merced Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/7/27/cottonwood-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 );