New Arrivals at Adult and Youth Correctional Facilities

New arrivals in adult and youth facilities are counted as intakes only (e.g. from non‐custody status to custody, transfer from another jurisdiction, or conditional sentence to custody). An individual could have more than one new arrival at a correctional facility during a fiscal year. New arrivals do not include the transfer of individuals between correctional facilities within the province. Statistics presented are based on data sourced from the Justice Enterprise Information Network (JEIN).

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/new-arrivals-at-adult-and-youth-correctional-t929-78tn\".\"new_arrivals_at_adult_and_youth_correctional\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.