crash_reports
6 rows where "datetime" is on date 2021-02-16 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-16
Time:
01:19
Address:
135 WARWICK RD
Speed
limit:
20
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that as he was travelling Northbound on Warwick Rd he lost control of his vehicle in the ice and collided with the tree. The vehicle sustained front end damage. The operator declined medical attention when it was offered.
Keywords:
Ice, Tree
Dcc:
Too fast for conditions, Swerving
Report
url:
Image
url:
Latitude:
42.3559213
Longitude:
-71.2171338
Location:
Case
number:
Date:
2021-02-16
Time:
14:22
Address:
327 AUBURN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The owner of MV#1 states that his MV was parked and unoccupied across from #327 Auburn St. Sometime between 1-2PM, another unknown MV struck MV#1 and left the area. No injuries, no tows.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3467029
Longitude:
-71.2479551
Location:
Case
number:
Date:
2021-02-16
Time:
16:50
Address:
WASHINGTON STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of MV1 stated she was traveling around the rotary eastbound. Opr of MV1 stated she was in the right lane making her way to the Massachusetts Turnpike. At this time, she was passing the off-ramp and made contact with MV2. Opr of MV1 stated she did not know how she hit MV2. MV1 suffered major damage and was towed by Tody's. Opr of MV1 was evaluated and signed a refusal. When I arrived on scene, Opr of MV2 was not there. I spoke to him on the phone. Opr of MV2 stated he traveled off the off-ramp, was traveling straight and at some point was struck on his rear left side of his vehicle. Opr of MV2 stated he was not injured and suffered minor damage on his vehicle.
Keywords:
Phone
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3498391
Longitude:
-71.2179998
Location:
Case
number:
Date:
2021-02-16
Time:
15:25
Address:
275 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that as he attempted to merge into the right lane his vehicle collided with Vehicle #2 whom he did not observe prior to the collision. The operator of Vehicle #2 stated that her vehicle was struck by Vehicle #1 as she travelled Southbound in the right lane. Both parties declined medical attention when it was offered. Vehicle #1 sustained damage to the rear driver's side. Vehicle #2 sustained damaged to the rear trailer on the passenger side.
Keywords:
[]
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.358572
Longitude:
-71.185233
Location:
Case
number:
Date:
2021-02-16
Time:
21:48
Address:
220 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On Tuesday 2/16/21 at approximately 2148 hours while assigned to unit n499 and driving thru the parking lot behind Seasons 52 (220 Boylston Street). I was flagged down by a motorist stating he was just involved in a minor motor vehicle crash. Operator, (FIGARO Ribiar), states he was travelling thru the parking lot coming down the aisle between Starbucks and Seasons 52 when a motor vehicle backed into him striking his vehicle on the drivers side rear tire. Operator, (KHANARINA Larisa), states she looked both ways prior to backing out of her parking spot but did not see FIGARO's vehicle coming and she proceeded to back into the vehicle. No injuries were reported.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3197333
Longitude:
-71.1761359
Location:
Case
number:
Date:
2021-02-16
Time:
22:45
Address:
241 CHURCH ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that she slid into the fence at 234 Church St as she attempted to navigate the bend in the road. The collision damaged a fence at 234 Church St, as well as a crosswalk sign at the intersection of Church St, and Oakland St. The sign and fence were moved to the side of the pedestrian way as best as it could, and the city was notified to remove the debris. The owner of the property, Mr. Steven Carter, was made aware. The vehicle sustained front end damage. The operator declined medical attention when it was offered.
Keywords:
Crosswalk, Ped
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3549706
Longitude:
-71.1891781
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);