crash_reports
3 rows where "datetime" is on date 2021-11-06 and hit_run = 1
This data as json, CSV (advanced)
Suggested facets: violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-06
Time:
00:39
Address:
192 SPIERS RD
Speed
limit:
25
Violation
cited:
no
Narrative:
At approximately 0039 hours on November 6, 2021 Officer Guarino and I, Officer Joyce, were dispatched to a report of a hit and run. At the scene we spoke to operator of MV1. He stated he heard a loud bang and came out of his house and observed his car damaged. Officer Guarino and I observed multiple pieced of MV2 on the road. The parts came back to a blue Hundai Elantra. The operator of MV1 will be emailing me survalence video from his home security system of the incident. Multiple units checked the area and did not find a vehicle matching the description. UPDATE 11/6/2021 1730HOURS: Officer Nardelli responded to Spiers Rd. The operator of MV2 Stanley Joseph, returned to the scene and exchanged information with the opperator of MV1 Elton Matos. Stanley Joseph who was working for Uber Eats, admitted he was looking at his GPS before the collision. Stanley Joseph said he left the scene because he did not want his car towed because he needs it for work. He did not intend to avoid exchanging information.
Keywords:
[]
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.2919967
Longitude:
-71.1823322
Location:
Case
number:
Date:
2021-11-06
Time:
02:14
Address:
219 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
At approximately 0214 hours on November 6, 2021, Officer Guarino and I, Officer Joyce were dispatched to 219 Commonwealth Ave for a report of a hit and run. I spoke to the driver of MV1 who said he was sitting in the drivers seat of his car when the driver of MV2 struck his vehicle from behind. The driver of MV1 then got out of his vehicle and took a video of MV2 before it fled the scene. MV 2 took a right onto Manet Rd and crashed into a city pole and sign. Photographs were taken of the city property and submitted to IT to be attached to the report. The driver of MV1 emailed me a copy of the video he captured, which was forwarded to IT to be attached to this report. Officer Guarino and I noticed multiple pieces of MV2 on the ground around MV1. Other officers searched the area for MV2 but were unsuccessful.
Keywords:
Crash, Pictures
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3377689
Longitude:
-71.174893
Location:
Case
number:
Date:
2021-11-06
Time:
14:11
Address:
1148 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was parked in a parking spot at 1148 Centre St. Owner saw a white SUV type vehicle back in to her vehicle and the drive away fleeing the area. There were no witnesses that came forward and no cameras in the area.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3329316
Longitude:
-71.1933784
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);