crash_reports
1 row where "datetime" is on date 2021-09-20, dcc contains "Unknown" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-20
Time:
16:43
Address:
1029 CHESTNUT ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On 9/20/21, Nipa Goud DOB 4/19/77 came to NPD Headquarters to report a past hit & run of MA reg 5RR913 ( vehicle #1). Goud states she was shopping in Johnson String 1029 Chestnut St on 9/15 around 1300 hrs when a good samaritan came into the store. He stated that the above mentioned vehicle had been hit in the parking lot. The witness is Allyn McCourt (617) 875-3457. He provided Goud with a description of an older female driving MA reg 2EE316. It was reported that she made contact with the rear of vehicle #1 and immediately left the scene. I spoke to Mccourt on the phone, who informed me that the woman was a white female between 60-70 yrs old. She appeared to be making a 3-point turn in the lot, hit a bush, then the rear bumper of vehicle #1. I asked Mccourt if there was any indication that the woman knew she hit vehicle #1, to which he stated "it certainly seemed so, because she motioned for me to move out of her way after she hit it". The vehicle was described by Mccourt as a blue sedan. MA reg 2EE316 comes back active on a 2011 blue Toyota Camry to Sergey Klepikov out of 1156 Chestnut St in Newton. QED shows a Vera Klepikov residing at that same address with a DOB of 12/22/52. I have left a message with the number on file for the Klepikov residence for Vera to contact me. Damage to vehicle #1 appears to be minor-moderate scraping from the picture I was shown by Goud. To be further investigated.
Keywords:
Bus, Phone, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3138013
Longitude:
-71.2255822
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);