crash_reports
4 rows where "datetime" is on date 2019-07-09, intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-09
Time:
07:30
Address:
334 RIVER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 was parked and unoccupied in front of #334 River St when it was struck by MV#2. The operator of MV#2 stated that he was traveling east on River St when his MV struck MV#1, which was parked on the side of the roadway. No injuries, no tows.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3573391
Longitude:
-71.2393008
Location:
Case
number:
Date:
2019-07-09
Time:
10:50
Address:
320 CRAFTS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The owner of MV1 (MA Reg: 673GR1) was parked on the side of the road in the area of 320 Crafts St. MV1 was not in the vehicle, and came outside when she heard a collision. MV1 was parked legally facing southbound on Crafts St. The operator of MV2 (MA Reg: 228YM9) stated she is unfamiliar with the area and was trying to figure out where to turn while driving down Craft St. MV2 stated that she looked at her GPS, came out of the travel lane, and sideswiped MV1. MV1 sustained damage to the rear and drivers side. MV2 sustained damage to the front bumper passengers side. MV2 was evaluated by medics and signed a patient refusal. MV2 was towed by Tody's Towing. The operator of MV2 was issued Massachusetts Uniform Citation T11272254 (89/4A)
Keywords:
Citation
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.3594023
Longitude:
-71.2129967
Location:
Case
number:
Date:
2019-07-09
Time:
17:34
Address:
76 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Tuesday 7/9/19 at approximately 1734 hours while assigned to marked unit n499 I was dispatched to the area of 76 Nahanton Street for a report of a 2 car MVA with no injuries. Upon arrival I spoke with the operator of MV1, BISHOP Robert, who stated that he was travelling eastbound operating a loner vehicle from Mercedes of westwood when the vehicle began "bucking" back and forth as he was slowing to a stop. He stated he didnt know why the vehicle was operating in such an erratic manner. Robert further stated that he was concerned that he would strike the vehicle in front of him so he swerved toward the middle of the road crossing the double yellow line into the path of MV2 striking the vehicle. I also spoke to the operator of MV2, LEMBERG Ekaterina, who stated that she was travelling westbound when she saw MV1 cross the double yellow line into her lane of travel. She was unable to stop and was struck by MV1.
Keywords:
[]
Dcc:
Lane departure, Defective equipment
Report
url:
Image
url:
Latitude:
42.2997571
Longitude:
-71.1929022
Location:
Case
number:
Date:
2019-07-09
Time:
14:06
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 7/9/2019 at approx 1406Hrs while assigned to 497 I responded to level 4A of the Newton Wellesley parking garage at 2014 Washington St for a report of a minor collision. Upon arrival I spoke with the operator of RI Reg FV705, Malorie CURLEY who stated she had parked her new work vehicle in the parking stall was exiting her vehicle to see if she was within the lines when the operator of Ma Reg 69EL83 Laurence HENDY pulled into the spot next to her, opened his door striking her truck, CURLEY stated as she was rounding the car HENDY proceeded to grab his door and slam it into her car several more times. CURLEY stated she confronted HENDY who refused to exchange information with her for the damage to her car and fled. CURLEY took pictures which she will provide in her own crash report. The front bumper of CURLEYS car had several spots where the white paint was peeled back , HENDYS vehicle had the matching white paint on the edge of his drivers side door. Although the damage was minor CURLEY requested a report for documentation as it was her work vehicle. i attempted to contact HENDY but no phone number is listed.
Keywords:
Crash, Phone, Pictures
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
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);