crash_reports
2 rows where dcc = "["Unknown"]", keywords contains "Pictures" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-22
Time:
18:06
Address:
30 TOWER RD
Speed
limit:
15
Violation
cited:
no
Narrative:
On Tuesday 12/22/2020, at approximately 1730 hours, I, Ofc Donald Murphy, met a party at the front desk in regards to a hit and run incident. I spoke with Andrew Shvetts, who stated his wife Tetianna Shvets's vehicle was struck today in the parking lot of Baza grocery market from 10 am-11 am. The owner of MV 1, Tetianna Shvets was shopping at Baza grocery market while her vehicle, MV 1, was parked in the parking lot. When Tetianna returned to her vehicle there was a note on her windshield stating MV 2 struck her vehicle "possibly" on the right rear side and left the scene. The plate of the vehicle was left on the note as well. There was no contact information of the witness left on the note or any manner of collision. There was minimal damage (a few scratches) on MV 1. Andrew provided photos of the damage to the vehicle and the note left on the windshield.The photos of the damage and note are attached to this report. The plate came back to 79 Wheeler Rd in Newton. I went to the address to follow up with the operator of MV 2. I spoke with the owner and operator of MV 2, Mrs. Lyuba Regelman. Lyuba admitted to shopping at Baza grocery market today. Lyuba denied hitting MV1 and there was no damage to her vehicle I could see that matched the damage from the incident. I will not be seeking charges on Lyuba for leaving the scene because there is no contact information of the witness and there is no matching damage to MV 2.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3102612
Longitude:
-71.2156323
Location:
Case
number:
Date:
2020-12-31
Time:
16:57
Address:
GROVE ST & CORNELL ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of vehicle 1 was travelling westbound on Cornell St. Vehicle 1 travelled through the intersection of Cornell and Grove St, and struck the stop sign on the opposite side of Cornell St. The stop sign was completely knocked over. Vehicle 1 was registered to 6 Colgate Cir. I observed vehicle 1 parked in the driveway at 6 Colgate Cir, there was minor damage to the front license plate. No one was injured. Photos were taken of the stop sign, and submitted to the IT bureau.
Keywords:
Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3295535
Longitude:
-71.2581248
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);