womens-world-cup-predictions/wwc-forecast-20150620-180614

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

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.98277462 3.87907395 0.39047121 1 0 0 0 0 1 1.0 0.763 0.4664 0.35665
2 USA D 95.18160659 3.55967206 0.40397923 1 0 0 0 0 1 0.95155 0.85355 0.42245 0.2977
3 Japan C 92.24884456 2.75363438 0.54616622 1 0 0 0 0 1 0.7259 0.39775 0.24 0.08275
4 Brazil E 92.01984651 2.68083985 0.53347523 1 0 0 0 0 1 0.62 0.3451 0.20445 0.0674
5 Canada A 89.49703079 2.20767956 0.67440029 1 0 0 0 0 1 0.756 0.43525 0.2157 0.0635
6 France F 92.27381631 2.8423125 0.6358772 1 0 0 0 0 1 0.7991 0.2205 0.09055 0.0516
7 England F 89.18730785 2.22026551 0.76086033 0 1 0 0 0 1 0.5087 0.25125 0.1065 0.02315
8 Norway B 89.01934357 2.21326936 0.79202033 0 1 0 0 0 1 0.4913 0.2333 0.096 0.0222
9 Australia D 89.25324873 2.40307569 0.94567596 0 1 0 0 0 1 0.38 0.1655 0.08125 0.02075
10 Netherlands A 86.25263155 1.85620247 0.98812305 0 0 1 0 0 1 0.2741 0.09165 0.03485 0.00535
11 China A 85.28614036 1.49060661 0.77268921 0 1 0 0 0 1 0.60895 0.08855 0.01195 0.00345
12 Switzerland C 83.76201604 1.93736935 1.53839946 0 0 1 0 0 1 0.244 0.0802 0.02125 0.00315
13 Cameroon C 81.47760261 1.34802094 1.27790157 0 1 0 0 0 1 0.39105 0.0393 0.0041 0.00095
14 South Korea E 83.74050015 1.74703436 1.33377106 0 1 0 0 0 1 0.2009 0.0165 0.00305 0.0008
15 Colombia F 80.28145186 1.10479891 1.20504948 0 0 1 0 0 1 0.04845 0.0186 0.0015 0.0006
16 Sweden D 91.2910534 2.6722951 0.72826591 0 0 1 0 0 1 0.0 0.0 0.0 0.0
17 New Zealand A 82.77932173 1.47558532 1.2015975 0 0 0 0 1 0 0.0 0.0 0.0 0.0
18 Thailand B 68.3779799 0.89783944 2.70035578 0 0 0 1 0 0 0.0 0.0 0.0 0.0
19 Ivory Coast B 71.93304198 1.38388497 2.75108685 0 0 0 0 1 0 0.0 0.0 0.0 0.0
20 Costa Rica E 74.78376713 0.93749476 1.85784044 0 0 0 1 0 0 0.0 0.0 0.0 0.0
21 Spain E 83.46047501 1.4656197 1.07430194 0 0 0 0 1 0 0.0 0.0 0.0 0.0
22 Mexico F 80.38973002 1.4827642 1.60154303 0 0 0 0 1 0 0.0 0.0 0.0 0.0
23 Nigeria D 85.82096781 1.70911311 0.91086045 0 0 0 0 1 0 0.0 0.0 0.0 0.0
24 Ecuador C 58.02110024 0.48176173 3.55908929 0 0 0 0 1 0 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-20150620-180614" (
"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" REAL,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 46.182ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub