crash_reports
2 rows where date = "2022-06-11" 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-11
Time:
13:21
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling northbound on Chestnut St and MV2 was traveling eastbound on Boylston St when MV2 ran the stop sign at the intersection and collided with the front right bumper of MV1. MV1 stopped to obtain MV2's information but MV2 fled from the scene. Operator of MV1 got a description of the vehicle but didn't obtain any plate information. There were no injuries on scene and MV1 was able to be driven away from the scene.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Case
number:
Date:
2022-06-11
Time:
14:54
Address:
53 ABERDEEN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 06/11/2022, while assigned to N499, I, Officer Conary, responded to Aberdeen Street for a report a minor MVA and one of the cars drove away. Upon arrival, I met with Operator of MV1 who explained to me that they parked their car Southbound of Aberdeen Street when their left side mirror was hit. Operator of MV1 said the operator of MV2 stopped and gave their phone number but did not exchange the rest of the information. I went to Operator of MV2's house and they explained to me that they tried to give their phone number to pay for the damages out of pocket instead of insurance. They also had their daughter in the car and was in a rush. After speaking to both operators, they both agreed there was miscommunication involving the exchange of information. I existed both parties getting the right information. There was minor damage to the rear side of MV1, and minor damage to right side of MV2.
Keywords:
Phone
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3195717
Longitude:
-71.2031248
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);