crash_reports
3 rows where dcc contains "Fatigue/Sleep", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
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:
Image
url:
Latitude:
42.327469
Longitude:
-71.2027999
Location:
Case
number:
Date:
2019-07-15
Time:
08:45
Address:
1177 WASHINGTON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV2 (MA Reg: 5NHV50) stated that he was travelling westbound on Washington St when he crashed into the rear of MV1 (MA Reg:6EZ983) which was parked and unoccupied. MV2 stated that he had just worked his first overnight shift and was very tired. MV2 stated that he may have fallen asleep at the wheel momentarily and crashed into MV1. The owner of MV1 was inside his home at 1177 Washington St and came outside when he heard the accident happen. The operator of MV2 sustained minor injuries and signed a patient refusal. MV2 sustained heavy front end damage and was towed by Tody's. MV1 sustained heavy rear end damage. MV2 was issued MA Uniform Citation T1272257 (c89/s4A).
Keywords:
Citation, Crash
Dcc:
Lane departure, Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.349298
Longitude:
-71.221892
Location:
Case
number:
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:
Image
url:
Latitude:
42.3111394
Longitude:
-71.1948172
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);