crash_reports
2 rows where dcc = "["Signs/Signals", "Inattention"]" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-02-19
Time:
12:43
Address:
COMMONWEALTH AVE & SUMNER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of MV # 1 admitted fault. Stated she was traveling WB on Commonwealth Ave CL when she turned left onto Sumner Street and then attempted to cross Commonwealth Ave. She stated she didn't see bus coming. Oper # 2 stated the MV #1 pulled out right in front of him while he was traveling WB on Commonwealth Ave. Oper # 1 was checked by medics and signed a refusal. MV #1 was towed by AAA B.C. police responded and took pictures. Bus was hired by Boston College.
Keywords:
Bus, Pictures
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.336314
Longitude:
-71.1914074
Location:
Case
number:
Date:
2021-11-09
Time:
16:14
Address:
ALBEMARLE RD & WATERTOWN ST
Speed
limit:
35
Violation
cited:
yes
Narrative:
MV1 stated he was attempting to turn left from Watertown St onto Albermarle Rd when the drivers side rear end of his bus made contact with the drivers side of MV2 causing minor damage. Operator of MV1 stated he saw MV2 "stop at the yellow light, I looked around to make sure it was safe to go and then when I went forward, I saw she had now moved out in to the middle of the intersection and was stopped blocking traffic". MV2 stated she was travelling straight when she was struck by MV1 causing minor damage. Operator of MV2 was cited for Unlicensed Operation as well as causing gridlock. No injuries reported and no tows requried. Digital images of the scene were turned ove to the IT Bureau.
Keywords:
Bus, Citation
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.354018
Longitude:
-71.213976
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);