crash_reports

1 row where keywords contains "Ice" and "retrieved" is on date 2021-12-17

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

2100001030

Date:

2021-12-09

Time:

07:47

Address:

1321 WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

Operator of MV1 (MA commercial registration M64535) was stopped facing eastbound on Washington at the red light at the intersection with Highland Street. Operator of MV2 (RI registration 387084) approached the intersection behind MV1 and attempted to stop by due to the icy road conditions, was unable to come to a complete stop in time and slid on black ice into the rear of MV1. MV2 sustained extensive damage to the front end.

Keywords:

Ice, Severe

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3494467

Longitude:

-71.2276058

Location:

1321 Washington St, Newton, MA 02465, 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);