crash_reports

1 row where dcc_code = "[4, 19]" and "retrieved" is on date 2021-01-08

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

2000000772

Date:

2020-12-27

Time:

15:07

Address:

23 LINCOLN ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 states she was pulling out of a parking space in front of 23 Lincoln Street traveling westbound when MV2 struck MV1 causing damage to the front left corner panel. MV1 sustained front end damage and was towed from the scene. Operator of MV2 states he was traveling westbound on Lincoln Street when he didn't see MV1 pulling out of the parking space and struck MV1 with MV2's front right corner panel. MV2 sustained front end damage and was towed from the scene. Towed motor vehicle inventory forms were completed and submitted. No injuries reported.

Keywords:

[]

Dcc:

Failed to yield, Inattention

Report url:

report

Image url:

image

Latitude:

42.3216962

Longitude:

-71.2071177

Location:

23 Lincoln 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);