crash_reports
2 rows where date = "2022-06-08" and "retrieved" is on date 2022-06-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-08
Time:
17:39
Address:
EAST BOWERS & HARVARD ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated she was on Harvard Street traveling south bound. When she approached Bowers Street, MV2 pulled out on to Harvard Street and struck MV1. The operator of MV2 stated he stopped at Bowers Street. proceeded to enter Harvard Street when MV1 came out of nowhere and MV2 struck MV1. MV1 had damage to the passenger side and MV2 had damage to the front bumper. Both operators stated they were not injured and motor vehicles were operable. Bowers Road is missing a stop sign.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.351813
Longitude:
-71.201886
Location:
Case
number:
Date:
2022-06-08
Time:
14:39
Address:
125 PARKER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
At approximately 1840HRs on Wednesday, June 08, 2022, I was dispatched to 125 Parker St. for a road rage incident. Upon arrival, I spoke with Derek Eggleton, who stated that he was walking from his truck on Glenwood Ave. to 125 Parker St. with building supplies in hand. As he crossed Parker St., he noticed a Maserati bearing MA Plate: SUGAR approaching him, southbound, at a high rate of speed. Derek then threw said building supplies and moved out of the way of the vehicle because he believed it was not going to stop. He then approached the vehicle which had slowed down and Derek states it "tapped" him in the leg. Heated words were exchanged between Derek and the operator of the vehicle, identified as Sidney Gersh, who ultimately drove off. While I was on scene, Officer Hatfield spoke with Sidney, who stated we was indeed involved in the incident, but states he did not hit Derek. Officer Hatfield observed no damage to the vehicle and I observed no marks on Derek, who signed a patient refusal. I advised Derek that I would be documenting this incident and explained to him that if he so chooses, he may seek charges through Newton District Court. He stated that he understood and would take that into consideration.
Keywords:
Speed, Walk
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3230647
Longitude:
-71.194353
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);