world-cup-predictions/wc-20140628-185951

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

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.004481909282845999 0.0011325285793529999
2 Argentina ARG f 89.97 2.9251 0.4979 1 1 0.777322362338555 0.588935500495228 0.409223169161743 0.161958295265063
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.019021187760177
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 1.0 0.7978962349151529 0.6236409441456271 0.494560785534899
7 Chile CHI b 85.73 2.5558 0.7047 0 1 0.0 0.0 0.0 0.0
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.16689604402714497 0.089141851877074 0.049674237695081995
11 Costa Rica CRC d 78.28 1.483 0.5568 1 1 0.5732672674210351 0.18046110064858603 0.051121004088174 0.007043441969094
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.102540240054916 0.053693516665492
17 Germany GER g 88.65 3.0556 0.7218 1 1 0.824872219904241 0.510477240709 0.161693274535233 0.09377341419363999
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.0025299231036849997
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.007817845373434
26 Netherlands NED b 87.26 2.7872 0.7040000000000001 1 1 0.7160956803956179 0.550841448934785 0.28513807430211796 0.08892137069456502
27 Nigeria NGA f 77.14 1.6979 0.79 0 1 0.242584442113075 0.06139913470609 0.006374120305109999 0.0017476831174209999
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.007412628996639001
31 Uruguay URU d 81.67 2.1888 0.8063 0 1 0.30964089396592104 0.035207721057703 0.012127659799193998 0.004503862364566
32 USA USA g 78.64 2.0284 0.9224 0 1 0.41239985975340904 0.10717189750014099 0.041873780402684 0.00620927868689

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140628-185951" (
"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 72.778ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub