incidents
3 rows where "StartedDate" is on date 2020-07-06
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108 | 108 | 2484 | fc988bbb-4f93-478d-8a6c-b1be51d436c7 | California Fire | California Street and Springwood Street. East of Rodeo | 38.02996 | -122.25471 | 298 | 100% | Contra Costa | 2020-07-08 07:07:14 | 2020-07-06 | CAL FIRE Santa Clara Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/7/6/california-fire/ | N |
109 | 109 | 2485 | ce7dddd1-7a79-4aa4-b6bc-f4181aa2ac05 | Patterson Fire | Hwy 580 and Patterson Pass Rd, west of Tracy | 37.71984 | -121.53524 | 150 | 100% | San Joaquin | 2020-07-06 19:04:39 | 2020-07-06 | CAL FIRE Santa Clara Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/7/6/patterson-fire/ | N |
110 | 110 | 2486 | deaaf3fb-e0b2-4430-97cc-10d6d626df27 | Mountain Meadow Fire | Mountain Meadows Drive and Cedar Creek Court, Southwest of Fairfield | 38.21614 | -122.12447 | 75 | 100% | Solano | 2020-07-28 11:50:34 | 2020-07-06 | Cordelia Fire Protection District and Fairfield City Fire Department | Wildfire | https://www.fire.ca.gov/incidents/2020/7/6/mountain-meadow-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 );