crash_reports
1 row where "date" is on date 2022-05-20 and latitude = "42.3549334"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2022-05-20
Time:
08:41
Address:
15 PINE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 05/20/2022 at 0841 I responded to 15 Pine St. for a MVA Hit&Run. An unknown vehicle damage a mirror of a parked vehicle. On scene at 15 Pine st. MA Reg 8TF318; 2019 NISS/ARMADA UTIL. color white, was parked unoccupied at the time of the collision. The vehicle was legally parked on Pine St (public Way) in front of #15 Pine st. The vehicle owner was identified as Morgan, James MA OLN#S73936038. Mr Morgan has video from his Ring doorbell of a possible suspect vehicle. I observed the video which shows a dark blue SUV. The video doesn't have the correct angle showing the impact but the audio distinctly can be heard, an impact with a clear cracking sound as the unknown vehicle passes. A license could not be observed due to the camera angle. The parked vehicle sustained damage to the mirror only. there was no visible damage to the body of the vehicle.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3549334
Longitude:
-71.2357668
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);