world-cup-predictions/wc-20140626-180150

32 rows sorted by rowid

View and edit SQL

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

Link rowid ▼ country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
1 Algeria ALG h 74.34 2.0441 1.2336 0.0355 0.6293 0.13082048120270098 0.038845541900482 0.006649939095973001 0.001722958825806
2 Argentina ARG f 90.14 2.9531 0.4932 1.0 1.0 0.7499991300017349 0.54826419693304 0.375030802961636 0.172833038158762
3 Australia AUS b 67.47 1.685 1.406 0.0 0.0 0.0 0.0 0.0 0.0
4 Belgium BEL h 83.12 2.1376 0.6547 0.9645 1.0 0.564153886672896 0.205345152396897 0.09918464239898199 0.027647579736209
5 Bosnia and Herzegovina BIH f 80.46 2.2777 0.9573 0.0 0.0 0.0 0.0 0.0 0.0
6 Brazil BRA a 91.24 3.2325 0.5205 1.0 1.0 0.7780854923348671 0.612296527190661 0.46470838936194203 0.35886074767283904
7 Chile CHI b 86.58 2.5767 0.637 0.0 1.0 0.221914507665133 0.115003237986451 0.05519860876285201 0.027865328191855
8 Ivory Coast CIV c 78.08 2.2328 1.1047 0.0 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 0.0
10 Colombia COL c 88.17 2.5118 0.4427 1.0 1.0 0.633888546441141 0.19754753238636702 0.101012909137928 0.05405600199679401
11 Costa Rica CRC d 78.46 1.4994 0.5545 1.0 1.0 0.563656080705206 0.19517910328294102 0.062167189520556 0.012867903659916
12 Croatia CRO a 77.94 2.0413 0.9788 0.0 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 0.0
14 England ENG d 81.15 2.0557 0.7531 0.0 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 0.0
16 France FRA e 87.68 2.6496 0.5759 1.0 1.0 0.7241824165320792 0.36560925820361895 0.12935266540053 0.068547533100018
17 Germany GER g 88.61 3.1728 0.7929999999999999 1.0 1.0 0.79277566070905 0.488903245997099 0.19603395759703 0.114566029605304
18 Ghana GHA g 79.01 1.9888 0.8654 0.0 0.0 0.0 0.0 0.0 0.0
19 Greece GRE c 74.48 1.1804 0.5712 0.0 1.0 0.43634391929478794 0.126280336263112 0.033407997134894 0.005537500740585
20 Honduras HON e 65.81 1.4244 1.2921 0.0 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 0.0
22 Italy ITA d 78.52 1.818 0.7794 0.0 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 0.0
24 South Korea KOR h 64.88 1.6581 1.5493 0.0 0.0073 0.00073001259109 0.00013512252081099998 1.1113726472e-05 1.8484745409999998e-06
25 Mexico MEX a 80.03 1.6198 0.5329 0.0 1.0 0.309494772961891 0.170683083147933 0.05797920857079 0.012971939737062
26 Netherlands NED b 87.39 2.8089999999999997 0.7022 1.0 1.0 0.6905052270382901 0.507857477306055 0.266111173109578 0.101305307781781
27 Nigeria NGA f 77.2 1.6936 0.7807 0.0 1.0 0.275817583468004 0.078978409949777 0.014058796832283999 0.004367390293846
28 Portugal POR g 79.15 2.1091 0.9392 0.0 0.0 0.0 0.0 0.0 0.0
29 Russia RUS h 76.98 1.464 0.6271 0.0 0.3634 0.079148829371719 0.025894299435286 0.004453016588217 0.0013394547408900003
30 Switzerland SUI e 79.87 2.2727 0.9986 0.0 1.0 0.250000869998355 0.12031437978420699 0.052707787188047 0.012292188281926
31 Uruguay URU d 82.11 2.1995 0.7766 0.0 1.0 0.366111453558818 0.075152702436533 0.028424684030317005 0.01149794434967
32 USA USA g 78.89 2.1631 0.9962 0.0 1.0 0.432371129452369 0.127710392878757 0.05350711858183901 0.0117193046522

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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