Library In-House Visits

Total number of patrons entering and exiting the library. In-house library visits are collected and calculated monthly using electronic gate counters. All libraries gather patron counts using the 3M / Bibliotheca security gates which count patrons as they enter and exit the library. Due to technical issues with the gate counters,Due to technical issues with the gate counters, the following numbers have been removed from the dataset.

• 1/8/2019 Express Library removed a count of 8,392,559

• 3/7/2019 Main Library removed in count 62089 and out count 61916

• 7/3/2019 Dobson Ranch Library removed in count 276404 and out count 163364

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 \"citydata-mesaaz-gov/library-inhouse-visits-dnby-et9x\".\"library_inhouse_visits\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.