steam_app

Table actions

Data source: steam-to-sqlite

3 rows where "release_date" is on date 2018-02-08 and type = "music"

✎ View and edit SQL

This data as json, CSV (advanced)

pk ▼ appid type is_free name controller_support metacritic_score metacritic_url recommendations achievements_total release_date created updated initial_price current_price
6848 800020 music 0 Kebab it Up! - Official Soundtrack         0 2018-02-08 2021-11-21 14:27:50.552386 2025-06-18 19:42:42.459047 99 74
7115 800740 music 0 Sprint Vector - OST         0 2018-02-08 2021-11-21 14:36:46.487768 2025-06-18 22:07:13.881267 1499 1499
69432 693170 music 0 A Hat in Time - B-Side Soundtrack full     166 0 2018-02-08 2021-11-25 06:17:32.999156 2025-06-15 22:59:43.844650 499 499

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