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	0.8	97.4	96.6	0.524	7	4	3	57.14285714	48.9	47.1	34.9	24.6	20.4	15.6	27.4	75.9	24.1	72.6	67.8	54.5	49.3	27.9	28.5	7.3	8.9	50	43.7	56.3	43.7	66.7	33.3	67.6	76.791	79.973	2.584	10.97	68.9	75.2	0.972	0.976	16.739	-1.3	164	275	70	164	188	117	145	81	306	220	189	87	87	189	187	59	190	268	90	230	207	177	100	309	55	245	125	213	238	199	19	176	232	261	253	94	166
2024	1078	3	Alabama	4	23.2	126.8	103.6	0.911	6	2	4	33.33333333	55.1	53	36.1	40.9	16.8	14.7	32.7	68.9	31.1	67.3	74.6	59.9	52.5	33.7	35.9	10.2	8.6	52.5	51.7	49.2	50.8	65.6	34.4	74	78.211	82.48	2.094	27.836	80.3	82.9	1.182	1.162	46.457	-0.6	16	5	177	24	38	283	124	292	186	256	80	248	248	80	16	14	262	153	264	118	189	138	223	350	13	217	148	18	33	8	156	106	27	344	20	339	40
2024	1077	8	Arizona	2	23.1	112.6	89.5	0.933	6	3	3	50	48.3	48.8	38.7	25.5	17.4	19	35.6	71.1	28.9	64.4	70.9	50	51.9	29.6	29.3	8.7	8.8	57.3	47	69.3	30.7	60.6	39.4	70.2	78.063	81.464	1.963	76.342	73.8	76.3	1.059	1.007	45.23	0.38	18	66	17	15	203	164	89	90	206	95	38	185	185	38	84	155	250	239	106	177	200	71	148	84	279	122	241	107	50	37	196	7	129	278	118	135	42
2024	1076	12	Auburn	4	33.7	123.1	89.4	0.975	8	7	1	87.5	56.6	42.3	34.2	41.4	14.6	18.4	30	69.1	30.9	70	71.2	54.9	45.2	40	23.8	16.1	7.8	63.4	46.7	65.2	34.8	69.3	30.7	72	77.688	80.951	2.195	43.053	74.3	72	1.191	0.936	31.551	2.3	3	11	16	4	21	49	155	295	100	120	130	238	238	130	69	52	97	39	47	15	152	26	139	157	206	288	77	50	86	76	127	69	118	196	15	54	105
2024	1075	14	Baylor	3	16.8	118.2	101.4	0.854	7	4	3	57.14285714	52.3	53.6	39.5	38.1	20.1	17.1	34.2	70.6	29.4	65.8	70.3	49.6	52	38	38.1	9.2	13.6	53.8	58.9	64.5	35.5	68.4	31.6	70.2	78.257	81.747	1.617	58.436	74.1	75.7	1.087	1.103	50.094	1.2	47	28	139	49	90	297	80	263	295	164	60	199	199	60	101	163	251	61	306	157	323	119	307	175	193	276	89	107	31	22	304	34	122	269	78	288	35
2024	1074	17	Boise St.	10	10.7	103.3	92.6	0.779	6	2	4	33.33333333	43.7	49.5	30.4	35.4	15.1	16.4	23.3	78	22	76.7	68.3	43.7	53.2	29.1	27.5	9.5	12.1	45.9	45	61.6	38.4	69.4	30.6	69	78.325	80.161	2.047	18.982	76.4	72	0.942	1.013	39.104	-1	89	184	31	81	296	190	212	229	114	191	280	63	63	280	170	287	277	248	74	146	288	224	117	229	135	290	74	144	26	171	172	135	79	196	279	145	61
2024	1073	25	BYU	6	23.1	119	95.9	0.923	5	4	1	80	55.6	48.6	26	31.7	16.3	16.9	30.1	77.5	22.5	69.9	71	55.2	46.9	37.3	34.7	4.2	2.6	64.1	41.9	48.9	51.1	66.2	33.8	71	78.499	81.22	2.232	19.483	74.4	68.5	1.158	0.972	25.783	0.8	18	27	64	17	29	153	266	173	169	171	128	67	67	128	80	50	124	71	235	307	35	18	82	354	10	229	134	74	18	54	116	133	115	123	25	91	130
2024	1072	33	Clemson	6	4.7	106.3	101.6	0.627	4	3	1	75	49.3	47	33.9	35.2	15.4	15.4	23.7	65.7	34.3	76.3	66.5	52.8	44.7	29.9	33.7	14.9	7.1	63.5	51.1	56.7	43.3	60.5	39.5	66.4	78.308	81.541	2.275	64.382	69.7	78	1.03	1.064	25.192	0.4	132	136	144	133	177	115	159	227	129	231	272	302	302	272	231	92	88	235	213	23	121	25	216	303	63	121	245	253	28	32	99	18	211	308	175	235	134
2024	1071	36	Colgate	14	-1.5	93.3	94.8	0.454	3	2	1	66.66666667	45.2	44.9	19.7	20.4	17.6	12.6	24	77.9	22.1	76	60.6	46.1	42.9	29.4	31.9	4.1	4.5	63.9	43.8	56.7	43.3	58.7	41.3	61.6	77.926	81.273	1.902	0.2	77.4	73.5	0.912	0.962	14.155	-0.37	185	318	50	186	278	73	318	49	213	310	266	65	65	266	325	250	60	242	168	308	60	21	102	303	63	82	284	353	60	48	214	362	61	226	301	79	180
2024	1070	37	College of Charleston	13	6.7	106.9	100.2	0.678	7	4	3	57.14285714	47.2	50.1	29.8	29.2	16.4	17.7	32.6	74.6	25.4	67.4	67.6	51.4	48.4	27.8	34.8	6.3	11.5	49.7	41.5	56.5	43.5	55.2	44.8	69.7	77.503	81.18	1.788	5.524	71.9	72.9	1.036	1.021	13.875	-1.6	115	126	125	115	239	215	225	136	175	142	83	107	107	83	193	114	166	272	237	258	278	180	73	307	58	27	337	126	117	59	256	227	174	213	163	155	183


