home / mad_dogs

Team Batting & Bowling Totals

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ season runs_scored wickets_lost overs_batted batting_avg batting_rpo batting_bpw runs_conceded wickets_taken overs_bowled bowling_avg bowling_rpo bowling_bpw
1 2025 5285 376 1140.0 14.05 4.64 18.2 6583 290 1038.3 22.7 6.34 21.5

Advanced export

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

CSV options:

CREATE TABLE team_totals (
        id              INTEGER PRIMARY KEY AUTOINCREMENT,
        season          INTEGER NOT NULL UNIQUE,
        runs_scored     INTEGER,
        wickets_lost    INTEGER,
        overs_batted    REAL,
        batting_avg     REAL,   -- R/W
        batting_rpo     REAL,   -- R/O
        batting_bpw     REAL,   -- B/W
        runs_conceded   INTEGER,
        wickets_taken   INTEGER,
        overs_bowled    REAL,
        bowling_avg     REAL,
        bowling_rpo     REAL,
        bowling_bpw     REAL
    );
Powered by Datasette · Queries took 38.34ms