I was mainly interested at looking at the SPL database and library as a physcial entity, and cataloging the absence from the database as a whole.

I used the same Query as before
To gather a larger set of data, I did two separate queries for each hundres sections of the dewey class.

First Query SELECT
title,
cout,
cin,
deweyClass,
(TIMESTAMPDIFF(YEAR, cout, cin))
FROM
spl2.inraw
WHERE
(itemtype = 'acbk'
AND (deweyClass > 700 AND deweyClass < 800)
AND (TIMESTAMPDIFF(YEAR, cout, cin) > 1)
AND (YEAR(cout) > 2005 AND YEAR(cout) < 2014))


Second Query

SELECT
title,
cout,
cin,
deweyClass,
(TIMESTAMPDIFF(YEAR, cout, cin))
FROM
spl2.inraw
WHERE
(itemtype = 'acbk'
AND (deweyClass > 800 AND deweyClass < 900)
AND (TIMESTAMPDIFF(YEAR, cout, cin) > 1)
AND (YEAR(cout) > 2005 AND YEAR(cout) < 2014))

I did two simple reorders of my same query, one by column weight and one by row weight. The most interesting reordering was by columns, which created an interesting revisualization that showed most books were checked out for a period of 60-70 months, then decrease. I found it odd that I capped around that number.

I used Processing.

Source Code + Data