womens-world-cup-predictions/wwc-forecast-20150623-235546

24 rows

View and edit SQL

Suggested facets: group, group_first, group_second, group_third_advance, group_third_no_advance, group_fourth, sixteen, quarter, semi, final, win

Link rowid team group wspi wspi_offense wspi_defense group_first group_second group_third_advance group_third_no_advance group_fourth sixteen quarter semi final win
1 Germany B 95.98584208 3.87817709 0.39069487 1 0 0 0 0 1 1 0.71625 0.4313 0.3287
2 USA D 95.17155166 3.54513451 0.39500423 1 0 0 0 0 1 1 0.87945 0.4397 0.3122
3 Japan C 92.28608175 2.770739 0.55658903 1 0 0 0 0 1 1 0.6195 0.3595 0.1228
4 Canada A 89.39820846 2.16137846 0.64956983 1 0 0 0 0 1 1 0.5769 0.28115 0.0822
5 France F 92.45938809 2.87121709 0.61450578 1 0 0 0 0 1 1 0.28375 0.11235 0.0631
6 Australia D 89.48423979 2.40622156 0.89733403 0 1 0 0 0 1 1 0.3805 0.17975 0.04465
7 England F 89.44996873 2.27096064 0.75733956 0 1 0 0 0 1 1 0.4231 0.1796 0.0419
8 China A 85.39163083 1.48348049 0.74762304 0 1 0 0 0 1 1 0.12055 0.01665 0.00445
9 Colombia F 80.22853762 1.07485766 1.18290426 0 0 1 0 0 1 0 0.0 0.0 0.0
10 Sweden D 91.3173372 2.67554072 0.72731706 0 0 1 0 0 1 0 0.0 0.0 0.0
11 Netherlands A 86.3493937 1.87821216 0.99563144 0 0 1 0 0 1 0 0.0 0.0 0.0
12 Cameroon C 81.15332719 1.28924313 1.26876041 0 1 0 0 0 1 0 0.0 0.0 0.0
13 Norway B 88.89282507 2.20550309 0.81478397 0 1 0 0 0 1 0 0.0 0.0 0.0
14 Brazil E 91.68669993 2.59357117 0.53525905 1 0 0 0 0 1 0 0.0 0.0 0.0
15 South Korea E 83.18267502 1.68034235 1.35958853 0 1 0 0 0 1 0 0.0 0.0 0.0
16 Switzerland C 83.69083781 1.87652891 1.48656887 0 0 1 0 0 1 0 0.0 0.0 0.0
17 Spain E 83.4537739 1.46410265 1.07613093 0 0 0 0 1 0 0 0.0 0.0 0.0
18 Thailand B 68.35123343 0.89770412 2.70560584 0 0 0 1 0 0 0 0.0 0.0 0.0
19 New Zealand A 82.82143389 1.48116673 1.20289329 0 0 0 0 1 0 0 0.0 0.0 0.0
20 Ivory Coast B 71.89190995 1.3806396 2.75509191 0 0 0 0 1 0 0 0.0 0.0 0.0
21 Costa Rica E 74.73457668 0.9351499 1.86442296 0 0 0 1 0 0 0 0.0 0.0 0.0
22 Mexico F 80.42516164 1.48580621 1.60142078 0 0 0 0 1 0 0 0.0 0.0 0.0
23 Nigeria D 85.84528046 1.71207232 0.91191163 0 0 0 0 1 0 0 0.0 0.0 0.0
24 Ecuador C 57.66963152 0.4860502 3.60848496 0 0 0 0 1 0 0 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150623-235546" (
"team" TEXT,
  "group" TEXT,
  "wspi" REAL,
  "wspi_offense" REAL,
  "wspi_defense" REAL,
  "group_first" INTEGER,
  "group_second" INTEGER,
  "group_third_advance" INTEGER,
  "group_third_no_advance" INTEGER,
  "group_fourth" INTEGER,
  "sixteen" INTEGER,
  "quarter" INTEGER,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 30.236ms