crash_reports
2 rows where dcc contains "Unknown", intersection = 1 and "retrieved" is on date 2021-04-12
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-03-26
Time:
18:06
Address:
WALNUT ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was traveling Westbound on Watertown St attempting to make a right turn onto Walnut St when he was struck by MV#2 in the intersection. OPMV#1 Stated he was making a right turn and the other vehicle was making a left turn at the same time he was when they collided. MV#2 Was traveling Eastbound on Watertown St attempting to make a left turn onto Walnut St when she was struck by MV#1 in the intersection. OPMV#2 Stated she was making a left turn onto Walnut St when she collided with the other vehicle.
Keywords:
[]
Dcc:
Failed to yield, Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3558464
Longitude:
-71.2090275
Location:
Case
number:
Date:
2021-04-09
Time:
07:39
Address:
BOYLSTON ST & QUINOBEQUIN RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of V1 stated traveling she was traveling north on Quinnobequinn Road, V2 was stopped at the stop sign and as continued north V2 struck her vehicle on passenger side rear. She stated V2 made it look like they were pulling over, she backed up and V2 took off on Rte.9 west. She stated the vehicle was a silver SUV (possibly a Toyota/ Honda partial plate MA reg. 1H. Unknown description of operator V2. Witness: Stated he was traveling north on Quinnobequinn Rd behind V1. He stated V2 went through the stop sign and struck V1. He observed V2 was a silver possibly Honda CRV which took off Rte.9 westbound. Description of operator unknown. I canvassed the area with negative results at this time.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.317164
Longitude:
-71.2268965
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);