Dataset: 93182 Steam Games

About this Dataset

93182 Steam Games

Updated:

The file 93182_steam_games.csv was scraped from Steam and SteamSpy as of 15th of September, 2024.

#	Column	Non-Null Count	Dtype
0	AppID	93182	int64
1	Name	93179	object
2	Release date	93182	object
3	Estimated owners	16462	object
4	Peak CCU	93182	int64
5	Required age	93182	int64
6	Price	93182	float64
7	DLC count	93182	int64
8	About the game	88392	object
9	Supported languages	93182	object
10	Full audio languages	93182	object
11	Reviews	10599	object
12	Header image	93182	object
13	Website	41654	object
14	Support url	44228	object
15	Support email	77348	object
16	Windows	93182	bool
17	Mac	93182	bool
18	Linux	93182	bool
19	Metacritic score	93182	int64
20	Metacritic url	4023	object
21	User score	93182	int64
22	Positive	93182	int64
23	Negative	93182	int64
24	Score rank	7	float64
25	Achievements	93182	int64
26	Recommendations	93182	int64
27	Notes	15339	object
28	Average playtime forever	93182	int64
29	Average playtime two weeks	93182	int64
30	Median playtime forever	93182	int64
31	Median playtime two weeks	93182	int64
32	Developers	88349	object
33	Publishers	87880	object
34	Categories	87887	object
35	Genres	88381	object
36	Tags	12918	object
37	Screenshots	90369	object
38	Movies	85535	object

May need some data cleaning. I endeavor to update annually.

Old version:

Raw data of 1000 games from Steam and SteamSpy APIs. Retreived 27th July 2023.

Includes Name, Required Age, Free or not, Description, etc.

Needs some data cleaning.

Tables

N 93182 Steam Games

@kaggle.joebeachcapital_top_1000_steam_games.n_93182_steam_games

126.24 MB
93182 rows
39 columns


CREATE TABLE n_93182_steam_games (
  "appid" BIGINT,
  "name" VARCHAR,
  "release_date" VARCHAR,
  "estimated_owners" VARCHAR,
  "peak_ccu" BIGINT,
  "required_age" BIGINT,
  "price" DOUBLE,
  "dlc_count" BIGINT,
  "about_the_game" VARCHAR,
  "supported_languages" VARCHAR,
  "full_audio_languages" VARCHAR,
  "reviews" VARCHAR,
  "header_image" VARCHAR,
  "website" VARCHAR,
  "support_url" VARCHAR,
  "support_email" VARCHAR,
  "windows" BOOLEAN,
  "mac" BOOLEAN,
  "linux" BOOLEAN,
  "metacritic_score" BIGINT,
  "metacritic_url" VARCHAR,
  "user_score" BIGINT,
  "positive" BIGINT,
  "negative" BIGINT,
  "score_rank" DOUBLE,
  "achievements" BIGINT,
  "recommendations" BIGINT,
  "notes" VARCHAR,
  "average_playtime_forever" BIGINT,
  "average_playtime_two_weeks" BIGINT,
  "median_playtime_forever" BIGINT,
  "median_playtime_two_weeks" BIGINT,
  "developers" VARCHAR,
  "publishers" VARCHAR,
  "categories" VARCHAR,
  "genres" VARCHAR,
  "tags" VARCHAR,
  "screenshots" VARCHAR,
  "movies" VARCHAR
);

Steamspy Data

@kaggle.joebeachcapital_top_1000_steam_games.steamspy_data

233.99 KB
1000 rows
20 columns


CREATE TABLE steamspy_data (
  "appid" BIGINT,
  "name" VARCHAR,
  "developer" VARCHAR,
  "publisher" VARCHAR,
  "score_rank" VARCHAR,
  "positive" BIGINT,
  "negative" BIGINT,
  "userscore" BIGINT,
  "owners" VARCHAR,
  "average_forever" BIGINT,
  "average_2weeks" BIGINT,
  "median_forever" BIGINT,
  "median_2weeks" BIGINT,
  "price" BIGINT,
  "initialprice" BIGINT,
  "discount" BIGINT,
  "languages" VARCHAR,
  "genre" VARCHAR,
  "ccu" BIGINT,
  "tags" VARCHAR
);

Steam App Data

@kaggle.joebeachcapital_top_1000_steam_games.steam_app_data

5.11 MB
1000 rows
39 columns


CREATE TABLE steam_app_data (
  "type" VARCHAR,
  "name" VARCHAR,
  "steam_appid" BIGINT,
  "required_age" DOUBLE,
  "is_free" VARCHAR,
  "controller_support" VARCHAR,
  "dlc" VARCHAR,
  "detailed_description" VARCHAR,
  "about_the_game" VARCHAR,
  "short_description" VARCHAR,
  "fullgame" VARCHAR,
  "supported_languages" VARCHAR,
  "header_image" VARCHAR,
  "website" VARCHAR,
  "pc_requirements" VARCHAR,
  "mac_requirements" VARCHAR,
  "linux_requirements" VARCHAR,
  "legal_notice" VARCHAR,
  "drm_notice" VARCHAR,
  "ext_user_account_notice" VARCHAR,
  "developers" VARCHAR,
  "publishers" VARCHAR,
  "demos" VARCHAR,
  "price_overview" VARCHAR,
  "packages" VARCHAR,
  "package_groups" VARCHAR,
  "platforms" VARCHAR,
  "metacritic" VARCHAR,
  "reviews" VARCHAR,
  "categories" VARCHAR,
  "genres" VARCHAR,
  "screenshots" VARCHAR,
  "movies" VARCHAR,
  "recommendations" VARCHAR,
  "achievements" VARCHAR,
  "release_date" VARCHAR,
  "support_info" VARCHAR,
  "background" VARCHAR,
  "content_descriptors" VARCHAR
);