incidents
3 rows where PercentContainedDisplay = "100%" and "StartedDate" is on date 2020-10-25
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 254 | 254 | 2651 | f6e28549-a711-429d-a4ed-9df6530a9a2a | Point Fire (Shasta and Tehama County) | Gas Point Rd and Libby Ln, Cottonwood | 40.38869 | -122.39033 | 275 | 100% | Shasta, Tehama | 2020-10-27 13:13:52 | 2020-10-25 | CAL FIRE Shasta-Trinity Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/10/25/point-fire-shasta-and-tehama-county/ | N |
| 255 | 255 | 2652 | 18a15a5f-ddde-48e9-92bc-1d40813a7794 | Dersch Fire | Dersch Rd and Franciscan Way, east of Anderson | 40.47646 | -122.18102 | 133 | 100% | Shasta | 2020-10-27 08:38:13 | 2020-10-25 | CAL FIRE Shasta-Trinity Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/10/25/dersch-fire/ | N |
| 256 | 256 | 2653 | fb6cb221-c303-4573-bd63-0c8b1468d4a2 | Olinda Fire | West Anderson Dr and Davidson Ln, southwest of Anderson | 40.41486 | -122.342 | 5 | 100% | Shasta | 2020-10-26 07:08:11 | 2020-10-25 | CAL FIRE Shasta-Trinity Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/10/25/olinda-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 );