crash_reports

1 row where dcc = "["Fatigue/Sleep"]" and "retrieved" is on date 2021-02-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:

2100000072

Date:

2021-01-31

Time:

04:00

Address:

254 WAVERLEY AVE

Speed limit:

25

Violation cited:

no

Narrative:

On Sunday 1/31/2021 at approx 0400hrs, while assigned to N494, I responded to 254 Waverley Ave for a single vehicle crash. Operator 1 states that he was coming home from work traveling NB on Waverley Ave. He states that a raccoon was in the road and had to swerve to avoid it. MV1 had heavy front end damage after crashing into the gated entrance of 254 Waverley Ave. The owner of the gate and fence was notified of the damage. Pictures were taken and submitted to IT. Operator 1 was transported to NWH with minor injuries and his vehicle was towed by Tody's towing service.

Keywords:

Crash, Pictures, Solar

Dcc:

Fatigue/Sleep

Report url:

report

Image url:

image

Latitude:

42.347645

Longitude:

-71.1804756

Location:

254 Waverley Ave, 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);