CREATE TABLE barttorvik_neutral (
  "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" DOUBLE,
  "w" DOUBLE,
  "l" DOUBLE,
  "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" DOUBLE,
  "badj_o_rank" DOUBLE,
  "badj_d_rank" DOUBLE,
  "barthag_rank" DOUBLE,
  "efg_rank" DOUBLE,
  "efgd_rank" DOUBLE,
  "ftr_rank" DOUBLE,
  "ftrd_rank" DOUBLE,
  "tov_rank" DOUBLE,
  "tov_d_rank" DOUBLE,
  "oreb_rank" DOUBLE,
  "dreb_rank" DOUBLE,
  "op_oreb_rank" DOUBLE,
  "op_dreb_rank" DOUBLE,
  "raw_t_rank" DOUBLE,
  "n_2pt_rank" DOUBLE,
  "n_2pt_d_rank" DOUBLE,
  "n_3pt_rank" DOUBLE,
  "n_3pt_d_rank" DOUBLE,
  "blk_rank" DOUBLE,
  "blked_rank" DOUBLE,
  "ast_rank" DOUBLE,
  "op_ast_rank" DOUBLE,
  "n_2ptr_rank" DOUBLE,
  "n_3ptr_rank" DOUBLE,
  "n_2ptrd_rank" DOUBLE,
  "n_3ptrd_rank" DOUBLE,
  "badjt_rank" DOUBLE,
  "avg_hgt_rank" DOUBLE,
  "eff_hgt_rank" DOUBLE,
  "exp_rank" DOUBLE,
  "talent_rank" DOUBLE,
  "ft_rank" DOUBLE,
  "op_ft_rank" DOUBLE,
  "pppo_rank" DOUBLE,
  "pppd_rank" DOUBLE,
  "elite_sos_rank" DOUBLE
);