crash_reports

1 row where "datetime" is on date 2019-11-27, dcc contains "Inattention" 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:

1900001218

Date:

2019-11-27

Time:

14:00

Address:

675 WASHINGTON

Speed limit:

35

Violation cited:

yes

Narrative:

Operator of MV1 (MA reg. 6SB554) states she was traveling westbound in the left travel lane on Washington Street when she was struck by MV2 on the passengers side of her car. Operator of MV2 (MA reg 9KJ369) states he was traveling west bound in the right travel lane on Washington Street when he attempted to turn into the left travel lane and accidently struck into MV1.

Keywords:

Crash

Dcc:

Inattention

Report url:

report

Image url:

image

Latitude:

42.3535682

Longitude:

-71.2010595

Location:

675 Washington 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);