crash_reports
2 rows where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2020-12-27
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-26
Time:
08:16
Address:
811 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of vehicle #1 was travelling West bound on Washington St. and was stopped in traffic for the red light at washington St. at Walnut. Operator of vehicle #1 stated vehicle #2 struck Vehicle #1 from behind. Operator of Vehicle #2 stated she was travelling West bound on Washington St. and did not sse that traffic had stopped in front of her. Vehicle #2 then collided with vehicle #1.
Keywords:
[]
Dcc:
Followed too closely, Inattention
Report
url:
Image
url:
Latitude:
42.351979
Longitude:
-71.2065202
Location:
Case
number:
Date:
2020-11-24
Time:
17:33
Address:
1616 CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Tuesday, November 24th 2020 at 1733 hours, myself, N-496 R March and Sgt Selig responded to 1616 Centre St for a 3 car motor vehicle accident. Newton Dispatch was informed there were people injured on scene, but upon our arrival we observed no parties involved were injured. Medics checked all parties involved and patient refusals were signed. The first vehicle involved was (Mass Reg #5HW126, PORS CAYENN COLOR GRAY, operated by Michael Queen. Commerce Insurance). The second vehicle involved was (Mass Reg #7ZA446, 2004 HOND ACCORD, COLOR GREEN, operated by Guy Levin. Commerce Insurance). The third vehicle involved was (Mass Reg # 5HM522, 2018 VOLK ATLAS COLOR RED. Operated by Alan Kurd. Bankers Standard Insurance.) Driver 1 stated he was traveling south on Centre St when Driver 2 slammed on the brakes in front of him. Driver 1 stated he rear ended Driver 2 as a result. Driver 2 stated his vehicle was nearly at a stop on Centre St because of heavy traffic. Driver 2 stated Driver 1 collided into the rear end of his vehicle. Driver 2 stated the impact of the collision caused his vehicle to rear end Driver 3 in front of him. Driver 3 stated he was nearly at a stop on Centre St because of heavy traffic. Driver 3 stated Driver 2 collided into the rear end of his vehicle. All three vehicles suffered major damage. Todys' Towing came and took Vehicle's 1 and 2. Vehicle 3 was able to be driven from the scene.
Keywords:
Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3207931
Longitude:
-71.2041922
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);