crash_reports
1 row where date = "2021-10-14", dcc = "["Visibility obstructed"]" and "retrieved" is on date 2021-11-01
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-14
Time:
18:34
Address:
AUBURN ST & LEXINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/14/2021 while assigned to marked cruiser N493 at approximately 18:34 hours I, Officer Vazhenin, responded to 307 Auburn Street for a report of 2 car MVA. Upon arrival I spoke to Ms. Jennifer Ann Pope (Driver 1 of MV 1), who stated that when she was taking a left turn to Auburn Street, she followed a car (MV 3) in front of her, because she believed that MV 2 saw her and was letting her to take a left turn. Ms. Pope (Driver 1) said that when she was making that turn, MV 2 started making a turn in the same direction. She stated that she stopped, but MV2 kept driving and crashed into the right front corner of her car (MV1). I then spoke to Ms. Katherine Mary Iodice (Driver 2 of MV2), who stated that she yielded the right of way to MV3 and then started making a turn right after that car. Ms. Iodice stated that she did not see MV1, which was following closely to MV3, and while she was making a turn, she observed MV1, but it was too late to stop and her car (MV2) crashed into MV1. Driver 1 of MV1 was at fault because she failed to yield the right of way to Driver 2 of MV2, which had an obstructed vision and did not see MV1.
Keywords:
Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3471575
Longitude:
-71.2470349
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);