crash_reports
2 rows where date = "2021-01-08" and keywords contains "Walk"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-08
Time:
07:06
Address:
FARWELL ST & NORTH ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated they were traveling Southbound on North St. and attempted to take a left Eastbound onto Farwell St. Operator of MV1 stated they hit a pedestrian with the left front end of their vehicle at the intersection. Operator of MV1 stated they did not see the pedestrian attempting to cross the street. There was minor surface damage to the left front end of the vehicle. Pedestrian 1 stated they were attempting to walk across at the intersection of Farwell St. @ North St. when MV1 struck them in their left hip causing them to fall down. Pedestrian 1 was wearing a green shirt and gray pants. Pedestrian 1 was transported by Waltham EMS to Newton-Wellesley Hospital. Pictures of the scene were taken and submitted to the IT Bureau.
Keywords:
Ems, Hospital, Ped, Pictures, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3623524
Longitude:
-71.2177025
Location:
Case
number:
Date:
2021-01-08
Time:
16:28
Address:
141 NEEDHAM ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On January 8, 2021 at approximately 16:28 hours I, Officer Guarino, responded to the parking lot of 141 Needham St for a report of a MVA hit and run. Upon arraival, I spoke with the operator of MV1, who showed me a dent on the front driver's side of her vehicle. There was minor scratches and no visible paint transfer around the dent. The vehicle was parked in a handicapped parking spot adjacent to a cross walk. The operator of MV1 said that she had washed the vehicle last week and had just noticed the dent when she exited the store and that she would have noticed the damage when she entered. There were no visible cameras in the area that would have footage of the incident.
Keywords:
Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3131214
Longitude:
-71.212987
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);