home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc = "["Followed too closely", "Inattention"]" and "retrieved" is on date 2022-07-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, violation_cited, 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:
22000583
Date:
2022-06-28
Time:
17:33
Address:
435 CENTRE ST
Speed limit:
25
Violation cited:
no
Narrative:
Opr of MV1 stated he was stopped in traffic waiting to travel forward. At this time, he had not moved yet and was hit from behind by MV2. MV1 sustained damage to the rear and rear right of the vehicle. No injuries reported and MV1 was not towed. Opr of MV2 stated he was moving forward slowly. Opr of MV2 stated MV1 must have stopped and he was unable to stop in time. MV2 made contact with MV1 from behind. The angle of the crash was due to MV2 attempting to avoid contact. MV2 sustained minor damage to the front center and front left of the vehicle. No injuries reported and MV2 was not towed.
Keywords:
Crash
Dcc:
Followed too closely, Inattention
Report url:
report
Image url:
image
Latitude:
42.3554626
Longitude:
-71.1864201
Location:
435 Centre St, Newton, MA 02458, USA
Case number:
22000596
Date:
2022-07-03
Time:
17:59
Address:
CHESTNUT ST & WASHINGTON ST
Speed limit:
24
Violation cited:
yes
Narrative:
MV 1 was traveling straight eastbound on Washington St. When MV 1 approached the intersection of Chestnut St and Washington St he rear ended MV 2. MV 1 sustained major damage to its front end including a fluid leak. The front air bag of MV 1 deployed. There were no injuries to the operator of MV 1, Mr. Million Yifru, and he signed a patient refusal with Fallon medics. Million was given a citation for operating a motor vehicle with an expired license (MGL ch 90-10) in hand. MV 1 was towed by todys due to it being disabled. MV 2 was stopped in traffic at the intersection of Chestnut and Washington St when he was rear ended by MV 1. MV 2 sustained minor damage to its rear bumper. The operator and passenger of MV 2 were not injured and both signed patient refusals. MV 2 was safe to drive from the crash.
Keywords:
Citation, Crash
Dcc:
Followed too closely, Inattention
Report url:
report
Image url:
image
Latitude:
 
Longitude:
 
Location:
None
Case number:
22000601
Date:
2022-07-06
Time:
17:05
Address:
ASHMONT AVE & CRAFTS ST
Speed limit:
25
Violation cited:
no
Narrative:
Opr of MV1 was slowing down to take a left on Ashmont Ave. At this time, MV2 made contact with MV1. MV1 suffered minor damage to the rear of her vehicle. MV1 was not towed and Opr was not injured. Opr of MV2 was traveling south on Crafts Street. At this time, MV1 was stopped and MV2 slowed down, but was unable to stop. MV2 made contact with MV1. MV2 was towed by Todys's. Opr of MV2 was seen by the medics and signed a refusal. Pass of MV2 did not report injuries. Due to the pass being a juvenile, she was picked up by her father.
Keywords:
[]
Dcc:
Followed too closely, Inattention
Report url:
report
Image url:
image
Latitude:
42.355854
Longitude:
-71.2031706
Location:
Ashmont Ave & 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 235.146ms