crash_reports

1 row where dcc contains "Visibility obstructed", intersection = 0 and "retrieved" is on date 2020-12-27

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

2000000729

Date:

2020-12-11

Time:

17:04

Address:

1229 WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

MV1 was pulling out of Enterprise Rent-a-car and signaled to make a LEFT turn. Two vehicles stopped in tandem for him in the right side westbound lane. He proceeded into the lane of traffic when MV2 collided with him from the left side westbound lane. MV1 stated that his front end was already in that left side westbound lane and he was in the middle of completing the turn when MV2 collided with him not paying attention to him or the two cars stopped for him. MV2 stated that he had a clear lane of travel and proceeded and MV1 came out of nowhere.

Keywords:

[]

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.349487

Longitude:

-71.2238931

Location:

1229 Washington St, Newton, MA 02465, 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);