world-cup-predictions/wc-20140617-000315

32 rows

View and edit SQL

Suggested facets: group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
1 Algeria ALG h 63.35 1.1188 1.166 0.0616 0.2067 0.035350456869402004 0.006215951295789001 0.0008199029204410002 9.6744518839e-05
2 Argentina ARG f 90.51 2.9010000000000002 0.4164 0.916 0.986 0.7194101634052241 0.53126997987858 0.35164598273461795 0.160550520938615
3 Australia AUS b 68.84 1.649 1.2804 0.002 0.0181 0.001684078687661 0.00046298032637900004 9.1514896859e-05 1.2761292182e-05
4 Belgium BEL h 82.1 2.1462 0.7351 0.4916 0.7796 0.35960046871515705 0.137245387012417 0.052554460910521 0.014402570113508
5 Bosnia and Herzegovina BIH f 80.81 2.3194 0.9513 0.0349 0.557 0.22819095766164998 0.08735162423221299 0.021124051510081003 0.007049261882265999
6 Brazil BRA a 91.61 3.3851 0.5567 0.9667 0.9981 0.7910472035078041 0.663626219145004 0.523531609397476 0.412326544025928
7 Chile CHI b 86.77 2.7182 0.7020000000000001 0.2958 0.7733 0.316555958124034 0.199922883656494 0.10177649491791699 0.040158115466704
8 Ivory Coast CIV c 79.11 2.2107 1.0052 0.2264 0.7916 0.39921132281953 0.127463168929913 0.043932979668999 0.010031094082088002
9 Cameroon CMR a 70.02 1.3536 0.9693 0.0006 0.0336 0.006755626882660999 0.002331947428091 0.000518576335869 6.5828763391e-05
10 Colombia COL c 87.62 2.3961 0.4209 0.7514 0.9637 0.639507590082529 0.219943069698542 0.112105243101171 0.05019287366526
11 Costa Rica CRC d 77.4 1.5919999999999999 0.6859 0.3964 0.7124 0.28109751554020196 0.074884720986478 0.023128178289491003 0.004824632437487
12 Croatia CRO a 76.37 1.8136 0.9164 0.0028 0.3734 0.10292575591249302 0.044256735786839994 0.013207833812501998 0.00231608995105
13 Ecuador ECU e 79.78 1.9875 0.8012 0.0326 0.1973 0.060652939786743 0.027518395065495 0.010166545772504998 0.002349047067209
14 England ENG d 82.19 2.1702 0.7440000000000001 0.087 0.3316 0.15129218289206697 0.040510434857833 0.015969616733152 0.0050654202765050005
15 Spain ESP b 86.75 2.6107 0.6378 0.0276 0.2501 0.0681459013721 0.040389660883552 0.020257170281636004 0.008956398702776
16 France FRA e 87.49 2.6233 0.5744 0.713 0.9301 0.577506343377319 0.31210645184820696 0.11977746562585499 0.055616874065252
17 Germany GER g 88.87 3.1985 0.7763 0.8609 0.9748 0.759808032673818 0.485631006055591 0.203162132001928 0.11383028324163198
18 Ghana GHA g 77.37 1.9046 0.9141 0.0091 0.1241 0.059659372700327 0.017047322740623 0.005996928018458 0.001157838482744
19 Greece GRE c 74.35 1.2919999999999998 0.6577 0.0091 0.1435 0.05857445395977 0.016745893986776998 0.004461503817726 0.0007114360249819999
20 Honduras HON e 68.35 1.5065 1.1953 0.0056 0.0708 0.011152231918108999 0.0033651876350279998 0.000796037299222 9.398091696899999e-05
21 Iran IRN f 70.6 1.2978 0.8898 0.0185 0.1817 0.04560197567213901 0.010979671147245 0.0016470475619349998 0.00029570591889899997
22 Italy ITA d 80.14 2.0362 0.8086 0.4621 0.7482 0.339733911353248 0.108067349733799 0.03821037789536599 0.009232418862606
23 Japan JPN c 73.12 2.0752 1.3316 0.0131 0.1012 0.039525256337352 0.01007499050223 0.002488903968907 0.000358144378192
24 South Korea KOR h 72.42 1.6882 1.0828 0.142 0.3831 0.09597002210787 0.023533457833988 0.00465795419397 0.0007813221539330001
25 Mexico MEX a 77.47 1.5187 0.6278 0.0299 0.5949 0.170248361316808 0.074206481729173 0.022681804696264997 0.004175719083034
26 Netherlands NED b 86.87 2.8015 0.7438 0.6746 0.9585 0.542637114196444 0.354057935452073 0.181201069172274 0.066533398006242
27 Nigeria NGA f 75.02 1.6593 0.8921 0.0306 0.2753 0.0866961545738 0.025714496458347003 0.004813380627273 0.001103129068054
28 Portugal POR g 80.92 2.1411 0.8218 0.0153 0.27 0.148492541553241 0.050812326773898 0.021294840158832 0.005050577166987
29 Russia RUS h 78.95 1.6554 0.6267 0.3048 0.6306 0.22984492838929899 0.074743022834944 0.021849467252531 0.005074974982757
30 Switzerland SUI e 79.31 2.0712 0.8939 0.2488 0.8018 0.270789233605018 0.11316031781919399 0.036861789497242996 0.008784833766694
31 Uruguay URU d 80.77 2.1806 0.8603 0.0545 0.2078 0.09105776701519802 0.023055526896831997 0.008646155294698999 0.002584793193771
32 USA USA g 77.53 2.0458 1.0036 0.1147 0.6311 0.311274176991001 0.093305401368455 0.030622981634287998 0.006216667503447

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140617-000315" (
"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.049ms