crash_reports
4 rows where dcc_code = "[]" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: date, intersection, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2020-12-21
Time:
15:14
Address:
13 FAXON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated while traveling south on Faxon Street and approaching his residence, 13 Faxon Street, he struck MV2 while pulling into his driveway. MV2 was unoccupied at the time of the accident. MV1 had minor scratch on the rear bumper. MV2 had minor damage to the front driver side bumper along with the front bumper. The license plate mount was also damaged on MV2. Operator of MV1 was not injured.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3643176
Longitude:
-71.1997368
Location:
Case
number:
Date:
2020-12-21
Time:
16:23
Address:
235 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was traveling southbound on Needham Street in congested traffic when MV2 struck MV1 in the rear bumper. MV1 sustained very minor damage to the rear bumper. Operator of MV2 states she was traveling southbound on Needham Street in congested traffic when MV3 struck MV2 in the rear bumper causing MV2 to collide with MV1. MV2 sustained damage to the front and rear bumper. Operator of MV3 states she was traveling southbound on Needham Street in congested traffic when she experienced mechanical failure with her brakes causing MV3 to collide with MV2, which also caused MV2 to collide with MV1. MV3 sustained damage to the front of the vehicle, which disabled the transmission. MV3 was towed by Tody's towing and a towed motor vehicle inventory form was completed. No injuries reported by all three operators.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3099663
Longitude:
-71.2150428
Location:
Case
number:
Date:
2020-12-21
Time:
21:53
Address:
WASHINGTON ST & HUNEWELLE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv1 stated he was traveling westbound on Washington St when M2 was pulling out of Hunnewell ave. Mv1 stated he did not have enough time to stop and hit Mv2. Mv2 fled the scene. Mv1 did not obtain any information of Mv2 other than it was an orange car.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3559644
Longitude:
-71.1803213
Location:
Case
number:
Date:
2020-12-28
Time:
11:59
Address:
RADCLIFF RD & TAMWORTH RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On 12/28/2020 at approx 1159hrs while assigned to 497 I responded to the area of Tamworth Rd for a report of a tractor trailer pulling down wires and utility poles. Upon arrival I observed the intersection of Radcliff Rd and Tamworth Rd blocked by a tractor trailer truck with multiple downed wires and broken telephone poles. I spoke with the operator of the tractor trailer, Lawrence TOGBA who stated he was following the detour off of Chestnut st to Quinobequinn Rd as he has repeatedly in the last several weeks when, this time , likely due to recent storms, the wires were hanging lower getting caught in his truck pulling and causing telephone polls 702/6 and pole 7 on Tamworth Rd to snap and telephone pole 1 on Radcliff Rd to snap. NFD, Eversource and Verizon responded and were able to free the truck from the wires and begin repairs to infrastructure. 526 Traffic Officer Wilson responded and took photos
Keywords:
Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.320714
Longitude:
-71.227275
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);