steam_app

Data source: steam-to-sqlite

267,384 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: release_date (date), created (date), updated (date)

Next page

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