crash_reports
3 rows where date = "2022-04-27" and "retrieved" is on date 2022-05-04
This data as json, CSV (advanced)
Suggested facets: intersection, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-27
Time:
12:49
Address:
CENTRE ST & LYMAN ST
Speed
limit:
5
Violation
cited:
no
Narrative:
MV#1 was southbound, slowed or stopped in traffic, in the area of Centre St. by Lyman St. when it was rear ended by MV#2. The operator of MV#2 stated they accelerated while in traffic causing the rear end collision. MV#1 sustained damage to its rear bumper, while MV#2 sustained heavy damage to its front end. All damage consistent with a rear end collision. No injuries reported, MV#1 was drive from scene, while MV#2 was towed by private tow.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3321554
Longitude:
-71.1943425
Location:
Case
number:
Date:
2022-04-27
Time:
10:24
Address:
45 BEECHER TER
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of MV#1 stated she accelerated once within the driveway of 45 Beecher Ter. causing her to collide into the front right corner of the home. It appears the vehicle then slid approx. 5-10 feet into the fence which runs adjacent to the driveway causing damage to both the fence and retaining wall. Damage observed to the front right corner of 45 Beecher Ter. MV#1 sustained heavy damage to its front end and was towed by its owner. No injuries reported. Homeowner of 45 Beecher Ter. on scene and took photographs of damage to his property.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3216877
Longitude:
-71.1823438
Location:
Case
number:
Date:
2022-04-27
Time:
08:26
Address:
CHESTNUT ST & DAVIS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of Vehicle #1 stated that as he was travelling Southbound on Chestnut St, he collided with Vehicle #2 as it attempted to make a left turn from Davis St onto Chestnut St. The operator of Vehicle #2 stated that he looked prior to the left turn, but didn't see any vehicles in his path prior to the collision with Vehicle #1. The operator of Vehicle #1 was transported to Newton-Wellesley Hospital as a result of the collision. The operator of Vehicle #2 was seen by the medics, but declined to be transported. A routine query revealed that Vehicle #2 was unregistered. As a result, the vehicle was cited, and towed.
Keywords:
Citation, Hospital
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3485635
Longitude:
-71.2252516
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);