crash_reports
2 rows where "datetime" is on date 2019-11-09 and speed_limit = 35
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-11-09
Time:
07:19
Address:
BEACON ST & HAMMONDSWOOD RD
Speed
limit:
35
Violation
cited:
yes
Narrative:
Operator of MV1 (Mass. Reg. 4WB261) states he was driving south bound on Hammondswood Road and approached the intersection with Beacon Street. MV1 stopped at the stop sign and turned right onto Beacon Street when he saw 2 police motorcycle units approaching from the distance on Beacon Street. The police motorcycle units did not have their emergency lights or sirens on. MV1 stopped on Beacon Street after he made his turn. MV1 was struck from the rear. Operator of MV2 (Mass. Reg. 4AL429) states he was operating south bound on Hammondswood Road behind MV1 when they approached the intersection with Beacon Street. MV1 stopped and took the right turn onto Beacon Street, MV2 stopped and took the right turn after MV1. MV1 abruptly and unsafely came to a stop on Beacon Street causing MV2 to rear end MV1. Operator of MV1 was determined to be operating MV1 without a drivers license and was subsequently issued a criminal application (T1440757) in hand for unlicensed operation of a motor vehicle (Mass General Law Ch.90 Sec. 10). A licensed operator came to the scene to drive MV1.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3323131
Longitude:
-71.1799813
Location:
Case
number:
Date:
2019-11-09
Time:
09:02
Address:
24 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of MV1 (Penn. Reg. CKM160) states she was driving east bound on Commonwealth Ave in the left lane when MV2 turned into the right side of her MV. Operator of MV2 (Mass. Reg. 2NB453) states she was driving east bound on Commonwealth Ave in the right lane when she turned left into MV1. Operator of MV2 states she was looking at the cars ahead and did not notice MV1 when she attempted to turn left.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3397085
Longitude:
-71.1675041
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);