MAT 259, 2015
Juan de Jesús
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.
WHEN title LIKE '%autobiography' THEN 1
END) AS autobio
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