Libraries - 2019 Circulation by Location

Circulation figures include new checkouts as well as renewals. Chicago Public Library consists of the Harold Washington Library Center, Sulzer and Woodson regional libraries and over 70 neighborhood branches. Many locations experience sporadic closures to perform facilities upgrade or emergency closures due to heating or air conditioning issues, or area power outages. Independence Branch closed due to a fire in 2015. Whitney Young has been closed since November 2017 for major renovations. Woodson Regional Library reopened after a major renovation in February 2018.

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 \"cityofchicago/libraries-2019-circulation-by-location-8rsv-tvu9\".\"libraries_2019_circulation_by_location\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.