Autobiographies provide an opportunity for self reflection, by looking into the lives of other people. This query explores the interest in that topic throughout the years and months.

SELECT
MONTH(cout),
MONTH(cout),
YEAR(cout),
SUM(CASE
WHEN title LIKE '%autobiography' THEN 1
ELSE 0
END) AS autobio

FROM
spl2.inraw
WHERE
DATE(cout) >= '2006-01-01'
AND DATE(cout) <= '2013-12-31'
GROUP BY MONTH(cout) , YEAR(cout)
ORDER BY YEAR(cout) , MONTH(cout)

Every checked out item in the database is being drawn as a particle within its own cell limits. I include the final image and another one to show how the 3D space can be understood once the cell data is shown. Several experiments to arrange the particles were made, as the image below clearly explains.

Final result obtained. Important to notice the 1:1 ratio of particles being shown with the original dataset numbers.

I used Processing.

Control: The data of each cell can be activated or deactivated with ’t’.

Source Code + Data