crash_reports

1 row where "datetime" is on date 2020-07-22 and dcc = "[]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

2000000400

Date:

2020-07-22

Time:

17:35

Address:

NEEDHAM ST & WINCHESTER ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was traveling Southbound on Winchester St. MV1 was merging onto Needham St. where there was a yield sign. MV2 was traveling directly behind MV1 on Winchester St. MV2 front end made contact with MV1 rear. MV3 was traveling directly behind MV2 on Winchester St. MV3 front end made contact with MV2 rear. The driver of MV2 was taken by the medics. MV1 and MV3 reported no injuries. All three vehicles were driven away.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3165242

Longitude:

-71.2088413

Location:

Needham St & Winchester St, Newton, MA 02461, 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);