home / mad_dogs

Bowling Statistics

1 row where player_id = 3

✎ 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
17 K. Venigalla 3 2025 31.2 0 215 4 53.75 6.86 47.0 1/7

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