steam_app

Table actions

Data source: steam-to-sqlite

6 rows where current_price = 999 and "release_date" is on date 2025-01-01

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: achievements_total, initial_price, release_date (date)

pk ▼ appid type is_free name controller_support metacritic_score metacritic_url recommendations achievements_total release_date created updated initial_price current_price
229406 3343950 game 0 I AM PILL         0 2025-01-01 2024-12-03 19:24:25.600674 2025-07-13 15:38:23.282839 999 999
230543 3396600 game 0 Gun Reflex VR         1 2025-01-01 2024-12-11 16:30:24.109504 2025-07-14 07:48:36.209500 999 999
230690 3399090 game 0 Magical Frontline         0 2025-01-01 2024-12-12 11:25:33.423631 2025-07-15 14:46:06.090572 999 999
231012 3382830 game 0 Zombie Escape         0 2025-01-01 2024-12-13 19:24:03.770814 2025-07-08 20:49:23.806668 19999 999
231015 3390060 game 0 Dino Dash         0 2025-01-01 2024-12-13 19:24:03.795276 2025-07-08 20:49:23.880118 19999 999
231016 3390080 game 0 City Heist         0 2025-01-01 2024-12-13 19:24:08.803914 2025-07-08 20:49:23.953682 19999 999

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "steam_app" (
	pk INTEGER NOT NULL, 
	appid INTEGER NOT NULL, 
	type VARCHAR, 
	is_free BOOLEAN, 
	name VARCHAR NOT NULL, 
	controller_support VARCHAR, 
	metacritic_score INTEGER, 
	metacritic_url VARCHAR, 
	recommendations INTEGER, 
	achievements_total INTEGER NOT NULL, 
	release_date DATE, 
	created DATETIME NOT NULL, 
	updated DATETIME NOT NULL, 
	initial_price INTEGER, 
	current_price INTEGER, 
	PRIMARY KEY (pk)
);
CREATE INDEX ix_steam_app_name ON steam_app (name);
CREATE UNIQUE INDEX ix_steam_app_appid ON steam_app (appid);