crash_reports
4 rows where dcc_code = "[5, 99]"
This data as json, CSV (advanced)
Suggested facets: violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-27
Time:
13:54
Address:
CENTRE ST & PARK ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of Veh # 1 stated she stopped at red light at Centre and Park and was rear ended by vehicle #2. Oper of Veh #2 stated that vehicle # 1 stopped short at a green light and she was unable to stop in time due to the wet roads. no tows. on injuries.
Keywords:
[]
Dcc:
Followed too closely, Unknown
Report
url:
Image
url:
Latitude:
42.285017
Longitude:
-71.156466
Location:
Case
number:
Date:
2020-10-08
Time:
16:24
Address:
CENTRE ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was stopped at the intersection of Centre St and Washington St proceeding to merge into Washington St Eastbound. MV#1 Was struck by MV#2 on the right side rear bumper upon merging. OPMV#1 Stated he was merging into traffic and was hit from behind by a vehicle on his right bumper side. MV#2 Was stopped at the intersection of Centre St and Washington St, behind MV#1, proceeding to merge into Washington St Eastbound. MV#2 collided with MV#1 merging into oncoming traffic. OPMV#2 Stated she was merging into Washington St when she hit the vehicle in front of her. No tows were needed, and no injuries were reported.
Keywords:
[]
Dcc:
Followed too closely, Unknown
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Case
number:
Date:
2021-04-12
Time:
09:51
Address:
WASHINGTON ST & WALTHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV#1 stating he was travelling straight ahead on Watertown St when he was rear ended by MV#2. Operator of MV#2 stated he was stopped at the light on Watertown St behind MV#1. He stated the light went green and they began to travel towards Waltham St at approximately 10mph when MV#1 stopped abruptly with no warning. MV#2 was not able to stop and rear ended MV#1. Passenger of MV#2 corroborated the driver's story and stated the truck in front of them stopped suddenly. There is a traffic light at the location of the crash that was red, however this light is for traffic coming down Washington St. MV#1 and MV#2 were travelling down Watertown St and that light did not apply to them. MV#1 was driven from the scene with no damage. MV#2 was towed by Perfection with heavy front end damage. Operator of MV#1(back pain) and the Passenger of MV#2 (knee pain) were evaluated by medics. Both patients signed refusals.
Keywords:
Crash
Dcc:
Followed too closely, Unknown
Report
url:
Image
url:
Latitude:
42.3494298
Longitude:
-71.2263543
Location:
Case
number:
Date:
2021-12-14
Time:
17:17
Address:
COMMONWEALTH AVE & LEXINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
V2 was turning right from Lexington St in order to go westbound on Commonwealth Ave. V1 was travelling behind v2, and also turning to go westbound on Commonwealth Ave. The front left of vehicle 1 rear ended the back right of vehicle 2. They pulled off to the side of the road. The operator of V2 accidentally put the vehicle in reverse, while trying to park. At this point v2 backed up into V1. No one was injured. I observed minor damage to both vehicles. The operator of vehicle 1 was issued a criminal complaint for unlicensed operation.
Keywords:
Crash
Dcc:
Followed too closely, Unknown
Report
url:
Image
url:
Latitude:
42.3478859
Longitude:
-71.247136
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);