Appearances

1 row where player_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ player_id season games
6 M. Jadhav 6 2025 20

Advanced export

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

CSV options: 

CREATE TABLE appearances (
        id          INTEGER PRIMARY KEY AUTOINCREMENT,
        player_id   INTEGER NOT NULL REFERENCES players(id),
        season      INTEGER NOT NULL,
        games       INTEGER NOT NULL,
        UNIQUE(player_id, season)
    );
CREATE INDEX idx_appearances     ON appearances(player_id);