home / mad_dogs

Fielding Statistics

1 row where player_id = 25

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ player_id season catches_fielding catches_wk stumpings runouts_direct runouts_assist
9 B. Simon 25 2025 7 0 0 0 0

Advanced export

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

CSV options:

CREATE TABLE fielding_stats (
        id                  INTEGER PRIMARY KEY AUTOINCREMENT,
        player_id           INTEGER NOT NULL REFERENCES players(id),
        season              INTEGER NOT NULL,
        catches_fielding    INTEGER DEFAULT 0,
        catches_wk          INTEGER DEFAULT 0,
        stumpings           INTEGER DEFAULT 0,
        runouts_direct      INTEGER DEFAULT 0,
        runouts_assist      INTEGER DEFAULT 0,
        UNIQUE(player_id, season)
    );
CREATE INDEX idx_fielding_player ON fielding_stats(player_id);
Powered by Datasette · Queries took 15.777ms