home / database

Menu
  • GraphQL API

achievement

Table actions
  • GraphQL API for achievement

Data source: steam-to-sqlite

15 rows where steam_app_pk = 195

✎ View and edit SQL

This data as json, CSV (advanced)

pk ▼ name percent steam_app_pk
3790 PORTAL_GET_PORTALGUNS 81.1 Portal 195
3791 PORTAL_KILL_COMPANIONCUBE 63.3 Portal 195
3792 PORTAL_ESCAPE_TESTCHAMBERS 55.5 Portal 195
3793 PORTAL_BEAT_GAME 52.1 Portal 195
3794 PORTAL_HIT_TURRET_WITH_TURRET 48.6 Portal 195
3795 PORTAL_BEAT_2ADVANCEDMAPS 18.2 Portal 195
3796 PORTAL_LONGJUMP 14.0 Portal 195
3797 PORTAL_BEAT_4ADVANCEDMAPS 11.9 Portal 195
3798 PORTAL_BEAT_6ADVANCEDMAPS 9.1 Portal 195
3799 PORTAL_INFINITEFALL 8.9 Portal 195
3800 PORTAL_TRANSMISSION_RECEIVED 4.2 Portal 195
3801 PORTAL_DETACH_ALL_CAMERAS 3.9 Portal 195
3802 PORTAL_GET_ALLGOLD 2.6 Portal 195
3803 PORTAL_GET_ALLSILVER 2.7 Portal 195
3804 PORTAL_GET_ALLBRONZE 2.7 Portal 195

Advanced export

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

CSV options:

CREATE TABLE "achievement" (
	pk INTEGER NOT NULL, 
	name VARCHAR NOT NULL, 
	percent FLOAT NOT NULL, 
	steam_app_pk INTEGER, 
	PRIMARY KEY (pk), 
	FOREIGN KEY(steam_app_pk) REFERENCES steam_app (pk)
);
Powered by Datasette · Queries took 1589.357ms · Data source: steam-to-sqlite