crash_reports
2 rows where dcc contains "Unknown" and dcc_code = "[3, 99]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-09
Time:
05:22
Address:
LEXINGTON ST & RUMFORD AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 states he was driving northbound on Lexington St operating MA reg 47C440 (vehicle #1). Once at the green light at Lexington/Rumford Ave, operator #1 attempted to take a left turn onto Rumford when MA reg 4FR581 (vehicle #2) collided with him. Vehicle #2 was driving eastbound on Rumford and operator #1 states he did not see the car until the crash occurred. Operator #2 reports he was driving eastbound on Rumford and was attempting to take a right turn onto Lexington St at the intersection. Operator #2 acknowledges that he had a red light but states he stopped prior to turning (right on red is allowed). It should be noted that upon my arrival on scene, vehicle #2 was located partially in the intersection with airbags deployed and I am not able to conclude that vehicle #2 was in fact turning right. The point of impact does appear to be the left front area. Operator #2 states he doesn't know what happened, and that vehicle #1 may have oversteered the left turn. The damage to both vehicles is extensive and mostly contained to the front end/undercarriage areas. Both vehicles were towed by Tody's and all parties signed patient refusals from medics on scene.
Keywords:
Airbag, Crash, Severe
Dcc:
Signs/Signals, Unknown
Report
url:
Image
url:
Latitude:
42.357825
Longitude:
-71.2396119
Location:
Case
number:
Date:
2021-11-23
Time:
14:36
Address:
CENTRE ST & SARGENT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator #1 stated he was travelling northbound on Centre St crossing Sargent St when MV#2 ran the red light and they collided. His passengers stated their light was green. MV#1 suffered moderate damage to the front left side of the vehicle. Operator #2 stated he was travelling eastbound on Sargent St across Centre St where he had a green light when MV#1 ran through a red light at a high rate of speed. MV#2 suffered minor damage to the front right and was able to be driven from the scene. The owner of MV#2 (Matt Murphy - MP Murphy Builders) arrived on scene and was advised. No injuries reported. On 11/23, an independent witness contacted the Newton Police Traffic Bureau. She indicated that Operator MV#2 ran the red light and was at fault for this accident. See narrative.
Keywords:
Crash, Moderate, Speed
Dcc:
Signs/Signals, Unknown
Report
url:
Image
url:
Latitude:
42.3470298
Longitude:
-71.1891713
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);