world-cup-predictions/wc-20140628-094211

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.0792 1.2188 0 1 0.175127780095759 0.049503757389372995 0.005846577102174 0.001477364944655
2 Argentina ARG f 89.97 2.9251 0.4979 1 1 0.777322362338555 0.588935500495228 0.409223169161743 0.176217089411349
3 Australia AUS b 67.28 1.6761 1.4137 0 0 0.0 0.0 0.0 0.0
4 Belgium BEL h 83.03 2.053 0.6078 1 1 0.587600140246591 0.19692403860014202 0.09319019701952601 0.021547879593318
5 Bosnia and Herzegovina BIH f 80.42 2.2769999999999997 0.9624 0 0 0.0 0.0 0.0 0.0
6 Brazil BRA a 91.21 3.2186 0.5182 1 1 0.823673601146162 0.657206065153528 0.513676582286621 0.40735666320720504
7 Chile CHI b 85.73 2.5558 0.7047 0 1 0.176326398853838 0.083529445053021 0.037437449794074 0.017742305186576
8 Ivory Coast CIV c 78.24 2.2402 1.1009 0 0 0.0 0.0 0.0 0.0
9 Cameroon CMR a 68.24 1.4598 1.1751 0 0 0.0 0.0 0.0 0.0
10 Colombia COL c 88.92 2.6119 0.4272 1 1 0.690359106034079 0.208959630119666 0.111608687341839 0.062193866821388
11 Costa Rica CRC d 78.28 1.483 0.5568 1 1 0.5732672674210351 0.18046110064858603 0.051121004088174 0.008135960942152
12 Croatia CRO a 77.95 2.0424 0.9815 0 0 0.0 0.0 0.0 0.0
13 Ecuador ECU e 80.04 1.7772 0.6444 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.4908 0.6234 0 0 0.0 0.0 0.0 0.0
16 France FRA e 87.64 2.6456 0.579 1 1 0.757415557886925 0.37861986719553703 0.119814615029231 0.062738960094068
17 Germany GER g 88.65 3.0556 0.7218 1 1 0.824872219904241 0.510477240709 0.186120175599829 0.10793970476807199
18 Ghana GHA g 78.32 1.9864 0.9151 0 0 0.0 0.0 0.0 0.0
19 Greece GRE c 74.47 1.1739 0.5684 0 1 0.42673273257896505 0.10822428923121301 0.024539070999449998 0.0029619194998290006
20 Honduras HON e 65.84 1.4308 1.2984 0 0 0.0 0.0 0.0 0.0
21 Iran IRN f 69.42 1.1061 0.8139 0 0 0.0 0.0 0.0 0.0
22 Italy ITA d 78.46 1.814 0.7828 0 0 0.0 0.0 0.0 0.0
23 Japan JPN c 72.68 2.0197 1.3317 0 0 0.0 0.0 0.0 0.0
24 South Korea KOR h 64.81 1.5092 1.4291 0 0 0.0 0.0 0.0 0.0
25 Mexico MEX a 80.09 1.6228 0.5322 0 1 0.283904319604382 0.160473161185417 0.05001380630688599 0.008974676741702
26 Netherlands NED b 87.26 2.7872 0.7040000000000001 1 1 0.7160956803956179 0.550841448934785 0.28513807430211796 0.09835727639668901
27 Nigeria NGA f 77.14 1.6979 0.79 0 1 0.242584442113075 0.06139913470609 0.008167889161598 0.00223950620782
28 Portugal POR g 79.89 2.1722 0.9308 0 0 0.0 0.0 0.0 0.0
29 Russia RUS h 76.4 1.4344 0.6447 0 0 0.0 0.0 0.0 0.0
30 Switzerland SUI e 79.75 2.2668 1.0069 0 1 0.222677637661444 0.10696856340448899 0.044900897719418 0.008514981713087
31 Uruguay URU d 81.67 2.1888 0.8063 0 1 0.30964089396592104 0.05030485967378599 0.017328023684633997 0.006435127223038001
32 USA USA g 78.64 2.0284 0.9224 0 1 0.41239985975340904 0.10717189750014099 0.041873780402684 0.007166717249052

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140628-094211" (
"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 28.414ms