crash_reports
3 rows where dcc = "["Inattention", "Distracted"]", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-09
Time:
10:50
Address:
320 CRAFTS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The owner of MV1 (MA Reg: 673GR1) was parked on the side of the road in the area of 320 Crafts St. MV1 was not in the vehicle, and came outside when she heard a collision. MV1 was parked legally facing southbound on Crafts St. The operator of MV2 (MA Reg: 228YM9) stated she is unfamiliar with the area and was trying to figure out where to turn while driving down Craft St. MV2 stated that she looked at her GPS, came out of the travel lane, and sideswiped MV1. MV1 sustained damage to the rear and drivers side. MV2 sustained damage to the front bumper passengers side. MV2 was evaluated by medics and signed a patient refusal. MV2 was towed by Tody's Towing. The operator of MV2 was issued Massachusetts Uniform Citation T11272254 (89/4A)
Keywords:
Citation
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.3594023
Longitude:
-71.2129967
Location:
Case
number:
Date:
2019-10-03
Time:
21:24
Address:
84 PARKER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 stated while traveling northbound on Parker St, she stopped at the intersection of Browning Rd and Parker. She initiated the left turn signal, prior to taking a left, MV#2 struck the rear of her vehicle causing moderate damage. MV#2 stated while traveling northbound on Parker St, his attention was taken off the road due to a bug crawling on his neck. MV#2 stated while his attention was diverted from the road he struck MV#1 with the front end of his vehicle. Both parties stated they did not sustain any injuries at this time and refused medical attention at this time. MV#1 was not towed from the scene due to minor damage. MV#2 awaited for his own tow from AAA. MV#2 was placed on the side of Browning Rd in a safe location to await his tow.
Keywords:
Moderate
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.324433
Longitude:
-71.1936569
Location:
Case
number:
Date:
2019-10-27
Time:
00:00
Address:
10 OAKWOOD RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV 1 was backing out of the driveway of 11 Oakwood Road and crashed into MV 2 which was parked across the street. There were no injuries to the operator of MV 1, MV 2 was a parked car with no operator. The damage sustaiined to MV 2 was the drivers side door. The damage sustained to MV 1 was the back bumper.
Keywords:
Crash
Dcc:
Inattention, Distracted
Report
url:
Image
url:
Latitude:
42.34364
Longitude:
-71.2038442
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);