This project aims to explore the popularity of Chinese-related media in the Seattle Public Library by analyzing checkout numbers for various item types, such as books, CDs, and music, from 2006 to 2022. Using SQL to query data, this study provides a detailed examination of trends and category percentages over time, as well as an analysis of the Dewey Decimal System classification of Chinese culture. Through data visualization, this project aims to gain a comprehensive understanding of the representation and popularity of Chinese-related media in the Seattle Public Library, which can provide valuable insights for cultural studies, library management, and Seattle Public Library users. The project will compare Dewey Classification Checkout Numbers for Chinese-related books in 2006 and 2022, which can give an idea about how Chinese culture is represented and how it has evolved in the Seattle Public Library.

YEAR(cout) AS years, select count(IF(deweyClass > 000 and deweyClass < 100, 1, NULL)) AS 'Computer science, information and general works', count(IF(deweyClass = 0000, 1, NULL)) AS 'Not in Dewey Class', count(IF(deweyClass >= 200 and deweyClass < 300, 1, NULL)) AS 'Religion', count(IF(deweyClass >= 100 and deweyClass < 200, 1, NULL)) AS 'Philosophy and psychology', count(IF(deweyClass >= 300 and deweyClass < 400, 1, NULL)) AS 'Social sciences', count(IF(deweyClass >= 400 and deweyClass < 500, 1, NULL)) AS 'Language', count(IF(deweyClass >= 600 and deweyClass < 700, 1, NULL)) AS 'Associations, organizations and museums', count(IF(deweyClass >= 500 and deweyClass < 600, 1, NULL)) AS 'Technology', count(IF(deweyClass >= 800 and deweyClass < 900, 1, NULL)) AS 'Literature', count(IF(deweyClass >= 900 and deweyClass < 1000, 1, NULL)) AS 'History and geography' count(IF(deweyClass >= 700 and deweyClass < 800, 1, NULL)) AS 'Arts and recreation', (SELECT distinct id,barcode,itemNumber,itemtype, title, cout, deweyClass from inner JOIN spl_2016.subject ON outraw.bibNumber = subject.bibNumber FROM spl_2016.outraw where YEAR(cout) in (2006,2022) where subject.subject like '%chinese' or subject.subject like '%china%') as A GROUP BY YEAR(cout);

Please put your work-in-progress images or screen shots here with some explanations.

Please put your final images or screen shots here with some explanations.

All work is developed within Processing
Source Code + Data