home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where "datetime" is on date 2019-09-16, intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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:
1900000945
Date:
2019-09-16
Time:
17:08
Address:
303 RIVER ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 was traveling westbound on River Street. Operator of MV2 was backing out of her driveway at 303 River Street. She stated she looked to her left, then her right and then the left again and saw it was clear to continue backing out. She did not see MV1 coming up River Street when she collided with him. MV1 sustained moderate front end damage and front and side airbag deployment. The vehicle was towed by Bobby Donahue from Tody's Towing. The operator of MV1 signed a patient refusal with Catalado AMB2. The operator of MV2 was not injured and was able to pull her vehicle back into her driveway. She sustained moderate damage to her rear passenger side.
Keywords:
Airbag, Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3570808
Longitude:
-71.2379314
Location:
303 River St, Newton, MA 02465, USA
Case number:
1900000946
Date:
2019-09-16
Time:
15:23
Address:
308 WATERTOWN ST
Speed limit:
25
Violation cited:
no
Narrative:
OPMV#1 Was traveling Eastbound on Watertown St when she collided with a parked car located at 308 Watertown St. OPMV#1 Stated she was driving straight on Watertown St and sneezed causing her to collide with a parked car. Both vehicles were towed by Tody's towing. OPMV#1 Signed a refusal with EMS.
Keywords:
Ems
Dcc:
Lane departure, Other improper action
Report url:
report
Image url:
image
Latitude:
42.3609521
Longitude:
-71.1989482
Location:
308 Watertown St, Newton, MA 02458, USA
Case number:
1900000947
Date:
2019-09-16
Time:
17:50
Address:
749 BEACON ST
Speed limit:
30
Violation cited:
no
Narrative:
On September 16, 2019 at approximately 17:50 hours I, Officer Guarino, responded to the area of 749 Beacon St. for a report of a motor vehicle crash involving a bicycle. Upon arrival with other units, we determined that MV 1 was parked in front of 749 Beacon St.The operator of MV1 opened the door to her vehicle to exit and her door struck a passing bicyclist. Traffic on Beacon St. westbound was stopped, the bicyclist fell off of the bicycle and sustained injuries and was transported to Newton-Wellesley Hospital for further evaluation.As the bicyclist was falling, he struck the rear of MV2, which did not appear to have any damage. The operator of MV1 said she did not see the bicyclist, as she went to exit her vehicle. Witness 1, who was stopped in traffic said that the bicyclist was traveling at a high speed and understood how MV1 did not see the bicycle coming. Officer D. Siegal transported the bicycle to the Newton Police Department and secured it in support services.
Keywords:
Bike, Crash, Hospital, Speed
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3307778
Longitude:
-71.1915316
Location:
749 Beacon St, Newton, MA 02459, USA
Case number:
1900000948
Date:
2019-09-16
Time:
19:27
Address:
29 CRAFTS ST
Speed limit:
25
Violation cited:
no
Narrative:
MV#1 Was parked on Lenglen Rd next to 29 Craft St when it was struck by another vehicle. The owner of MV#1 stated he has cameras on the vehicle and captured video of a gray Volkswagen (MA REG#R8875) traveling down Lenglen Rd and side swiping his vehicle before making a right turn onto Craft St traveling Northbound. I attempted to contact the OPMV#2, which he stated he didn't realize he struck a parked vehicle.
Keywords:
[]
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3548179
Longitude:
-71.1998756
Location:
29 Crafts 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 673.604ms