crash_reports
2 rows where dcc = "["Signs/Signals", "Inattention"]" and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-09
Time:
16:59
Address:
GROVE ST & RT. 128 N/B OFF RAMP
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 stated he was traveling Eastbound on Grove Street when he observed MV2 fail to stop for a stop sign coming off the RT. 128 Northbound ramp and collided with his vehicle. Operator of MV2 stated she was traveling Northbound on the RT. 128 Northbound off ramp when she attempted to turn Eastbound onto Grove Street, however collided with MV1.The operator of MV1 stated she must have not stopped for the stop sign and also stated she must have been looking at her GPS on her phone. No injuries. MV1 sustained heavy right front end damage. MV2 sustained heavy front end damage along with heavy drivers side damage. Both vehicles involved were towed on scene. A towed motor vehicle form was filled out for both involved vehicles.
Keywords:
Phone
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3423767
Longitude:
-71.2488975
Location:
Case
number:
Date:
2019-10-09
Time:
20:13
Address:
CHESTNUT ST & FULLER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was traveling Northbound on Chestnut Street. approaching Fuller Street when MV2 struck her vehicle on the drivers side. Operator of MV2 stated she was traveling Eastbound on Fuller Street. and proceeded through the intersection and collided with MV1. Operator of MV1 stated she did not observe the stop sign located on Fuller St. which was pointed out to her on the scene. No injuries. All involved signed patient refusals from the medics on scene. MV1 sustained heavy left front end and drivers side damage. MV2 sustained heavy front end damage. Both vehicles involved were towed on scene by Todys. A towed motor vehicle form was filled out for both vehicles and placed on file.
Keywords:
[]
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.335547
Longitude:
-71.223753
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);