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-07-15

✎ 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:
2100000495
Date:
2021-07-07
Time:
09:08
Address:
BEACON ST
Speed limit:
20
Violation cited:
yes
Narrative:
On 7/7/2021, at 0908 hrs, Newton Police responded to the area of Beacon St. and Paulson Rd. for a motor vehicle accident involving two vehicles. Upon arrival, MV#1 was observed with significant damage to the front driver side bumper as well as the front driver side wheel well. MV#2 had minor damage to its passenger side rear bumper. The operator of MV#1 stated she was stopped on Beacon St. by the entrance to Paulson Rd. waiting for the light at Beethoven Ave. to turn from red to green. The operator of MV#1 stated she was stopped behind several vehicles. As the light turned green, MV#1 accelerated and collided into MV#2 which was attempting to go around her in order to turn northbound onto Paulson Rd. from Beacon St. The operator of MV#2 stated he believed MV#1 was "parked" on Beacon St.which resulted in his decision to cross over the double yellow center lane, go around MV#1 and turn onto Paulson Rd. A witness to this collision indicated to police that the operator of MV#2 crossed over the double yellow center lane in an attempt to go around MV#1, which resulted in the collision. The operator of MV#2 was issued MA Uniform Citation T2014489 for: Mgl Ch. 89 Sec. 4A - Marked Lanes Violation. No injuries were reported and both vehicles were driven away from the scene.
Keywords:
Citation, Crash
Dcc:
Signs/Signals
Report url:
report
Image url:
image
Latitude:
42.3306165
Longitude:
-71.2037822
Location:
Beacon St, Newton, MA, 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 321.875ms