fivethirtyeight: march-madness-predictions/bracket-21: 19 rows where team

This table contains data behind the 2014 NCAA Tournament Predictions.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

19 rows where team_region = "Midwest"

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid ▼	team_id	team_name	team_seed	team_region	playin_flag	team_alive	rd1_win	rd2_win	rd3_win	rd4_win	rd5_win	rd6_win	rd7_win	win_odds	timestamp
34	34	2724	Wichita State	1	Midwest	0	1	1	0.975453920569	0.591415204901	0.24083336197	0.133934722343	0.077082429247	0.045025857696	21.20946032	3/21/2014 1:39 AM
35	35	13	Cal Poly	16a	Midwest	1	1	1	0.024546079431	0.001766218646	6.7109826e-05	5.619943e-06	6.31344e-07	8.3504e-08	11975452.08	3/21/2014 1:39 AM
36	36	2640	Texas Southern	16b	Midwest	1	0	0	0.0	0.0	0.0	0.0	0.0	0.0	--	3/21/2014 1:39 AM
37	37	96	Kentucky	8	Midwest	0	1	1	0.739316299302	0.340260219827	0.140502803137	0.079097020936	0.038469377955	0.019198655919	51.08697964	3/21/2014 1:39 AM
38	38	2306	Kansas State	9	Midwest	0	1	1	0.260683700698	0.066558356626	0.013198070188	0.004259027783	0.001463930729	0.000532452701	1877.101094	3/21/2014 1:39 AM
39	39	139	Saint Louis	5	Midwest	0	1	1	1.0	0.177735118466	0.059424655698	0.022491194612	0.007859245171	0.00288290676	345.8721271	3/21/2014 1:39 AM
40	40	152	North Carolina State	12a	Midwest	1	0	1	0.0	0.0	0.0	0.0	0.0	0.0	--	3/21/2014 1:39 AM
41	41	2752	Xavier	12b	Midwest	1	0	0	0.0	0.0	0.0	0.0	0.0	0.0	--	3/21/2014 1:39 AM
42	42	97	Louisville	4	Midwest	0	1	1	1.0	0.822264881534	0.545973999181	0.375575557412	0.225518752863	0.136614686494	6.319857225	3/21/2014 1:39 AM
43	43	2363	Manhattan	13	Midwest	0	0	1	0.0	0.0	0.0	0.0	0.0	0.0	--	3/21/2014 1:39 AM
44	44	113	Massachusetts	6	Midwest	0	1	1	0.294573469275	0.056982985793	0.018616959578	0.00371728402	0.001011175197	0.000295682767	3381.002985	3/21/2014 1:39 AM
45	45	2294	Iowa	11a	Midwest	1	0	0	0.0	0.0	0.0	0.0	0.0	0.0	--	3/21/2014 1:39 AM
46	46	2633	Tennessee	11b	Midwest	1	1	1	0.705426530725	0.241660203984	0.12471558541	0.044223221541	0.019114930849	0.008591044433	115.4002826	3/21/2014 1:39 AM
47	47	150	Duke	3	Midwest	0	1	1	0.929166050148	0.683485418794	0.408355794106	0.174490016321	0.087724804712	0.045031279266	21.2067864	3/21/2014 1:39 AM
48	48	2382	Mercer	14	Midwest	0	1	1	0.070833949852	0.01787139143	0.003887563966	0.000479971919	9.4916833e-05	2.0777753e-05	48127.40055	3/21/2014 1:39 AM
49	49	251	Texas	7	Midwest	0	1	1	1.0	0.21311401249	0.052565547054	0.0094234499	0.003284488979	0.001205614756	828.4523561	3/21/2014 1:39 AM
50	50	9	Arizona State	10	Midwest	0	0	1	0.0	0.0	0.0	0.0	0.0	0.0	--	3/21/2014 1:39 AM
51	51	130	Michigan	2	Midwest	0	1	1	1.0	0.78688598751	0.391858549886	0.152302913271	0.066677039761	0.030034472586	32.29507442	3/21/2014 1:39 AM
52	52	2747	Wofford	15	Midwest	0	0	1	0.0	0.0	0.0	0.0	0.0	0.0	--	3/21/2014 1:39 AM

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "march-madness-predictions/bracket-21" (
"team_id" INTEGER,
  "team_name" TEXT,
  "team_seed" TEXT,
  "team_region" TEXT,
  "playin_flag" INTEGER,
  "team_alive" INTEGER,
  "rd1_win" INTEGER,
  "rd2_win" REAL,
  "rd3_win" REAL,
  "rd4_win" REAL,
  "rd5_win" REAL,
  "rd6_win" REAL,
  "rd7_win" REAL,
  "win_odds" TEXT,
  "timestamp" TEXT
);

March Madness Predictions: bracket-21.csv

19 rows where team_region = "Midwest"

Advanced export