world-cup-predictions/wc-20140705-093245

32 rows sorted by win

View and edit SQL

Suggested facets: win_group, sixteen, quarter, cup, win

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win ▼
1 Algeria ALG h 75.78 2.0371 1.1288 0 1 0 0.0 0.0 0.0
3 Australia AUS b 67.48 1.6932 1.4136 0 0 0 0.0 0.0 0.0
5 Bosnia and Herzegovina BIH f 80.27 2.28 0.9725 0 0 0 0.0 0.0 0.0
7 Chile CHI b 86.41 2.5199 0.6144 0 1 0 0.0 0.0 0.0
8 Ivory Coast CIV c 78.36 2.2481 1.0948 0 0 0 0.0 0.0 0.0
9 Cameroon CMR a 68.4 1.4804 1.1804 0 0 0 0.0 0.0 0.0
10 Colombia COL c 89.29 2.6309 0.39299999999999996 1 1 1 0.0 0.0 0.0
12 Croatia CRO a 77.95 2.0444 0.9804 0 0 0 0.0 0.0 0.0
13 Ecuador ECU e 80.2 1.7948 0.6429 0 0 0 0.0 0.0 0.0
14 England ENG d 81.06 2.0549 0.7585 0 0 0 0.0 0.0 0.0
15 Spain ESP b 86.26 2.4998 0.6155 0 0 0 0.0 0.0 0.0
16 France FRA e 87.74 2.5758 0.5206 1 1 1 0.0 0.0 0.0
18 Ghana GHA g 78.44 2.0108 0.9211 0 0 0 0.0 0.0 0.0
19 Greece GRE c 74.83 1.1857 0.5541 0 1 0 0.0 0.0 0.0
20 Honduras HON e 65.77 1.4471 1.3155 0 0 0 0.0 0.0 0.0
21 Iran IRN f 69.33 1.1118 0.823 0 0 0 0.0 0.0 0.0
22 Italy ITA d 78.43 1.819 0.7859999999999999 0 0 0 0.0 0.0 0.0
23 Japan JPN c 72.87 2.029 1.3238 0 0 0 0.0 0.0 0.0
24 South Korea KOR h 65.27 1.5264 1.4137 0 0 0 0.0 0.0 0.0
25 Mexico MEX a 79.89 1.6288 0.5484 0 1 0 0.0 0.0 0.0
27 Nigeria NGA f 76.13 1.6419 0.8144 0 1 0 0.0 0.0 0.0
28 Portugal POR g 79.82 2.1783 0.9372 0 0 0 0.0 0.0 0.0
29 Russia RUS h 76.6 1.4475 0.6395 0 0 0 0.0 0.0 0.0
30 Switzerland SUI e 79.64 2.1847 0.9552 0 1 0 0.0 0.0 0.0
31 Uruguay URU d 80.97 2.1056 0.8004 0 1 0 0.0 0.0 0.0
32 USA USA g 78.24 2.0031 0.9302 0 1 0 0.0 0.0 0.0
11 Costa Rica CRC d 78.12 1.5056 0.5816 1 1 1 0.236919620896393 0.060266478982725 0.007074162489002
4 Belgium BEL h 83.39 2.0625 0.5815 1 1 1 0.300321407820291 0.123246959089967 0.023043942472761002
26 Netherlands NED b 87.75 2.8653 0.6958 1 1 1 0.763080379103607 0.38973139900592496 0.11822229989208302
17 Germany GER g 88.68 2.9235 0.634 1 1 1 1.0 0.267604766107597 0.145276660786488
2 Argentina ARG f 89.55 2.7778 0.4523 1 1 1 0.699678592179709 0.426755162921383 0.149205785287355
6 Brazil BRA a 90.84 3.1211 0.5006 1 1 1 1.0 0.7323952338924029 0.5571771490723101

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);
Powered by Datasette · Query took 31.861ms