Quentin's Films and His Oscar Years
MAT 259, 2016
Yan Kong

Concept

Quentin Tarantino is famous for his unique violence aesthetics. And his filmmaking style has won him tons of Academy awards nomination and several Oscars. In 2010, 2013 and 2016, his Inglorious Basterds, Unchained Django and the Hateful Eight are all nominated. It will be interesting to see the correlation between his nomination years and his films' checkouts in SPL in those years.


Query
    
SELECT 
bibNumber,
itemType,
title,
COUNT(bibNumber) AS Counts, 
SUM(CASE
    WHEN (YEAR(cout) = 2006) THEN 1
    ELSE 0
END) AS '2006',
SUM(CASE
    WHEN (YEAR(cout) = 2007) THEN 1
    ELSE 0
END) AS '2007',
SUM(CASE
    WHEN (YEAR(cout) = 2008) THEN 1
    ELSE 0
END) AS '2008',
SUM(CASE
    WHEN (YEAR(cout) = 2009) THEN 1
    ELSE 0
END) AS '2009',
SUM(CASE
    WHEN (YEAR(cout) = 2010) THEN 1
    ELSE 0
END) AS '2010',
SUM(CASE
    WHEN (YEAR(cout) = 2011) THEN 1
    ELSE 0
END) AS '2011',
SUM(CASE
    WHEN (YEAR(cout) = 2012) THEN 1
    ELSE 0
END) AS '2012',
SUM(CASE
    WHEN (YEAR(cout) = 2013) THEN 1
    ELSE 0
END) AS '2013',
SUM(CASE
    WHEN (YEAR(cout) = 2014) THEN 1
    ELSE 0
END) AS '2014',
SUM(CASE
    WHEN (YEAR(cout) = 2015) THEN 1
    ELSE 0
END) AS '2015',
SUM(CASE
    WHEN (YEAR(cout) = 2016) THEN 1
    ELSE 0
END) AS '2016',
SUM(CASE
    WHEN (YEAR(cout) = 2017) THEN 1
    ELSE 0
END) AS '2017'
FROM
spl_2016.outraw
WHERE
title = 'Reservoir dogs'
  or title = 'Pulp fiction'
    OR title = 'Pulp fiction the complete story of Quentin Tarantinos masterpiece'
    OR title = 'Quentin Tarantinos Death proof original soundtrack'
    OR title = 'Kill Bill volume 1'
    OR title = 'Kill Bill Vol 2 original soundtrack'
    OR title = 'Kill Bill Vol 2'
    OR title = 'Kill Bill Vol 1 original soundtrack'
    OR title = 'Kill Bill diary the making of a Tarantino classic as seen through the eyes of a screen legend'
    OR title = 'Jackie Brown a screenplay'
    OR title = 'Jackie Brown a Quentin Tarantino film music from the Miramar motion picture'
    OR title = 'Jackie Brown'
    OR title = 'Inglourious Basterds'
    OR title = 'hateful eight'
    OR title = 'Django unchained original motion picture soundtrack'
    OR title LIKE '%Django Unchained%'
    OR title = 'Death proof'
    OR title = 'Death proof original soundtrack'
GROUP BY bibNumber , itemtype, title
ORDER BY Counts DESC

Preliminary sketches

My visualization strategy is inspired by the radar system. On a radar panel, a circular area is divided equally into squential sectors. The target will show up on the panel when it is being scanned and then fade out. Also, when the target is closer to the center, it is closer to the radar.

Similarly, in my visualization, years are represented as sequential sectors in a circle. As a pointer scans through these areas, the corresponding yearly checkouts, which is represented by points, will show up and gradually fade out when the pointer leaves. The quantity of checkouts is shown by the size of each point.




Process

Quentin has 9 movies, so I assign every one of them a unique color and put it in a fixed orbit just like the solar system. Every film circles around the center, like 8 stars circles around the sun.






Final result

This radar scanning system demonstrates the popularity of Quentin Tatantino's movies and correlations between checkouts each year and Quentin's Oscar winning moments. It's easy to distinguish that in 2010, 2013 and 2016, there are big dots and cluster lying in its area, which show drastic increases for its yearly checkouts. And checkouts for his old movies also increases a little bit in his Oscar years.
According to our instructor's idea, I add UI to allow users to see the static overview of this visualization.
Press key '1': show the overview without data points fading out and scanning effect.
Press key '2': show the scanning system.






Code
All work is developed within Processing
Source Code + Data