crash_reports
6 rows where dcc contains "Unknown" and longitude = "-71.2000849"
This data as json, CSV (advanced)
Suggested facets: street1, speed_limit, hit_run, keywords, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-20
Time:
11:51
Address:
647 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date/time I responded to 647 Washington Street for a report of a two vehicle crash. Upon arrival I met with the operator of vehicle two Mr. Weiner, he stated he was stopped in the Whole foods parking lot when vehicle one backed up into his vehicle. They exchanged information but the operator of vehicle one Ms. Adetola left prior to my arrival. I obtained her license information through Mr. Weiner and when I ran the reg plate on vehicle one it came back to Watertown Ford. I advised Mr. Weiner of the process and I will contact Watertown Ford for more contact information on Ms. Adetola to obtain a statement. Update:Jan. 21, 2019 On Jan. 21, 2019 I contacted Watertown Ford advised them of the crash and obtained a phone number for the operator of vehicle one. I spoke to her on the phone she stated the parking lot roadway was covered in snow/ice, she was backing out of the parking spot and vehicle two continued traveling and struck her vehicle. I advised her of the process.
Keywords:
Crash, Phone, Snow
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
Location:
Case
number:
Date:
2019-07-15
Time:
10:21
Address:
647 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
An unknown MV struck a fire hydrant located on the sidewalk in front of Whole Foods. Fire department and water department were notified. Four photos were taken of the hydrant by me and given in hand to the It bureau.
Keywords:
Fire, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
Location:
Case
number:
Date:
2020-01-08
Time:
13:33
Address:
647 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Miriam Plavin-Masterman states that she parked vehicle #2 at the Whole Foods on Washington St earlier today. When she came out she noticed someone struck her right rear bumper. Miriam stated that checked with the store to see if there was video surveillance and there was not. No witnesses at this time. report for insurance purposes.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
Location:
Case
number:
Date:
2020-03-04
Time:
21:41
Address:
647 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator of MV1 stated at approximately 2000 hrs while parked in the Whole Foods parking lot, located at 647 Washington Street, her vehicle was struck on the front passenger side of her vehicle. Operator of MV1 stated she did not see who hit her due to her shopping inside whole foods. MV1 had minor damage to the passenger side of the vehicle.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
Location:
Case
number:
Date:
2020-04-19
Time:
16:50
Address:
647 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator of MV1 stated while inside the Whole Foods located at 647 Washington Street her MV was hit. Her vehicle was parked in the parking lot and had minor damage to the driver side. Operator of MV1 was able to drive her vehicle after the incident. No information was provided for the 2nd vehicle involved.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
Location:
Case
number:
Date:
2021-12-16
Time:
13:26
Address:
647 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On December 16th, 2021 at approximately 13:26 hours while working N491 I responded to a report of a mv crash in front of Whole Foods, #647 Washington St. On my arrival I located both involved vehicles. Vehicle #1 was a 2018 Black Nissan Rogue, ma plate 492NJ8, operated by a Thomas Gemelli. He stated he was exiting Whole Foods attempting to turn left E/B onto Washington St when he crashed into vehicle #2. Mr Gemelli further stated there was a large truck turning into Whole Foods at the same time he was exiting that blocked his view of vehicle #2. Vehicle #2 was a blue 2011 Ford Fiesta, ma reg. 949RCG, operated by a Eileen Kurkoski. She stated she was exiting from the gas station at #650 Washington St attempting to go W/B on Washington St when she was struck by vehicle #1. She also reported that her view of vehicle #1 was obstructed by the same truck entering Whole Foods.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3541087
Longitude:
-71.2000849
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);