womens-world-cup-predictions/wwc-forecast-20150616-220036

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.19232528 3.55931889 0.40227154 1.0 0.0 0.0 0.0 0.0 1.0 0.876 0.78945 0.43765 0.30305
2 Germany B 95.70674347 3.75464601 0.38800309 1.0 0.0 0.0 0.0 0.0 1.0 0.75205 0.6306 0.38845 0.29105
3 Japan C 92.22739288 2.74819308 0.54845613 1.0 0.0 0.0 0.0 0.0 1.0 0.7291 0.39585 0.23245 0.08385
4 Brazil E 92.22172419 2.74977373 0.55185607 1.0 0.0 0.0 0.0 0.0 1.0 0.6259 0.35035 0.2066 0.0751
5 Canada A 89.49340802 2.20497392 0.67344236 1.0 0.0 0.0 0.0 0.0 1.0 0.75625 0.4264 0.2025 0.0657
6 France F 91.87435461 2.76054881 0.66419654 0.27435 0.48335 0.13305 5e-05 0.1092 0.89075 0.5644 0.28315 0.1391 0.05825
7 Sweden D 91.36886605 2.65921331 0.69426378 0.0 0.0 0.95565 0.04435 0.0 0.95565 0.2424 0.15585 0.0595 0.03145
8 Norway B 89.03360239 2.2176068 0.79454575 0.0 1.0 0.0 0.0 0.0 1.0 0.52435 0.25 0.1042 0.0264
9 Australia D 89.28110473 2.40954944 0.94737365 0.0 1.0 0.0 0.0 0.0 1.0 0.3741 0.16725 0.08095 0.02475
10 England F 89.23662546 2.20757993 0.736598 0.50985 0.17115 0.3004 0.0171 0.0015 0.9814 0.501 0.1676 0.055 0.02045
11 Netherlands A 86.26324093 1.85907987 0.98979517 0.0 0.0 1.0 0.0 0.0 1.0 0.2668 0.0849 0.0307 0.006
12 China A 85.26116472 1.49010564 0.77729157 0.0 1.0 0.0 0.0 0.0 1.0 0.6082 0.08875 0.01585 0.0046
13 Switzerland C 83.85396953 1.9482125 1.53453768 0.0 0.0 1.0 0.0 0.0 1.0 0.24375 0.08195 0.0234 0.0039
14 Spain E 83.9137678 1.48393407 1.01573292 0.0 0.54025 0.0127 0.07945 0.3676 0.55295 0.19175 0.02555 0.0056 0.0019
15 Cameroon C 81.48012363 1.34791808 1.2775748 0.0 1.0 0.0 0.0 0.0 1.0 0.3918 0.0424 0.0063 0.0016
16 South Korea E 83.29040321 1.67766435 1.3361197 0.0 0.35475 0.01285 0.12775 0.50465 0.3676 0.1249 0.017 0.0038 0.00095
17 Colombia F 80.05031552 1.05180413 1.18383667 0.2158 0.2663 0.5179 0.0 0.0 1.0 0.1835 0.03345 0.0056 0.00075
18 Mexico F 81.27941922 1.5448733 1.52601912 0.0 0.0792 0.0315 0.0 0.8893 0.1107 0.026 0.00835 0.0023 0.00025
19 Costa Rica E 74.44914809 0.9813485 1.95405133 0.0 0.105 0.03595 0.7313 0.12775 0.14095 0.01775 0.00115 5e-05 0.0
20 Thailand B 68.31171641 0.89879575 2.71000752 0.0 0.0 5e-05 0.99995 0.0 5e-05 0.0 0.0 0.0 0.0
21 New Zealand A 82.78190603 1.47396666 1.19966862 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
22 Ivory Coast B 71.83744045 1.38339557 2.76356598 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
23 Nigeria D 85.86524905 1.71642825 0.91092507 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
24 Ecuador C 57.99890123 0.48321362 3.5634142 0.0 0.0 0.0 0.0 1.0 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-20150616-220036" (
"team" TEXT,
  "group" TEXT,
  "wspi" REAL,
  "wspi_offense" REAL,
  "wspi_defense" REAL,
  "group_first" REAL,
  "group_second" REAL,
  "group_third_advance" REAL,
  "group_third_no_advance" REAL,
  "group_fourth" REAL,
  "sixteen" REAL,
  "quarter" REAL,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 26.336ms