crash_reports
6 rows where "datetime" is on date 2022-07-07 and "retrieved" is on date 2022-07-26
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-07-07
Time:
07:49
Address:
CHAPEL ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated he was traveling west bound on Watertown Street approaching the intersection of Watertown St and Chapel St. The operator stated he saw someone he knew and waved. MV2 was stopped waiting to turn left on to Chapel St from Watertown St. The operator of MV1 stated after he waved to a friend, the operator of MV2 turned left and he struck MV2. The operator of MV2 stated he was stopped waiting to turn left on to Chapel Street. He stated he thought MV1 was waving him to go and turn on to Chapel St. When he made the turn, MV1 continued to drive and MV1 struck his vehicle. All parties stated they were not injured. MV1 had damage to the passenger side bumper. MV2 had damage to the rear passenger side and called for a private tow.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3608412
Longitude:
-71.200098
Location:
Case
number:
Date:
2022-07-07
Time:
13:48
Address:
1000 COMMONWEALTH AVE
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was travelling southbound at the entrance of 1000 Commonwealth Ave when MV#2 pulled out of her parking spot and struck him. MV#1 sustained moderate damages to its passenger side front and rear door area. There were no reported injuries to the operator of MV#1 or its passengers. The operator of MV#2 stated she was attempting to pull out of her parking spot and did not see MV#1 when she struck it. MV#2 sustained moderate damage to its driver's side front bumper. There were no reported injuries to the operator of MV#2.
Keywords:
Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3374309
Longitude:
-71.2088565
Location:
Case
number:
Date:
2022-07-07
Time:
12:57
Address:
CRAFTS ST & MAGUIRE CT
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated he was traveling south bound on Crafts Street approaching Maguire Ct when a vehicle with a trailer attached was turning into Maguire Court from Crafts street. The operator of MV1 stated he lowered his motorcycle to avoid striking the trailer of the vehicle, causing him to slide on the right side of his motorcycle. There was no contact with the vehicle trailer. There was minor damage to the right side of the motorcycle. The operator was checked by the medics and signed a refusal.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
Longitude:
Location:
Case
number:
Date:
2022-07-07
Time:
13:30
Address:
10 EMERSON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The witness to the hit and run stated she was inside and heard a bang. She looked out the window and heard MV1 back into the parked MV2. The witness then ran outside and observed the driver, a white male drive away and turn right onto Boyd Street. There was significant damage to the bumper of MV2. MV2's bumper was completely off. The vehicle involved was a white van with a green stripe. The witness got a phone number off the van, 401-827-8800. The phone number belongs to Liberty Mobility of West Warwick Rhode Island. A male party answered and stated he sold the vehicle years ago and has received multiple calls regarding the vehicle. A plate was not provided. The witness is not the owner of the vehicle, she is a neighbor.
Keywords:
Phone
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
Longitude:
Location:
Case
number:
Date:
2022-07-07
Time:
15:34
Address:
CHESTNUT ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 stated she was turning left from Washington St onto Chestnut St when she was sideswiped by MV2 causing front end damage. MV2 was described as a white pick up truck with a landscaping trailer which fled the scene down Washington St. No tow required & no injuries reported. A partial trailer plate of C8734 was provided however dispatch was unable to find a matching record. Digital images of the scene were captured & sent to the IT Bureau.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3493354
Longitude:
-71.2253682
Location:
Case
number:
Date:
2022-07-07
Time:
12:30
Address:
LOS ANGELES ST & CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV1 stated that some time between 8am and 12pm his vehicle was struck while parked on Los Angeles St. causing damage to the rear driver side of the vehicle. No tow required & canvass of the area was conducted yielding negative results.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3646689
Longitude:
-71.195653
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);