march-madness-predictions/bracket-08

4 rows where team_seed = 6 sorted by rd3_win

View and edit SQL

Suggested facets: team_alive

team_seed

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
10 194 Ohio State 6 South 0 0 1 0.0 0.0 0.0 0.0 0.0 0.0 -- 3/20/2014 3:51 PM
44 113 Massachusetts 6 Midwest 0 1 1 0.294573469275 0.056982985793000006 0.019293553806 0.003793495077 0.001003788646 0.000285600623 3500.392928 3/20/2014 3:51 PM
61 239 Baylor 6 West 0 1 1 0.703236756559 0.338102692122 0.12096231749900001 0.037460840011 0.015174633065 0.0068501842539999995 144.9814748 3/20/2014 3:51 PM
26 153 North Carolina 6 East 0 1 1 0.6796373677709999 0.36376216082199997 0.158570533817 0.063948749501 0.023856386924000002 0.008346343097 118.8129514 3/20/2014 3:51 PM

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "march-madness-predictions/bracket-08" (
"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
);
Powered by Datasette · Query took 24.936ms