This data as json, CSV (advanced)
| Link | rowid | country | country_id | group | spi | spi_offense | spi_defense | win_group | sixteen | quarter | semi ▼ | cup | win |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 3 | Australia | AUS | b | 67.52 | 1.6824 | 1.4017 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 5 | 5 | Bosnia and Herzegovina | BIH | f | 79.4 | 2.19 | 0.9789 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 8 | 8 | Ivory Coast | CIV | c | 78.11 | 2.2383 | 1.1081 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 9 | 9 | Cameroon | CMR | a | 68.13 | 1.4479 | 1.1705 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 12 | 12 | Croatia | CRO | a | 77.85 | 2.0359 | 0.9836 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 14 | 14 | England | ENG | d | 81.19 | 2.0524 | 0.75 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 15 | 15 | Spain | ESP | b | 86.3 | 2.5034 | 0.6205 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 21 | 21 | Iran | IRN | f | 70.91 | 1.1286 | 0.7440000000000001 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 22 | 22 | Italy | ITA | d | 78.54 | 1.8199 | 0.7809999999999999 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 23 | 23 | Japan | JPN | c | 72.56 | 2.0187 | 1.3374 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
JSON shape: default, array, newline-delimited
CREATE TABLE "world-cup-predictions/wc-20140625-180355" ( "country" TEXT, "country_id" TEXT, "group" TEXT, "spi" REAL, "spi_offense" REAL, "spi_defense" REAL, "win_group" REAL, "sixteen" REAL, "quarter" REAL, "semi" REAL, "cup" REAL, "win" REAL );