2014 World Cup Tournament Predictions: wc-20140630-223910.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
24 rows where win_group = 0
This data as json, copyable, CSV (advanced)
Suggested facets: 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 | 74.95 | 2.0782 | 1.2187 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 |
3 | 3 | Australia | AUS | b | 67.43 | 1.6909 | 1.4162 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
5 | 5 | Bosnia and Herzegovina | BIH | f | 80.41 | 2.2765 | 0.9615 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
7 | 7 | Chile | CHI | b | 86.39 | 2.5145 | 0.6159 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 |
8 | 8 | Ivory Coast | CIV | c | 78.4 | 2.251 | 1.0953 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
9 | 9 | Cameroon | CMR | a | 68.1 | 1.4603 | 1.1834 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
12 | 12 | Croatia | CRO | a | 77.87 | 2.0393 | 0.9843 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
13 | 13 | Ecuador | ECU | e | 80.12 | 1.7802 | 0.6397 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
14 | 14 | England | ENG | d | 81.04 | 2.0534 | 0.7611 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
15 | 15 | Spain | ESP | b | 86.27 | 2.4989 | 0.6176 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
18 | 18 | Ghana | GHA | g | 78.32 | 1.9857 | 0.9136 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
19 | 19 | Greece | GRE | c | 74.85 | 1.1864 | 0.5541 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 |
20 | 20 | Honduras | HON | e | 65.74 | 1.4357 | 1.308 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
21 | 21 | Iran | IRN | f | 69.41 | 1.1067 | 0.8145 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
22 | 22 | Italy | ITA | d | 78.39 | 1.8134 | 0.7858 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
23 | 23 | Japan | JPN | c | 72.85 | 2.0303 | 1.3274 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
24 | 24 | South Korea | KOR | h | 64.81 | 1.5079 | 1.4276 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
25 | 25 | Mexico | MEX | a | 79.9 | 1.63 | 0.5497 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 |
27 | 27 | Nigeria | NGA | f | 77.11 | 1.696 | 0.7895 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 |
28 | 28 | Portugal | POR | g | 79.88 | 2.1724 | 0.9304 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
29 | 29 | Russia | RUS | h | 76.4 | 1.4356 | 0.6446 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 |
30 | 30 | Switzerland | SUI | e | 79.73 | 2.2659 | 1.0059 | 0 | 1 | 0.222313840551778 | 0.106734114588824 | 0.037245381629818 | 0.006818953480146 |
31 | 31 | Uruguay | URU | d | 80.87 | 2.0924 | 0.8006 | 0 | 1 | 0.0 | 0.0 | 0.0 | 0.0 |
32 | 32 | USA | USA | g | 78.6 | 2.0285 | 0.9242 | 0 | 1 | 0.411279604021571 | 0.10656275909963 | 0.034223308651402 | 0.005617043875399 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "world-cup-predictions/wc-20140630-223910" ( "country" TEXT, "country_id" TEXT, "group" TEXT, "spi" REAL, "spi_offense" REAL, "spi_defense" REAL, "win_group" INTEGER, "sixteen" INTEGER, "quarter" REAL, "semi" REAL, "cup" REAL, "win" REAL );