crash_reports
1 row where "datetime" is on date 2021-09-02, dcc contains "Unknown" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-09-02
Time:
15:27
Address:
70 ORCHARD AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On September 2, 2021, I responded to the front desk of Newton Police Headquarters to speak with Charles Rankin who wanted to report a past hit and run. Mr. Rankin stated his vehicle (vehicle 1) was parked unoccupied by the curb at 70 Orchard Ave ( Public way in the City of Newton) on Tuesday, August 31. Later that day, he discovered damage to his drivers side mirror. He stated that a note was left behind stating that Massachusetts registration: V91699 struck his vehicle and left the area. He does not know who left the note due to no contact information being left behind. Mr. Rankin showed me a picture of the damage and it appears vehicle 2 side swiped vehicle 1 causing significant damage to the mirror. Mr. Rankin did research and discovered that the plate is registered to JCAC Enterprise out of Milford and provided me with a phone number. It should be noted that when I queried the plate it comes back to that company as well. I will attempt to follow up with the company during business hours on my next tour of duty. On September 3, I called JCAC Enterprise and spoke with an employee who stated they do not have any information on someone driving a truck in the area. They also stated that Mr. Rankin called them and they are going to pay for damages.
Keywords:
Bus, Phone, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3528246
Longitude:
-71.223313
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);