crash_reports
1 row where dcc = "["Inattention", "Unknown"]", hit_run = 0 and "retrieved" is on date 2020-10-20
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2020-10-13
Time:
15:42
Address:
WESTWOOD & WEBSTER
Speed
limit:
25
Violation
cited:
no
Narrative:
Reporting party states he is a garbage collector and was standing on the outside of vehicle #1 (trash truck) in the normal position used to jump off the truck, when he was struck by the opening door of vehicle #2. RP was on the rear passenger side ramp, and the trash truck was driving southbound on Westwood St right at Webster St. Vehicle #2 was reported to be parked on the side of the road when the reporting party was struck in the right arm. Medical attention was declined. I spoke with the operator of vehicle #2 who told me that he was parked on the side of the road and saw the garbage truck approaching from the rear. Operator #2 states he did not open the door, and believes that the other involved party may have had his arm extended as it made contact with his vehicle. Parties had already exchanged information prior to my arrival. Waste Management manager John Fogdiok ( 508-261-7228) is aware of the incident. No damage was sustained to either vehicle, and it is believed that the trash truck itself was not struck at all. Due to the conflicting statements, this report is for documentation and insurance purposes only at this time. All parties were advised and are satisfied.
Keywords:
[]
Dcc:
Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.348764
Longitude:
-71.2357818
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);