crash_reports
1 row where "datetime" is on date 2019-01-03 and street1 = "EAST BOYLSTON ST"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-03
Time:
07:26
Address:
BOYLSTON ST & ELLIS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 01/03/19 at 07:26 hours, I responded to a two car motor vehicle accident at Boylston Street and Ellis Street with one reported minor injury (headache). Operator of MV # 1 states she was exiting the Boylston Street (RT 9EB) off ramp at Ellis Street when she states that she came to a stop for the stop sign. She then inched out and thought it was clear to proceed straight through and struck MV # 2 on both passenger side doors. Operator also stated that she did not think traffic would be allowed to come from the left of her. She was advised that there is a sign below the stop sign that states that the oncoming traffic does not stop. Operator was issued MA Uniform Citation T1441046 for Ch. 89/9 Stop Sign Violation. MV # 1 sustained front end damage to the entire front but was still driveable and the operator reported no injuries. Operator of MV # 2 states she was operating straight through the Boylston Street overpass (SB) on to Ellis Street when she states that MV # 1 never stopped for the stop sign. MV # 1 then proceeded out and struck her vehicle on the passenger side. MV # 2 sustained moderate damage to both passenger side doors and was towed by Tody's towing. The operator complained of a headache but signed a patient refusal with Cataldo Ambulance One.
Keywords:
Citation, Crash, Ems, Moderate
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3167943
Longitude:
-71.2269407
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);
