March Madness Data

year YEAR	team_no TEAM NO	team_id TEAM ID	team TEAM	seed SEED	badj_em BADJ EM	badj_o BADJ O	badj_d BADJ D	barthag BARTHAG	games GAMES	w W	l L	win WIN%	efg EFG%	efg_d EFG%D	ftr FTR	ftrd FTRD	tov TOV%	tov_d TOV%D	oreb OREB%	dreb DREB%	op_oreb OP OREB%	op_dreb OP DREB%	raw_t RAW T	n_2pt 2PT%	n_2pt_d 2PT%D	n_3pt 3PT%	n_3pt_d 3PT%D	blk BLK%	blked BLKED%	ast AST%	op_ast OP AST%	n_2ptr 2PTR	n_3ptr 3PTR	n_2ptrd 2PTRD	n_3ptrd 3PTRD	badj_t BADJ T	avg_hgt AVG HGT	eff_hgt EFF HGT	exp EXP	talent TALENT	ft FT%	op_ft OP FT%	pppo PPPO	pppd PPPD	elite_sos ELITE SOS	wab WAB	badj_em_rank BADJ EM RANK	badj_o_rank BADJ O RANK	badj_d_rank BADJ D RANK	barthag_rank BARTHAG RANK	efg_rank EFG% RANK	efgd_rank EFGD% RANK	ftr_rank FTR RANK	ftrd_rank FTRD RANK	tov_rank TOV% RANK	tov_d_rank TOV%D RANK	oreb_rank OREB% RANK	dreb_rank DREB% RANK	op_oreb_rank OP OREB% RANK	op_dreb_rank OP DREB% RANK	raw_t_rank RAW T RANK	n_2pt_rank 2PT% RANK	n_2pt_d_rank 2PT%D RANK	n_3pt_rank 3PT% RANK	n_3pt_d_rank 3PT%D RANK	blk_rank BLK% RANK	blked_rank BLKED% RANK	ast_rank AST% RANK	op_ast_rank OP AST% RANK	n_2ptr_rank 2PTR RANK	n_3ptr_rank 3PTR RANK	n_2ptrd_rank 2PTRD RANK	n_3ptrd_rank 3PTRD RANK	badjt_rank BADJT RANK	avg_hgt_rank AVG HGT RANK	eff_hgt_rank EFF HGT RANK	exp_rank EXP RANK	talent_rank TALENT RANK	ft_rank FT% RANK	op_ft_rank OP FT% RANK	pppo_rank PPPO RANK	pppd_rank PPPD RANK	elite_sos_rank ELITE SOS RANK
2024	1079	2	Akron	14	5.2	107	101.8	0.639	12	11	1	91.66666667	52.9	47.5	37.8	26.2	15.6	17.6	30.1	73.8	26.2	69.9	66.1	55.1	49.2	33.1	29.8	10.3	7	52.9	40.3	58.9	41.1	62.4	37.6	66.1	76.791	79.973	2.584	10.97	73.4	63.3	1.126	0.956	4.788	-0.11	129	157	125	128	137	112	114	76	132	178	152	100	100	152	305	75	193	257	53	166	110	169	50	282	84	155	209	302	238	199	19	176	148	7	110	53	209
2024	1078	3	Alabama	4	30	126	96	0.958	16	14	2	87.5	57.9	45.7	34.7	33.7	15.4	16.8	36.2	71.2	28.8	63.8	73.5	57.1	48.1	39.2	28	11.9	12.3	55.6	39.6	51.9	48.1	60.9	39.1	73.2	78.211	82.48	2.094	27.836	78.6	68.4	1.258	0.982	21.044	2.6	8	4	35	9	21	39	195	254	119	228	32	203	203	32	11	33	145	25	14	95	349	116	37	349	14	119	246	15	33	8	156	106	25	66	6	101	11
2024	1077	8	Arizona	2	33.1	123.6	90.5	0.973	16	15	1	93.75	58.6	46.2	35.5	20.2	15.8	19	38.3	80.1	19.9	61.7	75.2	57.6	44.9	40.4	32.1	11.2	6.5	63.2	55	66.3	33.7	60.3	39.7	74.5	78.063	81.464	1.963	76.342	71.2	66	1.242	0.883	15.826	2.7	4	8	9	5	16	59	171	8	142	103	12	2	2	12	3	26	55	19	141	117	69	27	309	92	272	104	262	5	50	37	196	7	226	19	10	8	60
2024	1076	12	Auburn	4	30.7	120.5	89.8	0.967	16	15	1	93.75	53.7	42.1	44.3	39.8	14.5	20	33.6	68.8	31.2	66.4	71.4	54.4	40.7	35	29.8	17.6	7.8	66.7	41.4	61.3	38.7	65.6	34.4	71.4	77.688	80.951	2.195	43.053	76.9	73.4	1.188	0.921	16.187	2.7	7	15	8	7	114	7	29	335	80	63	66	300	300	66	53	97	3	173	53	5	164	17	67	211	155	261	106	52	86	76	127	69	54	269	30	21	56
2024	1075	14	Baylor	3	27.7	127.9	100.2	0.943	16	14	2	87.5	60.2	49.1	43.4	27	17.2	16.8	37.1	73.6	26.4	62.9	66.7	56.4	51.1	44.3	30.3	8.6	7.9	54.8	48.2	61.5	38.5	66.1	33.9	66.8	78.257	81.747	1.617	58.436	75	72.2	1.258	1.001	25.07	3.2	11	2	96	14	8	185	39	95	229	228	17	109	109	17	274	50	261	2	66	245	170	136	196	201	165	279	88	277	31	22	304	34	96	209	6	150	1
2024	1074	17	Boise St.	10	19.5	117	97.5	0.891	14	11	3	78.57142857	55.3	48.1	40.3	32	16.6	18.3	36	74.9	25.1	64	66.3	53.5	49	38.6	31.2	7.2	9.3	48.8	43.6	59.9	40.1	59.5	40.5	67.6	78.325	80.161	2.047	18.982	72	70.7	1.175	0.974	15.113	0.03	34	37	49	36	64	133	73	223	197	143	37	59	59	37	299	126	186	41	98	306	253	250	106	249	117	80	286	230	26	171	172	135	198	156	43	92	69
2024	1073	25	BYU	6	27.5	124	96.5	0.947	18	16	2	88.88888889	58.1	46.2	25.4	27	15.1	17.3	34.5	75	25	65.5	70.3	61.7	47.7	36.5	28.8	8.7	7.7	67.3	45.3	48.7	51.3	67.2	32.8	70.2	78.499	81.22	2.232	19.483	75.1	68.4	1.233	0.946	20.21	2.8	12	6	42	11	19	59	351	95	104	198	49	56	56	49	79	6	123	107	30	235	159	13	140	358	5	306	59	86	18	54	116	133	94	66	11	41	19
2024	1072	33	Clemson	6	18.9	118.6	99.7	0.88	16	12	4	75	54.5	48.1	34	27.1	14.3	14.2	30.9	75	25	69.1	66.7	54.6	46.6	36.2	33.5	12.7	6	51.2	39.7	61.8	38.2	59.5	40.5	66.8	78.308	81.541	2.275	64.382	80.9	72.1	1.186	1.018	15.652	-0.41	39	27	89	42	88	133	210	101	64	338	131	56	56	131	274	88	90	119	210	68	43	198	39	192	173	80	286	277	28	32	99	18	8	205	33	187	62
2024	1071	36	Colgate	14	0.5	102.3	101.8	0.514	15	12	3	80	54.8	45.3	27.7	25.2	14.2	16.6	24.5	78	22	75.5	66.4	54.9	47.4	36.4	28	11.6	6.2	61.9	53.8	60.3	39.7	60.4	39.6	67.9	77.926	81.273	1.902	0.2	66	62	1.104	0.913	1.982	-2.5	166	242	125	166	76	31	329	62	60	242	316	9	9	316	294	79	115	112	14	100	50	37	293	238	128	108	258	209	60	48	214	362	330	2	149	15	342
2024	1070	37	College of Charleston	13	5.9	110.6	104.7	0.653	14	12	2	85.71428571	51.8	48.8	28.9	25.6	14.1	15.9	34.6	73.2	26.8	65.4	71.5	52.2	48.4	34.2	33.1	10.1	10.7	53.8	42.3	53.7	46.3	66.7	33.3	72.6	77.503	81.18	1.788	5.524	72.3	68.9	1.147	1.013	4.966	-0.9	123	104	163	123	185	170	313	66	55	280	47	126	126	47	47	166	160	212	189	174	307	153	84	342	21	296	69	22	117	59	256	227	191	81	78	181	202


