crash_reports
1 row where "date" is on date 2019-07-14 and dcc_code = "[3]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-14
Time:
09:40
Address:
TREMONT ST & WAVERLEY AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 stated he was traveling eastbound on Tremont Street. As he was approaching the intersection of Waverly Ave and Tremont Street the traffic control signal turned red. Operator of MV1 stated he did not have time to stop and struck MV2 with the right front bumper of his vehicle. Operator of MV2 stated he was at the intersection of Waverly Ave and Tremont Street turn Westbound onto Tremont Street. The traffic control signal turned green and as he was making a left turn in the intersection MV1 struck the front of his vehicle. MV1 had significant damage to the right side of the vehicle. MV2 had significant damage to the front of the vehicle. Both vehicles were towed by Todys. The passenger of MV1 had a laceration to her left side of her face. Medics checked her and she signed a refusal. Operator of MV1 was cited for Ch. 89/9, failing to stop (T1271489).
Keywords:
Citation
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3540073
Longitude:
-71.1790101
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);