crash_reports

1 row where "date" is on date 2022-04-21, latitude = "42.3557988" and "retrieved" is on date 2022-04-28

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

22000329

Date:

2022-04-21

Time:

21:03

Address:

CENTRE ST & WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

The operator of MV1 stated he was in the left turn lane, turning westbound on to Washington Street. As he we was turning left on to Washington Street, MV2 was in the left turn only lane and attempted to go straight from Washington street to Centre toward Galen and struck MV1. The operator of MV2 stated he attempted to go straight on to Centre Street from Washington street and struck MV1. MV1 had minor damage to the rear driver side and MV2 had minor damage to the front passenger side. All parties stated they were not injured .

Keywords:

[]

Dcc:

Lane departure

Report url:

report

Image url:

image

Latitude:

42.3557988

Longitude:

-71.1865324

Location:

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