incidents
2 rows where "StartedDate" is on date 2020-10-18
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 249 | 249 | 2646 | f548cf8d-6412-4403-8992-a32c99cfe302 | Coleman Fire | Fort Hunter Liggett in Monterey County. | 36.1211 | -121.3274 | Monterey | 2020-10-19 08:07:47 | 2020-10-18 | U.S. Army Fort Hunter Liggett Military Base | Wildfire | https://www.fire.ca.gov/incidents/2020/10/18/coleman-fire/ | Y | ||
| 250 | 250 | 2647 | cbd8fd0c-8d0f-4df3-aea3-1355a685bb96 | Cameron Fire | North of Durock Road and South of Highway 50 between Cameron Park Drive and Ponderosa Road in El Dorado county. | 38.659387 | -120.964726 | 15 | 100% | El Dorado | 2020-10-21 17:16:51 | 2020-10-18 | CAL FIRE Amador-El Dorado Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/10/18/cameron-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 );