crash_reports
2 rows where date = "2021-10-14" and "retrieved" is on date 2021-10-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-10-14
Time:
13:03
Address:
RACHEL RD & WINCHESTER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated she came to a stop (four-way stop signs) on Winchester St S/B. #1 stated she looked to her left, a Mv was already stopped on Rachel Rd W/B. #1 stated she yielded to that Mv, that Mv then proceeded through the intersection. #1 stated she then proceeded next, attempting to continue straight ahead. #1 stated at that time, Mv#2 suddenly emerged from Rachel Rd W/B into the intersection directly behind the first Mv. #1 stated this was when her Mv was struck on her driver's side front end by #2. #1 sustained significant front end damage, rendered inoperable and was towed by Tody's. #2 operator stated she came to a stop at the end of Rachel Rd W/B. #2 stated at that time, she thought she had the right of way and attempted to proceed straight ahead through the intersection onto Goddard St. This was when the collision occurred with #1. #2 sustained significant passenger side front end damage, rendered inoperable and was towed by Tody's. Operator of MV#1 had a valid German License. No injuries.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3064293
Longitude:
-71.2056837
Location:
Case
number:
Date:
2021-10-14
Time:
15:46
Address:
CALIFORNIA ST & CRAFTS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated as he was travelling Northbound on Crafts St, a vehicle took a left turn from California St onto Crafts St, causing him to apply his brakes. Vehicle 2 then collided with the rear of his vehicle. The operator of Vehicle #2 stated that as he was travelling Northbound on Crafts St a vehicle pulled out from California St causing Vehicle #1 to apply his brakes. As a result, he collided with the rear end of Vehicle #1. All parties involved declined medical attention when it was offered. Both vehicles were towed from the scene as a result of being disabled.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.359357
Longitude:
-71.212863
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);