womens-world-cup-predictions/wwc-forecast-20150606-200029

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

24 rows

View and edit SQL

Suggested facets: group, group_second, 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.37189465 3.6707389 0.4333782 0.65075 0.2314 0.07875 0.0125 0.0266 0.9609 0.8074 0.65755 0.4203 0.28165
2 Germany B 95.62013758 3.74872162 0.40648384 0.836 0.15695 0.0063 0.00055 0.0002 0.99925 0.82115 0.6184 0.3991 0.2769
3 Japan C 92.68390203 2.89955856 0.56491442 0.7918 0.17305 0.0312 0.00255 0.0014 0.99605 0.79325 0.40815 0.22525 0.09165
4 Canada A 90.05495863 2.34027492 0.67870789 0.7025 0.21915 0.06155 0.0046 0.0122 0.9832 0.7316 0.39395 0.1881 0.0737
5 France F 92.43208926 2.87306335 0.61296943 0.60285 0.29195 0.0711 0.0129 0.0212 0.9659 0.6668 0.31455 0.15725 0.07365
6 Brazil E 92.24387196 2.81346244 0.60427981 0.69465 0.21845 0.06715 0.0082 0.01155 0.98025 0.50965 0.2785 0.1525 0.06085
7 Sweden D 91.62190282 2.69617142 0.65496404 0.2106 0.37285 0.19885 0.06785 0.14985 0.7823 0.44905 0.27275 0.1274 0.05165
8 England F 89.57669066 2.28454475 0.73304904 0.3152 0.4359 0.14265 0.03905 0.0672 0.89375 0.47785 0.19915 0.07625 0.02635
9 Norway B 88.73823352 2.19466519 0.82794379 0.15745 0.6976 0.0956 0.03265 0.0167 0.95065 0.46675 0.21375 0.0787 0.0204
10 Australia D 88.75910055 2.35241747 0.99599627 0.0936 0.2519 0.24675 0.10905 0.2987 0.59225 0.25705 0.1324 0.0522 0.01615
11 Netherlands A 86.22835138 1.92024301 1.05394839 0.1758 0.3186 0.20795 0.0734 0.22425 0.70235 0.3367 0.10195 0.0293 0.0076
12 Nigeria D 85.74639196 1.66362499 0.86641079 0.04505 0.14385 0.18455 0.1017 0.52485 0.37345 0.12335 0.0497 0.01485 0.00365
13 Spain E 84.69088189 1.61997836 1.01565825 0.1508 0.36255 0.2572 0.09185 0.1376 0.77055 0.19845 0.0537 0.01465 0.0036
14 Switzerland C 83.6780724 1.88391892 1.486003 0.146 0.49205 0.238 0.0746 0.04935 0.87605 0.3437 0.07575 0.0164 0.00325
15 South Korea E 84.23227471 1.75456506 1.24638671 0.14235 0.34735 0.26625 0.1009 0.14315 0.75595 0.1793 0.0524 0.0126 0.00295
16 China A 85.08595197 1.44672278 0.75308229 0.04165 0.2587 0.26065 0.1015 0.3375 0.561 0.21715 0.05415 0.0132 0.0026
17 New Zealand A 82.4940893 1.47563305 1.24111596 0.08005 0.20355 0.19895 0.0914 0.42605 0.48255 0.17635 0.0397 0.007 0.0014
18 Mexico F 81.08805665 1.52740328 1.52955794 0.0552 0.1638 0.25995 0.14865 0.3724 0.47895 0.11355 0.02845 0.0059 0.0008
19 Cameroon C 79.23694175 1.11525673 1.37272715 0.06115 0.3053 0.35225 0.1527 0.1286 0.7187 0.1796 0.02905 0.00465 0.0007
20 Colombia F 78.03260801 0.8709203 1.29108406 0.02675 0.10835 0.19665 0.12905 0.5392 0.33175 0.06205 0.0135 0.0026 0.0003
21 Ivory Coast B 75.53668836 1.44970877 2.30045465 0.00615 0.11585 0.2873 0.28545 0.30525 0.4093 0.0613 0.01015 0.0016 0.00015
22 Costa Rica E 72.79207702 0.82480634 2.01108448 0.0122 0.07165 0.1175 0.09095 0.7077 0.20135 0.01485 0.0015 0.00015 5e-05
23 Thailand B 68.0154265 0.91594939 2.76167334 0.0004 0.0296 0.10695 0.1852 0.67785 0.13695 0.0081 0.00065 5e-05 0.0
24 Ecuador C 63.34306299 0.48711953 2.89257853 0.00105 0.0296 0.06595 0.08275 0.82065 0.0966 0.005 0.0002 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150606-200029" (
"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 46.753ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub