crash_reports

1 row where "datetime" is on date 2020-07-08, dcc contains "Visibility obstructed" and intersection = 0

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

2000000363

Date:

2020-07-08

Time:

13:30

Address:

8 BELMONT STREET

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 stated she was driving Northbound on Belmont St. when she struck MV2 that was parked. Operator of MV1 stated she attempted to drive around MV2, however stated she couldn't see out of one of her eyes due to a partial obstruction. MV2 was parked with no operators inside. Owner notified of accident. MV1 sustained moderate passenger side damage. MV2 sustained minor left rear damage. No injuries. No vehicles towed.

Keywords:

Crash, Moderate

Dcc:

Visibility obstructed, Inattention

Report url:

report

Image url:

image

Latitude:

42.3530854

Longitude:

-71.1777372

Location:

8 Belmont 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);