world-cup-predictions/wc-20140626-221022

16 rows where sixteen = 0

View and edit SQL

Suggested facets: group

sixteen

semi

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
3 Australia AUS b 67.47 1.685 1.406 0 0 0.0 0.0 0.0 0.0
5 Bosnia and Herzegovina BIH f 80.46 2.2777 0.9573 0 0 0.0 0.0 0.0 0.0
8 Ivory Coast CIV c 78.08 2.2328 1.1047 0 0 0.0 0.0 0.0 0.0
9 Cameroon CMR a 68.13 1.4486 1.1702 0 0 0.0 0.0 0.0 0.0
12 Croatia CRO a 77.94 2.0413 0.9788 0 0 0.0 0.0 0.0 0.0
13 Ecuador ECU e 80.22 1.8419 0.6747 0 0 0.0 0.0 0.0 0.0
14 England ENG d 81.15 2.0557 0.7531 0 0 0.0 0.0 0.0 0.0
15 Spain ESP b 86.28 2.5038 0.6197 0 0 0.0 0.0 0.0 0.0
18 Ghana GHA g 79.01 1.9888 0.8654 0 0 0.0 0.0 0.0 0.0
20 Honduras HON e 65.81 1.4244 1.2921 0 0 0.0 0.0 0.0 0.0
21 Iran IRN f 69.34 1.1127 0.8220000000000001 0 0 0.0 0.0 0.0 0.0
22 Italy ITA d 78.52 1.818 0.7794 0 0 0.0 0.0 0.0 0.0
23 Japan JPN c 72.54 2.0196 1.3385 0 0 0.0 0.0 0.0 0.0
24 South Korea KOR h 64.88 1.6581 1.5493 0 0 0.0 0.0 0.0 0.0
28 Portugal POR g 79.15 2.1091 0.9392 0 0 0.0 0.0 0.0 0.0
29 Russia RUS h 76.98 1.464 0.6271 0 0 0.0 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140626-221022" (
"country" TEXT,
  "country_id" TEXT,
  "group" TEXT,
  "spi" REAL,
  "spi_offense" REAL,
  "spi_defense" REAL,
  "win_group" INTEGER,
  "sixteen" INTEGER,
  "quarter" REAL,
  "semi" REAL,
  "cup" REAL,
  "win" REAL
);
Powered by Datasette · Query took 20.811ms