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

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
79 2455 e7d05a34-0fdc-4db2-b713-0e10119d105d Grade Fire Boyd Dr and Rd 168, east of Orosi 36.5537 -119.19677 1,050 100% Tulare 2020-07-24 15:35:14 2020-06-22 CAL FIRE Tulare Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/22/grade-fire/ N
80 2456 cf392ebe-9c69-4a28-b52b-3772c06b493c Rico Fire Sargents Canyon Rd and Dead Mans Gulch Rd, southeast of San Ardo 35.9789 -120.87858 338 100% Monterey 2020-06-23 07:08:20 2020-06-22 CAL FIRE San Benito-Monterey Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/22/rico-fire/ N
81 2457 58e5665a-7aff-4f14-8ebe-490e73d3d37a River Fire River Road and Creston Road, West of Paso Robles 35.62906 -120.68326 15 100% San Luis Obispo 2020-06-25 09:05:06 2020-06-22   Wildfire https://www.fire.ca.gov/incidents/2020/6/22/river-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
);