crash_reports
6 rows where dcc = "[]" and speed_limit = 0
This data as json, CSV (advanced)
Suggested facets: hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-09-10
Time:
17:29
Address:
95 WELLS AVE
Speed
limit:
0
Violation
cited:
no
Narrative:
MV1 was parked at 95 wells ave and Owner1 came out to see that there was moderate damage to the vehicle. Vehicle was towed by AAA towing. A witness stated that they heard a bang and thought a gray SUV may have been involved. No cameras on the exterior of the building.
Keywords:
Moderate
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.2922215
Longitude:
-71.199726
Location:
Case
number:
Date:
2019-09-17
Time:
15:25
Address:
141 NEEDHAM ST
Speed
limit:
0
Violation
cited:
no
Narrative:
On Tuesday 9/17/19 at approximately 1525 hourts I was dispatched to the parking lot in front of Sierra Tradiing Post (141 Needham Street #50) for a report of a past hit and run. Upon arrival I spoke with Lillian ORTIZ-NADER who states that at approximately 2pm she parked her car in a parking space. She came back to her car at 3:25pm and noticed scratches to the drivers side rear fender, rear door and front door. She states that none of this damage was there before she parked the vehicle.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3131214
Longitude:
-71.212987
Location:
Case
number:
Date:
2021-01-20
Time:
13:29
Address:
200 BOYLSTON ST
Speed
limit:
0
Violation
cited:
no
Narrative:
The operator of MV1 stated she parked her department of public works city vehicle, MA REG M7917A in the public parking lot of Wegmans located at 200 Boylston street at 1pm and when she came back to her vehicle around 2pm she noticed minor damage to the drivers side panel. MV1 stated there were no witnesses and she does not recall what vehicle was parked next to her. There are no cameras in the area. Pictures of the damage were taken and submitted to the IT Bureau. MV1 was able to leave the scene without further incident.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3191343
Longitude:
-71.1756718
Location:
Case
number:
Date:
2021-02-12
Time:
15:23
Address:
157 HERRICK RD
Speed
limit:
0
Violation
cited:
no
Narrative:
MV1 was parked off to the shoulder of the roadway inside the parking lot of the Adelaide. Operator of MV1 came out from getting his COVID-19 vaccine and saw his vehicle had suffered front end damage. Operator of MV1 canvassed the area yielding negative results for any vehicle that could have struck his vehicle. Operator of MV1 spoke with the staff from the Adelaide who informed him there are no cameras in the parking lot. Operator of MV1 wanted this hit and run documented.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3255677
Longitude:
-71.1910346
Location:
Case
number:
Date:
2022-04-19
Time:
13:24
Address:
2014 WASHINGTON ST
Speed
limit:
0
Violation
cited:
no
Narrative:
On 04/19/2022@1324 hrs. I responded to 2014 Washington St/Newton Wellesley Hospital (E.R.Entrance) for a report of a MVA. On scene I spoke with Alexi Martin MA OLN#S30269628 owner of MA Reg. 1AND24; 2021 Toyt/RAV4 color green (V1). Martin's parked vehicle was backed into by MA Reg. 8844NO; 2016 Toyt/COR color black (V2). Owner of V2 is Jane Lindenbaum MA OLN#S71524093. V2 operated by Lindenbaum backed into V1 which was parked and unoccupied. V1 was parked by NWH Valet Jerome Saint Luc (Valet Co. is VPNE). Saint Luc witnessed the collision and stopped Lindenbaum. He informed her that she hit a parked vehicle as she backed up. Saint Luc informed me that Lindenbaum stated she did not hit the car and proceeded on her way. On scene I also spoke with VPNE Manager Jean Emmanuel Pierre-Canal (857)472-8269. I advised him that Saint Luc was not involved in the MVA but he did witness the collision. I checked with NWH Public Safety and reviewed video surveillance footage which captured the collision. The video did confirm the collision and Saint Luc stopping and speaking with Lindenbaum. Further follow up on this incident to be conducted.as I have not made contact with Jane Lindenbaum. I have left a VM message on a phone number believed to be hers.
Keywords:
Hospital, Phone
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3306679
Longitude:
-71.2477866
Location:
Case
number:
Date:
2022-05-18
Time:
19:04
Address:
126 CHAPEL ST
Speed
limit:
0
Violation
cited:
no
Narrative:
V1 was parked behind 126 Chapel Street. Sometime after 11:00, V1 was struck by another vehicle. That unknown vehicle hit, ran and did not leave information behind. Report taken for insurance purposes.No cameras in the area.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3611226
Longitude:
-71.2001064
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);