crash_reports
3 rows where dcc_code = "[11]", keywords contains "Crash" and "retrieved" is on date 2021-02-19
This data as json, CSV (advanced)
Suggested facets: date, address, street1, speed_limit, keywords, geocoded_address, latitude, longitude, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-26
Time:
18:42
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling Northbound on Chestnut Street and was turning Westbound onto Boylston Street. While making the turn MV1 lost control due to the snow on the ground and crashed into telephone pole 153. There is damage to the front of MV1. There was no damage done to the pole.
Keywords:
Crash, Snow
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Case
number:
Date:
2021-01-26
Time:
18:45
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling westbound on Boylston Street while attempting to turn Southbound on Chestnut Street. MV1 slid on the snow off the road and crashed into a State sign. There was damage to the front of MV1. MV1 damaged a State street sign located at the corner of Boylston Street and Chestnut Street. I took pictures of the damaged sign and delivered the SD card to IT to be attached to this report. The state was notified about the damage to their sign.
Keywords:
Crash, Pictures, Snow
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Case
number:
Date:
2021-02-09
Time:
13:23
Address:
BRIDGE ST & CHANDLER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On February 9th, 2021 at approximately 13:23 hours while working N491 I responded to the intersection of Bridge St @ Chandler St for a reported MV crash . On my arrival I identified operator #1 as Angelica Beker, operating a Black Volvo SUV. She reported going S/B on Bridge St when vehicle #2 came out into the intersection from Chandler St crashing into her vehicle. Operator #2 identified as Carly Lazarus was operating a grey 2015 Honda civic. She reported being on Chandler St E/B and as she approached the intersection of Bridge St she attempted to stop but due to the snowy surface slid out into the intersection striking vehicle #1. Neither vehicle needed to be towed.
Keywords:
Crash, Snow
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3615389
Longitude:
-71.202328
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);