CREATE TABLE barttorvik_home (
  "year" BIGINT,
  "team_no" BIGINT,
  "team_id" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "games" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efg_d" DOUBLE,
  "ftr" DOUBLE,
  "ftrd" DOUBLE,
  "tov" DOUBLE,
  "tov_d" DOUBLE,
  "oreb" DOUBLE,
  "dreb" DOUBLE,
  "op_oreb" DOUBLE,
  "op_dreb" DOUBLE,
  "raw_t" DOUBLE,
  "n_2pt" DOUBLE,
  "n_2pt_d" DOUBLE,
  "n_3pt" DOUBLE,
  "n_3pt_d" DOUBLE,
  "blk" DOUBLE,
  "blked" DOUBLE,
  "ast" DOUBLE,
  "op_ast" DOUBLE,
  "n_2ptr" DOUBLE,
  "n_3ptr" DOUBLE,
  "n_2ptrd" DOUBLE,
  "n_3ptrd" DOUBLE,
  "badj_t" DOUBLE,
  "avg_hgt" DOUBLE,
  "eff_hgt" DOUBLE,
  "exp" DOUBLE,
  "talent" DOUBLE,
  "ft" DOUBLE,
  "op_ft" DOUBLE,
  "pppo" DOUBLE,
  "pppd" DOUBLE,
  "elite_sos" DOUBLE,
  "wab" DOUBLE,
  "badj_em_rank" BIGINT,
  "badj_o_rank" BIGINT,
  "badj_d_rank" BIGINT,
  "barthag_rank" BIGINT,
  "efg_rank" BIGINT,
  "efgd_rank" BIGINT,
  "ftr_rank" BIGINT,
  "ftrd_rank" BIGINT,
  "tov_rank" BIGINT,
  "tov_d_rank" BIGINT,
  "oreb_rank" BIGINT,
  "dreb_rank" BIGINT,
  "op_oreb_rank" BIGINT,
  "op_dreb_rank" BIGINT,
  "raw_t_rank" BIGINT,
  "n_2pt_rank" BIGINT,
  "n_2pt_d_rank" BIGINT,
  "n_3pt_rank" BIGINT,
  "n_3pt_d_rank" BIGINT,
  "blk_rank" BIGINT,
  "blked_rank" BIGINT,
  "ast_rank" BIGINT,
  "op_ast_rank" BIGINT,
  "n_2ptr_rank" BIGINT,
  "n_3ptr_rank" BIGINT,
  "n_2ptrd_rank" BIGINT,
  "n_3ptrd_rank" BIGINT,
  "badjt_rank" BIGINT,
  "avg_hgt_rank" BIGINT,
  "eff_hgt_rank" BIGINT,
  "exp_rank" BIGINT,
  "talent_rank" BIGINT,
  "ft_rank" BIGINT,
  "op_ft_rank" BIGINT,
  "pppo_rank" BIGINT,
  "pppd_rank" BIGINT,
  "elite_sos_rank" BIGINT
);