incidents
3 rows where "StartedDate" is on date 2020-06-04
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30 | 30 | 2406 | 0416a81f-0a17-4835-b05e-fe59a6e7379a | Silver Fire | Dutch Flat Trail, East of San Jose | 37.329163 | -121.726223 | 19 | 100% | Santa Clara | 2020-06-04 17:37:30 | 2020-06-04 | CAL FIRE Santa Clara Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/4/silver-fire/ | N |
31 | 31 | 2407 | a5085c95-252d-4d1c-9e8a-6657a74b7ed5 | Brock Fire | Lake Shasta, West of Round Mountain | 40.837885 | -122.097933 | 15 | 100% | Shasta | 2020-06-10 07:31:01 | 2020-06-04 | U.S Forest Service - Shasta-Trinity National Forest | Wildfire | https://www.fire.ca.gov/incidents/2020/6/4/brock-fire/ | N |
32 | 32 | 2408 | 3837f75a-208d-41d0-8d89-5719a11912ef | Colleen Fire | Colleen Dr, South San Jose | 37.229703 | -121.851895 | 126 | 100% | Santa Clara | 2020-06-07 07:43:06 | 2020-06-04 | Unified Command: CAL FIRE Santa Clara Unit and City of San Jose | Wildfire | https://www.fire.ca.gov/incidents/2020/6/4/colleen-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 );