crash_reports
2 rows where "datetime" is on date 2020-11-05, "retrieved" is on date 2020-12-27 and violation_cited = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-11-05
Time:
16:01
Address:
BEACON ST & UPLAND RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Bike was traveling east on Beacon St with the right of way. MV#1 was traveling west on Beacon St, and turning left onto Upland Rd. As the bike was traveling east past Upland Rd, MV#1 took a left onto Upland Rd in front of the bike. this caused the bike to crash into MV#1. Operator of the bike sustained injuries, and was transported to Newton Wellesley Hospital. Operator of MV#1 sustained no injuries and signed a patient refusal. Pictures were taken and submitted to IT to be attached to this report.
Keywords:
Crash, Hospital, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.329864
Longitude:
-71.222242
Location:
Case
number:
Date:
2020-11-05
Time:
16:21
Address:
BEACON ST & CHESTNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1, operator:Oscar Benavidez was driving Eastbound on Beacon St and was attempting to turn right on to Chestnut St when he struck a bicyclist. MV1 stated "He was moving to the right side of the roadway to go around a vehicle that was making a left turn at Beacon and Chestnut. He didn't see a bicylist and heard something hit his car and that's when he stopped and observed a bicyclist on the ground". The bicyclist Jeffery Glassman complained about his right side being sore, but had no other visible injuries. He stated "he was riding his bike on Beacon St and about to be entering the intersection at Beacon and Chestnut when a vehicle pulled to the right and hit him" He signed the refusal on scene with EMS. No damage was done to MV1. Corrina Mieth witnessed the accident and stated "She observed the vehicle move over to the right side of the road and that's when the vehicle collided with the bicyclist". Pictures were taken of the scene.
Keywords:
Bike, Crash, Ems, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3291075
Longitude:
-71.225906
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);