crash_reports

1 row where dcc = "[]", intersection = 0 and "retrieved" is on date 2022-04-04

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

22000240

Date:

2022-03-22

Time:

08:28

Address:

79 ALBAN RD

Speed limit:

25

Violation cited:

no

Narrative:

Operator #1 stated he took a left on Alban Rd from Mossfield Rd when the top of his cement truck collided with power lines from pole 72 to 79 Alban Rd. The impact caused two poles to break and fall, four poles to lean and all power, cable and other utility wires were pulled down. Residents in the area said the pole had been repaired earlier in the week and the wires had not been mounted high enough. The meter was pulled out of 79 Alban Rd. Eversource and Comcast arrived on scene. Barriers were provided by DPW until a detail officer was assigned to the location. Operator#1 contacted his mechanic who rendered the truck safe to drive. No injuries reported.

Keywords:

Crash

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3262779

Longitude:

-71.2434073

Location:

79 Alban Rd, Waban, MA 02468, 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);