home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2019-06-24, dcc = "["Failed to yield"]" and keywords contains "Citation"

✎ 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:
1900000648
Date:
2019-06-24
Time:
16:36
Address:
BEACON ST & CHESTNUT ST
Speed limit:
25
Violation cited:
yes
Narrative:
The OP. of MV#1 states he was travelling eastbound on Beacon Street. As he was entering the intersection of Chestnut Street, MV#2 on the oncoming lane suddenly made a left turn in front of his path causing a collision. He pulled over and couldn't find MV#2 anywhere around. He describes MV#2 as a black pick-up truck. The OP. of MV#1 is a dog walker and there were 6 dogs inside the vehicle during the accident. He states the dogs appear fine and the collision wasn't a large impact. Witness #1 states he was the first car stopped on Chestnut Street waiting for the traffic light to turn green. He witnessed MV#2 cut in front of MV#1 and cause a collision. MV#2 then continued driving down Chestnut Street southbound and didn't stop. When they were all stopped at a traffic light for Chestnut Street and Woodward Rd., Witness#1 took down the plate of MV#2 as L92280 and described it as a black pick-up truck with possible MA commercial plates. He describes that it has a spare tire on the bed of the truck leaning against the back window. MV#2 then accelerated away when the light turned green and turned into a unknown side street. The owner of the plate given is for Eric P. Rowe out of Norton, MA. His vehicle model does match the description of a black pick-up truck. I gave Norton P.D. a call at approx. 1800 hrs. A short while later, they called back and said the pick-up wasn't home but gave me a cell phone number. I was able to speak with Eric Rowe and he stated he was the OP. of MV#2. He stated he was on Beacon Street westbound making a left towards Chestnut Street southbound. There was a car making a turn in front of him and he saw MV#1 slow down, which is why he made the turn. A minor collision happened so he stopped to look at this truck and saw no damage. He didn't see MV#1 stopped anywhere so he drove away thinking there was no need to exchange paperwork for no damage to his truck. The OP. of MV#2 was advised of the proper procedure and that he will be getting a citation in the mail. An incident report was also generated.
Keywords:
Citation, Crash, Phone, Walk
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3291075
Longitude:
-71.225906
Location:
Beacon St & Chestnut St, Newton, MA 02468, 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 355.624ms