crash_reports

Table actions

2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-08-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

Case number:
2100000609
Date:
2021-08-16
Time:
09:16
Address:
267 WATERTOWN ST
Speed limit:
25
Violation cited:
no
Narrative:
On Wednesday August 16, 2021 at approx. 0916 hours I responded to the area of 267 Watertown Street for a report of a motor vehicle crash with a City tree and property damage. Upon arrival I met with the operator of the truck, Lucky Thipharacksa d.o.b. 10-8-84 of 25 Bradley Avenue Hamdon CT., who works for MKN UNITED INC. 1039 STATE STREET SUITE 203 BETTENDORF, I.A. 52722. He stated he was traveling west on Watertown Street when the top right portion of the truck had impact with a City tree. As a result of the impact, the tree took down Verizon cable wires, causing damage to the right side of the house number 279/281 Watertown Street ( gutters, masonry-brick, landscape, and possible other house damage. The resident at 267 Watertown Street was notified of the tree down near and partially against the property fence. I advised her if there is damage to contact me after tree removal and I will add information to the report. Forestry was notified to remove the tree, the owner of 279/281 Watertown Street was notified of process and report. Verizon was notified of wires. I conducted a post crash level one inspection on the truck which I placed Out Of Service due to the damage. The driver was arrangements for the tow. Below is inspection findings. VIOLATIONS 393.201A POST CRASH (4) UPPER FRAME RAILS DAMAGED - SEPARATED (OOS) 393.201A POST CRASH (3) SIDE FRAME RAILS DAMAGED - SEPARATED (OOS) 393.201A POST CRASH (5) FRONT FRAME RAILS DAMAGED - SEPARATED FROM FRAME (OOS) All parties advised of the process and there were no reported injuries.
Keywords:
Crash, Tree
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3615207
Longitude:
-71.1976947
Location:
267 Watertown St, Newton, MA 02458, USA
Case number:
2100000610
Date:
2021-08-16
Time:
12:20
Address:
74 GROVE ST
Speed limit:
25
Violation cited:
no
Narrative:
MV 1 was traveling westbound on Grove St when a tree's branch located on 73 Grove St broke off and fell on MV1. As result of the crash MV1 sustained significant front end and head damage. A private tow company came and took the motor vehicle, and Newton Forestry was noticed. Officer Ferguson took pictures of the accident.
Keywords:
Crash, Pictures, Tree
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3438088
Longitude:
-71.2475375
Location:
74 Grove St, Auburndale, MA 02466, 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);