incidents
3 rows where "StartedDate" is on date 2020-06-09
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46 | 46 | 2422 | d77e9eeb-a4ed-41b8-adff-9dd99aac5971 | Cronan Fire | at Cronan Ranch off of Pedro Hill, near the community of Pilot Hill | 38.827755 | -120.988571 | 29 | 100% | El Dorado | 2020-06-10 18:11:53 | 2020-06-09 | CAL FIRE Amador-El Dorado Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/9/cronan-fire/ | N |
47 | 47 | 2423 | dc1f8080-9c95-40e3-859b-71f6a080f05b | Vineyard Fire | Highway 128 and Elkhorn Road, South of Yorkville | 38.89695 | -123.21318 | 151 | 100% | Mendocino | 2020-06-10 18:59:05 | 2020-06-09 | CAL FIRE Mendocino Unit | Wildfire | https://www.fire.ca.gov/incidents/2020/6/9/vineyard-fire/ | N |
48 | 48 | 2424 | 21f49b4c-a5cd-4f17-90fd-b9f464b823c1 | India Fire | Roblar Rd and Basilone Rd, Camp Pendleton Marine Corps Base | 33.37579 | -117.47166 | 1,100 | 100% | San Diego | 2020-06-25 09:23:48 | 2020-06-09 | Camp Pendleton | Wildfire | https://www.fire.ca.gov/incidents/2020/6/9/india-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 );