home / mad_dogs

Bowling Statistics

1 row where player_id = 39

✎ 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
2 N. Thapar 39 2025 21.0 5 66 6 11.0 3.14 21.0 4/19

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