Library People Counts

The number of people that physically visit the library, across all 20 locations. There are multiple counters at locations with multiple entry points.

People counter devices use a reflective beam to count each entry and exit. The number reported is the total result divided by two to account for entrances and exists.

The Days Open indicates the number of days of the week that the count is for, ending on the Week End Date.

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 \"winnipeg-ca/library-people-counts-g3zt-s3kr\".\"library_people_counts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.