crash_reports
2 rows where "datetime" is on date 2019-05-31, dcc_code = "[]" and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-05-31
Time:
14:32
Address:
114 WEST ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR STATED SHE WAS GOING S/B ON WEST ST WHEN HER VEHICLE CAUGHT EITHER A VERIZON OR CABLE WIRE THAT WAS HANGING IN THE STREET BY #114 WEST ST. SHE FURTHER REPORTS NEVER SEEING THE WIRE. ACCORDING TO THE OPERATOR AS SHE WAS DRIVING S/B DOWN WEST ST HER FRONT LICENSE PLATE COVER CAUGHT A LOW HANGING WIRE CAUSING HER PLASTIC COVER TO FLY OFF HITTING HER HOOD CAUSING DAMAGE. THE FORCE OF THE IMPACT ALSO CAUSED DAMAGE TO OTHER AREAS OF HER VEHICLE, CRACKED, BUMPER ALONG WITH HER DRIVERS SIDE MIRROR. IT WAS LATER DETERMINED THAT JUST PRIOR TO VEHICLE #1 PASSING THE SCENE A POSTAL EMPLOYEE HAD JUST STARTED TO ATTEMPT TO TIE OFF THE WIRE TO A FENCE AT THE SAME TIME CAUSING THE ACCIDENT . VERIZON WAS CONTACTED EARLIER DUE TO A COMPLAINT OF A WIRE DOWN. PRIOR TO THE POSTAL WORKER ATTEMPTING TO PUT THE WIRE UP THERE WAS NO IMMEDIATE HAZARD IN THE ROAD. HOWEVER THE WIRE WAS BLOCKING THE SIDEWALK AND APPARENTLY THE POSTAL EMPLOYEE WAS CONCERNED THAT A PEDESTRIAN MIGHT TRIP ON IT.
Keywords:
Crash, Ped
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3577326
Longitude:
-71.1974473
Location:
Case
number:
Date:
2019-05-31
Time:
15:14
Address:
FRANKLIN ST & WAVERLEY AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 stated he was traveling northbound on Waverly Ave and slowed down to turn when he was struck from behind by MV2. Operator of MV2 stated she was traveling northbound on Waverly Ave when she was struck from behind by MV3 pushing her into MV1. Operator of MV3 stated she was traveling northbound on Waverly Ave when she was struck from behind by MV4 pushing her into MV2. Operator of MV4 stated he was traveling to close to MV3 and had no time to stop and struck the vehicle causing the accident. Operator of MV4 was determined to be operating under the influence of alcohol and was placed under arrest for 90/24 OUI (See incident #19021959). No operators reported any injuries. MV3 and MV4 were towed by Todys due to damage.
Keywords:
Alcohol, Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3492419
Longitude:
-71.1804564
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);