crash_reports
2 rows where "datetime" is on date 2019-04-11 and keywords contains "Ped"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-11
Time:
14:06
Address:
EXIT 21 OFF RAMP & WASHINGTON ST
Speed
limit:
20
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 STATED AS HE WAS MERGING OFF OF THE EXIT 21 RAMP ONTO WASHINGTON STREET A PEDESTRIAN WAS CROSSING THE ROAD SO HE STOPPED TO LET HIM GO. HE STATED AS HE STOPPED FOR THE PEDESTRIAN TO CROSS, HE WAS STRUCK IN THE REAR BY MV 2. MODERATE DAMAGE SUSTAINED TO MV 1 AND NO INJURIES REPORTED. OPERATOR OF MV 2 STATED HE WAS TRAVELING BEHIND MV 1, ALSO MERGING ONTO WASHINGTON STREET WHEN MV 1 SUDDENLY STOPPED TO LET A PEDESTRIAN CROSS. HE STATED DUE TO THE QUICK STOP HE WAS UNABLE TO BRAKE IN TIME AND REAR ENDED MV 1. MODERATE DAMAGE SUSTAINED TO THE FRONT OF MV 2 AND NO INJURIES WERE REPORTED. THE PEDESTRIAN WHO WAS CROSSING THE STREET STAYED ON SCENE AND CONFIRMED THAT HE WAS TRYING TO CROSS THE STREET AT THE TIME OF THE ACCIDENT.
Keywords:
Crash, Moderate, Ped
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3498391
Longitude:
-71.2179998
Location:
Case
number:
Date:
2019-04-11
Time:
16:09
Address:
CENTRE ST & HOMER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle #1 stated they were traveling northbound on Centre St. when Vehicle #2 was stoped infront of him and was attempting to take a left on Homer St. Vehicle #1 stated he attempted to pass Vehicle #2 on the right to continue going straight when Vehicle #2 cut his wheel and pulled out infront of him. Vehicle #1 stated he continued around Vehicle #2 and continued to drive. Vehicle #1 stated that Vehicle #2 started to follow him and at some point his vehicle was struck by Vehicle #2 on the side of the rear left bumper. Vehicle #2 stated he was attempting to turn left onto Homer St. and was allowing a pedestrian to cross the road infront of him. Vehicle #2 stated he saw Vehicle #1 passing him on his right and attempted to get his attention. Vehicle #2 stated that when Vehicle #1 was passing him he clipped the front right of his vehicle. Vehicle #1 had minor damage to the side of his rear left bumper and was able to be driven away. Vehicle #2 had minor damage to the front right corner of his vehicle and was able to be driven. Both operators were asked if they were injured in the accident and both stated they were uninjured. Due to many inconsistancys in the stories from both operators and the statements from witnesses I am unable to determine who is at fault in the accident. Please see incident # 19013829 for additional information regarding the accident.
Keywords:
Crash, Ped
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3344554
Longitude:
-71.1934235
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);