womens-world-cup-predictions/wwc-forecast-20150705-205539

24 rows

View and edit SQL

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

group_second

  • 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 USA D 95.63772683 3.72060494 0.3844409 1 0 0 0 0 1 1 1 1 1
2 Japan C 92.48656821 2.85151854 0.58661748 1 0 0 0 0 1 1 1 1 0
3 Germany B 95.34941382 3.61346515 0.3966634 1 0 0 0 0 1 1 1 0 0
4 England F 89.9094553 2.34198677 0.72700829 1 0 0 0 0 1 1 1 0 0
5 Australia D 89.1937513 2.3222276 0.87491862 0 1 0 0 0 1 1 0 0 0
6 France F 92.39050827 2.84257721 0.60593554 0 1 0 0 0 1 1 0 0 0
7 China A 85.2966142 1.45066504 0.73044386 0 1 0 0 0 1 1 0 0 0
8 Canada A 89.24633242 2.15013955 0.67428507 1 0 0 0 0 1 1 0 0 0
9 Cameroon C 81.14726598 1.28555215 1.26646929 0 1 0 0 0 1 0 0 0 0
10 Norway B 88.96149976 2.2171047 0.81332603 0 1 0 0 0 1 0 0 0 0
11 Sweden D 91.27760318 2.67313719 0.73732785 0 0 1 0 0 1 0 0 0 0
12 Colombia F 80.32179255 1.08830127 1.1834853 0 0 1 0 0 1 0 0 0 0
13 Netherlands A 86.32386562 1.87287374 0.99592841 0 0 1 0 0 1 0 0 0 0
14 Brazil E 91.6508985 2.59019463 0.54337599 1 0 0 0 0 1 0 0 0 0
15 South Korea E 83.17886628 1.68173287 1.36262542 0 1 0 0 0 1 0 0 0 0
16 Switzerland C 83.69169363 1.87480487 1.48542074 0 0 1 0 0 1 0 0 0 0
17 Spain E 83.4556343 1.46285844 1.07532064 0 0 0 0 1 0 0 0 0 0
18 Thailand B 68.27938091 0.89297622 2.71046759 0 0 0 1 0 0 0 0 0 0
19 New Zealand A 82.820177 1.47817271 1.20066419 0 0 0 0 1 0 0 0 0 0
20 Ivory Coast B 71.65816258 1.37909096 2.78607594 0 0 0 0 1 0 0 0 0 0
21 Costa Rica E 74.76121893 0.93512152 1.86093246 0 0 0 1 0 0 0 0 0 0
22 Mexico F 80.4941388 1.48666003 1.59203496 0 0 0 0 1 0 0 0 0 0
23 Nigeria D 85.83672106 1.71686858 0.91985464 0 0 0 0 1 0 0 0 0 0
24 Ecuador C 57.67291988 0.4842065 3.60637595 0 0 0 0 1 0 0 0 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150705-205539" (
"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" INTEGER
);
Powered by Datasette · Query took 33.159ms