world-cup-predictions/wc-20140615-030217

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.1193 1.1652 0.0559 0.1952 0.036463248275172 0.007627300966429 0.0009756230695100001 0.00012488212100000002
2 Argentina ARG f 89.99 2.8546 0.45 0.735 0.9172 0.660629954468069 0.460184956260147 0.284739724736969 0.130766936764436
3 Australia AUS b 69.0 1.6523 1.2717 0.0016 0.0207 0.0015039352460859997 0.00045040762399500004 9.940198430600001e-05 1.6079938359e-05
4 Belgium BEL h 82.01 2.1377 0.7362 0.4934 0.7823 0.356842945882919 0.150803652463599 0.05693598573061 0.016015632640773
5 Bosnia and Herzegovina BIH f 80.33 2.3162 0.9857 0.158 0.5687 0.266717702936508 0.114839223968526 0.033071790579547004 0.009625300906162
6 Brazil BRA a 91.63 3.391 0.5577 0.9705 0.9989 0.792943965770741 0.6816570201701279 0.552040070442157 0.44376363256949
7 Chile CHI b 86.68 2.7208 0.7117 0.3077 0.775 0.321205618127669 0.20815492432426003 0.111921160522129 0.044597569099122
8 Ivory Coast CIV c 78.84 2.2473 1.0498 0.2699 0.7742 0.39637997155387605 0.119609766162163 0.04416586756294 0.010447787013163
9 Cameroon CMR a 70.01 1.3521 0.968 0.0005 0.0291 0.005831286056846 0.002060881510317 0.000514085589499 6.6258036322e-05
10 Colombia COL c 85.81 2.1793 0.4513 0.7005 0.9419 0.585853548931339 0.18244171970350798 0.089668110378795 0.036123681741152
11 Costa Rica CRC d 74.13 1.3273 0.6977 0.3458 0.658 0.2412219487186 0.052727843874542 0.015398393901693001 0.002861502719701
12 Croatia CRO a 76.25 1.8066 0.9186 0.002 0.3762 0.10254432450885499 0.044992135331431 0.01433397062182 0.002551873548394
13 Ecuador ECU e 80.79 2.0336 0.7584 0.2401 0.5611 0.232707358056438 0.103293391103438 0.033999908607195 0.00939464610077
14 England ENG d 83.16 2.2045 0.6895 0.1056 0.3523 0.179409058555315 0.05136068631633401 0.022617408704877003 0.007734020996818001
15 Spain ESP b 86.8 2.6166 0.6364 0.0261 0.2462 0.066545385882602 0.041346259759208 0.022058701396314 0.010135521874318001
16 France FRA e 86.13 2.4875 0.6181 0.5318 0.7966 0.452272040520335 0.24554171889889398 0.09271007516558301 0.038863629228027996
17 Germany GER g 88.86 3.1981 0.7783 0.6646 0.874 0.676737118932485 0.443384477006128 0.198299918006956 0.109518143205287
18 Ghana GHA g 77.4 1.9047 0.9113 0.0874 0.3161 0.155052069566005 0.05362569609105 0.01651585464863 0.003507122030194
19 Greece GRE c 76.83 1.3401 0.5379 0.014 0.1643 0.075305842299625 0.023446269599220002 0.007480242042676 0.001390581349981
20 Honduras HON e 69.73 1.5687 1.1589 0.0592 0.201 0.04931492900309299 0.014676983538555 0.0031766391860340005 0.00045830761805199996
21 Iran IRN f 70.6 1.2974 0.8887 0.0365 0.1944 0.05888182184379499 0.01598483127087 0.0025615552464450003 0.00046543595077599997
22 Italy ITA d 79.39 1.9753 0.8202 0.4652 0.7344 0.339271908125368 0.10354893756549198 0.038176805969436005 0.009038704569221
23 Japan JPN c 73.61 2.1362 1.3426 0.0156 0.1196 0.049583014777587996 0.013007427812565002 0.003607242652747 0.000550672958135
24 South Korea KOR h 72.44 1.6916 1.0833 0.1405 0.3917 0.105110983424327 0.030074263842786 0.0057742663885630005 0.001034305678891
25 Mexico MEX a 77.55 1.5331 0.6328 0.027 0.5958 0.17058856421484 0.07643786768068599 0.025479977783279 0.004786623622074999
26 Netherlands NED b 86.94 2.8146 0.7449 0.6646 0.9581 0.5388369201922849 0.35895443428757706 0.19532673673893 0.073113398155013
27 Nigeria NGA f 75.14 1.6667 0.8891 0.0705 0.3197 0.117766774792554 0.039444803995714 0.008214720036078 0.0018492572931049999
28 Portugal POR g 81.07 2.1479 0.8149 0.1514 0.4767 0.26817696344089503 0.11071862864524001 0.039694637395812006 0.010602560126863999
29 Russia RUS h 79.0 1.656 0.623 0.3102 0.6308 0.235694566639917 0.086612436161087 0.025161573546584003 0.006066015078891
30 Switzerland SUI e 78.06 1.9812 0.9198 0.1689 0.4413 0.16170941837921302 0.064974062466622 0.019419116905773 0.004519721396961
31 Uruguay URU d 83.23 2.2318 0.7017 0.0834 0.2553 0.132974707038351 0.039803418278596 0.017855123627455 0.006118549670027
32 USA USA g 77.47 2.0538 1.0128 0.0966 0.3332 0.16592210383829098 0.05821357332089401 0.018005310830656998 0.0038916459985179996

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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