march-madness-predictions/bracket-06

4 rows where team_seed = 6 sorted by rd4_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 2:27 PM
44 113 Massachusetts 6 Midwest 0 1 1 0.294573469275 0.056982985793000006 0.019293553806 0.003793495077 0.001057735381 0.000299070373 3342.694624 3/20/2014 2:27 PM
61 239 Baylor 6 West 0 1 1 0.703236756559 0.338102692122 0.143482608394 0.044268181398 0.017872989089 0.008011351273000001 123.8228877 3/20/2014 2:27 PM
26 153 North Carolina 6 East 0 1 1 0.6796373677709999 0.36376216082199997 0.158570533817 0.063948749501 0.023702281714 0.008440514959 117.4761836 3/20/2014 2:27 PM

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "march-madness-predictions/bracket-06" (
"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 37.761ms