achievement
Data source: steam-to-sqlite
15 rows where steam_app_pk = 195
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
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) );