world-cup-predictions/wc-20140621-205738

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 64.22 1.1757 1.1682 0.0208 0.1638 0.025873515281317 0.004620839484798 0.000568903189709 8.1562171353e-05
2 Argentina ARG f 89.92 2.8288 0.4448 0.9523 1.0 0.7448531006460101 0.52319975290441 0.33958332354299897 0.15751682466792
3 Australia AUS b 70.33 1.7888 1.2996 0.0 0.0 0.0 0.0 0.0 0.0
4 Belgium BEL h 81.82 2.1451 0.7583 0.6544 0.8727 0.406078692816409 0.151261658683469 0.06218054296668401 0.017398294590363
5 Bosnia and Herzegovina BIH f 80.59 2.3324 0.9795 0.0216 0.5635 0.191637578527785 0.074139763600522 0.019183335351911 0.006595880207121999
6 Brazil BRA a 91.07 3.1874 0.5156 0.9187 0.9944 0.750695709156169 0.6036045958770129 0.454032108209233 0.34894325790987296
7 Chile CHI b 87.79 2.7379 0.6167 0.4032 1.0 0.44826837186145996 0.294781591448003 0.156793506320573 0.06893431948458
8 Ivory Coast CIV c 79.49 2.2617 1.0151 0.0122 0.7438 0.39504811155103103 0.147561485293115 0.052739404129812 0.012518875957725002
9 Cameroon CMR a 69.4 1.4905 1.12 0.0 0.0 0.0 0.0 0.0 0.0
10 Colombia COL c 87.51 2.4223 0.4507 0.9878 1.0 0.6580393303491939 0.21311992372609198 0.10508148176442401 0.052313272078268
11 Costa Rica CRC d 78.55 1.5911 0.6107 0.8831 1.0 0.46828643561039796 0.15573138357812302 0.051069662641701 0.011229542862719998
12 Croatia CRO a 79.53 2.0276 0.8497 0.0378 0.3937 0.12726554719704802 0.064055350333067 0.022274087851663994 0.005102817876871999
13 Ecuador ECU e 80.0 1.989 0.789 0.0045 0.3755 0.10474943262141001 0.049048116591390994 0.020290268678343003 0.004874299669546
14 England ENG d 81.43 2.1314 0.7789 0.0 0.0 0.0 0.0 0.0 0.0
15 Spain ESP b 85.73 2.4815 0.6526 0.0 0.0 0.0 0.0 0.0 0.0
16 France FRA e 87.82 2.7485 0.62 0.9951 0.9999 0.702179526160218 0.37927624218031397 0.146867920411677 0.07691686749413801
17 Germany GER g 89.38 3.237 0.745 0.7649 0.9765 0.7752240631239821 0.476748363243182 0.23474445358328302 0.13450931934852
18 Ghana GHA g 76.28 1.8449 0.9481 0.0 0.1485 0.06590610994830699 0.018248944201181998 0.006545217395112 0.001237817747517
19 Greece GRE c 74.21 1.1796 0.5825 0.0 0.2127 0.09015301763219301 0.025563582128006 0.006850888561076 0.00116330036249
20 Honduras HON e 68.33 1.5117 1.2037 0.0 0.0203 0.002868760266765 0.000867104886817 0.000223965183354 2.7701841176999998e-05
21 Iran IRN f 70.81 1.1916 0.7949 0.0 0.1538 0.029402165218055002 0.006941311856193001 0.000960251387882 0.00020717771729599998
22 Italy ITA d 79.26 1.9422 0.8095 0.0565 0.5789 0.19987952247227603 0.042029383925112004 0.013722496241489 0.004145639173519
23 Japan JPN c 73.35 1.9701 1.2392 0.0 0.0435 0.017902500452728003 0.004782279266649999 0.001230615332276 0.00018913743686000003
24 South Korea KOR h 72.52 1.6902 1.0808 0.1271 0.409 0.10057014233266 0.023883318393535 0.004901537722806 0.00088408536435
25 Mexico MEX a 78.45 1.4757 0.534 0.0435 0.6119 0.18167434187497103 0.085842323082875 0.027649588500211 0.0057820512399959995
26 Netherlands NED b 86.18 2.7976 0.8089 0.5968 1.0 0.492096029910428 0.31878994722373905 0.15920917904091197 0.061072754854445
27 Nigeria NGA f 74.86 1.5469 0.8212 0.0261 0.2827 0.072055731705481 0.021440167517451002 0.004395882233512999 0.0010281598731439999
28 Portugal POR g 79.07 2.082 0.9213 0.0362 0.2383 0.12119711756416401 0.039921181818256005 0.014886660179928 0.0035174464909120003
29 Russia RUS h 78.33 1.6129 0.6409 0.1977 0.5545 0.181709800535474 0.05723368455741299 0.015932288222897 0.003970464475497999
30 Switzerland SUI e 78.27 2.1691 1.0401 0.0004 0.6043 0.152253704854182 0.067765777524772 0.026664771558506 0.005829600803446001
31 Uruguay URU d 81.49 2.2386 0.8471 0.0604 0.4211 0.17069108193212804 0.044138154118168 0.016745914034797 0.005746356313164
32 USA USA g 78.54 2.1097 0.9792 0.1989 0.6367 0.323440558397762 0.10540377255632101 0.034671745763224994 0.008263171987185

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140621-205738" (
"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.973ms