The Checkout Numbers of the Ten Books at SPL from 2006-2014
MAT 259, 2016
Han-Wei Kung

Concept
I visualized the checkout numbers of the ten books (Republic, Leviathan, The Prince, The Clash of Civilizations, The Elements of Style, Ethics, The Structure of Scientific Revolutions, Democracy in America, The Communist Manifesto, The Politics) at the Seattle Public Library from January 2006 to December 2014 (52*9=468 weeks.) I chose these ten books because the students at Princeton University are required to read them, according to this article.

Query
SELECT
title,
year(checkouts.checkOut),
WeekOfYear(checkouts.checkOut),
checkouts.callNumber
FROM spl3._rawXmlDataCheckOuts AS checkouts
WHERE checkouts.title LIKE "Republic"
AND (checkouts.callNumber LIKE "%PLATO%" OR checkouts.callNumber LIKE "%321%")
AND ((checkouts.checkOut BETWEEN "2006-01-01" AND "2014-12-31") AND (checkouts.itemType LIKE "%bk%"))
ORDER BY year(checkouts.checkOut), WeekOfYear(checkouts.checkOut)

Process
I wrote Python scripts to pre-visualize the results.






Final result







Code
All work was developed within Python. I continued developing the program using Processing in my Project 3.
Source Code + Data