Feminism was named as the word of year for 2017 by the Merriam-Webster dictionary. The online searches for the word, feminism, has exponentially increased by 70% compared to the previous year in 2016. Searches for the term found its largest spike following up to the Women’s March in January.
The most recent anniversary of the Women’s March has inspired me to extract data that includes similar phrases like ‘feminism’ or ‘feminist’ from the Seattle Public Library (SPL) database. I am exploring specific checked-out items that contains these similar phrases in the title. My objective is to explore whether or not the rising popularity of feminism have made a direct impact to the items being checked-out in the Seattle Public Library.
Code: Select all
SELECT
title, bibNumber, COUNT(bibNumber) AS counts,
# 2006
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',
# 2007
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2007-1',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2007-2',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2007-3',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2007-4',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2007-5',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2007-6',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2007-7',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2007-8',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2007-9',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2007-10',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2007-11',
SUM(CASE
WHEN (YEAR(cout) = 2007 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2007-12',
# 2008
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2008-1',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2008-2',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2008-3',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2008-4',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2008-5',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2008-6',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2008-7',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2008-8',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2008-9',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2008-10',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2008-11',
SUM(CASE
WHEN (YEAR(cout) = 2008 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2008-12',
# 2009
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2009-1',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2009-2',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2009-3',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2009-4',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2009-5',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2009-6',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2009-7',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2009-8',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2009-9',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2009-10',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2009-11',
SUM(CASE
WHEN (YEAR(cout) = 2009 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2009-12',
# 2010
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2010-1',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2010-2',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2010-3',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2010-4',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2010-5',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2010-6',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2010-7',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2010-8',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2010-9',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2010-10',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2010-11',
SUM(CASE
WHEN (YEAR(cout) = 2010 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2010-12',
# 2011
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2011-1',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2011-2',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2011-3',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2011-4',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2011-5',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2011-6',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2011-7',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2011-8',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2011-9',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2011-10',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2011-11',
SUM(CASE
WHEN (YEAR(cout) = 2011 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2011-12',
# 2012
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2012-1',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2012-2',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2012-3',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2012-4',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2012-5',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2012-6',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2012-7',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2012-8',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2012-9',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2012-10',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2012-11',
SUM(CASE
WHEN (YEAR(cout) = 2012 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2012-12',
# 2013
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2013-1',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2013-2',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2013-3',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2013-4',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2013-5',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2013-6',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2013-7',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2013-8',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2013-9',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2013-10',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2013-11',
SUM(CASE
WHEN (YEAR(cout) = 2013 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2013-12',
# 2014
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2014-1',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2014-2',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2014-3',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2014-4',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2014-5',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2014-6',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2014-7',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2014-8',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2014-9',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2014-10',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2014-11',
SUM(CASE
WHEN (YEAR(cout) = 2014 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2014-12',
# 2015
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2015-1',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2015-2',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2015-3',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2015-4',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2015-5',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2015-6',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2015-7',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2015-8',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2015-9',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2015-10',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2015-11',
SUM(CASE
WHEN (YEAR(cout) = 2015 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2015-12',
# 2016
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2016-1',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2016-2',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2016-3',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2016-4',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2016-5',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2016-6',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2016-7',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2016-8',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2016-9',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2016-10',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2016-11',
SUM(CASE
WHEN (YEAR(cout) = 2016 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2016-12',
# 2017
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 1) THEN 1
ELSE 0
END) AS '2017-1',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 2) THEN 1
ELSE 0
END) AS '2017-2',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 3) THEN 1
ELSE 0
END) AS '2017-3',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 4) THEN 1
ELSE 0
END) AS '2017-4',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 5) THEN 1
ELSE 0
END) AS '2017-5',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 6) THEN 1
ELSE 0
END) AS '2017-6',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 7) THEN 1
ELSE 0
END) AS '2017-7',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 8) THEN 1
ELSE 0
END) AS '2017-8',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 9) THEN 1
ELSE 0
END) AS '2017-9',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 10) THEN 1
ELSE 0
END) AS '2017-10',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 11) THEN 1
ELSE 0
END) AS '2017-11',
SUM(CASE
WHEN (YEAR(cout) = 2017 and month(cout) = 12) THEN 1
ELSE 0
END) AS '2017-12'
FROM
spl_2016.outraw
WHERE
(bibNumber = '3008726') #1
OR (bibNumber = '3077814') #2
OR (bibNumber = '2290181') #3
OR (bibNumber = '2368106') #4
OR (bibNumber = '3201929') #5
OR (bibNumber = '3255843') #6
OR (bibNumber = '1969986') #7
OR (bibNumber = '2430480') #8
OR (bibNumber = '3122735') #9
OR (bibNumber = '2627029') #10 !!!!
OR (bibNumber = '3167619') #11
OR (bibNumber = '2617983') #12
OR (bibNumber = '2969106') #13
OR (bibNumber = '2332111') #14
OR (bibNumber = '3171454') #15 ****
OR (bibNumber = '2603334') #16
OR (bibNumber = '2539072') #17
OR (bibNumber = '2112099') #18
OR (bibNumber = '2662999') #19
OR (bibNumber = '2940670') #20 !!!!
OR (bibNumber = '2458866') #21
OR (bibNumber = '2086099') #22
OR (bibNumber = '2953130') #25
OR (bibNumber = '3107624') #26
OR (bibNumber = '2369568') #27
OR (bibNumber = '3002627') #28
OR (bibNumber = '2805744') #29
OR (bibNumber = '1775275') #30 !!!!
GROUP BY bibNumber , title
ORDER BY counts DESC
I was inspired by the Tableau format. I mapped out the skeleton of the template by measuring the pixels. Although I ran into trouble with creating the top line graph from my initial template, it is still an element I plan on factoring in.