Bowling Statistics
1 row where player_id = 1
This data as json, CSV (advanced)
| id ▼ | player_id | season | overs | maidens | runs_conceded | wickets | average | economy | balls_per_wkt | best_figures |
|---|---|---|---|---|---|---|---|---|---|---|
| 13 | J. Moore 1 | 2025 | 98.1 | 1 | 521 | 17 | 30.65 | 5.31 | 34.6 | 2/20 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);