crash_reports
2 rows where datetime = "2022-02-13T18:56" and "datetime" is on date 2022-02-13
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-02-13
Time:
18:56
Address:
241 COUNTRY CLUB RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 operator was travelling down hill on Countryside Rd when vehicle controls were lost and MV1 drove onto 241 Countryside Rd front lawn. Road conditions include snowing at the time of incident and slippery roads due to snow and ice. MV1 operator was able to remove vehicle from front lawn. no injuries reported. Homeowner, Richard Goldstone will speak with homeowners insurance about possible damage to lawn.
Keywords:
Ice, Snow
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3022406
Longitude:
-71.1892477
Location:
Case
number:
Date:
2022-02-13
Time:
18:56
Address:
PROSPECT AVE & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Sunday February 13, 2022 at approx. 1856 hours I was traveling north on Walnut Street approaching the intersection of Prospect Ave when I observed a two motor vehicle crash with City property damage. Upon arrival on scene I activated my emergency lights and exited my cruiser to check on all parties and notified dispatch of the crash. I observed both vehicles had airbag deployment and notified for medics to respond. The operator of vehicle one stated he was traveling north on Walnut Street when vehicle two traveled through Prospect Ave onto Walnut Street into his path of travel causing impact. The operator of vehicle two stated he was traveling east, down hill on Prospect Ave, he applied his brakes and his vehicle slide uncontrollable downhill through the intersection onto Walnut Street where vehicle one had impact with his vehicle, which caused him to spin around onto the curb striking a City tree and sidewalk. The vehicle was close to a retaining wall belonging to 580 Walnut Street but did not appear to have had contact. Fire and medics arrive on scene, to check on both parties due to both vehicles having airbag deployment. Both parties declined medical treatment and stated they did not have any injuries. Prospect Ave and Walnut Street were both covered with ice/snow and untreated. I notified for a sander to treat the roadways which was a contributing factor of the crash. Todys towing arrived on scene and towed both vehicles to their tow lot. All parties advised of the process. I took pictures of the City property damage that I will download at the I.T. Bureau.
Keywords:
Airbag, Crash, Fire, Ice, Pictures, Solar, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3415191
Longitude:
-71.2066448
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);