Name: Steam Store Games (Clean Dataset)
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Steam Store Games (Clean Dataset)

I wanted to create a dataset from scratch based around games on the Steam Store. Using data gathered from the Steam Store and SteamSpy APIs, this dataset provides information about various aspects of games on the store, such as its genre and the estimated number of owners.

Gathered around May 2019, it contains most games on the store released prior to that date. Unreleased titles were removed as well as many non-games like software, though some may have slipped through.

Feel free to use this data however you wish. I created it to be used as part of my data science learning journey, tracking progress on my blog.

Most of all, I hope you enjoy exploring this data. It's my first big data science project, and I wanted to make it about something fun and interesting. Feedback and suggestions are more than welcome.

Tables

Steam

@kaggle.nikdavis_steam_store_games.steam

1.67 MB
27075 rows
18 columns


CREATE TABLE steam (
  "appid" BIGINT,
  "name" VARCHAR,
  "release_date" TIMESTAMP,
  "english" BIGINT,
  "developer" VARCHAR,
  "publisher" VARCHAR,
  "platforms" VARCHAR,
  "required_age" BIGINT,
  "categories" VARCHAR,
  "genres" VARCHAR,
  "steamspy_tags" VARCHAR,
  "achievements" BIGINT,
  "positive_ratings" BIGINT,
  "negative_ratings" BIGINT,
  "average_playtime" BIGINT,
  "median_playtime" BIGINT,
  "owners" VARCHAR,
  "price" DOUBLE
);

Steam Description Data

@kaggle.nikdavis_steam_store_games.steam_description_data

52.2 MB
27334 rows
4 columns


CREATE TABLE steam_description_data (
  "steam_appid" BIGINT,
  "detailed_description" VARCHAR,
  "about_the_game" VARCHAR,
  "short_description" VARCHAR
);

Steam Media Data

@kaggle.nikdavis_steam_store_games.steam_media_data

18.78 MB
27332 rows
5 columns


CREATE TABLE steam_media_data (
  "steam_appid" BIGINT,
  "header_image" VARCHAR,
  "screenshots" VARCHAR,
  "background" VARCHAR,
  "movies" VARCHAR
);

Steam Requirements Data

@kaggle.nikdavis_steam_store_games.steam_requirements_data

7.37 MB
27319 rows
6 columns


CREATE TABLE steam_requirements_data (
  "steam_appid" BIGINT,
  "pc_requirements" VARCHAR,
  "mac_requirements" VARCHAR,
  "linux_requirements" VARCHAR,
  "minimum" VARCHAR,
  "recommended" VARCHAR
);

Steamspy Tag Data

@kaggle.nikdavis_steam_store_games.steamspy_tag_data

1.23 MB
29022 rows
372 columns


CREATE TABLE steamspy_tag_data (
  "appid" BIGINT,
  "n_1980s" BIGINT,
  "n_1990s" BIGINT,
  "n_2_5d" BIGINT,
  "n_2d" BIGINT,
  "n_2d_fighter" BIGINT,
  "n_360_video" BIGINT,
  "n_3d" BIGINT,
  "n_3d_platformer" BIGINT,
  "n_3d_vision" BIGINT,
  "n_4_player_local" BIGINT,
  "n_4x" BIGINT,
  "n_6dof" BIGINT,
  "atv" BIGINT,
  "abstract" BIGINT,
  "action" BIGINT,
  "action_rpg" BIGINT,
  "action_adventure" BIGINT,
  "addictive" BIGINT,
  "adventure" BIGINT,
  "agriculture" BIGINT,
  "aliens" BIGINT,
  "alternate_history" BIGINT,
  "america" BIGINT,
  "animation_modeling" BIGINT,
  "anime" BIGINT,
  "arcade" BIGINT,
  "arena_shooter" BIGINT,
  "artificial_intelligence" BIGINT,
  "assassin" BIGINT,
  "asynchronous_multiplayer" BIGINT,
  "atmospheric" BIGINT,
  "audio_production" BIGINT,
  "bmx" BIGINT,
  "base_building" BIGINT,
  "baseball" BIGINT,
  "based_on_a_novel" BIGINT,
  "basketball" BIGINT,
  "batman" BIGINT,
  "battle_royale" BIGINT,
  "beat_em_up" BIGINT,
  "beautiful" BIGINT,
  "benchmark" BIGINT,
  "bikes" BIGINT,
  "blood" BIGINT,
  "board_game" BIGINT,
  "bowling" BIGINT,
  "building" BIGINT,
  "bullet_hell" BIGINT,
  "bullet_time" BIGINT,
  "crpg" BIGINT,
  "capitalism" BIGINT,
  "card_game" BIGINT,
  "cartoon" BIGINT,
  "cartoony" BIGINT,
  "casual" BIGINT,
  "cats" BIGINT,
  "character_action_game" BIGINT,
  "character_customization" BIGINT,
  "chess" BIGINT,
  "choices_matter" BIGINT,
  "choose_your_own_adventure" BIGINT,
  "cinematic" BIGINT,
  "city_builder" BIGINT,
  "class_based" BIGINT,
  "classic" BIGINT,
  "clicker" BIGINT,
  "co_op" BIGINT,
  "co_op_campaign" BIGINT,
  "cold_war" BIGINT,
  "colorful" BIGINT,
  "comedy" BIGINT,
  "comic_book" BIGINT,
  "competitive" BIGINT,
  "conspiracy" BIGINT,
  "controller" BIGINT,
  "conversation" BIGINT,
  "crafting" BIGINT,
  "crime" BIGINT,
  "crowdfunded" BIGINT,
  "cult_classic" BIGINT,
  "cute" BIGINT,
  "cyberpunk" BIGINT,
  "cycling" BIGINT,
  "dark" BIGINT,
  "dark_comedy" BIGINT,
  "dark_fantasy" BIGINT,
  "dark_humor" BIGINT,
  "dating_sim" BIGINT,
  "demons" BIGINT,
  "design_illustration" BIGINT,
  "destruction" BIGINT,
  "detective" BIGINT,
  "difficult" BIGINT,
  "dinosaurs" BIGINT,
  "diplomacy" BIGINT,
  "documentary" BIGINT,
  "dog" BIGINT,
  "dragons" BIGINT,
  "drama" BIGINT
);

Steam Support Info

@kaggle.nikdavis_steam_store_games.steam_support_info

1007.05 KB
27136 rows
4 columns


CREATE TABLE steam_support_info (
  "steam_appid" BIGINT,
  "website" VARCHAR,
  "support_url" VARCHAR,
  "support_email" VARCHAR
);