crash_reports
2 rows where dcc = "[]", 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), keywords (array)
Case
number:
Date:
2020-08-17
Time:
17:52
Address:
1180 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 8/17/2020 at 1550 hrs, while on patrol, I was flagged down by a passerby stating a man had just fallen off his "Bike" in front of 1680 Washington St. Upon arrival, I observed a motorcycle parked on the side of the road with the operator standing next to it. The motorcycle had several scratches on its side and a cracked plastic window, consistent with a collision. The operator stated as he was traveling eastbound on Washington St. his motorcycle began to "skid" on the road's surface as he changed lanes. This "skid" caused the operator to loose control resulting in a collision with the road's surface. The operator had minor lacerations to the knee and elbow and was transported to Newton-Wellesley Hospital. The Motorcycle was placed in the adjacent parking lot, to be picked up later in the evening. It should be noted the roadway in front of 1680 Washington St. had recently been paved over and was smooth and free of debris or defect. There were yaw marks for approx 100 yards in both lanes. There was no indication from the marks of a lane change.
Keywords:
Hospital
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3489656
Longitude:
-71.2221296
Location:
Case
number:
Date:
2020-08-21
Time:
05:26
Address:
COMMONWEALTH AVE & ROWE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Upon arrival for a report of down wires. I saw a telephone pole leaning, there were low wires, across Commonwealth Avenue just east of Rowe Street, making the road not passable. Vehicle 1 states he was traveling east on Commonwealth Avenue when he struck wires down in the roadway causing damage to his vehicle. The operator of vehicle 1 notified his office and was able to safely pull into the carriage lane to await a service truck. Eversource and Verizon notified for wires and utility pole.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3474233
Longitude:
-71.2433149
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);