crash_reports
2 rows where "retrieved" is on date 2021-04-28 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-04-20
Time:
11:46
Address:
978 BOYLSTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 04/20/21 at 11:46 hours, I (Traffic Unit 523) responded to the CVS parking lot located at 978 Boylston Street for a city motor vehicle hit & run accident. The city vehicle was struck when the operator was inside the store and the other unknown vehicle left the scene. The CVS parking lot is a thru-way for the public to access and park for the store. The weather at the time was partly cloudy and the road conditions were dry. On arrival, I met the driver of the city vehicle identified as William Bertrand (MA D/L# S24973075). The vehicle is a 2016 Ford Escape color black with MA registration # M2534A and is labeled as vehicle number 304. Mr. Bertrand stated he was parked in the lot and went inside the store. The Escape was parked in the seventh spot in from the parking stalls closet to the entrance of the store. He then came out and observed that the vehicle had been struck on it's rear driver's side quarter panel area. He says the other vehicle had left the scene and no note was left on his vehicle. I observed numerous scrape marks to that mentioned area and I took digital photos of the damage. I also observed two small specks of paint on the damaged area that were a bluish gray type of color from the suspect vehicle. It appears that due to the scrape marks that the unknown vehicle was pulling in to the parking space to the left of the city vehicle. As it was pulling in, it struck the city vehicle with it's front passenger quarter panel area. I spoke to Nick (CVS manager) on the phone and was inquiring about possible surveillance footage of the lot. He stated that he didn't believe the cameras cover that area of the lot but he would look for any possible footage and notify me if so.
Keywords:
Crash, Phone, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3181167
Longitude:
-71.211237
Location:
Case
number:
Date:
2021-04-27
Time:
15:54
Address:
33 AUSTIN ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Ms. Samantha Mirrer stated that she left her vehicle in the Star Market parking lot at 33 Austin St. She returned to find that the vehicle had been struck on the driver's side. Of yet, the other vehicle is unknown. Star Market has video surveillance of the parking lot, however the view of Ms. Mirrer's vehicle is blocked, and license plates are unable to be made out.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3498004
Longitude:
-71.2087985
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);