crash_reports
5 rows where dcc contains "Unknown" and "retrieved" is on date 2021-12-06
This data as json, CSV (advanced)
Suggested facets: date, intersection, speed_limit, violation_cited, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-23
Time:
18:10
Address:
NEEDHAM ST & WINCHESTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was stopped in traffic, in the middle lane at the intersection of Needham St and Winchester St when MV#2 attempted to pass him on his left and collided with his vehicle. OPMV#1 Stated he was waiting at the light and the person behind him became impatient and tried to drive around him and hit his car. MV#2 Was slowing/stopped at the intersection of Needham St and Winchester St when she attempted to enter the left travel lane causing the vehicle to collide with MV#1. OPMV#2 Stated she didn't hit his vehicle but remembers hearing a noise prior to making the left turn onto Winchester St from Needham St. Should be noted there is minor damage on all bumpers on MV#2.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3165242
Longitude:
-71.2088413
Location:
Case
number:
Date:
2021-11-24
Time:
08:20
Address:
1321 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator of MV 1 and stated that when he pulled out of his parking space in the parking lot of 1321 Washington st, he accidently sideswiped MV 2 which was parked next to him on his passenger side. There were no injuries due to this accident and neither vehicle was towed.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
Case
number:
Date:
2021-11-24
Time:
11:53
Address:
ALDEN ST & CENTRE ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Oper # 1 stated he was traveling SB on Centre Street when Vehicle # 2 pulled in front of him and he was unable to stop in time. Oper #2 stated she stopped at Alden Street and Centre Street. Traffic was stopped on Centre Street due to red light ahead. No one was blocking intersection so she pulled out and turned left onto Centre Street when she was struck by Veh #1. She stated Veh #1 had gott into left turn lane early making Centre Street two lanes , when it doesn't become two lanes until after the intersection. Medics responded and everyone signed a refusal, Both vehicles towed by Tody's.
Keywords:
[]
Dcc:
Lane departure, Unknown
Report
url:
Image
url:
Latitude:
42.3371882
Longitude:
-71.1931665
Location:
Case
number:
Date:
2021-11-24
Time:
14:22
Address:
85 OAK HILL ST
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that she was travelling Westbound on Old Farm Rd prior to the collision with Vehicle #2. The owner of Vehicle #2 stated that his trailer was parked on the roadside of Old Farm Rd prior the collision with Vehicle #1
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.2984091
Longitude:
-71.180166
Location:
Case
number:
Date:
2021-11-30
Time:
08:57
Address:
CHESTNUT ST & WINTER STREET
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Tuesday November 30, 2021 at approx. 0857 hours I responded to the area of Chestnut Street and Ellis Street for a report of a two motor vehicle crash with unknown injuries. Upon arrival on scene Medics and Fire personnel were rendering aid to all operators / occupants, due to the location of the crash additional units were requested on scene to divert traffic. Operator of vehicle one Ms. Kim, stated she stopped at the stop sign. She stated her vision was obstructed with a truck that was parked on the northeast corner of Chestnut Street / Winter Street.. She stated she accelerated forward looking south and north. She stated she was going through the intersection when vehicle two traveling southbound had struck her vehicle. Operator of vehicle two Mr. Lafaiete-Gheringer stated he was traveling south on Chestnut Street when vehicle one traveled west from Winter Street through the intersection and struck his vehicle. After Medic evaluations on Ms. Kim and her child Ariela Seok, she signed patient refusal's with no reported injuries at this time. Mr. Lafaiete-Gheringer was transported to Newton Wellesley Hospital for a minor laceration on his head due to impact, non life threatening. Todys towing of 1354 Washington Street arrived on scene and towed both vehicles to their tow lot. Towed inventory sheets were completed. All parties advised of the process and I advised them my contact information. After reviewing the crash site area, possible obstructions and a safer way for vehicular and pedestrian traffic, I am recommending a stop sign be placed on the southbound lane Chestnut Street just prior to Ellis Street. In addition Mr. Lafaiete-Gheringer has an active registration without a Massachusetts license with an effective date of August 16, 2021. He currently has an active California License, with an California address. Therefore I am issuing and mailing Mr. Lafaiete-Gheringer MA citation number T1445575(warning) for Chapter 90 Section 26a Failure to notify registry of his license address change.
Keywords:
Citation, Crash, Fire, Hospital, Ped
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3145855
Longitude:
-71.2251773
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);