crash_reports

1 row where dcc_code = "[21]" 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), keywords (array), dcc (array)

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

Case number:

2000000766

Date:

2020-12-22

Time:

16:03

Address:

415 PARKER ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 stated she was traveling southbound on Parker Street when she began to get drowsy and she believes she turned the steering wheel to the right, which caused her to strike a tree and roll over onto the snow bank. MV1 was upright on its side when a passerby assisted the operator in getting out through the passenger side door. Operator of MV1 sustained no visible injuries and was evaluated by Cataldo and transported to NWH. Bobby Donahue of Tody's Towing towed the vehicle which had damage moderate damage.

Keywords:

Moderate, Snow, Tree

Dcc:

Fatigue/Sleep

Report url:

report

Image url:

image

Latitude:

42.3132574

Longitude:

-71.1963487

Location:

415 Parker St, Newton, MA 02459, 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);