home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where dcc_code = "[3]" and "retrieved" is on date 2021-12-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:
2100000991
Date:
2021-11-26
Time:
16:19
Address:
WALNUT ST & WATERTOWN ST
Speed limit:
25
Violation cited:
no
Narrative:
On 11/26/2021, at 1619 hrs, Newton Police were dispatched to the intersection of Watertown St. and Walnut St. (both public ways within the City of Newton) for a motor vehicle collision involving two vehicles. The operator of MV#1 stated they had a green light as the were traveling southbound on Walnut St. through the intersection of Watertown St. when MV#2 collided into their passenger side. The operator of MV#1's (2) infant children were located within child protection devices in the second row of the vehicle and were reported to be uninjured. The operator of MV#1 and his wife whom was seated in the front seat of the vehicle declined medical attention for themselves and their children. The operator of MV#2 admitted to police he was turning right (southbound) onto Walnut St. from Watertown St. when he collided into the passenger side of MV#1. There is a posted "No turn on right" sign on the corner of Watertown St. and Walnut St. Damage to MV#1 and MV#2 was consistent with MV#2 colliding into MV#1's passenger side. Both vehicles were able to be driven from the scene and the operator of MV#2 was issued Ma Uniform Citation; T20144922 for: Mgl Ch. 89. Sec 9. Red light violation. Mgl Ch. 90. Sec. 11. No License in Possession.
Keywords:
Citation
Dcc:
Signs/Signals
Report url:
report
Image url:
image
Latitude:
42.3558631
Longitude:
-71.2090326
Location:
Watertown St & Walnut St, Newton, MA 02460, 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 341.046ms