JR Facility Average Daily Population by Month

This is a way to increase DCYF transparency by taking an existing report that may not be available to the public and converting them into a form that is accessible to entities that need this information.

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 \"wa-gov/jr-facility-average-daily-population-by-month-in55-r2cm\".\"jr_facility_average_daily_population_by_month\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.