2014 World Cup Tournament Predictions: wc-20140709-231617.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
12 rows where semi = 0 and sixteen = 1
This data as json, copyable, CSV (advanced)
Suggested facets: group, win_group, quarter
| 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 |
| 4 | 4 | Belgium | BEL | h | 83.02 | 1.9872 | 0.5613 | 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 |
| 10 | 10 | Colombia | COL | c | 89.06 | 2.5956 | 0.3968 | 1 | 1 | 1 | 0 | 0 | 0.0 |
| 11 | 11 | Costa Rica | CRC | d | 78.38 | 1.4254 | 0.5066 | 1 | 1 | 1 | 0 | 0 | 0.0 |
| 16 | 16 | France | FRA | e | 87.85 | 2.5769 | 0.5113 | 1 | 1 | 1 | 0 | 0 | 0.0 |
| 19 | 19 | Greece | GRE | c | 74.84 | 1.1949 | 0.561 | 0 | 1 | 0 | 0 | 0 | 0.0 |
| 25 | 25 | Mexico | MEX | a | 79.57 | 1.6152 | 0.5617 | 0 | 1 | 0 | 0 | 0 | 0.0 |
| 27 | 27 | Nigeria | NGA | f | 76.23 | 1.6545 | 0.8175 | 0 | 1 | 0 | 0 | 0 | 0.0 |
| 30 | 30 | Switzerland | SUI | e | 79.62 | 2.183 | 0.9556 | 0 | 1 | 0 | 0 | 0 | 0.0 |
| 31 | 31 | Uruguay | URU | d | 80.86 | 2.1078 | 0.8106 | 0 | 1 | 0 | 0 | 0 | 0.0 |
| 32 | 32 | USA | USA | g | 78.5 | 2.0192 | 0.9236 | 0 | 1 | 0 | 0 | 0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "world-cup-predictions/wc-20140709-231617" ( "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" INTEGER, "win" REAL );