home / mad_dogs

Bowling Statistics

1 row where player_id = 7

✎ 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
8 S. Aqai 7 2025 68.3 1 450 22 20.45 6.57 18.7 7/32

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 19.036ms