crash_reports
3 rows where "date" is on date 2019-03-09 and dcc contains "Inattention"
This data as json, CSV (advanced)
Suggested facets: speed_limit, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-09
Time:
01:17
Address:
WASHINGTON ST. & CHURCH ST.
Speed
limit:
25
Violation
cited:
no
Narrative:
On 03/09/2019, at 0117 hrs, I responded to Washington St. at Church St. for a two car MVA. Upon arrival, I observed both vehicles facing the same direction in the outer eastbound lane of Washington St. MV1 had moderate damage to the front end and MV2 had heavy damage to the rear end. The operator of MV1 stated that as he was approaching MV2 he attempted to slow down but the vehicle accelerated, rear ending MV2. The operator of MV1 stated that moments after the traffic light turned from red to green, MV2 rear ended her. The passenger in MV2 sustained a bruised lip but all involved parties signed patient refusals with Cataldo. Tody's towed MV2.
Keywords:
Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3558456
Longitude:
-71.1904222
Location:
Case
number:
Date:
2019-03-09
Time:
15:23
Address:
ALBEMARLE RD & CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 STATED HE WAS TRAVELING SOUTHBOUND ON CRAFTS STREET AND AS HE APPROACHED THE INTERSECTION AT ALBERMARLE ROAD HIS VEHICLE WAS STRUCK ON THE DRIVERS SIDE BY MV 2. MODERATE DAMAGE SUSTAINED TO MV 1 AND NO INJURIES WERE REPORTED. MV 1 WAS TOWED BY TODYS TO THEIR LOT AFTER ALL VALUABLES WERE REMOVED BY THE OWNER. OPERATOR OF MV 2 WAS TRAVELING WESTBOUND ON ALBERMARLE ROAD AND AS HE DROVE ACROSS THE INTERSECTION OF CRAFTS STREET AFTER COMING TO A STOP AT THE STOP SIGN, HE STRUCK MV 1 ON THE DRIVERS SIDE. HEAVY DAMAGE SUSTAINED TO MV 2 AND OPERATOR WAS TRANSPORTED BY MEDICS TO NWH TO BE EVALUATED FOR HIS INJURIES. OPERATOR OF MV 2 WAS UNABLE TO PROVIDE A STATEMENT OF HOW THE ACCIDENT OCCURRED AND HIS VEHICLE WAS ALSO TOWED BY TODYS TO THEIR LOT. A WITNESS TO THE ACCIDENT IDENTIFIED AS BRIAN ABDOW STATED THAT MV 2 WAS AT FAULT. HE STATED THAT MV 2 CAME TO A STOP AT THE STOP SIGN BUT THEN ACCELERATED INTO TRAFFIC ON CRAFTS STREET AND STRUCK MV 1 WHO HAD THE RIGHT OF WAY. OPERATOR OF MV 2 IS BEING ISSUED MA UNIFORM CITATION T1268369 FOR CH.89 S.9 FAILURE TO COMPLY WITH STOP SIGN.
Keywords:
Citation, Crash, Moderate
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3598454
Longitude:
-71.2170818
Location:
Case
number:
Date:
2019-03-09
Time:
13:03
Address:
BEACON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator was on Beacon St E/B waiting on a green light to turn on Chestnut N/B. Mv#2 operator was directly behind #1, proceeded straight ahead when the light turned green and rear ended #1. #1 stated she may have been injured without specifying where she may have been hurt other than experiencing a headache. Medics responded and a patient refusal was signed. Both vehicles sustained minor damage, rear end and front end, respectively.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3291075
Longitude:
-71.225906
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);