crash_reports
2 rows where date = "2020-01-10" and dcc_code = "[3]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-10
Time:
09:23
Address:
CARLSON AVE & DEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Veh #1 stated he was traveling due East on Dedham St when veh #2 pulled out of the "left turn only" lane and struck his drivers side. This pushed him into the curb flattening his passenger side front tire. Slight/moderate damage to veh #1 drivers side. Veh #2 stated he was traveling East on Dedham St when he realized he was in the wrong lane .He then tried to pull into the right lane when he collided with veh # 1. Slight/ moderate damage to veh #2 passenger side . Operator of veh#2 was cited in hand Mass #T2013424 for Ch89/ Sec4a-Unsafe lane change. Both vehicles were driven from the scene.
Keywords:
Citation, Moderate
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.2989668
Longitude:
-71.1865087
Location:
Case
number:
Date:
2020-01-10
Time:
18:02
Address:
AUSTIN ST & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated while traveling Northbound on Walnut Street MV2 was traveling close to his vehicle. Operator of MV1 stated as he approached the crosswalk to let a pedestrian cross, MV2 was in the left turn only lane onto Austin Street. Operator of MV1 stated MV2 then passed him on the left, striking the driver side of his vehicle and continued on Walnut Street toward Washington Street. Operator of MV1 stated as MV2 passed he was able to get a License Number of that vehicle. After speaking with the Operator of MV1, I contacted the Operator of MV2. The Operator of MV2 stated while traveling Northbound on Walnut Street, MV1 was attempting to look for a parking spot by stopping at times and turning his turn signal on and off. Operator of MV2 stated as MV1 turned his turn signal on and stopped after multiple times of breaking, he went around MV1. Operator of MV2 stated he did not know he struck the other vehicle and that is why he continued on Walnut Street. MV1 had moderate damage to the driver side of the vehicle. MV2 had moderate scratches to the passenger side of his vehicle.
Keywords:
Crosswalk, Moderate, Ped
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3505802
Longitude:
-71.2069457
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);