crash_reports

Table actions

2 rows where dcc = "["Fatigue/Sleep"]", intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000671
Date:
2019-06-29
Time:
04:48
Address:
160 LAKE AVE
Speed limit:
25
Violation cited:
yes
Narrative:
Operator of MV1 states she arrived at The Sinclair restaurant in Cambridge with a friend at approximately 11:30pm and had 1 glass of wine. Operator of MV1 states she left at closing at approximately 2am to drive her friend home located on Mass Ave. Operator of MV1 states after dropping her friend off she traveled home to 41 Hyde St in Newton. Operator of MV1 states she took Lake Ave westbound heading towards Hyde St when she was fighting off sleep and must have passed out at the wheel and struck a city tree on the eastbound side of Lake Ave in front of 160 Lake Ave. Operator of MV1 states she contacted AAA at 3:37am, but they never showed up so she abandoned the vehicle and walked home. Operator of MV1 states she didn't sustain any injuries and refused medical attention. MV1 sustained heavy damage to the left front fender and was towed by Tody's.
Keywords:
Tree, Walk
Dcc:
Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.327469
Longitude:
-71.2027999
Location:
160 Lake Ave, Newton, MA 02459, USA
Case number:
1900001282
Date:
2019-12-13
Time:
16:25
Address:
44 WHEELER RD
Speed limit:
25
Violation cited:
yes
Narrative:
Based on observations, and statements made, the following occoured. M/V#1 was travelling west on Wheeler Rd. The operator stated that she had been suffering from a migrane, and was fatigued, and believe she may have dosed off. The M/v crossed into the left lane, and struck M/V#2 which was parked in front of 44 Wheeler Rd. Citation #T2013109 was issued to the operator of M/V#1 for MGL 89/4/A Marked lanes violation.
Keywords:
Citation
Dcc:
Fatigue/Sleep
Report url:
report
Image url:
image
Latitude:
42.3111394
Longitude:
-71.1948172
Location:
44 Wheeler Rd, Newton, MA 02459, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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