world-cup-predictions/wc-20140710-164509

24 rows where win_group = 0

View and edit SQL

Suggested facets: group, sixteen

win_group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
1 Algeria ALG h 76.15 2.0503 1.1128 0 1 0 0 0 0.0
3 Australia AUS b 67.3 1.7113 1.4411 0 0 0 0 0 0.0
5 Bosnia and Herzegovina BIH f 80.33 2.3019 0.9837 0 0 0 0 0 0.0
7 Chile CHI b 86.06 2.483 0.6242 0 1 0 0 0 0.0
8 Ivory Coast CIV c 78.33 2.246 1.0959 0 0 0 0 0 0.0
9 Cameroon CMR a 68.21 1.4582 1.1747 0 0 0 0 0 0.0
12 Croatia CRO a 77.6 2.0163 0.9858 0 0 0 0 0 0.0
13 Ecuador ECU e 80.2 1.8056 0.6508 0 0 0 0 0 0.0
14 England ENG d 81.04 2.0514 0.7581 0 0 0 0 0 0.0
15 Spain ESP b 86.09 2.5053 0.6357 0 0 0 0 0 0.0
18 Ghana GHA g 78.91 2.0327 0.9034 0 0 0 0 0 0.0
19 Greece GRE c 74.85 1.194 0.5597 0 1 0 0 0 0.0
20 Honduras HON e 65.55 1.4395 1.3230000000000002 0 0 0 0 0 0.0
21 Iran IRN f 69.39 1.1246 0.8303 0 0 0 0 0 0.0
22 Italy ITA d 78.42 1.8216 0.7891 0 0 0 0 0 0.0
23 Japan JPN c 72.81 2.0375 1.3349 0 0 0 0 0 0.0
24 South Korea KOR h 65.28 1.5218 1.4104 0 0 0 0 0 0.0
25 Mexico MEX a 79.6 1.6241 0.5659 0 1 0 0 0 0.0
27 Nigeria NGA f 76.25 1.671 0.828 0 1 0 0 0 0.0
28 Portugal POR g 80.3 2.1837 0.9048 0 0 0 0 0 0.0
29 Russia RUS h 76.58 1.4501 0.6433 0 0 0 0 0 0.0
30 Switzerland SUI e 79.62 2.1881 0.9593 0 1 0 0 0 0.0
31 Uruguay URU d 80.82 2.102 0.8095 0 1 0 0 0 0.0
32 USA USA g 78.5 2.0165 0.9219 0 1 0 0 0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140710-164509" (
"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
);
Powered by Datasette · Query took 26.508ms