Autobiography
MAT 259, 2015
Juan de Jesús

Concept
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.

Query

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)


Final Result

General view of the grid. 2008 and 2010 were the years with most interest. 2006 show very small interest, but this can be because of partial data logs.

Query time: 320s.













Code
I used Processing.

Source Code + Data