world-cup-predictions/wc-20140624-100611

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

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 74.33 2.0422 1.2336 0.0337 0.6401 0.152131591415827 0.044050543894357 0.007521703048151001 0.002016244430958
2 Argentina ARG f 89.63 2.7355 0.4271 0.8876 1.0 0.7224704729532769 0.487516768864654 0.30831360767663696 0.136766041687987
3 Australia AUS b 67.47 1.6808 1.4028 0.0 0.0 0.0 0.0 0.0 0.0
4 Belgium BEL h 83.24 2.148 0.6549 0.9663 1.0 0.5348949271141971 0.22269710186508998 0.10604332212623802 0.029586264008834
5 Bosnia and Herzegovina BIH f 79.36 2.1892 0.9814 0.0 0.0 0.0 0.0 0.0 0.0
6 Brazil BRA a 91.3 3.2355 0.5203 1.0 1.0 0.781063218516647 0.630875148191154 0.48139544050645 0.37937399254460796
7 Chile CHI b 86.51 2.5638 0.6397 0.0 1.0 0.21893678148328 0.11937742738865402 0.057599655139950995 0.029908049784608995
8 Ivory Coast CIV c 79.78 2.2765 1.0104 0.0128 0.7645 0.410296064597658 0.15620697928841198 0.059400139549947994 0.013817578324153
9 Cameroon CMR a 68.12 1.4495 1.1711 0.0 0.0 0.0 0.0 0.0 0.0
10 Colombia COL c 87.38 2.4055 0.4584 0.9872 1.0 0.6546896481470551 0.192199691814393 0.094755733439504 0.049649621262122
11 Costa Rica CRC d 78.53 1.5816 0.6108 0.883 1.0 0.46547571394905896 0.154902492931729 0.053327025433185994 0.011318152150712
12 Croatia CRO a 77.85 2.0363 0.9831 0.0 0.0 0.0 0.0 0.0 0.0
13 Ecuador ECU e 80.01 1.9795 0.7881 0.0036 0.3726 0.11484672141691199 0.05171194876446401 0.021672459170547997 0.005003288454669
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
16 France FRA e 87.82 2.7444 0.6244 0.9961 0.9998 0.719639777687854 0.391963358372043 0.141817139424501 0.078235054730396
17 Germany GER g 88.63 3.1647 0.7912 0.8522 0.9971 0.773705656870699 0.461360130133117 0.19902788183077302 0.11450194291916599
18 Ghana GHA g 79.05 1.9912 0.8658 0.0 0.1943 0.082799015819689 0.028279220047737003 0.011469635650593 0.0024747931029050004
19 Greece GRE c 72.83 1.1075 0.6136 0.0 0.1981 0.08047720167784 0.021782271445509996 0.005892805202081 0.0008988673210750001
20 Honduras HON e 68.39 1.5099 1.2039 0.0 0.0208 0.003469863914871 0.000996896409698 0.000260303606189 3.113556233e-05
21 Iran IRN f 70.9 1.1282 0.7436 0.0 0.1237 0.023842843243239 0.005605094133863001 0.000712714123822 0.000168117800268
22 Italy ITA d 79.29 1.9384 0.8114 0.0514 0.5776 0.20017806863184 0.037938343000984004 0.012675058799788998 0.00406533571694
23 Japan JPN c 73.42 1.9724 1.2429 0.0 0.0374 0.015343082976986 0.0041487813377870005 0.0011226784318710001 0.00016683850816100003
24 South Korea KOR h 64.51 1.6438 1.5604 0.0 0.0067 0.00071089438223 0.00012346092652500002 1.0248610127e-05 1.7501119419999997e-06
25 Mexico MEX a 80.23 1.6356 0.5319 0.0 1.0 0.31237882220372404 0.159363363451386 0.058680908055167 0.01323107497831
26 Netherlands NED b 87.42 2.812 0.7052 1.0 1.0 0.6876211777962591 0.48080766922575197 0.26565559411326894 0.10076069449763499
27 Nigeria NGA f 76.19 1.5304 0.7288 0.1124 0.8763 0.244153118016195 0.077496736761369 0.01664551559543 0.004178661047939
28 Portugal POR g 79.06 2.1023 0.9427 0.0 0.0514 0.022253255969021 0.007719507938734001 0.0031761693302590002 0.00069583835538
29 Russia RUS h 76.93 1.4614 0.6293 0.0 0.3532 0.08876410301008301 0.027665953098739 0.00480104654696 0.001485686866974
30 Switzerland SUI e 78.08 2.1497 1.0474 0.0003 0.6068 0.171577202767758 0.072803738842487 0.028731481559794998 0.005958442707392
31 Uruguay URU d 81.49 2.2369 0.8522 0.0656 0.4224 0.173540220019547 0.04239783192424701 0.016479495074673 0.005794397273744
32 USA USA g 78.85 2.1611 0.9996 0.1478 0.7572 0.344740555418344 0.120009539947202 0.042812237954083 0.009912135850808001

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140624-100611" (
"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 52.161ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub