crash_reports
2 rows where dcc = "["Glare"]", keywords contains "Pictures" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-26
Time:
10:54
Address:
CHERRY ST & WEBSTER ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
ON 3-26-19 AT APPROX. 1054HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT THE INTERSECTION OF WEBSTER AND CHERRY ST. I S[POKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING E-BOUND ON WEBSTER AND HAD THE GREEN LIGHT. WHEN HE WENT THROUGH THE INTERSECTION HE WAS HIT IN THE LEFT SIDE BY VEHICLE #2. VEHICLE #1 STATES AFTER BEING HIT HIS VEHICLE SPUN AND HIS RIGHT REAR SIDE HIT A EVERSOURCE UTILITY POLE ( 453/7 ). AFTER HITTING THE UTILITY POLE HIS VEHICLE CONTINUED TO MOVE ACROSS THE STREET TO 35 WEBSTER WHERE HE HIT A ROCK WALL CAUSING DAMAGE TO HIS LEFT FRONT. VEHICLE #2 STATES SHE WAS TRAVELING S-BOUND ON CHERRY ST. AS SHE APPROACHED WEBSTER ST. SHE STATES SHE WAS BLINDED BY SUN GLARE AND CONFUSED THE LIGHTS AT CHERRY AND WASHINGTON AS BEING THE CORRECT LIGHTS ( THEY WERE GREEN AT THE TIME ). WHEN SHE REALIZED THE LIGHT AT CHERRY AND WEBSTER WAS RED SHE WAS UNABLE TO AVOID HITTING VEHICLE #1. VEHICLE #1 HAD EXTENSIVE REAR AND LEFT FRONT END DAMAGE AND WAS TOWED BY TODYS. VEHICLE #2 HAD EXTENSIVE FRONT END DAMAGE AND WAS TOWED BY TODYS. OPERATOR OF VEHICLE #2 WAS MAILED CITATION ( T1442287 ) FOR CHAPTER 89/9 FAILURE TO YIELD. VEHICLE #1 WAS MAILED CITATION ( T1442286 ) FOR PASSENGER RESTRICTION VIOLATIONS UNDER JUNIOR OPERATOR LICENSE. ALL PARTIES , ( WITH THE EXCEPTION OF WRIGLEY LOWE ) REPORTED NO INJURIES AND SIGNED PATIENT REFUSALS. CHRISTOPHER CAMPBELL AND SERGIO ALVAREZ WERE TURNED OVER TO THEIR PARENTS. WRIGLEY LOWE WAS TRANSPORTED BY MEDIC2 TO NEWTON WELLESLEY HOSPITAL FOR MINOR CUTS. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANIES. I TOOK APPROX. 7 PICTURES OF THE UTILITY POLE AND THE ROCK WALL. DISC TURNED OVER TO I.T. DIRECTOR SMITH. NEW DISC PLACED IN 492 CAMERA.
Keywords:
Citation, Crash, Glare, Hospital, Pictures, Severe, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.350159
Longitude:
-71.228704
Location:
Case
number:
Date:
2019-06-03
Time:
16:10
Address:
WALDORF RD & CANTERBURY RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated he was taking a left onto Waldorf Rd. Westbound from Canterbury Rd. when he saw a child bicyclist traveling Eastbound on Waldorf Rd. in the street. He stated that immediately after, the solar glare from the sun impaired his vision and he could no longer see the child, and at that time the two collided. The left driver's side door area struck the bicyclist, as well as the possible front left tire. The operator and passenger stated they were uninjured. MV1 sustained little to no damage. The bicyclist was identified as CHO, Elena, and she stated she was traveling Eastbound on Waldorf Rd. approaching Canterbury Rd. She stated MV1 took a left onto Waldorf Rd. towards her and at that time she collided with the left side of MV1 and fell off her bike. The rear wheel of the bike was bent due to the collision. Elena stated that she was ok but had right hip pain. She was wearing a helmet, green jacket, blue shirt, black pants, and was riding a pink and white Diamondback bicycle (Serial # A1504026648). Her mother KIM, Kyung arrived on scene and signed a patient refusal with AMB1, and transported her to Harvard Vanguard Wellesley for an evaluation. I took photos of the scene and submitted them to the IT bureau to be attached to this report.
Keywords:
Bike, Glare, Helmet, Impairment, Pictures, Solar
Dcc:
Glare
Report
url:
Image
url:
Latitude:
42.318986
Longitude:
-71.217644
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);