College Basketball Big 12 Conference (1996 - 2021)

Yearly College Basketball Big 12 Conference Data (1996 - 2021)

@kaggle.mattop_college_basketball_big_12_conference_1996_2021

Table List

1 table(48.72 KB)

Big12basketball

@kaggle.mattop_college_basketball_big_12_conference_1996_2021.big12basketball

48.72 KB
290 rows
37 columns

id Id	year Year	rank Rank	school School	games Games	wins Wins	losses Losses	win_percentage Win Percentage	conference_wins Conference Wins	conference_losses Conference Losses	home_wins Home Wins	home_losses Home Losses	away_wins Away Wins	away_losses Away Losses	offensive_rating Offensive Rating	defensive_rating Defensive Rating	net_rating Net Rating	field_goals Field Goals	field_goal_attempts Field Goal Attempts	field_goal_percentage Field Goal Percentage	n_3_pointers 3 Pointers	n_3_pointer_attempts 3 Pointer Attempts	n_3_pointer_percentage 3 Pointer Percentage	effective_field_goal_percentage Effective Field Goal Percentage	free_throws Free Throws	free_throw_attempts Free Throw Attempts	free_throw_percentage Free Throw Percentage	offensive_rebounds Offensive Rebounds	total_rebounds Total Rebounds	assists Assists	steals Steals	blocks Blocks	turnovers Turnovers	personal_fouls Personal Fouls	points Points	opponent_points Opponent Points	simple_rating Simple Rating
1	2021	1	Baylor	34	27	7	0.794	14	4	15	2	8	3	111.5	92.7	18.8	28.3	61.3	0.462	8.1	23.5	0.343	0.528	12.4	17.8	0.697	12.9	37.2	15.9	8.8	3.4	12.4	16.1	77	64.1	21.73
2	2021	2	Kansas	40	34	6	0.85	14	4	16	1	6	4	111.5	95.8	15.6	28.6	59.8	0.478	7.2	19.8	0.361	0.538	13.9	19.4	0.717	11	37.9	15.3	6.3	4.3	12.1	15.9	78.2	67.3	22.28
3	2021	3	Texas Tech	37	27	10	0.73	12	6	18		3	7	106	89.2	16.8	26.2	55.5	0.472	6.1	18.9	0.321	0.526	13.6	19.5	0.698	10.6	36.4	13.7	8	3.5	13.5	16.2	72.1	60.6	20.08
4	2021	4	Texas	34	22	12	0.647	10	8	16	3	4	7	105.9	93.4	12.5	24.5	55.5	0.441	6.6	20	0.33	0.501	13.2	17.7	0.746	10.4	33.3	13.2	7.7	3.4	11.6	17.9	68.8	60.6	17.01
5	2021	5	Oklahoma State	30	15	15	0.5	8	10	10	6	3	8	96.9	93.1	3.8	25.1	57.9	0.434	5.4	18.2	0.295	0.48	12.7	19.1	0.667	11.6	37.1	12.7	8.5	5.4	15.1	17.4	68.4	65.7	13.28
6	2021	6	TCU	34	21	13	0.618	8	10	12	4	4	6	101.1	95.8	5.3	25.4	57.7	0.439	5.5	18.3	0.302	0.487	12.2	18.1	0.674	13	39	13.6	6.4	4.1	14.5	15.5	68.5	64.9	13.72
7	2021	7	Iowa State	35	22	13	0.629	7	11	14	5	4	6	96.9	92.4	4.5	24.3	56.3	0.431	6.7	21.2	0.315	0.491	10.4	15.2	0.683	9.6	32.4	14.7	8.5	3.1	13.8	18.3	65.6	62.5	12.38
8	2021	8	Oklahoma	35	19	16	0.543	7	11	12	6	3	8	103	97	6	25.3	53.1	0.476	7.6	21.9	0.347	0.548	10.9	14.6	0.747	7.7	31.8	14	7.4	1.9	14.7	15.5	69.1	65	14.12
9	2021	9	Kansas State	31	14	17	0.452	6	12	9	7	5	7	101.5	99.2	2.3	24.1	57.4	0.42	8.4	24.3	0.346	0.494	12.3	17	0.726	8.9	33.2	12.5	7.3	1.6	11.5	17.1	69	67.5	10.61
10	2021	10	West Virginia	33	16	17	0.485	4	14	12	5	1	10	99.9	100.7	-0.8	23.6	57.1	0.413	6.3	19.2	0.328	0.468	14.9	20.6	0.724	10.8	32.2	10.5	7.8	4.5	12.4	17.4	68.5	69	10.23


CREATE TABLE big12basketball (
  "id" BIGINT,
  "year" BIGINT,
  "rank" BIGINT,
  "school" VARCHAR,
  "games" BIGINT,
  "wins" BIGINT,
  "losses" BIGINT,
  "win_percentage" DOUBLE,
  "conference_wins" BIGINT,
  "conference_losses" BIGINT,
  "home_wins" DOUBLE,
  "home_losses" DOUBLE,
  "away_wins" DOUBLE,
  "away_losses" DOUBLE,
  "offensive_rating" DOUBLE,
  "defensive_rating" DOUBLE,
  "net_rating" DOUBLE,
  "field_goals" DOUBLE,
  "field_goal_attempts" DOUBLE,
  "field_goal_percentage" DOUBLE,
  "n_3_pointers" DOUBLE,
  "n_3_pointer_attempts" DOUBLE,
  "n_3_pointer_percentage" DOUBLE,
  "effective_field_goal_percentage" DOUBLE,
  "free_throws" DOUBLE,
  "free_throw_attempts" DOUBLE,
  "free_throw_percentage" DOUBLE,
  "offensive_rebounds" DOUBLE,
  "total_rebounds" DOUBLE,
  "assists" DOUBLE,
  "steals" DOUBLE,
  "blocks" DOUBLE,
  "turnovers" DOUBLE,
  "personal_fouls" DOUBLE,
  "points" DOUBLE,
  "opponent_points" DOUBLE,
  "simple_rating" DOUBLE
);