crash_reports
1 row where "date" is on date 2019-01-23, dcc contains "Visibility obstructed" and dcc_code = "["18"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-23
Time:
14:07
Address:
165 NEEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Leary was crossing Needham St southbound at the corner of the property between Stop and Shop and Jiffy Lube. She states that she was 1/4 of the way across the street when she was struck by MV1. The left side of her body(arm, hip) struck the right side of the MV. She fell to the ground. MV1 states that he was pulling out of the Stop and Shop driveway to turn right onto Needham St. He saw the pedestrian next to the snow bank on the right side of the driveway as he approached the end of the driveway. When he got to the end he did not see her anymore and assumed she had continued walking west on Needham St. He then turned right and felt the collision and then he saw her. He immediately pulled into the Jiffy Lube lot to check on her. I took pictures of the scene and the MV. They were TOT IT. After further investigation, on 2/7 the operator was cited for 90/14 failure to stop for pedestrian. I spoke with Kenneth via phone and advised him of the update. The citation was mailed to him. I am charging for 90/14 failure to stop for a pedestrian. On Wednesday February 6, the operator information of this report was ammended to show the correct operator information.
Keywords:
Citation, Ped, Phone, Pictures, Snow, Walk
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
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);