womens-world-cup-predictions/wwc-forecast-20150626-212544

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.90624128 3.83608612 0.38579271 1 0 0 0 0 1 1 1.0 0.56815 0.42805
2 USA D 95.09991272 3.50513455 0.38409866 1 0 0 0 0 1 1 1.0 0.43185 0.30105
3 Japan C 92.30697264 2.77306773 0.55489785 1 0 0 0 0 1 1 0.62675 0.3641 0.1158
4 Canada A 89.38022145 2.15701999 0.65045921 1 0 0 0 0 1 1 0.5624 0.27595 0.07435
5 England F 89.4700273 2.27382028 0.75716815 0 1 0 0 0 1 1 0.4376 0.18875 0.04175
6 Australia D 89.49375488 2.40798969 0.89845767 0 1 0 0 0 1 1 0.37325 0.1712 0.039
7 France F 92.45547366 2.86035316 0.60579991 1 0 0 0 0 1 1 0.0 0.0 0.0
8 China A 85.29538008 1.45196847 0.73205398 0 1 0 0 0 1 1 0.0 0.0 0.0
9 Norway B 88.90017494 2.20611072 0.81513365 0 1 0 0 0 1 0 0.0 0.0 0.0
10 Brazil E 91.69531573 2.59449794 0.53568615 1 0 0 0 0 1 0 0.0 0.0 0.0
11 Cameroon C 81.15516903 1.28988726 1.26984845 0 1 0 0 0 1 0 0.0 0.0 0.0
12 Colombia F 80.2403625 1.07996998 1.18725631 0 0 1 0 0 1 0 0.0 0.0 0.0
13 Netherlands A 86.35140306 1.87854532 0.99665716 0 0 1 0 0 1 0 0.0 0.0 0.0
14 Sweden D 91.33791418 2.68103029 0.72945133 0 0 1 0 0 1 0 0.0 0.0 0.0
15 South Korea E 83.18705846 1.68162498 1.36103608 0 1 0 0 0 1 0 0.0 0.0 0.0
16 Switzerland C 83.69584445 1.87673669 1.48675124 0 0 1 0 0 1 0 0.0 0.0 0.0
17 Spain E 83.45912309 1.46402223 1.07592992 0 0 0 0 1 0 0 0.0 0.0 0.0
18 Thailand B 68.3371111 0.89820857 2.70825714 0 0 0 1 0 0 0 0.0 0.0 0.0
19 New Zealand A 82.82535056 1.48295727 1.20496165 0 0 0 0 1 0 0 0.0 0.0 0.0
20 Ivory Coast B 71.8652506 1.380736 2.75912616 0 0 0 0 1 0 0 0.0 0.0 0.0
21 Costa Rica E 74.73363007 0.93534359 1.86505023 0 0 0 1 0 0 0 0.0 0.0 0.0
22 Mexico F 80.39914327 1.48523699 1.60561017 0 0 0 0 1 0 0 0.0 0.0 0.0
23 Nigeria D 85.87150724 1.71677561 0.91302836 0 0 0 0 1 0 0 0.0 0.0 0.0
24 Ecuador C 57.67961095 0.48582571 3.60713515 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-20150626-212544" (
"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 24.17ms