crash_reports

1 row where "date" is on date 2020-11-27, dcc_code = "[10]" and keywords contains "Crash"

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

2000000703

Date:

2020-11-27

Time:

17:09

Address:

320 WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was traveling westbound on Washington Street. MV2 was traveling westbound on Washington Street and attempted to turn into MV1's lane. While doing so MV2 struck the front passenger side of MV1. There were no injuries and both parties exchanged information. The operator of MV1 wanted an accident report.

Keywords:

Crash

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3563932

Longitude:

-71.1872752

Location:

320 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);