world-cup-predictions/wc-20140625-220012

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.32 2.0416 1.2344 0.0364 0.6362 0.151059716731993 0.04459237216323201 0.00754032594998 0.001994596539873
2 Argentina ARG f 89.65 2.7396 0.4256 1.0 1.0 0.7530006531971779 0.515658688386897 0.339534475756331 0.147769790011585
3 Australia AUS b 67.52 1.6824 1.4017 0.0 0.0 0.0 0.0 0.0 0.0
4 Belgium BEL h 83.12 2.134 0.6552 0.9636 1.0 0.531135863655043 0.207411730089022 0.099974276350876 0.027862581023355
5 Bosnia and Herzegovina BIH f 79.4 2.19 0.9789 0.0 0.0 0.0 0.0 0.0 0.0
6 Brazil BRA a 91.27 3.2346 0.521 1.0 1.0 0.7788352855777251 0.6131344427431209 0.46971445335203 0.36710961565964
7 Chile CHI b 86.6 2.5703 0.6345 0.0 1.0 0.22116471442239102 0.11445388465744599 0.05603438522319999 0.028838279903402004
8 Ivory Coast CIV c 78.11 2.2383 1.1081 0.0 0.0 0.0 0.0 0.0 0.0
9 Cameroon CMR a 68.13 1.4479 1.1705 0.0 0.0 0.0 0.0 0.0 0.0
10 Colombia COL c 88.18 2.5068 0.4405 1.0 1.0 0.6317194704033511 0.19645083433970603 0.102328909124878 0.055790993047067
11 Costa Rica CRC d 78.59 1.5038 0.5506 1.0 1.0 0.5667303385298721 0.19735065645726002 0.065460362063822 0.013683072520073999
12 Croatia CRO a 77.85 2.0359 0.9836 0.0 0.0 0.0 0.0 0.0 0.0
13 Ecuador ECU e 80.11 1.9817 0.7822 0.0 0.0 0.0 0.0 0.0 0.0
14 England ENG d 81.19 2.0524 0.75 0.0 0.0 0.0 0.0 0.0 0.0
15 Spain ESP b 86.3 2.5034 0.6205 0.0 0.0 0.0 0.0 0.0 0.0
16 France FRA e 87.8 2.7439999999999998 0.6238 1.0 1.0 0.7470027773524169 0.40662100546977403 0.146373550627425 0.080146419854363
17 Germany GER g 88.62 3.1686 0.7927 0.8514 0.9973 0.774206309972633 0.46622277705355597 0.20075071012858603 0.11467619924661598
18 Ghana GHA g 79.02 1.9875 0.8654 0.0 0.1974 0.084658378282212 0.027037047538974002 0.011236187095246 0.002434563693145
19 Greece GRE c 74.37 1.1835 0.5811 0.0 1.0 0.433269661470122 0.12495398178020699 0.034206833596903005 0.0056637638531309995
20 Honduras HON e 68.45 1.5159 1.2065 0.0 0.0 0.0 0.0 0.0 0.0
21 Iran IRN f 70.91 1.1286 0.7440000000000001 0.0 0.0 0.0 0.0 0.0 0.0
22 Italy ITA d 78.54 1.8199 0.7809999999999999 0.0 0.0 0.0 0.0 0.0 0.0
23 Japan JPN c 72.56 2.0187 1.3374 0.0 0.0 0.0 0.0 0.0 0.0
24 South Korea KOR h 64.85 1.6567 1.551 0.0 0.0075 0.0009442776597959999 0.00017122778940299998 1.4037591143e-05 2.353706133e-06
25 Mexico MEX a 80.16 1.6322 0.534 0.0 1.0 0.31217149437875896 0.17264691044528196 0.061051561694632994 0.013801146589006002
26 Netherlands NED b 87.4 2.8013 0.6993 1.0 1.0 0.6878285056211341 0.505048451317339 0.271316966526233 0.103290538432285
27 Nigeria NGA f 76.16 1.5231 0.7259 0.0 1.0 0.252997222647675 0.07601825426452799 0.012712769606245003 0.003831770843192
28 Portugal POR g 79.15 2.1062 0.9394 0.0 0.0463 0.020192063924428003 0.006583220191565 0.0027865094771829997 0.000617087760783
29 Russia RUS h 76.95 1.4615 0.6284 0.0 0.3563 0.09004437550409401 0.028891516205997 0.004952070516604 0.001512237571052
30 Switzerland SUI e 78.11 2.1503 1.0465 0.0 1.0 0.24699934680271 0.10532379360148199 0.042768466130674 0.008953515728059
31 Uruguay URU d 82.21 2.209 0.7769 0.0 1.0 0.3682805295966621 0.07596083825963901 0.029646806686688 0.012327476821534998
32 USA USA g 78.85 2.1632 1.0015 0.1486 0.759 0.34775901426978306 0.11546836724563099 0.041596342501294 0.009693997195743

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140625-220012" (
"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 29.125ms