crash_reports

1 row where "date" is on date 2022-05-15 and dcc contains "Visibility obstructed"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

22000405

Date:

2022-05-15

Time:

14:07

Address:

DEDHAM ST & NAHANTON ST

Speed limit:

25

Violation cited:

no

Narrative:

OPERATOR 1 OF MV1 WAS TURNING FROM NAHANTON ST ONTO DEDHAM ST (S/B) AND PULLED INTO THE LEFT (INSIDE ) LANE AND WENT TO SWITCH LANES INTO THE RIGHT (OUTSIDE) LANE AND COLLIDED WITH MOTORCYCLE1. MINOR DAMAGE TO MV1. MC1 WAS TURNING ONTO DEDHAM ST (S/B) FROM NAHANTON ST AND WAS IN THE RIGHT LANE. MV1 DID NOT SEE MC1 AND SIDESWIPED MC1. MC1 SLID THE MC TO THE GROUND. MINOR INJURIES TO OPERATOR2 OF MC1. OPERATOR2 WAS EVALUATED BY THE MEDICS AND REFUSED TRANSPORTATION. MINOR DAMAGE TO MC1. NO TOWS NEEDED. NO CITATIONS ISSUED AT THIS TIME.

Keywords:

Citation

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3003288

Longitude:

-71.1881827

Location:

Nahanton St & Dedham St, Newton, MA 02459, 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);