crash_reports

1 row where date = "2021-11-04" and "retrieved" is on date 2021-11-16

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

2100000902

Date:

2021-11-04

Time:

19:48

Address:

260 NEEDHAM ST

Speed limit:

25

Violation cited:

no

Narrative:

On November 4, 2021 at approximately 19:48 hours Officer Guarino and I, Officer Joyce responded to 160 Needham St. for a report of a three car motor vehicle crash. Upon arrival, all vehicles were off of the roadway and parked at 160 Needham St. The operator of MV1 had heavy front end damage and all operators agreed that MV2 and MV3 were stopped on Needham St when MV1 Crashed into MV2 causing MV2 to crash into MV3. There was no visible damage to MV3, MV2 had damage to the rear bumper. There were no reported injuries and MV1 was towed by Tody's. All parties were advised that a poilce report would be on file and were given the report number.

Keywords:

Crash

Dcc:

Followed too closely, Too fast for conditions

Report url:

report

Image url:

image

Latitude:

42.3087594

Longitude:

-71.214008

Location:

260 Needham 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);