crash_reports
1 row where "date" is on date 2022-06-02, longitude = "-71.2297026" and "retrieved" is on date 2022-06-14
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-02
Time:
13:03
Address:
17 RUSSELL RD
Speed
limit:
20
Violation
cited:
no
Narrative:
On June 2nd, 2022 at approximately 13:02 hours while assigned to N491 I responded to #17 Russell Rd for a past hit & run crash. On my arrival I spoke with the R/P, Jason Kenyon. He stated he found a note on his vehicle from his neighbor, Monique Ricard, #18 Russell Rd, stating she observed a dark blue vehicle, Ma plate 3XCB84, operated by a B/M crash into the front of his vehicle. Mr Kenyons vehicle was parked in his driveway facing out. Wit ness thought the operator was going to leave a note but never did. I queried the suspects vehicles registration and it came back on a 2020 Blue Toyota Corolla, to a Samiir Muhamed, #36 Oakcrest Rd, Hyde Park Ma. Dispatch attempted to locate a telephone listing for the owner to no avail. Witness further reported that the suspect vehicle originally came out W/B from Charlesbank Terrence and appeared to have hit his accelerator instead of his brake causing his vehicle to accelerate forward into the driveway of #17 Russell Rd crashing into vehicle #1. Vehicle#2's damage would be on the passenger side front/quarter. video of this crash was later sent to the Traffic bureau. This crash will be further investigated by the traffic bureau.
Keywords:
Crash
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3594083
Longitude:
-71.2297026
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);