4 rows where "StartedDate" is on date 2020-07-27

View and edit SQL

Suggested facets: PercentContainedDisplay, UpdatedDate (date), StartedDate (date)

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
140 2516 9810b7b8-b865-4413-a60c-5f47e8945eda Cottonwood Fire Hwy 152 and Romero Visitors Center, west of Santa Nella 37.083806 -121.101634 788 100% Merced 2020-07-29 06:49:54 2020-07-27 CAL FIRE Madera-Mariposa-Merced Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/27/cottonwood-fire/ N
141 2517 69aa5821-3027-464a-9c61-daa8b75e090f Adams Fire Scott Rd and Highway 395, south of Doyle 39.922415 -120.025872     Lassen 2020-08-17 11:05:08 2020-07-27 USFS Plumas National Forest Wildfire https://www.fire.ca.gov/incidents/2020/7/27/adams-fire/ N
142 2518 dfc476d5-b274-4bfb-bf55-4af5ef611f5e Ridge Fire Old Ridge Route Rd in the community of Quail Lake 34.75844 -118.72004 321 100% Los Angeles 2020-07-30 19:44:55 2020-07-27 Los Angeles County Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/7/27/ridge-fire/ N
143 2519 4751b58f-771f-4d9c-b742-4aad10ef45eb Lincoln Fire Bendixsen Street and Simpson Private Road, Samoa 40.78804 -124.19954 25 100% Humboldt 2020-08-03 09:44:30 2020-07-27 Samoa Fire Protection District Wildfire https://www.fire.ca.gov/incidents/2020/7/27/lincoln-fire/ N

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);