crash_reports
3 rows where "retrieved" is on date 2022-01-24
This data as json, CSV (advanced)
Suggested facets: intersection, hit_run, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-12-18
Time:
20:48
Address:
CRAFTS ST & FESSENDEN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 stated he was traveling straight and hit MV2. Operator MV1 sustained minor injures and was transported to NWH. MV1 sustained damage and was towed by Tody's. Operator of MV1 was charged and given Massachusetts uniform citation (T1448307) see report #20152278. Operator of MV2 stated he was stopped waiting for the green light and was hit from behind. All occupants of MV2 signed patient refusals. MV2 sustained damage but was not towed.
Keywords:
Citation
Dcc:
Reckless driving, Other improper action
Report
url:
Image
url:
Latitude:
42.3596868
Longitude:
-71.2148342
Location:
Case
number:
Date:
2022-01-21
Time:
20:30
Address:
1175 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 01/22/2022, while assigned to West Newton, I, Officer Conary, met with the Operator of MV1 in the lobby for a report of a past hit and run. Operator of MV1 explained to me that on 01/21/2022, she parked MV1 on Walnut Street in front of 1175 at the parking meters. Approximately after an hour or two, she returned to MV1 and saw that there was damage to the front bumper. I did not respond to the accident. MV1 was able to be driven from scene.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3214071
Longitude:
-71.2062807
Location:
Case
number:
Date:
2022-01-22
Time:
18:25
Address:
195 ADAMS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 said he was traveling south bound on Adams street and a vehicle traveling north bound had it's high beams on. Operator of MV1 said this caused him to pull quickly to the right and he could not see initially. Operator of MV1 said he struck MV2 which was parked in front of 195 Adams Street. MV1 had damage to the front passenger bumper. MV2 had damage to the rear driver side bumper. There were no injuries and MV1 was towed away by Tody's. Owner of MV2 arranged for his vehicle to be towed privately. A towed motor vehicle form was filled out and placed in its proper location.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3582404
Longitude:
-71.2003053
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);


