Average Daily Counts at Adult and Youth Correctional Facilities
Average daily count statistics of adults and youth in custody are derived from daily count statistics of adults and youth incarcerated in adult or youth correctional facilities in Nova Scotia. The average daily count is submitted to Statistics Canada and data is published for the provinces and territories on an annual basis through their Key Indicators Report (KIR) survey and CANSIM. Due to the time lag in publishing the data by Statistics Canada, however, data for the most recent year is provided by the Nova Scotia Department of Justice.
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 \"novascotia-ca/average-daily-counts-at-adult-and-youth-xbcp-7w2t\".\"average_daily_counts_at_adult_and_youth\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.