womens-world-cup-predictions/wwc-forecast-20150701-205548

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 USA D 95.26520562 3.55118306 0.36726221 1 0 0 0 0 1 1 1 1 0.67485
2 Japan C 92.36959983 2.76685631 0.53095113 1 0 0 0 0 1 1 1 1 0.32515
3 Germany B 95.63652448 3.73205647 0.40030886 1 0 0 0 0 1 1 1 0 0.0
4 England F 89.80172147 2.34833905 0.76095023 1 0 0 0 0 1 1 1 0 0.0
5 Australia D 89.24834659 2.33578519 0.87807712 0 1 0 0 0 1 1 0 0 0.0
6 France F 92.41503258 2.84996955 0.60825051 0 1 0 0 0 1 1 0 0 0.0
7 China A 85.30920193 1.45334141 0.73158414 0 1 0 0 0 1 1 0 0 0.0
8 Canada A 89.2190125 2.14424642 0.67518889 1 0 0 0 0 1 1 0 0 0.0
9 Cameroon C 81.1877656 1.29298273 1.26830474 0 1 0 0 0 1 0 0 0 0.0
10 Norway B 88.9441622 2.21388282 0.81467446 0 1 0 0 0 1 0 0 0 0.0
11 Sweden D 91.32379808 2.68026656 0.73383979 0 0 1 0 0 1 0 0 0 0.0
12 Colombia F 80.30175776 1.08225146 1.18031641 0 0 1 0 0 1 0 0 0 0.0
13 Netherlands A 86.34617581 1.8775047 0.99724454 0 0 1 0 0 1 0 0 0 0.0
14 Brazil E 91.66029841 2.58927689 0.54115961 1 0 0 0 0 1 0 0 0 0.0
15 South Korea E 83.1825934 1.68156906 1.36221138 0 1 0 0 0 1 0 0 0 0.0
16 Switzerland C 83.70204014 1.87699996 1.48645658 0 0 1 0 0 1 0 0 0 0.0
17 Spain E 83.45374167 1.46219154 1.07533868 0 0 0 0 1 0 0 0 0 0.0
18 Thailand B 68.32218202 0.89766203 2.70970757 0 0 0 1 0 0 0 0 0 0.0
19 New Zealand A 82.82413891 1.4817329 1.20427441 0 0 0 0 1 0 0 0 0 0.0
20 Ivory Coast B 71.77227437 1.37883261 2.76995171 0 0 0 0 1 0 0 0 0 0.0
21 Costa Rica E 74.7435253 0.93582956 1.86423336 0 0 0 1 0 0 0 0 0 0.0
22 Mexico F 80.4633014 1.48703896 1.59765224 0 0 0 0 1 0 0 0 0 0.0
23 Nigeria D 85.87399594 1.71990924 0.91663154 0 0 0 0 1 0 0 0 0 0.0
24 Ecuador C 57.70653048 0.48791498 3.60608278 0 0 0 0 1 0 0 0 0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150701-205548" (
"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" INTEGER,
  "final" INTEGER,
  "win" REAL
);
Powered by Datasette · Query took 33.797ms