home / mad_dogs

Bowling Statistics

1 row where player_id = 13

✎ 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
5 J. Simon 13 2025 24.0 0 186 11 16.91 7.75 13.1 3/20

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.823ms