crash_reports
1 row where "datetime" is on date 2019-01-19, dcc = "["Reckless driving"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-19
Time:
18:30
Address:
423 LEXINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 1/19/19 I responded to 25 Normandy Rd for a report of a past hit and run. I spoke with the Operator of MV#1 who stated the accident had taken place in front of Tom's Pizza, 423 Lexington St, at approximately 1830 hrs. Operator of MV#1 stated she parked her vehicle in a parking spot directly in front of the restaurant and went inside. When she returned approximately 5 minutes later she realized her vehicle had been rear ended. Two witnesses provided her with information about the accident and the plate number. (See witness narratives.) MV#1 suffered moderate damage to the rear and was driven from the scene. Waltham PD responded to the address listed for MV#2 and were not able to locate the vehicle. At approximately 2000 hrs, I was contacted at the police station by the owner of MV#2's wife. After further investigation (see incident report #19002425) it was determined that the operator of MV#2 at the time of the accident was the vehicle owner's brother. I spoke with Operator of MV#2 on the phone and he stated that the road was icy and slippery due to snow and he crashed into the back of MV#1. He stated he was nervous and thought he had only hit the sidewalk curb. Operator of MV#2 was issued citation T1440626 by mail for 90/24C Leaving the Scene of Property Damage, 90/10A Unlicensed Operation and 90/24 Use of MV Without Authority. He stated the vehicle suffered minor damage to the front.
Keywords:
Citation, Crash, Ice, Moderate, Phone, Snow
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3473356
Longitude:
-71.2472474
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);