Bowling Statistics
1 row where player_id = 3
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
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);