womens-world-cup-predictions/wwc-forecast-20150608-235509

24 rows sorted by team

View and edit SQL

Suggested facets: group, group_fourth, 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
10 Australia D 88.81130327 2.37774597 1.01244558 0.01915 0.2519 0.23505 0.0836 0.4103 0.5061 0.1783 0.0856 0.0377 0.01155
6 Brazil E 92.20304783 2.80629249 0.60471356 0.69315 0.22275 0.06575 0.0077 0.01065 0.98165 0.5329 0.2846 0.1586 0.0605
17 Cameroon C 80.56865737 1.24722775 1.31289467 0.13445 0.45155 0.40505 0.0086 0.00035 0.99105 0.2844 0.04625 0.00795 0.00105
4 Canada A 90.0420391 2.33912161 0.679161 0.69835 0.22235 0.06505 0.0033 0.01095 0.98575 0.7529 0.3952 0.1872 0.0678
15 China A 85.09317063 1.44496289 0.75433206 0.03605 0.27065 0.2621 0.11025 0.32095 0.5688 0.2214 0.04825 0.0113 0.00235
20 Colombia F 77.90059968 0.85403887 1.2999991 0.02535 0.1029 0.19815 0.1186 0.555 0.3264 0.0547 0.01115 0.0015 0.0002
22 Costa Rica E 72.8524419 0.82461938 2.01043583 0.0104 0.0718 0.1222 0.08345 0.71215 0.2044 0.01245 0.00135 0.00015 0.0
24 Ecuador C 58.96834544 0.43366441 3.3907074 5e-05 0.0003 0.0087 0.0116 0.97935 0.00905 0.00015 0.0 0.0 0.0
9 England F 89.57469099 2.28507808 0.73300983 0.32155 0.4323 0.1462 0.0391 0.06085 0.90005 0.46575 0.1876 0.07455 0.02265
5 France F 92.42188356 2.87402685 0.61311111 0.6025 0.2915 0.0738 0.01125 0.02095 0.9678 0.6613 0.30405 0.14615 0.0674
1 Germany B 95.94164506 3.88160108 0.38861359 0.8901 0.1094 0.00045 5e-05 0.0 0.99995 0.85155 0.65895 0.42475 0.30825
21 Ivory Coast B 73.05950009 1.34703519 2.55326183 0.00025 0.04805 0.17195 0.32285 0.4569 0.22025 0.02215 0.00305 0.00025 0.0
3 Japan C 92.55498105 2.84089356 0.53616988 0.8576 0.1245 0.0178 0.0001 0.0 0.9999 0.79105 0.4137 0.23295 0.08685
19 Mexico F 81.11759201 1.526282 1.52955975 0.0506 0.1733 0.2791 0.1338 0.3632 0.503 0.1096 0.02625 0.00485 0.00045
11 Netherlands A 86.36259221 1.89771761 1.00666992 0.2449 0.41795 0.2458 0.0369 0.05445 0.90865 0.45015 0.12805 0.03715 0.00945
18 New Zealand A 82.20727934 1.40722945 1.21964101 0.0207 0.08905 0.19615 0.08045 0.61365 0.3059 0.0851 0.0174 0.00375 0.00065
12 Nigeria D 86.60542479 1.86296093 0.9201984 0.0383 0.2147 0.17745 0.16325 0.4063 0.43045 0.1356 0.05525 0.01855 0.0033
8 Norway B 88.9258991 2.21123156 0.80418016 0.1096 0.8418 0.04335 0.00525 0.0 0.99475 0.51065 0.23925 0.08965 0.02295
14 South Korea E 84.27156514 1.75454239 1.24417863 0.13755 0.34355 0.2789 0.09645 0.14355 0.76 0.17085 0.0461 0.0108 0.003
13 Spain E 84.71913892 1.62046735 1.01571946 0.1589 0.3619 0.2586 0.08695 0.13365 0.7794 0.1894 0.0487 0.0143 0.003
7 Sweden D 91.64736437 2.76718209 0.72284224 0.1248 0.3905 0.15 0.1581 0.1766 0.6653 0.36055 0.21475 0.10525 0.04195
16 Switzerland C 83.52083956 1.80659718 1.43382769 0.0079 0.42365 0.47795 0.0702 0.0203 0.9095 0.288 0.06245 0.0131 0.0023
23 Thailand B 67.47916807 0.87243906 2.7925564 0.0 0.00075 0.0891 0.36705 0.5431 0.08985 0.00375 0.00025 0.0 0.0
2 USA D 95.40339767 3.69765053 0.43756671 0.81775 0.1429 0.03135 0.0012 0.0068 0.992 0.86735 0.7218 0.41955 0.28435

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150608-235509" (
"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.359ms