2014 World Cup Tournament Predictions: wc-20140704-180211.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
24 rows where quarter = 0
This data as json, copyable, CSV (advanced)
Suggested facets: group, sixteen
Link | rowid ▼ | country | country_id | group | spi | spi_offense | spi_defense | win_group | sixteen | quarter | semi | cup | win |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | Algeria | ALG | h | 75.66 | 2.0226 | 1.1263 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
3 | 3 | Australia | AUS | b | 67.52 | 1.6931 | 1.4109 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
5 | 5 | Bosnia and Herzegovina | BIH | f | 80.29 | 2.2809 | 0.9722 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
7 | 7 | Chile | CHI | b | 86.41 | 2.5202 | 0.6154 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
8 | 8 | Ivory Coast | CIV | c | 78.39 | 2.2513 | 1.0945 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
9 | 9 | Cameroon | CMR | a | 68.18 | 1.4673 | 1.1835 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
12 | 12 | Croatia | CRO | a | 77.91 | 2.0451 | 0.9837 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
13 | 13 | Ecuador | ECU | e | 80.23 | 1.7942 | 0.6404 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
14 | 14 | England | ENG | d | 81.06 | 2.0548 | 0.7589 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
15 | 15 | Spain | ESP | b | 86.27 | 2.5009 | 0.6159 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
18 | 18 | Ghana | GHA | g | 78.28 | 1.9921 | 0.9192 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
19 | 19 | Greece | GRE | c | 74.85 | 1.1878 | 0.5543 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
20 | 20 | Honduras | HON | e | 65.86 | 1.446 | 1.3086 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
21 | 21 | Iran | IRN | f | 69.34 | 1.1123 | 0.8226 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
22 | 22 | Italy | ITA | d | 78.4 | 1.8161 | 0.786 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
23 | 23 | Japan | JPN | c | 72.9 | 2.0328 | 1.3245 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
24 | 24 | South Korea | KOR | h | 65.18 | 1.527 | 1.4198 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
25 | 25 | Mexico | MEX | a | 79.87 | 1.6292 | 0.55 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
27 | 27 | Nigeria | NGA | f | 76.2 | 1.6394 | 0.8075 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
28 | 28 | Portugal | POR | g | 79.78 | 2.1732 | 0.9364 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
29 | 29 | Russia | RUS | h | 76.58 | 1.4474 | 0.6407 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 |
30 | 30 | Switzerland | SUI | e | 79.76 | 2.1817 | 0.9438 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
31 | 31 | Uruguay | URU | d | 80.98 | 2.1081 | 0.8009 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
32 | 32 | USA | USA | g | 78.19 | 1.9978 | 0.9297 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "world-cup-predictions/wc-20140704-180211" ( "country" TEXT, "country_id" TEXT, "group" TEXT, "spi" REAL, "spi_offense" REAL, "spi_defense" REAL, "win_group" INTEGER, "sixteen" INTEGER, "quarter" INTEGER, "semi" REAL, "cup" REAL, "win" REAL );