crash_reports

1 row where date = "2021-10-13" and "retrieved" is on date 2021-10-19

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100000821

Date:

2021-10-13

Time:

15:23

Address:

24 ELLIOT ST

Speed limit:

25

Violation cited:

no

Narrative:

M/V #1 was traveling north on Elliot St. As it approached and attempted to pass under the MBTA bridge, the top of the trailer struck the underside of the bridge. It should be noted, that there are no signs of the bridge height, or max. allowable height facing north. The top left corner of the trailer was damaged. There was no visible damage to the bridge.

Keywords:

[]

Dcc:

Unknown

Report url:

report

Image url:

image

Latitude:

42.3179196

Longitude:

-71.2125693

Location:

24 Elliot St, Newton, MA 02461, 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);