womens-world-cup-predictions/wwc-forecast-20150617-210614

24 rows

View and edit SQL

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

group

group_third_advance

  • 0 20
  • 1 4
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 USA D 95.19397959 3.56046321 0.40327438 1 0 0 0 0 1 0.95115 0.85055 0.46705 0.32815
2 Germany B 95.70346004 3.7528398 0.38785835 1 0 0 0 0 1 0.74075 0.55435 0.3352 0.2533
3 Japan C 92.25542615 2.75302043 0.54581278 1 0 0 0 0 1 0.7292 0.40055 0.24175 0.0861
4 Brazil E 92.02669906 2.68099217 0.53387174 1 0 0 0 0 1 0.6165 0.34035 0.20535 0.07445
5 Canada A 89.49226634 2.20496259 0.67409607 1 0 0 0 0 1 0.75055 0.4382 0.2125 0.0683
6 France F 92.2651622 2.83885484 0.63691501 1 0 0 0 0 1 0.7998 0.28605 0.1192 0.0673
7 Sweden D 91.38160016 2.66307181 0.69533274 0 0 1 0 0 1 0.25925 0.1363 0.0521 0.02795
8 Norway B 89.03727714 2.21691417 0.79334914 0 1 0 0 0 1 0.49635 0.2323 0.09545 0.026
9 England F 89.19946569 2.2210224 0.76035207 0 1 0 0 0 1 0.50365 0.2458 0.1037 0.02545
10 Australia D 89.27714493 2.40909078 0.94819411 0 1 0 0 0 1 0.3835 0.17205 0.0848 0.0245
11 Netherlands A 86.24636722 1.85552198 0.98963472 0 0 1 0 0 1 0.2708 0.08705 0.03475 0.00675
12 China A 85.27256894 1.49052318 0.77602754 0 1 0 0 0 1 0.6173 0.09045 0.01535 0.00435
13 Switzerland C 83.78797092 1.94132612 1.53894582 0 0 1 0 0 1 0.24945 0.0837 0.0217 0.0039
14 Cameroon C 81.48187359 1.3478804 1.27763597 0 1 0 0 0 1 0.3827 0.03825 0.00415 0.0014
15 South Korea E 83.73319453 1.74517965 1.3337663 0 1 0 0 0 1 0.2002 0.0233 0.00445 0.00125
16 Colombia F 80.28686753 1.10514638 1.20508317 0 0 1 0 0 1 0.04885 0.02075 0.0025 0.00085
17 New Zealand A 82.78756556 1.47428696 1.19945697 0 0 0 0 1 0 0.0 0.0 0.0 0.0
18 Thailand B 68.35111448 0.89736657 2.70349166 0 0 0 1 0 0 0.0 0.0 0.0 0.0
19 Spain E 83.46439344 1.46549686 1.07421634 0 0 0 0 1 0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.83719724 1.38377277 2.76430911 0 0 0 0 1 0 0.0 0.0 0.0 0.0
21 Costa Rica E 74.76881634 0.93763309 1.86021923 0 0 0 1 0 0 0.0 0.0 0.0 0.0
22 Mexico F 80.41636803 1.486867 1.60229443 0 0 0 0 1 0 0.0 0.0 0.0 0.0
23 Nigeria D 85.86600561 1.7161016 0.91082785 0 0 0 0 1 0 0.0 0.0 0.0 0.0
24 Ecuador C 58.03406445 0.48170908 3.55755304 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-20150617-210614" (
"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 34.446ms