world-cup-predictions/wc-20140624-181518

32 rows sorted by sixteen

View and edit SQL

Suggested facets: group, win_group, sixteen, quarter, cup, win

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen ▼ quarter semi cup win
3 Australia AUS b 67.47 1.6808 1.4028 0.0 0.0 0.0 0.0 0.0 0.0
5 Bosnia and Herzegovina BIH f 79.36 2.1892 0.9814 0.0 0.0 0.0 0.0 0.0 0.0
9 Cameroon CMR a 68.12 1.4495 1.1711 0.0 0.0 0.0 0.0 0.0 0.0
12 Croatia CRO a 77.85 2.0363 0.9831 0.0 0.0 0.0 0.0 0.0 0.0
14 England ENG d 81.41 2.1272 0.7842 0.0 0.0 0.0 0.0 0.0 0.0
15 Spain ESP b 86.3 2.5 0.6188 0.0 0.0 0.0 0.0 0.0 0.0
22 Italy ITA d 79.29 1.9384 0.8114 0.0 0.0 0.0 0.0 0.0 0.0
24 South Korea KOR h 64.51 1.6438 1.5604 0.0 0.0075 0.000946067448014 0.000163064235963 1.3481952816e-05 2.236931978e-06
20 Honduras HON e 68.39 1.5099 1.2039 0.0 0.0219 0.0036006736095829995 0.001028763015756 0.00027067100968900003 3.2500947028e-05
23 Japan JPN c 73.42 1.9724 1.2429 0.0 0.0389 0.016296587458765 0.0044066096768129994 0.0012075255027480002 0.000179951116467
28 Portugal POR g 79.06 2.1023 0.9427 0.0 0.0474 0.020588294368124 0.007038453881981999 0.002898223459956 0.000637224775244
21 Iran IRN f 70.9 1.1282 0.7436 0.0 0.126 0.024284421002515 0.005712120591085001 0.000725720128261 0.00017113330284799998
18 Ghana GHA g 79.05 1.9912 0.8658 0.0 0.1885 0.080443960702729 0.027704307772235 0.011253166534658 0.0024323711006670004
19 Greece GRE c 72.83 1.1075 0.6136 0.0 0.1951 0.080374415403291 0.021754450913901 0.005821787403830999 0.0008932878552030001
29 Russia RUS h 76.93 1.4614 0.6293 0.0 0.3574 0.089296824148196 0.027892119167767005 0.004840456310607 0.001498597950467
13 Ecuador ECU e 80.01 1.9795 0.7881 0.0033 0.3751 0.116791792610445 0.05274539470821 0.022166401209507 0.005123495232806
30 Switzerland SUI e 78.08 2.1497 1.0474 0.0003 0.603 0.169072851474207 0.07176679970589099 0.028391075129855 0.0059062853619269995
1 Algeria ALG h 74.33 2.0422 1.2336 0.0367 0.6351 0.15231661218421 0.04406288599552401 0.0076002411279019995 0.002022530594791
8 Ivory Coast CIV c 79.78 2.2765 1.0104 0.0122 0.766 0.4153166596127871 0.158299236002029 0.060329874077183 0.014053176388164
32 USA USA g 78.85 2.1611 0.9996 0.148 0.7668 0.349498048530834 0.12166510752930197 0.043538792576997 0.010094102486827
27 Nigeria NGA f 76.19 1.5304 0.7288 0.112 0.874 0.24322933084974396 0.077394279456234 0.016644578106046002 0.004180175212742
17 Germany GER g 88.63 3.1647 0.7912 0.852 0.9973 0.77312990038399 0.460631488856487 0.199046650177535 0.114594770068995
2 Argentina ARG f 89.63 2.7355 0.4271 0.888 1.0 0.722822652950477 0.48755165241401205 0.308702134536429 0.13718821780586601
4 Belgium BEL h 83.24 2.148 0.6549 0.9633 1.0 0.533780292233991 0.22221186226910897 0.10590782108543301 0.029636737461802
6 Brazil BRA a 91.3 3.2355 0.5203 1.0 1.0 0.781063218516647 0.628220618793489 0.479408189893429 0.377819771001
7 Chile CHI b 86.51 2.5638 0.6397 0.0 1.0 0.21893678148328 0.117720166302422 0.056809852005742005 0.029505412538751
10 Colombia COL c 87.38 2.4055 0.4584 0.9878 1.0 0.6202232695217211 0.182104184603346 0.08977832767221801 0.047055359994922004
11 Costa Rica CRC d 78.53 1.5816 0.6108 1.0 1.0 0.485309914785195 0.16891986167129003 0.058382498448410994 0.0121649713681
16 France FRA e 87.82 2.7444 0.6244 0.9964 1.0 0.720198277503139 0.392431700400519 0.142232499267228 0.078469800082868
25 Mexico MEX a 80.23 1.6356 0.5319 0.0 1.0 0.31237882220372404 0.16037078642437302 0.059050082875421 0.013348502812017998
26 Netherlands NED b 87.42 2.812 0.7052 1.0 1.0 0.6876211777962591 0.48274237605514503 0.266725905320755 0.10138531386671999
31 Uruguay URU d 81.49 2.2369 0.8522 0.0 1.0 0.382479153218255 0.07546170955736099 0.028254044187310003 0.011604073741801002

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140624-181518" (
"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.102ms