2014 World Cup Tournament Predictions: wc-20140709-095047.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
32 rows
This data as json, copyable, CSV (advanced)
Suggested facets: group, win_group, sixteen, quarter, semi, cup, win
Link | rowid ▼ | country | country_id | group | spi | spi_offense | spi_defense | win_group | sixteen | quarter | semi | cup | win |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | Algeria | ALG | h | 76.16 | 2.052 | 1.1136 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
2 | 2 | Argentina | ARG | f | 89.59 | 2.711 | 0.4079 | 1 | 1 | 1 | 1 | 0.568205442452069 | 0.221573190785292 |
3 | 3 | Australia | AUS | b | 67.18 | 1.6952 | 1.4354 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
4 | 4 | Belgium | BEL | h | 83.02 | 1.9872 | 0.5613 | 1 | 1 | 1 | 0 | 0.0 | 0.0 |
5 | 5 | Bosnia and Herzegovina | BIH | f | 80.32 | 2.288 | 0.9752 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
6 | 6 | Brazil | BRA | a | 88.59 | 3.0144 | 0.6982 | 1 | 1 | 1 | 1 | 0.0 | 0.0 |
7 | 7 | Chile | CHI | b | 86.08 | 2.4816 | 0.6211 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
8 | 8 | Ivory Coast | CIV | c | 78.33 | 2.2472 | 1.097 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
9 | 9 | Cameroon | CMR | a | 68.21 | 1.4583 | 1.1754 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
10 | 10 | Colombia | COL | c | 89.06 | 2.5956 | 0.3968 | 1 | 1 | 1 | 0 | 0.0 | 0.0 |
11 | 11 | Costa Rica | CRC | d | 78.38 | 1.4254 | 0.5066 | 1 | 1 | 1 | 0 | 0.0 | 0.0 |
12 | 12 | Croatia | CRO | a | 77.59 | 2.0176 | 0.9873 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
13 | 13 | Ecuador | ECU | e | 80.18 | 1.7985 | 0.6473 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
14 | 14 | England | ENG | d | 81.04 | 2.0512 | 0.7583 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
15 | 15 | Spain | ESP | b | 86.12 | 2.4992 | 0.6287 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
16 | 16 | France | FRA | e | 87.85 | 2.5769 | 0.5113 | 1 | 1 | 1 | 0 | 0.0 | 0.0 |
17 | 17 | Germany | GER | g | 91.36 | 3.3853 | 0.5849 | 1 | 1 | 1 | 1 | 1.0 | 0.638669842358573 |
18 | 18 | Ghana | GHA | g | 78.91 | 2.0298 | 0.9016 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
19 | 19 | Greece | GRE | c | 74.84 | 1.1949 | 0.561 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
20 | 20 | Honduras | HON | e | 65.54 | 1.4403 | 1.3249 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
21 | 21 | Iran | IRN | f | 69.38 | 1.1185 | 0.8258 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
22 | 22 | Italy | ITA | d | 78.41 | 1.8209 | 0.789 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
23 | 23 | Japan | JPN | c | 72.8 | 2.0351 | 1.3342 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
24 | 24 | South Korea | KOR | h | 65.26 | 1.5219 | 1.4116 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
25 | 25 | Mexico | MEX | a | 79.57 | 1.6152 | 0.5617 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
26 | 26 | Netherlands | NED | b | 87.4 | 2.7093 | 0.6367 | 1 | 1 | 1 | 1 | 0.431794557547931 | 0.139756966856135 |
27 | 27 | Nigeria | NGA | f | 76.23 | 1.6545 | 0.8175 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
28 | 28 | Portugal | POR | g | 80.3 | 2.1822 | 0.9043 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
29 | 29 | Russia | RUS | h | 76.57 | 1.45 | 0.6437 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
30 | 30 | Switzerland | SUI | e | 79.62 | 2.183 | 0.9556 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
31 | 31 | Uruguay | URU | d | 80.86 | 2.1078 | 0.8106 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
32 | 32 | USA | USA | g | 78.5 | 2.0192 | 0.9236 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "world-cup-predictions/wc-20140709-095047" ( "country" TEXT, "country_id" TEXT, "group" TEXT, "spi" REAL, "spi_offense" REAL, "spi_defense" REAL, "win_group" INTEGER, "sixteen" INTEGER, "quarter" INTEGER, "semi" INTEGER, "cup" REAL, "win" REAL );