2014 World Cup Tournament Predictions: wc-20140705-093245.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
4 rows where group = "g"
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17 | 17 | Germany | GER | g | 88.68 | 2.9235 | 0.634 | 1 | 1 | 1 | 1.0 | 0.267604766107597 | 0.145276660786488 |
| 18 | 18 | Ghana | GHA | g | 78.44 | 2.0108 | 0.9211 | 0 | 0 | 0 | 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.0 |
| 32 | 32 | USA | USA | g | 78.24 | 2.0031 | 0.9302 | 0 | 1 | 0 | 0.0 | 0.0 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "world-cup-predictions/wc-20140705-093245" ( "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 );