crash_reports
1 row where "datetime" is on date 2019-12-06, dcc = "["Failed to yield", "Unknown"]" and dcc contains "Unknown"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-06
Time:
00:46
Address:
131 WOODLAND RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator #1 states he was driving northbound on Seminary Ave in MA reg 5LE114 (vehicle #1), when he was t-boned on the driver's side by MA reg 959SD7 (vehicle #2). Operator #2 states that he was attempting to turn left out of the Arnow Campus Center parking garage and did not see vehicle #1 approaching from the right. It should be noted that the physical address of the parking garage appears to be 131 Woodland Rd, however the collision occurred on the Seminary Ave side. All parties declined medical attention and no tows were needed. Vehicle #1 sustained significant damage along the driver's side doors. Vehicle #2 has moderate front end damage. Operator #2 was issued Ma citation T1268432 in hand for Failure to Yield to Oncoming Traffic. 131 Woodland Rd will be the address used in documenting this crash.
Keywords:
Citation, Crash, Moderate
Dcc:
Failed to yield, Unknown
Report
url:
Image
url:
Latitude:
42.3425074
Longitude:
-71.2474214
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);