Fielding Statistics
1 row where player_id = 39
This data as json, CSV (advanced)
| id ▼ | player_id | season | catches_fielding | catches_wk | stumpings | runouts_direct | runouts_assist |
|---|---|---|---|---|---|---|---|
| 17 | N. Thapar 39 | 2025 | 4 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE fielding_stats (
id INTEGER PRIMARY KEY AUTOINCREMENT,
player_id INTEGER NOT NULL REFERENCES players(id),
season INTEGER NOT NULL,
catches_fielding INTEGER DEFAULT 0,
catches_wk INTEGER DEFAULT 0,
stumpings INTEGER DEFAULT 0,
runouts_direct INTEGER DEFAULT 0,
runouts_assist INTEGER DEFAULT 0,
UNIQUE(player_id, season)
);
CREATE INDEX idx_fielding_player ON fielding_stats(player_id);