home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where dcc = "["Failed to yield"]", keywords contains "Citation" and "retrieved" is on date 2021-06-29

✎ 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:
2100000455
Date:
2021-06-22
Time:
15:01
Address:
ARMORY ST & WASHINGTON ST
Speed limit:
30
Violation cited:
yes
Narrative:
On Tuesday, June 22, 2021, while on patrol in Traffic unit N525, I observed a motor vehicle crash at the intersection of Washington Street and Armory Street, Newton. Washington Street and Armory Street are both public ways maintained by the City of Newton. The weather at the time of the crash was overcast with light rain. The road surface was wet. While parked in the Armory Street side parking lot (W) 1121 Washington Street, I observed a white 2016 Mazda CX-3 (MA: 1924DD) accelerate from it's stopped position on Armory Street and onto Washington Street to merge into traffic. I then observed the Mazda's front driver side bumper/fender/wheel area crash into the front passenger side bumper/fender/wheel area of a passing 2016 black Ford Fusion (MA: 3ZJ461) . The Ford was traveling on Washington Street (W) and had the right of way. The operator of the Mazda, Ms. Marcella Velasco (S28312041) was provided Massachusetts Uniform Citation 047509AB in hand for Chapter 89, Section 9 (Fail to Yield to the Right of Way). The Mazda was removed from the roadway by Tody's Towing. I provide transportation for Ms. Velasco to the Enterprise Rent-A-Car located at 1229 Washington Street, Newton due to her vehicle being disabled.
Keywords:
Citation, Crash, Rain
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3494712
Longitude:
-71.219707
Location:
Armory St & Washington St, Newton, MA 02465, 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 342.04ms