crash_reports
1 row where "retrieved" is on date 2022-03-14 and violation_cited = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-03-09
Time:
15:56
Address:
999 WATERTOWN ST
Speed
limit:
15
Violation
cited:
yes
Narrative:
Operator 1 states he was walking to his vehicle in the parking lot at 999 Watertown St (CVS Pharmacy) when he saw that a vehicle in the parking space to the left of him was too close to his vehicle, preventing him from being able to enter. Operator 1 asked operator 2 if he could back up to create space and when operator 2 reversed, the back passenger side of his vehicle scraped against the left side of vehicle 1's bumper. Operator 1 then asked operator 2 for his registration, operator 2 offered money and then left the parking lot without exchanging information. Upon making contact with operator 2, he stated he was the operator of vehicle 2 and admitted backing up into vehicle 1. Operator 2 stated he was scared to give his information because he does not have a driver's license and he left the area. I observed minor damage to on the left side of the rear bumper on vehicle 1 and minor damage to the right side of the rear bumper of vehicle 2. I issued operator 2 Massachusetts Uniform citation: T1445618 for the following: MGL Ch. 90 Sec. 24 Leaving the scene after a collission with property damage MGL Ch. 90 Sec. 10 Unlicensed Operation of a motor vehicle
Keywords:
Citation, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3497447
Longitude:
-71.2260743
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);