crash_reports
2 rows where latitude = "42.3553475"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-12-23
Time:
21:54
Address:
135 RANDLETT PK
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling westbound on Randlett Park and struck MV2 which was parked in front of 135 Randlett Park. There was damage to the front passenger side of MV1 and there was damage to the driver side front and rear bumper along with damage to both doors on the driver side. Operator of MV1 admitted to texting and driving. Both MV1 and MV2 were towed away from the scene and operator of MV1 was handed Massachusetts Uniformed Citation T1446550 in hand. Fallon Medics arrived on scene and operator of MV1 signed a patient refusal. MV1 was revoked for insurance I mailed Massachusetts Uniform Citation T1446551 to Jason Markle at 25 Linnet Street, West Roxbury. Jason Markle is the registered owner of MV1.
Keywords:
Citation, Phone
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3553475
Longitude:
-71.2221992
Location:
Case
number:
Date:
2022-05-20
Time:
16:11
Address:
135 RANDLETT PK
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of MV1 said she was standing in front of her house, 135 Randlett Park when she heard a loud bang. Owner of MV1 saw a landscaping company truck and trailer speeding away from her car. Owner of MV1 noted that there was a vehicle parked directly across the street making the street narrow but said trucks have been going up and down the street all day without any issues. Owner of MV1 said she could not make out the lettering on the truck but got the license plate which is 459567. Owner of MV1 said she's certain that this was the license plate but there is a chance she missed a number. I ran the license plate and it comes back cancelled to a 1988 American Command Pick Up truck and there is no contact information for the owner of the vehicle. It shows that the registration has been expired since 12/31/1989. Owner of MV1 showed me the damage that was done to the vehicle which was a flat tire on the rear direr side. Owner of MV1 made arrangements for AAA to come and take care of the vehicle. I provided Owner of MV1 with this accident report number. I canvassed the area for the landscaping truck with negative results. Owner of MV1 contacted me stating her neighbor has a picture of the truck off of their front door camera. Owner of MV1 emailed me the picture and I forwarded the picture to IT to be attached to this report. It should be noted you can not make out the lettering of the company in the photo.
Keywords:
Crash, Pictures, Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3553475
Longitude:
-71.2221992
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);