womens-world-cup-predictions/wwc-forecast-20150622-215702

24 rows sorted by group_third_no_advance

View and edit SQL

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

sixteen

  • 1 16
  • 0 8
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.98752634 3.87844074 0.39069387 1 0 0 0 0 1 1.0 0.71165 0.43255 0.33945
2 USA D 95.17233893 3.54483776 0.39484166 1 0 0 0 0 1 1.0 0.87795 0.4346 0.3193
3 Japan C 92.27341791 2.75941178 0.54833119 1 0 0 0 0 1 0.7359 0.4649 0.27 0.0884
4 Canada A 89.39646289 2.16119816 0.65009751 1 0 0 0 0 1 1.0 0.572 0.29865 0.0829
5 France F 92.46148661 2.87144076 0.61451971 1 0 0 0 0 1 1.0 0.28835 0.11615 0.06785
6 Australia D 89.48328917 2.40614215 0.89778695 0 1 0 0 0 1 1.0 0.4257 0.1954 0.0454
7 England F 89.45125672 2.27099929 0.75739245 0 1 0 0 0 1 1.0 0.428 0.1955 0.04395
8 Netherlands A 86.27200633 1.85810628 0.9891554 0 0 1 0 0 1 0.2641 0.1094 0.04045 0.00675
9 China A 85.39438945 1.48389299 0.74778985 0 1 0 0 0 1 1.0 0.12205 0.0167 0.006
10 Colombia F 80.23010753 1.07484828 1.18281106 0 0 1 0 0 1 0.0 0.0 0.0 0.0
11 Norway B 88.89538742 2.20582112 0.81485364 0 1 0 0 0 1 0.0 0.0 0.0 0.0
12 Sweden D 91.32207182 2.67633498 0.72725221 0 0 1 0 0 1 0.0 0.0 0.0 0.0
13 Cameroon C 81.16004997 1.29032084 1.2690225 0 1 0 0 0 1 0.0 0.0 0.0 0.0
14 Brazil E 91.68798883 2.59354799 0.53524316 1 0 0 0 0 1 0.0 0.0 0.0 0.0
15 South Korea E 83.18423079 1.68040074 1.35958492 0 1 0 0 0 1 0.0 0.0 0.0 0.0
16 Switzerland C 83.6928993 1.87679257 1.48670378 0 0 1 0 0 1 0.0 0.0 0.0 0.0
17 Spain E 83.45481192 1.46409277 1.07614329 0 0 0 0 1 0 0.0 0.0 0.0 0.0
19 New Zealand A 82.82440642 1.48157353 1.20303066 0 0 0 0 1 0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.89372246 1.38069797 2.75499949 0 0 0 0 1 0 0.0 0.0 0.0 0.0
22 Mexico F 80.42628412 1.48580321 1.60140696 0 0 0 0 1 0 0.0 0.0 0.0 0.0
23 Nigeria D 85.84723606 1.71213207 0.91184131 0 0 0 0 1 0 0.0 0.0 0.0 0.0
24 Ecuador C 57.6762919 0.48658135 3.60826012 0 0 0 0 1 0 0.0 0.0 0.0 0.0
18 Thailand B 68.3620899 0.89757892 2.70408301 0 0 0 1 0 0 0.0 0.0 0.0 0.0
21 Costa Rica E 74.73527574 0.93515599 1.86444569 0 0 0 1 0 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-20150622-215702" (
"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.816ms