library-entrances-2006-2020.csv (93.69 kB)

Entrances to the University of Sussex Library 2006-2020

Download (93.69 kB)
posted on 10.02.2021, 09:32 by Tim Graves
This dataset contains the daily entrance totals to the University of Sussex Library between 2006 and 2020.

The file is a two column *csv file containing date:total.

Every time a visitor walks through the turnstiles at the main entrance, this is logged to an entry management system. The system had been gathering data for several years before 2006, but all previous data was lost in a major software upgrade towards the end of that year.

The data shows a huge drop between December 2009 and February 2010. This was a period of building refurbishment, during which visitors were routed through a temporary, unmonitored, entrance.

The SQL query used to extract this data was:

select DATE_FORMAT(TIMESTAMP, "%d/%m/%Y") AS theday,COUNT(SerialNo) AS entrances

FROM transactions

WHERE TIMESTAMP >= '2006-10-06'

and timestamp < '2021-01-01'

AND ZoneNo=1

AND Direction='I'

AND Address IN (1,2)

GROUP BY theday

ORDER BY timestamp




The Library