crash_reports
1 row where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-11-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-11-10
Time:
08:02
Address:
52 KELVEDEN RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 stated they had parked their vehicle on 11/10 at 17:00 on the street in front of their home at 52 Kelveden Rd. This morning at 08:00 they discovered their vehicle had been struck. MV#1 sustained moderate damages to its driver's side front headlight area. MV#1 (MA REG 287ME6) is a blue colored vehicle. There were pieces of silver colored vehicle parts ( Body panels) laying near the point of impact and silver colored paint transfer on the front bumper of MV#1. I inspected the silver colored vehicle parts and could not locate any identifying part numbers. A search of the surrounding area showed negative results for possible involved vehicles. I did not observe any video cameras in the neighboring houses. On 11/13, the owner of MV#1 contacted me stating that one of his neighbors had a camera that captured a possible involved vehicle. The video was emailed to me and I reviewed it. The video showed on 11/10 at 01:52:52 a silver colored sedan drove by the camera. At 01:53:20 the video showed a silver colored sedan drove by in the opposite direction. At 01:53:38 a loud noise was heard. The video footage only shows a silver colored sedan with its driver's side fog light out and no other identifying markings. The owner of MV#1 was not able to provide the address or contact information of where the cameras were from but believes the house is located on Mossfield Rd. I have consulted with the traffic bureau and they will see if a followup is possible. Traffic Bureau update (Officer Gaudet): I reviewed the video submitted to Officer Setiabudi and I am not able to make out a license plate or any other identifying features of the vehicle aside from the fact that it is a gray sedan. The vehicle is not observed making contact with any other vehicles in the area. I canvased the area of 52 Kelveden Road and the surrounding streets for any gray vehicles with driver side damage. This canvass yielded a negative result.
Keywords:
Crash, Moderate
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3265256
Longitude:
-71.2420152
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);