crash_reports

1 row where "datetime" is on date 2020-08-20, dcc = "["Distracted"]" and intersection = 0

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

2000000466

Date:

2020-08-20

Time:

15:27

Address:

1897 WASHINGTON ST.

Speed limit:

30

Violation cited:

no

Narrative:

MV/1 stated she was stopped on Washington St. waiting to turn left into Woodland Golf Country Club. While waiting to turn left MV/1 was struck by MV/2. Mv/2 had struck the right rear bumper of MV/1. The driver of MV/2 stated that he was heading East bound on Washington St. when he was cut off by another driver causing him to stear to the left and strike MV.1 with the right front corner of his bumper. Both MV/1 and MV/2 stated there was heavy amounts of traffic.

Keywords:

[]

Dcc:

Distracted

Report url:

report

Image url:

image

Latitude:

42.3365452

Longitude:

-71.2460112

Location:

1897 Washington St, Auburndale, MA 02466, 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);