crash_reports

1 row where "datetime" is on date 2019-11-13, dcc contains "Physical impairment" and hit_run = 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:

1900001170

Date:

2019-11-13

Time:

21:37

Address:

1351 WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV2 was parked in front of 1351 Washington Street with his directional on, waiting to enter traffic when MV1 sidewiped his vehicle. MV2 sustained scratches to the rear bumper, driver side front door, and driver side rear door. The driver's side mirror was also knocked off. MV1 did not appear to have any damage. Neither party reported any injuries from the accident. Operator of MV2 did not require a tow. MV1 was towed by Todys Towing due to the operator being transported to NWH for a medical evaluation.

Keywords:

Crash

Dcc:

Lane departure, Physical impairment

Report url:

report

Image url:

image

Latitude:

42.3490685

Longitude:

-71.2284991

Location:

1351 Washington St, West 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);