crash_reports
2 rows where dcc contains "Visibility obstructed", intersection = 0 and keywords = "["Crash", "Fire", "Pictures"]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-11
Time:
12:12
Address:
14 COOK ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 11-11-19 AT APPROX. 1212HRS. WHILE WORKING N492 I TOOK A REPORT FOR CITY MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 14 COOK ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS BACKING N-BOUND ON COOK ST. DRIVER SAW A BARREL IN HIS REAR VIEW. HE MANEUVERED HIS WAY AROUND THE BARREL BUT DID NOT SEE THE FIRE HYDRANT BEHIND IT UNTIL HE HAD HIT IT. VEHICLE #1 HAD LEFT END DAMAGE ON THE LEFT REAR BUMPER. DRIVER REPORTS NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. THERE WAS NO DAMAGE TO THE FIRE HYDRANT. I TOOK 4 PICTURES OF THE SCENE AND PLACED THE DISC WITH I.T.
Keywords:
Crash, Fire, Pictures
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.360667
Longitude:
-71.1985185
Location:
Case
number:
Date:
2020-05-16
Time:
10:01
Address:
281 NEWTONVILLE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On May 16th, 2020 at approximately 10:01 hours while working N491 I responded to #281 Newtonville Ave for a reported single vehicle crash. While en route the reporting party stated the vehicle had left the scene. On my arrival I spoke with the R/P who stated while riding his bike down Newtonville Ave he observed a black colored landscaping pickup truck back out of Pillion Court onto Newtonville Ave and hit a fire hydrant across the Street. Its possible the driver never knew he struck the hydrant. The R/P never saw the driver or the license plate number. Fire department and water department were notified and were responding. Pictures were taken and later submitted to Technology Bureau.
Keywords:
Crash, Fire, Pictures
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3527856
Longitude:
-71.1984141
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);