crash_reports

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

✎ 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:

2100000768

Date:

2021-09-28

Time:

10:07

Address:

386 WOLCOTT ST

Speed limit:

25

Violation cited:

no

Narrative:

On 9/28/21m at approx 1007Hrs while assigned to 497 I responded to the area of 386 Wolcott St for a report of downed wires. Upon arrival I observed a City of Newton DPW dump truck Ma Reg M4921A with the dump up and wires from 386 Wolcott St to pole 472/7 entangled in it. I spoke with the operator, John Carroll who stated he was raising the rear to drop the asphalt and due to heavy downpour didn't see the wires. Power company notified and responded. 2 pictures taken and turned into IT.

Keywords:

Pictures

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3480459

Longitude:

-71.243593

Location:

386 Wolcott St, Newton, MA 02466, USA

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);