home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Glare"]", keywords contains "Pictures" and "retrieved" is on date 2020-10-06

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000317
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:
report
Image url:
image
Latitude:
42.350159
Longitude:
-71.228704
Location:
Cherry St & Webster St, Newton, MA 02465, USA
Case number:
1900000570
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:
report
Image url:
image
Latitude:
42.318986
Longitude:
-71.217644
Location:
Waldorf Rd & Canterbury Rd, Newton, MA 02461, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 233.443ms