This data as json, CSV (advanced)
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 | 1 | Algeria | ALG | h | 64.22 | 1.1757 | 1.1682 | 0.024 | 0.1601 | 0.026137633503823997 | 0.004762820123842999 | 0.000625121492642 | 8.585510843899999e-05 |
2 | 2 | Argentina | ARG | f | 89.92 | 2.8288 | 0.4448 | 0.9033 | 1.0 | 0.7357357957780211 | 0.5150712772621779 | 0.330783156304989 | 0.154600102648226 |
3 | 3 | Australia | AUS | b | 70.33 | 1.7888 | 1.2996 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
4 | 4 | Belgium | BEL | h | 81.82 | 2.1451 | 0.7583 | 0.6486 | 0.87 | 0.40199038112440005 | 0.15387561341366598 | 0.06352451703277201 | 0.017696037682148 |
5 | 5 | Bosnia and Herzegovina | BIH | f | 80.59 | 2.3324 | 0.9795 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
6 | 6 | Brazil | BRA | a | 91.07 | 3.1874 | 0.5156 | 0.9174 | 0.9938 | 0.750206111674258 | 0.603403624057202 | 0.451811175415877 | 0.34845387729937705 |
7 | 7 | Chile | CHI | b | 87.79 | 2.7379 | 0.6167 | 0.3995 | 1.0 | 0.447972591916498 | 0.29437714439875295 | 0.15787199921561904 | 0.069349428052618 |
8 | 8 | Ivory Coast | CIV | c | 79.49 | 2.2617 | 1.0151 | 0.0142 | 0.7402 | 0.393062389118911 | 0.146258348864573 | 0.053462491842893 | 0.012634453268506 |
9 | 9 | Cameroon | CMR | a | 69.4 | 1.4905 | 1.12 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
10 | 10 | Colombia | COL | c | 87.51 | 2.4223 | 0.4507 | 0.9858 | 1.0 | 0.6586811888789339 | 0.213942882817648 | 0.1045912493672 | 0.052364321225439006 |
11 | 11 | Costa Rica | CRC | d | 78.55 | 1.5911 | 0.6107 | 0.8757 | 1.0 | 0.46677754554421297 | 0.15474900326743898 | 0.05180199473336 | 0.011343037929811998 |
12 | 12 | Croatia | CRO | a | 79.53 | 2.0276 | 0.8497 | 0.0369 | 0.3948 | 0.127729329129002 | 0.064294042816293 | 0.022872672161676003 | 0.005214875198755 |
13 | 13 | Ecuador | ECU | e | 80.0 | 1.989 | 0.789 | 0.0039 | 0.3739 | 0.110326190609519 | 0.051914696729333 | 0.021413681134464 | 0.005111987647438 |
14 | 14 | England | ENG | d | 81.43 | 2.1314 | 0.7789 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
15 | 15 | Spain | ESP | b | 85.73 | 2.4815 | 0.6526 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
16 | 16 | France | FRA | e | 87.82 | 2.7485 | 0.62 | 0.9958 | 0.9998 | 0.7355343124624691 | 0.395742684425909 | 0.15337539229046399 | 0.080646409895771 |
17 | 17 | Germany | GER | g | 89.38 | 3.237 | 0.745 | 0.7762 | 0.9804 | 0.7770606993794341 | 0.478690576089819 | 0.23479513758478998 | 0.13537747841636 |
18 | 18 | Ghana | GHA | g | 76.28 | 1.8449 | 0.9481 | 0.0 | 0.155 | 0.068740023424567 | 0.019834424236486 | 0.0070731208739240005 | 0.00133367611425 |
19 | 19 | Greece | GRE | c | 74.21 | 1.1796 | 0.5825 | 0.0 | 0.2165 | 0.09147638122301 | 0.025996729885075 | 0.007168292624101 | 0.0012046518617049998 |
20 | 20 | Honduras | HON | e | 68.33 | 1.5117 | 1.2037 | 0.0 | 0.0211 | 0.003171893896433 | 0.000964160720018 | 0.00025165153249000004 | 3.0655072943000006e-05 |
21 | 21 | Iran | IRN | f | 70.81 | 1.1916 | 0.7949 | 0.0 | 0.1239 | 0.023651341716592004 | 0.005450542032817 | 0.000754011131153 | 0.000163413977494 |
22 | 22 | Italy | ITA | d | 79.26 | 1.9422 | 0.8095 | 0.0603 | 0.5852 | 0.202886647840559 | 0.043055120542814 | 0.014098839245529 | 0.0042499351426029995 |
23 | 23 | Japan | JPN | c | 73.35 | 1.9701 | 1.2392 | 0.0 | 0.0433 | 0.017803535566033 | 0.004837993741932 | 0.0012740037910530001 | 0.000194539135702 |
24 | 24 | South Korea | KOR | h | 72.52 | 1.6902 | 1.0808 | 0.1217 | 0.4062 | 0.098637274487032 | 0.024123943093597 | 0.0049304632576850005 | 0.0008957957361719999 |
25 | 25 | Mexico | MEX | a | 78.45 | 1.4757 | 0.534 | 0.0457 | 0.6114 | 0.18145713687351897 | 0.08563425916043801 | 0.028170604854143997 | 0.00585708096803 |
26 | 26 | Netherlands | NED | b | 86.18 | 2.7976 | 0.8089 | 0.6005 | 1.0 | 0.492634830406801 | 0.319170696342193 | 0.16117378113234498 | 0.061659199867296 |
27 | 27 | Nigeria | NGA | f | 74.86 | 1.5469 | 0.8212 | 0.0967 | 0.8761 | 0.22653364999890196 | 0.068174292383725 | 0.014315401883906 | 0.003286271792816 |
28 | 28 | Portugal | POR | g | 79.07 | 2.082 | 0.9213 | 0.0316 | 0.2315 | 0.118024266705303 | 0.0400254972797 | 0.015048337040912 | 0.003520368484479 |
29 | 29 | Russia | RUS | h | 78.33 | 1.6129 | 0.6409 | 0.2057 | 0.5637 | 0.186976730914508 | 0.059974556812256 | 0.016894263942572 | 0.004170706864219001 |
30 | 30 | Switzerland | SUI | e | 78.27 | 2.1691 | 1.0401 | 0.0003 | 0.6052 | 0.16504681553798 | 0.07368029582601401 | 0.029040741265318998 | 0.0063020488638119996 |
31 | 31 | Uruguay | URU | d | 81.49 | 2.2386 | 0.8471 | 0.064 | 0.4148 | 0.16931231182829 | 0.044280154105602994 | 0.016884537395438 | 0.005764516544003 |
32 | 32 | USA | USA | g | 78.54 | 2.1097 | 0.9792 | 0.1922 | 0.6331 | 0.322432990461005 | 0.10771461957064901 | 0.035993361452665004 | 0.008489275201589 |
JSON shape: default, array, newline-delimited
CREATE TABLE "world-cup-predictions/wc-20140621-235521" ( "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 );