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.75 MB
27,075 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

54.74 MB
27,334 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

19.69 MB
27,332 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.73 MB
27,319 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.29 MB
29,022 rows
372 columns

CREATE TABLE steamspy_tag_data (
  "appid" BIGINT,
  "n_1980s" BIGINT  -- 1980s,
  "n_1990s" BIGINT  -- 1990s,
  "n_2_5d" BIGINT  -- 2.5d,
  "n_2d" BIGINT  -- 2d,
  "n_2d_fighter" BIGINT  -- 2d Fighter,
  "n_360_video" BIGINT  -- 360 Video,
  "n_3d" BIGINT  -- 3d,
  "n_3d_platformer" BIGINT  -- 3d Platformer,
  "n_3d_vision" BIGINT  -- 3d Vision,
  "n_4_player_local" BIGINT  -- 4 Player Local,
  "n_4x" BIGINT  -- 4x,
  "n_6dof" BIGINT  -- 6dof,
  "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  -- Animation \u0026 Modeling,
  "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  -- Design \u0026 Illustration,
  "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

1.03 MB
27,136 rows
4 columns

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