world-cup-predictions/wc-20140615-210736

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.36 1.1191 1.1659 0.0626 0.2008 0.037079586082793 0.0076099829125369995 0.000989556168147 0.000122486261922
2 Argentina ARG f 90.0 2.8521 0.4498 0.7394 0.9284 0.667417941808283 0.4659645635805061 0.287156873647858 0.132339770282397
3 Australia AUS b 69.04 1.6546 1.2727 0.0009 0.0177 0.0012679296229119999 0.00034007739967599997 7.4848664383e-05 1.2384897333e-05
4 Belgium BEL h 82.06 2.1405 0.7355 0.483 0.7686 0.351257918903751 0.148426493800987 0.056049126924731 0.015774382531831003
5 Bosnia and Herzegovina BIH f 80.23 2.3098 0.9905 0.155 0.56 0.25319968192409503 0.107760544219434 0.031031346281973998 0.008915413982640999
6 Brazil BRA a 91.63 3.3847 0.5572 0.9681 0.9977 0.7903011667780698 0.661871926163867 0.533413480688734 0.427828061182055
7 Chile CHI b 86.79 2.7203 0.7033 0.3124 0.7731 0.324806391200161 0.20613221582869298 0.111074196883983 0.04429511491275401
8 Ivory Coast CIV c 79.17 2.2141 1.0043 0.2149 0.7812 0.394443291769854 0.12669882541041802 0.047364833397032007 0.01105996761769
9 Cameroon CMR a 70.05 1.3531 0.9672 0.0008 0.0341 0.006810689442228001 0.002299744362487 0.000577803535572 7.556478972699999e-05
10 Colombia COL c 87.69 2.3949 0.4158 0.7628 0.9633 0.639781089516653 0.218401782725575 0.11741307115037 0.054528427025748
11 Costa Rica CRC d 77.48 1.5852 0.6767 0.4125 0.7258 0.289086237599847 0.07783584623494201 0.026116059311217004 0.00558368593236
12 Croatia CRO a 76.22 1.8052 0.9215 0.0022 0.372 0.101130222114206 0.043586190777705 0.013950008820268998 0.00247652844029
13 Ecuador ECU e 80.8 2.0274 0.7549 0.0444 0.2387 0.09010939362284301 0.041903873022403 0.016000664290565 0.004006939886277
14 England ENG d 82.21 2.1617 0.7381 0.0861 0.3253 0.148291098546387 0.039926083808537995 0.016772941236131 0.005481207716049001
15 Spain ESP b 86.78 2.6112 0.6368 0.0255 0.2498 0.067608320669777 0.04006024067834 0.021199229163498003 0.009681164521953
16 France FRA e 86.13 2.4866 0.6193 0.6826 0.9102 0.527393893045075 0.28273138170567896 0.100910067940864 0.043853502819494
17 Germany GER g 88.87 3.1972 0.7786 0.6699 0.8788 0.6809934019132831 0.441399394486248 0.19738524969177002 0.1089442256293
18 Ghana GHA g 77.38 1.9044 0.9135 0.0852 0.3103 0.152848509303094 0.052057740683054 0.015992663806911996 0.0033841926588850002
19 Greece GRE c 74.29 1.2891 0.6597 0.0099 0.1461 0.060052899883549 0.01707761835653 0.0049697329433709995 0.000807147430666
20 Honduras HON e 70.01 1.5756 1.1482 0.0085 0.0796 0.018227653407340002 0.0057821616555480005 0.001451215141085 0.00019253843048099996
21 Iran IRN f 70.6 1.2971 0.8897 0.0338 0.1925 0.05488190118184299 0.014869518987138002 0.0023528058795039995 0.000423647511302
22 Italy ITA d 80.14 2.036 0.8097 0.445 0.7397 0.333914999305032 0.105065786705718 0.040125727543371 0.009950949877108
23 Japan JPN c 73.13 2.0751 1.3309 0.0124 0.1094 0.042909365582678 0.011068367076448 0.002987738269895 0.000439506532687
24 South Korea KOR h 72.42 1.6883 1.0835 0.1495 0.3921 0.10644662677927198 0.029142364987188002 0.005643150380422 0.000991914803874
25 Mexico MEX a 77.77 1.5407 0.6249 0.0289 0.5962 0.17241511108618301 0.076142064504229 0.025624090389977996 0.004888534401279
26 Netherlands NED b 86.92 2.8119 0.747 0.6612 0.9594 0.5356601690864741 0.35012916691343104 0.19034242622294 0.071331812167327
27 Nigeria NGA f 75.07 1.6598 0.8902 0.0718 0.3191 0.11322499906421 0.0378455059909 0.00787329691675 0.0017421295216929996
28 Portugal POR g 80.99 2.1415 0.8184 0.1484 0.4649 0.260480820569714 0.106317499929621 0.037944469956531 0.010057539892249
29 Russia RUS h 78.98 1.6544 0.625 0.3049 0.6385 0.236497309181636 0.08577226662079401 0.024652011210064 0.005959218968969
30 Switzerland SUI e 78.03 1.9791 0.9216 0.2645 0.7715 0.275544535946337 0.11125718410801401 0.033873503805244995 0.007731202096071
31 Uruguay URU d 80.89 2.194 0.8617 0.0564 0.2092 0.09152101779597901 0.023364063053423 0.009428800287400998 0.002924122546085
32 USA USA g 77.76 2.0627 1.0004 0.0965 0.346 0.17439582726649303 0.061159523309941 0.019259009449431 0.0041967147315

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140615-210736" (
"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 28.82ms