crash_reports
2 rows where "datetime" is on date 2019-05-31, dcc = "[]" and intersection = 0
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:19
Address:
317 PARKER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The Operator of vehicle 1 stated that she had just made a right turn onto Parker Street from Hagen Road, she then over turned and lost control of the vehicle and hit the curb and then a tree on the sidewalk. This caused major damage to the entire front passenger side quarter panel and wheel. The vehicle was immobile and had to be towed away.
Keywords:
Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3164878
Longitude:
-71.1952349
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);