Batting Statistics

1 row where player_id = 23

✎ 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
27 A. Athavia 23 2025 9 1 51 6.38 20 147 34.7 0

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);