2 rows where "StartedDate" is on date 2020-07-28

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
144 2520 66f80cfd-55ff-4f8b-b971-708bef8c6d87 Border 11 Fire Marron Valley Rd and Border Rd, Marron Valley 32.62212 -116.77048 100 100% San Diego 2020-07-29 19:00:39 2020-07-28 CAL FIRE/San Diego County Fire Wildfire https://www.fire.ca.gov/incidents/2020/7/28/border-11-fire/ N
145 2521 b7cf91b3-e441-46c7-8214-a2ce84a21a3d Branch Fire Hwy 58 and Soda Lake Rd, California Valley 35.35146 -120.00521 3,022 100% San Luis Obispo 2020-08-01 19:47:20 2020-07-28 CAL FIRE San Luis Obispo Unit Wildfire https://www.fire.ca.gov/incidents/2020/7/28/branch-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
);