3 rows where "StartedDate" is on date 2020-06-10

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
49 2425 c3c10b8f-a073-4ca6-bb7f-fdc57cf82b4c Elizabeth Fire Elizabeth and Foothill Rd, north of Ventura 34.29475 -119.17808 289 100% Ventura 2020-06-12 07:53:46 2020-06-10 Ventura County Fire Department Wildfire https://www.fire.ca.gov/incidents/2020/6/10/elizabeth-fire/ N
50 2426 3e6e0977-3563-442d-8bf3-d87c97b49880 Soda Fire Hwy 58 and Soda Lake Rd, California Valley 35.35146 -120.00521 1,672 100% San Luis Obispo 2020-06-11 20:23:25 2020-06-10 CAL FIRE San Luis Obispo Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/10/soda-fire/ N
51 2427 4561c1c7-f447-4450-9ea8-f9717ee19f8d Lime Fire Lime Canyon Rd and Piru Canyon Rd, west of Lake Piru 34.46182 -118.77347 803 100% Ventura 2020-06-17 13:43:05 2020-06-10 Unified Command: CAL FIRE, Ventura County Fire Department and Las Padres National Forrest Wildfire https://www.fire.ca.gov/incidents/2020/6/10/lime-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
);