home / mad_dogs

Bowling Statistics

1 row where player_id = 26

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ player_id season overs maidens runs_conceded wickets average economy balls_per_wkt best_figures
10 Upul S. 26 2025 26.0 0 163 7 23.29 6.27 22.3 2/28

Advanced export

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

CSV options:

CREATE TABLE bowling_stats (
        id              INTEGER PRIMARY KEY AUTOINCREMENT,
        player_id       INTEGER NOT NULL REFERENCES players(id),
        season          INTEGER NOT NULL,
        overs           REAL,
        maidens         INTEGER,
        runs_conceded   INTEGER,
        wickets         INTEGER,
        average         REAL,
        economy         REAL,
        balls_per_wkt   REAL,
        best_figures    TEXT,    -- e.g. "7/32"
        UNIQUE(player_id, season)
    );
CREATE INDEX idx_bowling_player  ON bowling_stats(player_id);
Powered by Datasette · Queries took 20.264ms