Batting Statistics

1 row where player_id = 20

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ player_id season innings not_outs runs average highest balls_faced strike_rate ducks
23 J. Corbett 20 2025 10 3 55 7.86 33* 59 81.4 3

Advanced export

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

CSV options: 

CREATE TABLE batting_stats (
        id              INTEGER PRIMARY KEY AUTOINCREMENT,
        player_id       INTEGER NOT NULL REFERENCES players(id),
        season          INTEGER NOT NULL,
        innings         INTEGER,
        not_outs        INTEGER,
        runs            INTEGER,
        average         REAL,
        highest         TEXT,    -- e.g. "81*"
        balls_faced     INTEGER,
        strike_rate     REAL,    -- R/100b
        ducks           INTEGER DEFAULT 0,
        UNIQUE(player_id, season)
    );
CREATE INDEX idx_batting_player  ON batting_stats(player_id);
CREATE INDEX idx_batting_season  ON batting_stats(season);