Local Law 85 – Visitation Quarterly

Quarterly report on DOC visitation metrics.

New York City Local Law 85 of 2015 requires the New York City Department of Correction (DOC) to publicly report Jail Visitation Statistics within 30 days of the beginning of each quarter for the preceding quarter. Specifically, the DOC is required to report the following metrics on a quarterly basis:

(1)The total number of visitors to city jails, the total number of visitors to borough jail facilities, and the total number of visitors to city jails on Rikers Island,</p>

(2) The total number of visitors that visited a person in custody at city jails, the total number of visitors that visited a person in custody at borough jail facilities, and the total number of visitors that visited a person in custody at city jails on Rikers Island, </p>

(3) The number of visitors unable to visit a person in custody at any city jail, in total and disaggregated by the reason such visit was not completed, </p>

(4) The person in custody visitation rate, which shall be calculated by dividing the average daily number of visitors who visited persons in custody at city jails during the reporting period by the average daily person in custody population of city jails during the reporting period, </p>

(5) The borough jail facility visitation rate, which shall be calculated by dividing the average daily number of visitors who visited persons in custody at borough jail facilities during the reporting period by the average daily person in custody population of borough jail facilities during the reporting period, and </p>

(6) The Rikers Island visitation rate, which shall be calculated by dividing the average daily number of visitors who visited persons in custody at city jails on Rikers Island during the reporting period by the average daily person in custody population of city jails on Rikers Island during the reporting period. The data within this report represents information that was available to the Department at the time of report production is subject to change based on updated information subsequently reported by staff members to the Department.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/local-law-85-visitation-quarterly-b3eu-nmy6\".\"local_law_85_visitation_quarterly\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.