Information School, University of Washington

Game Graph: A Video Game Metadata Graph Database

INFX 595/596: Capstone

Game Graph is a video game metadata graph database and web application that provides an easy and extensible way to create, store, and retrieve metadata about video games. Building upon the work done at the Seattle Interactive Media Museum (SIMM) and the Game Metadata Research (GAMER) Group, this application envisions every possible point of information within a property graph database framework. By utilizing the graph database model, users are able to easily explore the relationships of video games.
The goal of this project is to provide a useful tool for cataloging video game metadata, while assisting research into video games as information objects. As a component to a larger system, Game Graph provides the structural foundation for digitally cataloging video game collections.

Video Game Reviews Text Analysis

INFX 598: Data Science III: Scaling, Applications, and Ethics

Fei Guo, Victor Li, Jonathan Lin, Xinyu Zheng

Video game have reached a saturation point where there are devoted media sites to reviewing video games as well as news around the gaming industry. However, there has not been research done on game reviews the same way that other entertainment industries like movies and music have. We seek to find textual patterns and characteristics in video game reviews by scraping established video game sites and conducting latent dirichlet allocation, jargon distance, and sentiment analysis to identify common writer characteristics and habits. We found that most writers typically score games between 60 to 70 out of 100 and use similar phrases to describe those games in their reviews. Further, we found through sentiment analysis that most writers use positively associated words, even for games that score poorly. We suggest more detailed analysis for games in certain genres to see if these results are consistent within a subpopulation of the reviews and propose suggestions for future work which include a write recommendation system.


Choropleth map

INFX 598: Advanced Data Visualization

Choropleth map in d3.js that shows AKB48 group members by home prefecture.


Interactive Map of Video Game Makers

INFX 598: Advanced Data Visualization

Using leaflet.js, created an interactive map of video game companies in Washington State


Exploring and Predicting Frequently Reviewed Businesses for Yelp’s Dataset Challenge

INFX 573: Introduction to Data Science, Autumn 2014

John Fuller, Lauren Hubener, Jonathan Lin, Amy Trost

A project using Yelp Academic Data to explore ways to predict which businesses will receive more than 100 user reviews.

Github Link:

UW/SIMM Video Game Metadata Schema: Controlled Vocabulary for DRM. Version 1.0

INFX 598: Metadata for Interactive Media, Autumn 2014

Jin Ha Lee, Andrew Perti, Stephen Keating, Jonathan Long Lin (2014)


SQL database schema for the Seattle Japanese Language School

INFX 543: Relational Database Management Systems, Spring 2014

Jonathan Lin, Justin Melde, Heather Walker, Heather Welch

ERD link:

Instructional video on basics of wotagei, a geeky Japanese dance.

LIS 560: Instructional and Training Strategies for Information Professionals, Spring 2014

Video Link:

A responsive redesign of University of Washington Health Sciences Library’s nurse toolkit webpage

LIS 510: Information Behavior, Winter 2014


Aidoru Base, an XML powered database of Japanese idol groups

INFX 542: Information Structures Using XML, Winter 2014


Patron Driven Acquisition in Academic Libraries

LIS 570: Research, Assessment, and Design, Autumn 2013

Azusa Higashigawa, Jonathan Lin

Video Link:

Waseda University, Graduate School of Asia and Pacific Studies

A Study of Transnational Idol Otaku: Playful expressions of Japanese creative culture

Masters Thesis Academic Year 2008