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

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

24 rows

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
1 Germany B 95.93792723 3.88094256 0.38856526 0.8908 0.1083 0.00085 5e-05 0.0 0.99995 0.8415 0.65245 0.43645 0.31135
2 USA D 95.34577735 3.67160326 0.43359268 0.69355 0.18915 0.07135 0.01105 0.0349 0.95405 0.80695 0.66245 0.3974 0.26625
3 Japan C 92.69064994 2.90306817 0.56145387 0.72875 0.2079 0.06035 0.0027 0.0003 0.997 0.7692 0.39775 0.22135 0.0875
4 Canada A 90.0379057 2.33863332 0.67879252 0.69855 0.22535 0.0607 0.0037 0.0117 0.9846 0.73485 0.39215 0.19165 0.0756
5 France F 92.41683073 2.87356435 0.613163 0.60155 0.29255 0.075 0.01235 0.01855 0.9691 0.66375 0.2967 0.1433 0.06355
6 Brazil E 92.1985986 2.80584988 0.60458384 0.69655 0.2171 0.0658 0.00925 0.0113 0.97945 0.51905 0.28235 0.157 0.0629
7 Sweden D 91.64510749 2.7669115 0.7222455 0.14565 0.3523 0.16055 0.15085 0.19065 0.6585 0.368 0.2218 0.10595 0.0419
8 England F 89.57239005 2.28535534 0.73303018 0.3176 0.4338 0.1474 0.0398 0.0614 0.8988 0.4777 0.19685 0.07645 0.0248
9 Norway B 88.92240139 2.21081693 0.8037218 0.10865 0.8422 0.0424 0.00675 0.0 0.99325 0.50025 0.23555 0.0896 0.0212
10 Australia D 88.78652903 2.35818682 0.99583049 0.11005 0.26195 0.2031 0.07905 0.34585 0.5751 0.23655 0.1223 0.04525 0.0139
11 Netherlands A 86.3586733 1.89758303 1.00659781 0.2409 0.4188 0.24525 0.04 0.05505 0.90495 0.44705 0.1343 0.03865 0.0101
12 Nigeria D 86.60256362 1.86296534 0.92006627 0.05075 0.1966 0.1758 0.14825 0.4286 0.42315 0.1396 0.059 0.0202 0.00595
13 Spain E 84.71566263 1.62047535 1.01572394 0.15105 0.3622 0.2592 0.0892 0.13835 0.77245 0.1935 0.0529 0.01365 0.0035
14 South Korea E 84.2680232 1.75462579 1.24428067 0.14085 0.34815 0.2709 0.09565 0.14445 0.7599 0.17815 0.04835 0.01325 0.00315
15 Switzerland C 83.68968372 1.88192381 1.48627652 0.1334 0.38585 0.39505 0.06985 0.01585 0.9143 0.3248 0.0774 0.01795 0.00295
16 China A 85.08745418 1.44440534 0.75413195 0.03975 0.27215 0.25825 0.1121 0.31775 0.57015 0.2236 0.05565 0.013 0.00255
17 Cameroon C 80.56539514 1.24722882 1.31289404 0.1378 0.40555 0.4451 0.011 0.00055 0.98845 0.27055 0.0499 0.0085 0.0011
18 Mexico F 81.11271552 1.5264817 1.53003372 0.0556 0.16735 0.27625 0.1332 0.3676 0.4992 0.11795 0.02755 0.0051 0.00085
19 New Zealand A 82.20347034 1.40702569 1.2194893 0.0208 0.0837 0.2005 0.0795 0.6155 0.305 0.08325 0.018 0.00295 0.00065
20 Colombia F 77.89752486 0.85403823 1.2999987 0.02525 0.1063 0.197 0.119 0.55245 0.32855 0.05895 0.012 0.002 0.0002
21 Costa Rica E 72.8466195 0.824785 2.01103605 0.01155 0.07255 0.1252 0.0848 0.7059 0.2093 0.0145 0.0016 0.0002 5e-05
22 Ivory Coast B 73.05618543 1.34705583 2.55334636 0.0004 0.0482 0.16865 0.3207 0.46205 0.21725 0.0257 0.0029 0.00015 0.0
23 Thailand B 67.4773809 0.87245726 2.79261745 0.0001 0.0013 0.0883 0.37235 0.53795 0.0897 0.0043 0.0001 0.0 0.0
24 Ecuador C 58.96720721 0.43366262 3.39071868 5e-05 0.0007 0.00705 0.0089 0.9833 0.0078 0.0003 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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