2014 World Cup Tournament Predictions: wc-20140705-225331.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 | 75.78 | 2.0371 | 1.1288 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
2 | 2 | Argentina | ARG | f | 89.55 | 2.7778 | 0.4523 | 1 | 1 | 1 | 1 | 0.551426183133153 | 0.192794332279813 |
3 | 3 | Australia | AUS | b | 67.48 | 1.6932 | 1.4136 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
4 | 4 | Belgium | BEL | h | 83.39 | 2.0625 | 0.5815 | 1 | 1 | 1 | 0 | 0.0 | 0.0 |
5 | 5 | Bosnia and Herzegovina | BIH | f | 80.27 | 2.28 | 0.9725 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
6 | 6 | Brazil | BRA | a | 90.84 | 3.1211 | 0.5006 | 1 | 1 | 1 | 1 | 0.732395233892403 | 0.536714258545463 |
7 | 7 | Chile | CHI | b | 86.41 | 2.5199 | 0.6144 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
8 | 8 | Ivory Coast | CIV | c | 78.36 | 2.2481 | 1.0948 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
9 | 9 | Cameroon | CMR | a | 68.4 | 1.4804 | 1.1804 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
10 | 10 | Colombia | COL | c | 89.29 | 2.6309 | 0.393 | 1 | 1 | 1 | 0 | 0.0 | 0.0 |
11 | 11 | Costa Rica | CRC | d | 78.12 | 1.5056 | 0.5816 | 1 | 1 | 1 | 0 | 0.0 | 0.0 |
12 | 12 | Croatia | CRO | a | 77.95 | 2.0444 | 0.9804 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
13 | 13 | Ecuador | ECU | e | 80.2 | 1.7948 | 0.6429 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
14 | 14 | England | ENG | d | 81.06 | 2.0549 | 0.7585 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
15 | 15 | Spain | ESP | b | 86.26 | 2.4998 | 0.6155 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
16 | 16 | France | FRA | e | 87.74 | 2.5758 | 0.5206 | 1 | 1 | 1 | 0 | 0.0 | 0.0 |
17 | 17 | Germany | GER | g | 88.68 | 2.9235 | 0.634 | 1 | 1 | 1 | 1 | 0.267604766107597 | 0.134419672494964 |
18 | 18 | Ghana | GHA | g | 78.44 | 2.0108 | 0.9211 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
19 | 19 | Greece | GRE | c | 74.83 | 1.1857 | 0.5541 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
20 | 20 | Honduras | HON | e | 65.77 | 1.4471 | 1.3155 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
21 | 21 | Iran | IRN | f | 69.33 | 1.1118 | 0.823 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
22 | 22 | Italy | ITA | d | 78.43 | 1.819 | 0.786 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
23 | 23 | Japan | JPN | c | 72.87 | 2.029 | 1.3238 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
24 | 24 | South Korea | KOR | h | 65.27 | 1.5264 | 1.4137 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
25 | 25 | Mexico | MEX | a | 79.89 | 1.6288 | 0.5484 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
26 | 26 | Netherlands | NED | b | 87.75 | 2.8653 | 0.6958 | 1 | 1 | 1 | 1 | 0.448573816866847 | 0.13607173667976 |
27 | 27 | Nigeria | NGA | f | 76.13 | 1.6419 | 0.8144 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
28 | 28 | Portugal | POR | g | 79.82 | 2.1783 | 0.9372 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
29 | 29 | Russia | RUS | h | 76.6 | 1.4475 | 0.6395 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
30 | 30 | Switzerland | SUI | e | 79.64 | 2.1847 | 0.9552 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
31 | 31 | Uruguay | URU | d | 80.97 | 2.1056 | 0.8004 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
32 | 32 | USA | USA | g | 78.24 | 2.0031 | 0.9302 | 0 | 1 | 0 | 0 | 0.0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "world-cup-predictions/wc-20140705-225331" ( "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 );