3 rows where "UpdatedDate" is on date 2020-06-29

View and edit SQL

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

Link rowid ▼ IncidentId UniqueId Name Location Latitude Longitude AcresBurnedDisplay PercentContainedDisplay CountiesList UpdatedDate StartedDate AdminUnit IncidentTypeDisplay Url IsActive
85 2461 5b8b9b63-9cc6-4d55-9502-87009d75732c 58 Fire Van Buren Street and Avenue 58, Thermal 33.27665 -115.96594 12 100% Riverside 2020-06-29 07:00:24 2020-06-24 CAL FIRE Riverside County Fire Wildfire https://www.fire.ca.gov/incidents/2020/6/24/58-fire/ N
87 2463 d10cd103-f627-497d-a338-6430438ed7fb Bend Fire Belmont Trail and Bend Rd, California Valley 35.30742 -119.88048 263 100% San Luis Obispo 2020-06-29 07:06:13 2020-06-25 BLM California Central District Wildfire https://www.fire.ca.gov/incidents/2020/6/25/bend-fire/ N
93 2469 58a3d354-a532-440e-bfa8-aca414cf4cd0 Muck Fire Highway 299 and Muck Valley Road, South of Nubieber 41.0336731 -121.2199939 12 100% Lassen 2020-06-29 18:49:13 2020-06-29 CAL FIRE Lassen- Modoc Unit Wildfire https://www.fire.ca.gov/incidents/2020/6/29/muck-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
);