crash_reports
3 rows where "datetime" is on date 2020-11-05, retrieved = "2020-12-27T11:33:29" and "retrieved" is on date 2020-12-27
This data as json, CSV (advanced)
Suggested facets: street1, speed_limit, violation_cited, dcc, dcc_code, 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:
Case
number:
Date:
2020-11-05
Time:
17:45
Address:
BEACON ST & CRESCENT AVE
Speed
limit:
30
Violation
cited:
yes
Narrative:
On Thursday, November 5th 2020, at approximately 17:45 hours, I, was responding to a call at 1269 Centre St for the report of an attempted larceny. I was travelling northbound on Crescent Ave, when I heard a loud crash behind me on Beacon St. I diverted from that call, and observed a three car accident at the intersection of Beacon at Crescent St, and notified dispatch to send Newton medics. It was determined that vehicle 1 was travelling northbound on Crescent Ave, and drove through the stop sign, without stopping, striking vehicle 2 on the front left of their vehicle. Vehicle 3 was stopped at the stop sign on the other side of Crescent Ave facing southbound. Vehicle 1 spun, and the opposite side of the vehicle struck vehicle 3, on their front right side. Vehicle 2 crashed into the residents fence at 19 Crescent Ave. I observed heavy damage to the right side of vehicle 1, as well as the back left side. Vehicle 2 had heavy damage on the front of the vehicle. Vehicle 3 had heavy damage to the front right of their vehicle. No one was injured, and the Newton medics cleared with refusals. Tody's towed all three vehicles to their lot. Photos were taken of the fence, and were submitted to the It bureau. A Massachusetts Uniform citation was filled out (T2080109) for Ch. 89 S. 9 (failing to stop/stop sign) and given in hand to the operator of vehicle 1.
Keywords:
Citation, Crash, Pictures
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3303911
Longitude:
-71.1980873
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);