mad_dogs

Season and career statistics for all players

Tables

appearances

id, player_id, season, games

49 rows

batting_stats

id, player_id, season, innings, not_outs, runs, average, highest, balls_faced, strike_rate, ducks

35 rows

bowling_stats

id, player_id, season, overs, maidens, runs_conceded, wickets, average, economy, balls_per_wkt, best_figures

18 rows

bunny_coefficient

id, player_id, season, cvr, wickets, bc

12 rows

career_milestones

id, player_id, season, milestone

27 rows

fielding_stats

id, player_id, season, catches_fielding, catches_wk, stumpings, runouts_direct, runouts_assist

32 rows

matches

id, season, competition, opponent, result, mad_dogs_runs, mad_dogs_wkts, mad_dogs_overs, opp_runs, opp_wkts, opp_overs, notes

0 rows

partnerships

id, season, wicket, runs, player1_id, player1_runs, player2_id, player2_runs, opponent, competition, all_time_record

8 rows

players

id, name

52 rows

seasons

year

1 row

sqlite_sequence

name, seq

10 rows

team_season_stats

id, season, competition, played, won, lost, tied, abandoned

6 rows

team_totals

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 row

... and 1 hidden table

Download SQLite DB: mad_dogs.db 128.0 KB