home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc contains "Visibility obstructed", keywords contains "Solar" and "retrieved" is on date 2020-10-06

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, 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:
1900000199
Date:
2019-02-19
Time:
07:32
Address:
84 JACKSON ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator 1 states she was traveling Eastbound on Jackson St when she was blinded by the sun. Unable to see Operator 1 struck vehicle 2 which was parked from behind. Vehicle 1 sustained major damage and was towed by Tody's. Vehicle 2 sustained minor damage. There were no injuries.
Keywords:
Solar
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3193464
Longitude:
-71.1862309
Location:
84 Jackson St, Newton, MA 02459, USA
Case number:
1900000432
Date:
2019-04-29
Time:
07:48
Address:
80 MADISON AVE
Speed limit:
25
Violation cited:
no
Narrative:
MV1 was traveling east on Madison Ave from Walnut St approaching #80. There were 2 landscape vehicles parked on left side of the street. The operator, Sarah Ruth Loper-Sengupta, stated that she never saw the pedestrian that was in the roadway (N) due to solar glare. Loper-Sengupta stated she heard a thump coming from the passenger side of her vehicle. Loper-Sengupta stated she looked over to her right and saw a trash barrel in the air. Loper-Sengupta stated she then saw a male party lying on the roadway on her passenger side. Immediately after striking the pedestrian, Loper-Sengupta, stopped to check on him. There was a golden doodle dog in the back seat of the MV at the time of the accident, unrestrained. There were no obstructions hanging from the mirror or windshield area. The front drivers visor was down. There was no airbag deployment. I observed significat damage to the front passenger side windshield area. There was also damage to the front passenger side hood area. See Sgt. Lee update for victim statement Numerous pictures were taken by Ofc. Gaudet of the MV and scene. They were TOT IT. The MV was towed by Tody's due to its shattered windshield. No citation will be issued to Loper-Sengupta. The solar glare caused her to not able to see the pedestrian. The Sgt. and I dont believe the pedestrian looked before crossing with the barell on his left shoulder because he would have been able to see the MV coming as this is straight away section of Madison Ave. It should be noted, that when I arrived on scene I immediately noticed the seolar glare as I walked east on Madison Ave.
Keywords:
Airbag, Citation, Crash, Glare, Ped, Pictures, Solar, Walk
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3497937
Longitude:
-71.2051351
Location:
80 Madison Ave, Newton, MA 02460, USA
Case number:
2000000309
Date:
2020-05-30
Time:
17:50
Address:
HIBBARD RD & TREMONT ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 stated she was traveling Westbound on Tremont Street and could not see well due to a sun glare. Operator of MV1 further stated when she approached the intersection of Tremont Street at Hibbard Road she struck a pedestrian riding a bicycle. I was able to speak with two witnesses on scene who were friends with Ms. Shokri. Both were approximately 10 feet behind her in the crosswalk before she was struck by MV1. Witness statements are documented in this report. Both parents responded on scene and were entered into this report as non-motorists. Both followed medics to Newton Wellesley Hospital. MV1 sustained moderate front end damage. Pedestrian involved suffered minor injuries and was transported to Newton Wellesley Hospital. Operator of MV1 was evaluated on scene and signed a patient refusal. Due to the bicycle being moved prior to my arrival, pictures were not taken on scene. The bicycle was left off the roadway for her friends to pick up. Ms. Skokri was wearing a pink shirt, black shorts and was riding a black bicycle. Ms. Shokri was not wearing any protective equipment.
Keywords:
Bike, Crosswalk, Glare, Hospital, Moderate, Ped, Pictures, Solar
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.354757
Longitude:
-71.1810975
Location:
Hibbard Rd & Tremont St, Newton, MA 02458, 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 1199.844ms