2D Visualization | Top Grunge
MAT 259, 2018
Adam Jahnke
Concept
Since Seattle has a strong historical conection to grunge music and the band Nirvana; I wanted to see the check out preformance and ativity of grunge bands related to Nirvana. This data set focuses on the year 2006 and includes bands such as, Nirvana, The Foo Fighters, Sunny Day Real Estate and Hole.
Query
mySQL query :
SELECT
bibNumber, title,
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 1) THEN 1
ELSE 0
END) AS '2006-1',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 2) THEN 1
ELSE 0
END) AS '2006-2',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 3) THEN 1
ELSE 0
END) AS '2006-3',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 4) THEN 1
ELSE 0
END) AS '2006-4',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 5) THEN 1
ELSE 0
END) AS '2006-5',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 6) THEN 1
ELSE 0
END) AS '2006-6',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 7) THEN 1
ELSE 0
END) AS '2006-7',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 8) THEN 1
ELSE 0
END) AS '2006-8',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 9) THEN 1
ELSE 0
END) AS '2006-9',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 10) THEN 1
ELSE 0
END) AS '2006-10',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 11) THEN 1
ELSE 0
END) AS '2006-11',
SUM(CASE
WHEN (YEAR(cout) = 2006 AND MONTH(cout) = 12) THEN 1
ELSE 0
END) AS '2006-12'
FROM
spl_2016.inraw
WHERE
bibNumber = '1254271'
OR bibNumber = '1318184'
OR bibNumber = '596977'
OR bibNumber = '1633444'
OR bibNumber = '2040694'
OR bibNumber = '1845161'
OR bibNumber = '1849805'
OR bibNUmber = '1847206'
OR bibNUmber = '1839774'
AND (itemType LIKE '%CD%')
GROUP BY bibNumber , title, itemType
Preliminary sketches
This project relied on Rodger Luo's example code for this assignment.
Process
Work-in-progress. The inital mapping of the data in grey scale.
Final result
Final image. what is beeing seen is the preformace of grunge albums over the period of 12 months in 2006.
Code