womens-world-cup-predictions/wwc-forecast-20150627-180119

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.91117028 3.83610853 0.38573816 1 0 0 0 0 1 1 1.0 0.56535 0.42215
2 USA D 95.10706105 3.50661101 0.38483612 1 0 0 0 0 1 1 1.0 0.43465 0.29775
3 Japan C 92.28069644 2.7423017 0.5306097 1 0 0 0 0 1 1 1.0 0.57945 0.17445
4 Canada A 89.38687548 2.15745594 0.65064558 1 0 0 0 0 1 1 0.5712 0.25515 0.0712
5 England F 89.47639786 2.27399506 0.75713592 0 1 0 0 0 1 1 0.4288 0.1654 0.03445
6 Australia D 89.21537319 2.33338414 0.88335857 0 1 0 0 0 1 1 0.0 0.0 0.0
7 France F 92.46235297 2.86093906 0.60601447 1 0 0 0 0 1 1 0.0 0.0 0.0
8 China A 85.30891474 1.45318608 0.73177495 0 1 0 0 0 1 1 0.0 0.0 0.0
9 Norway B 88.91578187 2.21028539 0.81739648 0 1 0 0 0 1 0 0.0 0.0 0.0
10 Brazil E 91.6996198 2.59698037 0.53873627 1 0 0 0 0 1 0 0.0 0.0 0.0
11 Cameroon C 81.17715458 1.2931502 1.27052755 0 1 0 0 0 1 0 0.0 0.0 0.0
12 Colombia F 80.25637321 1.07962595 1.18497741 0 0 1 0 0 1 0 0.0 0.0 0.0
13 Netherlands A 86.36490082 1.88093065 0.99759666 0 0 1 0 0 1 0 0.0 0.0 0.0
14 Sweden D 91.34239078 2.68155163 0.73030129 0 0 1 0 0 1 0 0.0 0.0 0.0
15 South Korea E 83.19027875 1.68205142 1.36173246 0 1 0 0 0 1 0 0.0 0.0 0.0
16 Switzerland C 83.70552499 1.87747766 1.48668304 0 0 1 0 0 1 0 0.0 0.0 0.0
17 Spain E 83.45531886 1.46231587 1.07551365 0 0 0 0 1 0 0 0.0 0.0 0.0
18 Thailand B 68.34112618 0.89817858 2.70792608 0 0 0 1 0 0 0 0.0 0.0 0.0
19 New Zealand A 82.83065443 1.48348835 1.20540685 0 0 0 0 1 0 0 0.0 0.0 0.0
20 Ivory Coast B 71.86721792 1.38015469 2.75856809 0 0 0 0 1 0 0 0.0 0.0 0.0
21 Costa Rica E 74.73539729 0.93512845 1.86500208 0 0 0 1 0 0 0 0.0 0.0 0.0
22 Mexico F 80.40433934 1.48532835 1.60553124 0 0 0 0 1 0 0 0.0 0.0 0.0
23 Nigeria D 85.86513726 1.71697529 0.91542623 0 0 0 0 1 0 0 0.0 0.0 0.0
24 Ecuador C 57.69963036 0.48754526 3.60652575 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-20150627-180119" (
"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 28.939ms