Steam Store Games (Clean Dataset)

Combined data of 27,000 games scraped from Steam and SteamSpy APIs

@kaggle.nikdavis_steam_store_games

Table List

6 tables(82.24 MB)

Steam

Steamspy Tag Data

Steam Description Data

Steam Media Data

Steam Requirements Data

Steam Support Info

Steam

@kaggle.nikdavis_steam_store_games.steam

1.67 MB
27075 rows
18 columns

appid Appid	name Name	release_date Release Date	english English	developer Developer	publisher Publisher	platforms Platforms	categories Categories	genres Genres	steamspy_tags Steamspy Tags	achievements Achievements	positive_ratings Positive Ratings	negative_ratings Negative Ratings	average_playtime Average Playtime	median_playtime Median Playtime	owners Owners	price Price
10	Counter-Strike	Wed Nov 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Valve	Valve	windows;mac;linux	Multi-player;Online Multi-Player;Local Multi-Player;Valve Anti-Cheat enabled	Action	Action;FPS;Multiplayer		124534	3339	17612	317	10000000-20000000	7.19
20	Team Fortress Classic	Thu Apr 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Valve	Valve	windows;mac;linux	Multi-player;Online Multi-Player;Local Multi-Player;Valve Anti-Cheat enabled	Action	Action;FPS;Multiplayer		3318	633	277	62	5000000-10000000	3.99
30	Day of Defeat	Thu May 01 2003 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Valve	Valve	windows;mac;linux	Multi-player;Valve Anti-Cheat enabled	Action	FPS;World War II;Multiplayer		3416	398	187	34	5000000-10000000	3.99
40	Deathmatch Classic	Fri Jun 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Valve	Valve	windows;mac;linux	Multi-player;Online Multi-Player;Local Multi-Player;Valve Anti-Cheat enabled	Action	Action;FPS;Multiplayer		1273	267	258	184	5000000-10000000	3.99
50	Half-Life: Opposing Force	Mon Nov 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Gearbox Software	Valve	windows;mac;linux	Single-player;Multi-player;Valve Anti-Cheat enabled	Action	FPS;Action;Sci-fi		5250	288	624	415	5000000-10000000	3.99
60	Ricochet	Wed Nov 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Valve	Valve	windows;mac;linux	Multi-player;Online Multi-Player;Valve Anti-Cheat enabled	Action	Action;FPS;Multiplayer		2758	684	175	10	5000000-10000000	3.99
70	Half-Life	Sun Nov 08 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Valve	Valve	windows;mac;linux	Single-player;Multi-player;Online Multi-Player;Steam Cloud;Valve Anti-Cheat enabled	Action	FPS;Classic;Action		27755	1100	1300	83	5000000-10000000	7.19
80	Counter-Strike: Condition Zero	Mon Mar 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Valve	Valve	windows;mac;linux	Single-player;Multi-player;Valve Anti-Cheat enabled	Action	Action;FPS;Multiplayer		12120	1439	427	43	10000000-20000000	7.19
130	Half-Life: Blue Shift	Fri Jun 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Gearbox Software	Valve	windows;mac;linux	Single-player	Action	FPS;Action;Sci-fi		3822	420	361	205	5000000-10000000	3.99
220	Half-Life 2	Tue Nov 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	1	Valve	Valve	windows;mac;linux	Single-player;Steam Achievements;Steam Trading Cards;Captions available;Partial Controller Support;Steam Cloud;Includes Source SDK	Action	FPS;Action;Sci-fi	33	67902	2419	691	402	10000000-20000000	7.19


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
);