crash_reports

Table actions

1 row where keywords = "["Pictures"]" and "retrieved" is on date 2021-08-24

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000575
Date:
2021-08-03
Time:
15:48
Address:
COMMONWEALTH AVE & WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of vehicle one stated that while making a right turn onto Commonwealth Ave from Washington St the rear passenger side of his load on a flatbed trailer struck the traffic light at the south west corner. Vehicle one had no damage and did not require a tow. I took photos of the vehicle involved and the traffic light.The vehicle involved is registered out of Canada and was making a delivery of a modular house for Turtle Lane LLC. For the purpose of what company to contact for the City of Newton to bill for the repair of the traffic light contact Stephen Vona of Turtle Lane LLC ( 617 ) 519-6908 77 Oldham Rd Newton , MA 02465. All streets in this report are public ways.
Keywords:
Pictures
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3412048
Longitude:
-71.2384553
Location:
Commonwealth Avenue & 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);