incidents
2 rows where PercentContainedDisplay = "100%" and "StartedDate" is on date 2020-08-15
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180 | 180 | 2556 | 36aa4641-bb29-4b34-baad-e96406b4f702 | Whale Fire | Old Creek Road and Sant Rita Road, north of Cayucos in San Luis Obispo County. | 35.472114 | -120.856731 | 312 | 100% | San Luis Obispo | 2020-11-10 14:21:08 | 2020-08-15 | CAL FIRE San Luis Obispo | Wildfire | https://www.fire.ca.gov/incidents/2020/8/15/whale-fire/ | N |
| 181 | 181 | 2557 | 3a48ec04-0297-4561-bb64-e6461acde361 | Hills Fire | Highway 33 and Sutter Ave, south of Coalinga in Fresno County. | 36.09876 | -120.427342 | 2,121 | 100% | Fresno | 2020-08-24 21:10:45 | 2020-08-15 | CAL FIRE Fresno-Kings County Fire | Wildfire | https://www.fire.ca.gov/incidents/2020/8/15/hills-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 );