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	197	Akron	14	3.1	105	101.9	0.585	20	11	9	55	51.5	49.3	31.1	30.7	18.2	16	29.1	74.7	25.3	70.9	67.1	54.7	51.6	31.4	30.1	6.6	8.2	45.3	48.3	58.2	41.8	63.7	36.3	67	76.791	79.973	2.584	10.97	71.7	72.5	1.051	1.022	16.217	-4.4	131	179	109	131	81	74	183	92	228	211	152	30	30	152	256	16	187	257	18	287	60	251	64	294	71	232	135	265	238	199	19	176	186	188	120	47	269
2024	1078	48	Alabama	4	18.7	125.4	106.7	0.865	16	7	9	43.75	54.6	54.3	35.8	45.8	16.6	14.5	33.6	68.9	31.1	66.4	75	58.1	54.1	33.6	36.5	8.7	12.7	47.1	50	54.6	45.4	65.7	34.3	73.8	78.211	82.48	2.094	27.836	78.1	78.9	1.169	1.185	51.464	0.8	19	3	204	24	11	315	65	345	130	303	37	254	254	37	5	3	298	157	294	175	329	221	113	336	27	294	72	10	33	8	156	106	12	357	3	351	8
2024	1077	33	Arizona	2	23.7	119.7	96	0.927	17	10	7	58.82352941	51.4	51	38	30.9	16.4	17.3	34.6	73.6	26.4	65.4	71.7	51.8	50.4	33.7	34.8	7	10.7	54.6	50.6	68.4	31.6	63.3	36.7	71.7	78.063	81.464	1.963	76.342	72.4	74.3	1.116	1.048	43.206	2.2	7	11	22	7	83	146	30	97	116	126	29	55	55	29	43	73	127	152	199	268	240	46	130	61	302	219	146	40	50	37	196	7	157	284	19	98	52
2024	1076	43	Auburn	4	26.8	120.8	94	0.947	18	12	6	66.66666667	54.5	44.6	32.9	42.2	15.3	16.5	32.3	70.4	29.6	67.7	70.6	55.3	44.6	35.4	29.8	14.7	9.2	58	43.9	63.6	36.4	67.7	32.3	70.4	77.688	80.951	2.195	43.053	73.2	73.8	1.162	0.993	38.561	2.8	4	6	9	4	14	1	134	316	50	179	60	183	183	60	67	12	5	75	15	8	136	15	24	171	196	328	36	67	86	76	127	69	127	260	5	18	77
2024	1075	36	Baylor	3	17.6	117.7	100.1	0.866	16	8	8	50	50.9	53.6	37.6	35.1	18.2	17.5	33.5	72.1	27.9	66.5	67	50.4	52.8	34.5	36.7	8.4	11.7	52.8	57.6	61.9	38.1	62.8	37.2	66.7	78.257	81.747	1.617	58.436	72.9	73.6	1.084	1.084	50.734	1.8	24	18	76	23	104	287	38	193	228	111	39	120	120	39	263	133	245	116	298	188	299	78	303	218	149	201	169	275	31	22	304	34	137	248	52	189	11
2024	1074	125	Boise St.	10	13.1	110.5	97.4	0.81	16	9	7	56.25	48.5	51.3	32.5	34.1	16.3	15.6	29.8	78.7	21.3	70.2	66.9	49.3	54.5	31.6	30	6.7	13.1	45	50.6	60.3	39.7	66.2	33.8	67.7	78.325	80.161	2.047	18.982	76.1	73.3	1.046	1.042	38.695	0.8	50	79	31	49	226	166	151	174	106	239	129	1	1	129	271	177	310	253	16	280	338	260	130	251	113	305	59	227	26	171	172	135	39	227	133	83	76
2024	1073	68	BYU	6	17.4	117.3	99.9	0.864	15	7	8	46.66666667	51.3	50.3	25.1	38.5	15.4	14.4	30.9	75.6	24.4	69.1	69.7	53.6	48.8	32.7	35.3	6.4	6.3	57.6	49.5	50.2	49.8	64.4	35.6	69.7	78.499	81.22	2.232	19.483	72.2	71	1.091	1.061	43.682	0.09	26	22	73	25	86	107	326	259	55	307	103	20	20	103	110	29	64	202	225	294	10	18	96	358	5	255	112	106	18	54	116	133	165	115	44	124	47
2024	1072	76	Clemson	6	16.6	115.8	99.2	0.856	16	9	7	56.25	53.3	49.3	27.2	35.2	15.5	13	24.7	74.6	25.4	75.3	68.5	54.2	47.6	34.7	34.5	9.7	7.6	55.7	48.5	57.8	42.2	59.3	40.7	67.5	78.308	81.541	2.275	64.382	76.5	76.2	1.09	1.078	41.542	1.4	29	28	53	31	32	74	281	194	59	345	292	35	35	292	174	19	41	109	182	110	32	30	70	301	63	70	296	245	28	32	99	18	35	336	45	168	62
2024	1071	201	Colgate	14	-0.6	102.3	102.9	0.483	18	12	6	66.66666667	52.2	48.8	27.5	23.9	18.1	15.8	25.4	73.3	26.7	74.6	65.9	52	49.8	35.1	31.4	8.4	8.2	51.8	52.1	62.9	37.1	60.3	39.7	66.6	77.926	81.273	1.902	0.2	69.7	71.3	1.026	1.015	18.863	-1.6	172	228	129	172	57	49	274	5	216	225	270	67	67	270	310	70	101	83	48	188	60	97	166	193	173	112	257	277	60	48	214	362	259	131	169	40	208
2024	1070	186	College of Charleston	13	8.5	114.5	106	0.708	19	14	5	73.68421053	52.9	52	25.3	30.4	14.5	16.8	32.7	73.5	26.5	67.3	68.4	52.9	52.3	35.3	34.3	6.6	9.5	53.5	43.2	52.3	47.7	60.3	39.7	69.8	77.503	81.18	1.788	5.524	72	71.8	1.141	1.066	15.68	-0.7	88	40	185	89	40	208	325	86	21	158	52	57	57	52	179	40	222	78	173	287	153	64	16	349	15	112	257	103	117	59	256	227	173	153	12	136	278


CREATE TABLE barttorvik_away_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" 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
);