crash_reports

1 row where "date" is on date 2022-01-29, intersection = 0 and "retrieved" is on date 2022-04-04

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

22000085

Date:

2022-01-29

Time:

19:12

Address:

85 CHARLESBANK RD

Speed limit:

25

Violation cited:

no

Narrative:

MV Operator states he was traveling straight ahead when his Ford Transit slid out of control because of the severe snow storm. MV Operator slid into a small concrete median/island in the middle of the intersection. The Motor Vehicle's steering wheel air bag deployed when hitting the island. The MV Operator and the passenger did not suffer any injuries and denied medical attention. The Motor Vehicle sustained damage to the front center and was Towed by Tody's Service Inc as it was inoperable.

Keywords:

Severe, Snow

Dcc:

Improper turn

Report url:

report

Image url:

image

Latitude:

42.3588924

Longitude:

-71.180003

Location:

85 Charlesbank Rd, 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);