steam_app

Table actions

Data source: steam-to-sqlite

4 rows where achievements_total = 5 and "release_date" is on date 2025-02-06

✎ View and edit SQL

This data as json, CSV (advanced)

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

pk ▼ appid type is_free name controller_support metacritic_score metacritic_url recommendations achievements_total release_date created updated initial_price current_price
233965 3446750 game 0 To The Top, Mammoth! full       5 2025-02-06 2025-01-14 12:31:25.013939 2025-08-06 03:44:30.615527 499 499
235647 3472010 game 0 The Armed Shadow         5 2025-02-06 2025-01-23 18:30:21.266558 2025-07-30 16:33:21.629317 999 999
235765 3452940 game 0 Prism: Master Tape         5 2025-02-06 2025-01-24 07:24:50.601329 2025-07-31 11:47:16.012584 99 99
237951 3485040 game 0 Kinetic Playtest         5 2025-02-06 2025-02-06 17:26:58.549733 2025-07-29 20:55:34.141407    

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