world-cup-predictions/wc-20140704-180211

16 rows where sixteen = 1 sorted by quarter

View and edit SQL

Suggested facets: group, win_group, quarter, semi, cup, win

sixteen

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter ▼ semi cup win
1 Algeria ALG h 75.66 2.0226 1.1263 0 1 0 0.0 0.0 0.0
7 Chile CHI b 86.41 2.5202 0.6154 0 1 0 0.0 0.0 0.0
19 Greece GRE c 74.85 1.1878 0.5543 0 1 0 0.0 0.0 0.0
25 Mexico MEX a 79.87 1.6292 0.55 0 1 0 0.0 0.0 0.0
27 Nigeria NGA f 76.2 1.6394 0.8075 0 1 0 0.0 0.0 0.0
30 Switzerland SUI e 79.76 2.1817 0.9438 0 1 0 0.0 0.0 0.0
31 Uruguay URU d 80.98 2.1081 0.8009 0 1 0 0.0 0.0 0.0
32 USA USA g 78.19 1.9978 0.9297 0 1 0 0.0 0.0 0.0
2 Argentina ARG f 89.57 2.7809 0.4528 1 1 1 0.7002935249892321 0.4271677031846121 0.173903848277696
4 Belgium BEL h 83.39 2.0624 0.5817 1 1 1 0.29970647501076697 0.122821272684504 0.02826304270697
6 Brazil BRA a 90.61 3.0775 0.5044 1 1 1 0.716501245994315 0.523013018878129 0.392651462990771
10 Colombia COL c 89.43 2.6374 0.3827 1 1 1 0.283498754005685 0.145122589786179 0.079067991590717
11 Costa Rica CRC d 78.13 1.5062 0.5814 1 1 1 0.23664306556953305 0.06013546189915799 0.009005071253749001
16 France FRA e 88.14 2.6777 0.5429 1 1 1 0.0 0.0 0.0
17 Germany GER g 88.28 2.9655 0.7021 1 1 1 1.0 0.331864391335693 0.17717678350047197
26 Netherlands NED b 87.78 2.8659 0.6943 1 1 1 0.763356934430467 0.38987556223172704 0.139931799679625

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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