Steam Store Games (Clean Dataset)
Combined data of 27,000 games scraped from Steam and SteamSpy APIs
@kaggle.nikdavis_steam_store_games
Steam Media Data
@kaggle.nikdavis_steam_store_games.steam_media_data
- 18.78 MB
- 27332 rows
- 5 columns
steam_appidSteam Appid | header_imageHeader Image | screenshotsScreenshots | backgroundBackground | moviesMovies |
|---|---|---|---|---|
| 10 | https://steamcdn-a.akamaihd.net/steam/apps/10/header.jpg?t=1528733245 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/10/0000000132.600x338.jpg?t=1528733245', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/10/0000000132.1920x1080.jpg?t=1528733245'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/10/0000000133… | https://steamcdn-a.akamaihd.net/steam/apps/10/page_bg_generated_v6b.jpg?t=1528733245 | nan |
| 20 | https://steamcdn-a.akamaihd.net/steam/apps/20/header.jpg?t=1528732825 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/20/0000000164.600x338.jpg?t=1528732825', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/20/0000000164.1920x1080.jpg?t=1528732825'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/20/0000000165… | https://steamcdn-a.akamaihd.net/steam/apps/20/page_bg_generated_v6b.jpg?t=1528732825 | nan |
| 30 | https://steamcdn-a.akamaihd.net/steam/apps/30/header.jpg?t=1512413490 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/30/0000000169.600x338.jpg?t=1512413490', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/30/0000000169.1920x1080.jpg?t=1512413490'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/30/0000000170… | https://steamcdn-a.akamaihd.net/steam/apps/30/page_bg_generated_v6b.jpg?t=1512413490 | nan |
| 40 | https://steamcdn-a.akamaihd.net/steam/apps/40/header.jpg?t=1528733362 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/40/0000000142.600x338.jpg?t=1528733362', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/40/0000000142.1920x1080.jpg?t=1528733362'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/40/0000000143… | https://steamcdn-a.akamaihd.net/steam/apps/40/page_bg_generated_v6b.jpg?t=1528733362 | nan |
| 50 | https://steamcdn-a.akamaihd.net/steam/apps/50/header.jpg?t=1542245736 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/50/0000000155.600x338.jpg?t=1542245736', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/50/0000000155.1920x1080.jpg?t=1542245736'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/50/0000000156… | https://steamcdn-a.akamaihd.net/steam/apps/50/page_bg_generated_v6b.jpg?t=1542245736 | nan |
| 60 | https://steamcdn-a.akamaihd.net/steam/apps/60/header.jpg?t=1528733092 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/60/ss_2bf674132e28385f168dbc46ff55eea7be8c8886.600x338.jpg?t=1528733092', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/60/ss_2bf674132e28385f168dbc46ff55eea7be8c8886.1920x1080.jpg?t=1528733092'}, {'id': 1, 'path_thu… | https://steamcdn-a.akamaihd.net/steam/apps/60/page_bg_generated_v6b.jpg?t=1528733092 | nan |
| 70 | https://steamcdn-a.akamaihd.net/steam/apps/70/header.jpg?t=1530045175 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/70/0000002354.600x338.jpg?t=1530045175', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/70/0000002354.1920x1080.jpg?t=1530045175'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/70/0000002343… | https://steamcdn-a.akamaihd.net/steam/apps/70/page_bg_generated_v6b.jpg?t=1530045175 | nan |
| 80 | https://steamcdn-a.akamaihd.net/steam/apps/80/header.jpg?t=1512411962 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/80/0000002528.600x338.jpg?t=1512411962', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/80/0000002528.1920x1080.jpg?t=1512411962'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/80/0000002529… | https://steamcdn-a.akamaihd.net/steam/apps/80/page_bg_generated_v6b.jpg?t=1512411962 | nan |
| 130 | https://steamcdn-a.akamaihd.net/steam/apps/130/header.jpg?t=1542159361 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/130/0000000127.600x338.jpg?t=1542159361', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/130/0000000127.1920x1080.jpg?t=1542159361'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/130/0000000… | https://steamcdn-a.akamaihd.net/steam/apps/130/page_bg_generated_v6b.jpg?t=1542159361 | nan |
| 220 | https://steamcdn-a.akamaihd.net/steam/apps/220/header.jpg?t=1541802014 | [{'id': 0, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/220/0000001864.600x338.jpg?t=1541802014', 'path_full': 'https://steamcdn-a.akamaihd.net/steam/apps/220/0000001864.1920x1080.jpg?t=1541802014'}, {'id': 1, 'path_thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/220/0000001… | https://steamcdn-a.akamaihd.net/steam/apps/220/page_bg_generated_v6b.jpg?t=1541802014 | [{'id': 904, 'name': 'Half-Life 2 Trailer', 'thumbnail': 'https://steamcdn-a.akamaihd.net/steam/apps/904/movie.jpg?t=1507237301', 'webm': {'480': 'http://steamcdn-a.akamaihd.net/steam/apps/904/movie480.webm?t=1507237301', 'max': 'http://steamcdn-a.akamaihd.net/steam/apps/904/movie_max.webm?t=1507237… |
CREATE TABLE steam_media_data (
"steam_appid" BIGINT,
"header_image" VARCHAR,
"screenshots" VARCHAR,
"background" VARCHAR,
"movies" VARCHAR
);