Batting Statistics

1 row where player_id = 22

✎ 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
28 B.N. Nazari 22 2025 10 1 50 5.56 18 81 61.7 4

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