world-cup-predictions/wc-20140627-100126

32 rows

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.97 2.0798 1.2188 0 1 0.17523315928421804 0.049545642715742 0.005855056267223001 0.0014802777479549997
2 Argentina ARG f 89.97 2.925 0.498 1 1 0.7772483092752671 0.58883795655823 0.4091296023271401 0.176173293099103
3 Australia AUS b 67.27 1.676 1.4141 0 0 0.0 0.0 0.0 0.0
4 Belgium BEL h 83.03 2.0529 0.6076 1 1 0.587650321524429 0.196982967646929 0.09322255440232301 0.021559882840193
5 Bosnia and Herzegovina BIH f 80.42 2.2769 0.9623 0 0 0.0 0.0 0.0 0.0
6 Brazil BRA a 91.21 3.2184 0.5182 1 1 0.823666033191854 0.657134246382474 0.513600629304784 0.407295801687219
7 Chile CHI b 85.73 2.5555 0.7046 0 1 0.176333966808146 0.08351615683433901 0.03742873126471499 0.017738182672457
8 Ivory Coast CIV c 78.24 2.2401 1.1009 0 0 0.0 0.0 0.0 0.0
9 Cameroon CMR a 68.24 1.4598 1.1752 0 0 0.0 0.0 0.0 0.0
10 Colombia COL c 88.92 2.6122 0.4272 1 1 0.690488617681937 0.209069116945114 0.111683965205142 0.06224823779362001
11 Costa Rica CRC d 78.28 1.4832 0.5567 1 1 0.5733072153300799 0.180505340198018 0.05114986680783099 0.008143554260359
12 Croatia CRO a 77.95 2.0427 0.9815 0 0 0.0 0.0 0.0 0.0
13 Ecuador ECU e 80.04 1.7771 0.6445 0 0 0.0 0.0 0.0 0.0
14 England ENG d 81.1 2.052 0.7566 0 0 0.0 0.0 0.0 0.0
15 Spain ESP b 86.17 2.4906 0.6235 0 0 0.0 0.0 0.0 0.0
16 France FRA e 87.64 2.6458 0.579 1 1 0.757415569407758 0.37868383053581794 0.119860602543039 0.06277365503728399
17 Germany GER g 88.65 3.0555 0.7218 1 1 0.8247668407157821 0.5103563039891971 0.186082126449347 0.10792149784773501
18 Ghana GHA g 78.33 1.9865 0.915 0 0 0.0 0.0 0.0 0.0
19 Greece GRE c 74.47 1.1738 0.5682 0 1 0.42669278466992 0.10822161265105698 0.024543936748733994 0.002963228708424
20 Honduras HON e 65.84 1.4305 1.2984 0 0 0.0 0.0 0.0 0.0
21 Iran IRN f 69.42 1.1058 0.8136 0 0 0.0 0.0 0.0 0.0
22 Italy ITA d 78.46 1.8138 0.7827 0 0 0.0 0.0 0.0 0.0
23 Japan JPN c 72.68 2.0198 1.3317 0 0 0.0 0.0 0.0 0.0
24 South Korea KOR h 64.8 1.5089 1.4295 0 0 0.0 0.0 0.0 0.0
25 Mexico MEX a 80.1 1.6230000000000002 0.5321 0 1 0.283967030734408 0.16051264594268302 0.050041487162440994 0.008982859264683
26 Netherlands NED b 87.26 2.7873 0.7041 1 1 0.7160329692655921 0.5507604012082429 0.285120630632133 0.09836020782038499
27 Nigeria NGA f 77.14 1.6980000000000002 0.7899 0 1 0.242584430592242 0.061414222759243 0.008172158916346999 0.0022412435495520002
28 Portugal POR g 79.89 2.1719 0.9307 0 0 0.0 0.0 0.0 0.0
29 Russia RUS h 76.4 1.4341 0.6447 0 0 0.0 0.0 0.0 0.0
30 Switzerland SUI e 79.75 2.267 1.0069 0 1 0.222751690724733 0.107011687082887 0.044922852739921 0.008521427458551998
31 Uruguay URU d 81.66 2.1886 0.8064 0 1 0.309511382318063 0.050280479838072 0.017316730049404 0.006430451785256
32 USA USA g 78.63 2.0283 0.9224 0 1 0.412349678475571 0.107167388711954 0.041869069179478 0.0071661984272250005

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140627-100126" (
"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 26.773ms