crash_reports
3 rows where latitude = "42.3469722" and street1 = "WEST 2040 COMMONWEALTH AVE"
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-10
Time:
12:57
Address:
2040 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
Sigfredo Velez was backing vehicle #2 into a driveway to make a delivery. Velez states that he was already into his turn when vehicle #1 tried to go around his truck, while doing so Vehicle #1 struck Velez truck. Aleksey Stebenkov states that he attempted to go around vehicle #2 and when he did he hit vehicle #2. No injures no tows.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
Case
number:
Date:
2019-09-17
Time:
09:45
Address:
2040 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Francis Vincent was operating vehicle #1 W/B on Comm Ave. Francis states that he was driving and looking at traffic straight ahead. Francis states that he drove into a green dumpster that was left on the side of the road by Star Market. Francis states that he did not see the dumpster because it blended in with the tree line. I spoke with Star Market Manager Joe Granata. Joe stated that the disposal company was brining a new dumpster and the dumpster was left in the street so the exchange could be made. No injures, vehicle #1 towed by Todys
Keywords:
Tree
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
Case
number:
Date:
2020-06-15
Time:
15:30
Address:
2040 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On 6/15/2020 at approximately 1540 hours, I responded to 2040 Commonwealth ave for a report of a two car accident. Upon arrival, I spoke with MV 1 who stated that he was reversing his tractor trailer into the shaws loading dock area when he struck MV2 with the backend of his cab. There is minimal damage and no injuries reported. I then spoke MV2 who stated that he was behind MV1 driving westbound on Commonwealth ave. He stopped to let the tractor trailer back into the loading dock. He realized he did not leave the trailer enough room to make the turn and that is when MV1 and MV2 struck. He reports no injuries and minor damage to his vehicle.
Keywords:
Crash
Dcc:
Followed too closely, Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
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);