crash_reports
4 rows where dcc_code = "[19]" and speed_limit = 0
This data as json, CSV (advanced)
Suggested facets: violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-16
Time:
08:53
Address:
197 CALIFORNIA ST
Speed
limit:
0
Violation
cited:
no
Narrative:
Operator 1 of MV 1 was pulling into a parking spot in the parking lot and accidentally pressed the gas instead of the brake. MV 1 collided with a fence owned by McDonalds at 197 California St and then a fence owned by the City of Newton at Forte Park at 235 California St. Todys arrived and was able to retrieve the vehicle and bring it back up from the embankment. Minor damage to MV1 and no injuries to operator 1. Pictures were taken of the scene and turned into the IT bureau.
Keywords:
Crash, Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3651092
Longitude:
-71.1963023
Location:
Case
number:
Date:
2019-06-18
Time:
02:51
Address:
160 BOYLSTON ST
Speed
limit:
0
Violation
cited:
yes
Narrative:
Operator 1 of MV1 stated she attempted to put her MV in reverse and the vehicle went forward instead. MV1 collided with the building at 160 Boylston St. Major damage to MV 1. Towed by Todys towing. Operator 1 citated for c90 s24 Leaving the scene of property damage. Reference incident report #19024881.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3195309
Longitude:
-71.1736296
Location:
Case
number:
Date:
2019-07-24
Time:
08:47
Address:
25 CHESTNUT ST
Speed
limit:
0
Violation
cited:
no
Narrative:
Operator was backing out of a parking spot in a private garage when he swiped the cement pillar next to him.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3488353
Longitude:
-71.2257494
Location:
Case
number:
Date:
2021-05-19
Time:
07:22
Address:
12 MIDDLESEX RD
Speed
limit:
0
Violation
cited:
no
Narrative:
On 5/19/2021 at 0730 hrs, I responded to the parking lot of 12 Middlesex Rd. the United States Postal Office; Chestnut Hill. Postal Truck #9204484 (MV#2) was parked facing southbound in the rear parking lot across from the loading dock. MV#2 had front end damage and a broken head light. The operator of MV#1 (carrier truck) stated he had difficulty maneuvering as he was backing up the truck and collided into the front of MV#2. No damage was observed to MV#1. MV#2 was unoccupied at the time of the collision. No injuries were reported.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.326314
Longitude:
-71.1649964
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);