home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where date = "2019-10-23" and dcc_code = "[]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900001080
Date:
2019-10-23
Time:
09:08
Address:
CHESTNUT ST & RTE 9 RAMP
Speed limit:
25
Violation cited:
no
Narrative:
Pamela Kolman (vehicle #2) was stopped at the stop sign on Chestnut St at the Rte 9 off Ramp. Pamela states that she went to go through the intersection and vehicle #1 struck her vehicle. Pamela stated that she pulled over out of the intersection and vehicle #1 kept going. Pamela did not get the plate of vehicle #1. No injuries no tows. Update: at approx 1145 hrs Lauren Vaniderstine came to NHQ to report a hit and run accident. Lauren state that she was involved in this accident and states that vehicle #2 continued through the intersection on Chestnut St. Lauren got out of her vehicle and saw she had damage to the right rear of her car. Lauren did not see vehicle #2 pulled over up the road. Lauren went to her doctors appointment and then came to file a report. I gave Lauren vehicle #2 info. I went by driver #2 house and gave her Laurens info. Both parties advised.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3490865
Longitude:
-71.2253457
Location:
9 Chestnut St, Newton, MA 02465, USA
Case number:
1900001082
Date:
2019-10-23
Time:
13:06
Address:
41 BEACONWOOD RD
Speed limit:
25
Violation cited:
no
Narrative:
On Wednesday October 23rd, 2019 at approximately 1306 hours I responded to 40 Beaconwood Road for a motor vehicle accident involving a city vehicle. At the time of the accident the weather conditions were sunny and the road conditions were dry. Beaconwood Road is a public way owned by the City of Newton. Upon arrival I spoke with the operator of the city vehicle (MV1) identified as Norayr Sargsyan ( S34138376). Norayr stated that he was traveling southbound on Beaconwood Rd operating a yellow 2009 Ford drwsup truck (MA COM REG; M2939A) and as he passed a landscaping truck that was parked, the rear drivers side corner of the city truck made contact with the rear drivers side of the landscaping trailer. Norayr stated there was a car parked facing the wrong direction directly across from the trailer making it hard for him to pass in between both vehicles. No damage to the city truck was visible, minor damage was present on the trailer. Photographs were taken of the damage and submitted to the IT bureau. No injuries were reported. I spoke with the operator of the landscaping truck (MV2) identified as Jose Nunez (S24348117). Jose stated MV2, a red 2008 Ford drwsup dump truck was unoccupied and parked with a red 2012 Brav utility trailer (MV3) attached to it. Jose reiterated the same sequence of events as Norayr. Both vehicles were able to leave the scene without further incident and I advised both parties a report would be submitted.
Keywords:
Crash, Pictures, Solar
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3298273
Longitude:
-71.2101648
Location:
41 Beaconwood Rd, Newton, MA 02461, USA
Case number:
1900001086
Date:
2019-10-23
Time:
17:51
Address:
BOYLSTON ST & WINCHESTER ST
Speed limit:
30
Violation cited:
no
Narrative:
The operator of vehicle 1 stated that she was traveling North on Winchester Street when vehicle 2 came out from her right side at a high rate of speed and cut her path of travel off. It happened too quickly for her to stop and she crashed head on into the driver side front corner of vehicle 2. She stated she was on the left side of the lane but was traveling with the normal flow of traffic. This caused minor damage to vehicle 2 which was able to be driven away, vehicle 1 sustained major damage to the front bumper and hood and needed to be towed. The operator of vehicle 2 stated he was turning left onto Winchester Street after he had stopped at the stop sign. He stated traffic had stopped to let him turn, he proceeded to do so and vehicle 1 came from the far side of the lane, going around stopped traffic, and crashed into his car.
Keywords:
Crash, Speed
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3192444
Longitude:
-71.2072004
Location:
Boylston St & Winchester St, 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 221.723ms