crash_reports

1 row where "datetime" is on date 2021-01-26 and dcc_code = "[11, 99]"

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

2100000056

Date:

2021-01-26

Time:

20:08

Address:

BEACON ST & WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

MV#1 Was traveling straight on Washington St when he lost control of the vehicle at the intersection of Beacon St and Washington St and struck the utility pole. OPMV#1 Stated he lost control of his vehicle while making the turn and collided with the utility pole. Vehicle was towed by Tody's Towing. Verizon utility pole with minor damage to the base of the pole.

Keywords:

[]

Dcc:

Swerving, Unknown

Report url:

report

Image url:

image

Latitude:

42.3300068

Longitude:

-71.2484874

Location:

Beacon St & Washington St, Newton, MA 02462, 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);