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

24 rows sorted by group_third_no_advance

View and edit SQL

Suggested facets: group, group_first, group_third_no_advance, sixteen, quarter, semi, final, win

group_third_advance

  • 0 20
  • 1 4

group_second

  • 0 18
  • 1 6

group_fourth

  • 0 18
  • 1 6
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.9083266 3.83584248 0.38574992 1 0 0 0 0 1 1 1 0.56515 0.4257
2 USA D 95.10437316 3.50649052 0.38484998 1 0 0 0 0 1 1 1 0.43485 0.3043
3 Japan C 92.27370242 2.74118592 0.53070182 1 0 0 0 0 1 1 1 0.60445 0.18245
4 England F 89.82047907 2.34203662 0.74917098 1 0 0 0 0 1 1 1 0.39555 0.08755
5 Australia D 89.21394219 2.33337534 0.8830936 0 1 0 0 0 1 1 0 0.0 0.0
6 France F 92.46354832 2.86166617 0.60567606 0 1 0 0 0 1 1 0 0.0 0.0
7 China A 85.29942131 1.45211907 0.73194131 0 1 0 0 0 1 1 0 0.0 0.0
8 Canada A 89.17113501 2.1403993 0.6817502 1 0 0 0 0 1 1 0 0.0 0.0
9 Cameroon C 81.17396015 1.2930853 1.27064268 0 1 0 0 0 1 0 0 0.0 0.0
10 Norway B 88.92239869 2.21078224 0.81587755 0 1 0 0 0 1 0 0 0.0 0.0
11 Sweden D 91.33973649 2.68134434 0.73009993 0 0 1 0 0 1 0 0 0.0 0.0
12 Colombia F 80.27718112 1.08058037 1.18239688 0 0 1 0 0 1 0 0 0.0 0.0
13 Netherlands A 86.34608812 1.87815344 0.9978009 0 0 1 0 0 1 0 0 0.0 0.0
14 Brazil E 91.69694808 2.59696875 0.53875528 1 0 0 0 0 1 0 0 0.0 0.0
15 South Korea E 83.18278313 1.68140824 1.36193804 0 1 0 0 0 1 0 0 0.0 0.0
16 Switzerland C 83.69328815 1.87620758 1.48703797 0 0 1 0 0 1 0 0 0.0 0.0
17 Spain E 83.45514212 1.46247771 1.07533874 0 0 0 0 1 0 0 0 0.0 0.0
19 New Zealand A 82.81893278 1.48216959 1.20557594 0 0 0 0 1 0 0 0 0.0 0.0
20 Ivory Coast B 71.86541926 1.38012965 2.75860767 0 0 0 0 1 0 0 0 0.0 0.0
22 Mexico F 80.41864939 1.48574836 1.60338125 0 0 0 0 1 0 0 0 0.0 0.0
23 Nigeria D 85.8629464 1.71701819 0.91543867 0 0 0 0 1 0 0 0 0.0 0.0
24 Ecuador C 57.6982561 0.48768945 3.60683902 0 0 0 0 1 0 0 0 0.0 0.0
18 Thailand B 68.33961893 0.89820883 2.70802025 0 0 0 1 0 0 0 0 0.0 0.0
21 Costa Rica E 74.73388958 0.93516523 1.86503702 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-213532" (
"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" REAL,
  "win" REAL
);
Powered by Datasette · Query took 25.213ms