March Madness Data

year YEAR	conf_id CONF ID	conf CONF	badj_em BADJ EM	badj_o BADJ O	badj_d BADJ D	barthag BARTHAG	g G	w W	l L	win WIN%	efg EFG%	efgd EFGD%	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
2024	1	A10	6.8	106.3	99.5	0.681	73	38	35	52.05479452	49.6	48.6	35.3	34	18.4	17.5	28.7	69.8	30.2	71.3	66.6	48.6	49.2	34.1	31.8	10	11	52	50.6	61.2	38.8	62.7	37.3	67.1	77.133	80.264	1.884	18.386	73.2	70.7	1.027	1.029	23.554	-0.8
2024	2	ACC	13.8	113.1	99.3	0.817	73	38	35	52.05479452	50.3	50.1	35	32.2	16.3	17	27.4	68.4	31.6	72.6	68.7	51.3	51.1	32.5	32.3	9.2	9.3	51.7	51.3	62.9	37.1	63.5	36.5	68.7	77.897	81.078	1.653	62.324	75.5	73.7	1.058	1.068	35.818	-0.08
2024	3	AE	2.2	105.2	103	0.561	8	6	2	75	53.8	47.4	36.6	36.9	16.2	18.1	22.7	68.3	31.7	77.3	68	52.6	45.9	37	33.5	12	6.7	47.4	48.5	59.9	40.1	66.7	33.3	69.3	76.776	79.091	2.147	6.236	73.3	65.7	1.077	1.002	8.703	-0.1
2024	4	Amer	5.4	106.9	101.5	0.645	66	30	36	45.45454545	49	50.2	33.2	33.4	16.4	17.3	28.2	68.8	31.2	71.8	68.8	48.3	49.9	33.5	33.8	11	10.9	49.2	52.6	62.9	37.1	62	38	68.7	77.293	80.347	2.237	30.455	71.3	70.3	1.033	1.058	23.939	-1
2024	5	ASun	-6.8	103.3	110.1	0.325	15	10	5	66.66666667	51.1	50.9	35.1	32.1	17.7	18.2	33.5	70.6	29.4	66.5	69	52	50.4	33	34.4	9.8	7	44.4	47	63.9	36.1	58.6	41.4	68.9	76.777	79.668	2.026	8.164	74.8	74.9	1.084	1.059	6.003	-0.3
2024	6	B10	17	113.7	96.7	0.866	65	34	31	52.30769231	50.3	49.3	33.8	32.6	16.4	16.6	30.8	70.4	29.6	69.2	68.4	49.7	49	34.2	33.2	9.6	9.4	53.3	55.3	65.2	34.8	64.5	35.5	68.3	77.912	81.161	1.982	57.333	72.4	74.5	1.073	1.051	38.369	0.04
2024	7	B12	16.1	112.2	96.1	0.856	73	41	32	56.16438356	49.2	48.4	34	35.8	17.6	17.2	31.3	71.9	28.1	68.7	69	48.8	48.1	33.3	32.6	9.8	10.5	55	51.8	62.2	37.8	61.4	38.6	69.2	77.588	80.916	2.096	48.607	73.2	74.1	1.051	1.024	37.419	0.18
2024	8	BE	18.2	112.5	94.3	0.884	45	25	20	55.55555556	49.6	48.9	29	30.3	15.4	16.6	27.8	73.9	26.1	72.2	68.3	50.9	48.8	31.8	32.6	9.5	9.8	54.7	52.9	60.4	39.6	62.2	37.8	68.4	77.722	80.772	2.102	50.583	74.7	72.3	1.05	1.018	38.931	0.21
2024	9	BSky	-4.3	103.4	107.7	0.385	31	14	17	45.16129032	51.6	52.4	31.8	32.4	17.5	17.2	26.9	72.5	27.5	73.1	67.5	52.6	52.9	33.5	34.4	7.4	7.8	44.6	41.6	58.2	41.8	62.5	37.5	68.7	77.249	80.202	2.057	4.159	75.8	72.1	1.057	1.057	7.195	-1.4
2024	10	BSth	-1.5	101.4	102.9	0.458	29	16	13	55.17241379	48.7	48.1	34.6	34.1	17.1	16.1	28.1	74	26	71.9	67.3	47.1	49.9	34.4	30	8.7	9	52.5	51.1	63.3	36.7	64.6	35.4	67.3	76.79	79.666	2.237	8.169	68.7	74	1.014	1.02	11.266	-0.9


CREATE TABLE conference_stats_neutral (
  "year" BIGINT,
  "conf_id" BIGINT,
  "conf" VARCHAR,
  "badj_em" DOUBLE,
  "badj_o" DOUBLE,
  "badj_d" DOUBLE,
  "barthag" DOUBLE,
  "g" BIGINT,
  "w" BIGINT,
  "l" BIGINT,
  "win" DOUBLE,
  "efg" DOUBLE,
  "efgd" 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
);