crash_reports
3 rows where dcc contains "Inattention", longitude = "-71.217724" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: address, street1, speed_limit, dcc, dcc_code, geocoded_address, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-01
Time:
20:12
Address:
ELIOT AVE & WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 Stated while traveling Westbound on Watertown St at the intersection of Eliot Ave his vehicle was struck on the driver side by MV#2. MV#1 stated MV#2 was attempting to cross Watertown St from Eddy St when MV#2 entered his lane of travel.MV#1 had heavy front and driver side damage following the collision. MV#2 Stated while traveling Northbound on Eddy St she attempted to cross Watertown St and on to Eliot Ave. MV#2 stated MV#1 had dim headlights and appeared to be traveling at a high rate of speed. MV#2 stated the front passenger side of her vehicle struck MV#1 on the driver side. Both MV#1 and MV#2 were towed from the scene due to heavy damage to both vehicles. All parties signed a medical refusal on scene and stated the were not injured at this time.
Keywords:
Speed
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3526115
Longitude:
-71.217724
Location:
Case
number:
Date:
2020-01-15
Time:
15:11
Address:
EDDY ST & WATERTOWN ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 stated she stopped at the stop sign on Eddy St then attempted to turn left on to Watertown St when MV2 "hit me." MV1 sustained heavy passenger side damage and was removed from the scene by Tody's Towing. MV2 stated he was travelling w/b down Watertown St when MV1 "cut in front of me and I couldn't stop in time" subsequently striking MV1 causing minor damage. After contact with MV1, MV2 spun and struck MV3 who was travelling e/b on Watertown St causing front end damage. MV2 was removed from the scene by Export Towing & MV3 was removed by Tody's Towing. All parties were evaluated by Cataldo Ambulance who cleared with patient refusals.
Keywords:
Ems
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3526115
Longitude:
-71.217724
Location:
Case
number:
Date:
2020-04-20
Time:
21:14
Address:
EDDY ST & WATERTOWN ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 stated he was travelling w/b on Watertown St when MV2 "tried to go straight across the intersection and we hit" causing minor front end damage. No injuries reported or tows required. MV2 stated he was travelling n/b on Eddy St and "stopped at the stop sign, pulled out and got hit" causing heavy damage.No injuries reported and AAA responded for the vehicle.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3526115
Longitude:
-71.217724
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);