world-cup-predictions/wc-20140614-210740

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

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.0605 0.1977 0.037178679088309 0.0077691657813409995 0.0010016981248710001 0.000126492522173
2 Argentina ARG f 89.99 2.8546 0.45 0.7405 0.9238 0.6657997343666839 0.4636831843630321 0.28571422908202004 0.131411937439466
3 Australia AUS b 69.0 1.6523 1.2717 0.0026 0.0204 0.001938295656431 0.00057150978909 0.000133508795974 1.9199757287e-05
4 Belgium BEL h 82.01 2.1377 0.7362 0.4959 0.7868 0.359984631754447 0.151916268233057 0.057103622910106 0.01607843621627
5 Bosnia and Herzegovina BIH f 80.33 2.3162 0.9857 0.1601 0.569 0.265511126906161 0.11433339101994199 0.032893694314675 0.009580999920542
6 Brazil BRA a 91.63 3.391 0.5577 0.9669 0.9983 0.7921829118753001 0.680168651564631 0.5510628853764928 0.44248315207767097
7 Chile CHI b 86.68 2.7208 0.7117 0.3083 0.7741 0.321584037630187 0.207535920342898 0.111282211045364 0.044378718269478
8 Ivory Coast CIV c 78.84 2.2473 1.0498 0.1698 0.5593 0.279051899806629 0.086649017667071 0.031764900930203 0.0074264127127299994
9 Cameroon CMR a 70.01 1.3521 0.968 0.0006 0.0334 0.006618585990913001 0.002302485394637 0.000563660315661 7.3269336412e-05
10 Colombia COL c 85.81 2.1793 0.4513 0.738 0.9431 0.58231260865945 0.17487277254191802 0.085788954086843 0.035300172800503994
11 Costa Rica CRC d 74.13 1.3273 0.6977 0.3383 0.6699 0.251019045084876 0.054637708789357003 0.015836016317321 0.00295866685669
12 Croatia CRO a 76.25 1.8066 0.9186 0.0023 0.3842 0.10493691305084302 0.045809013279746 0.014640784891784999 0.0026054647477090002
13 Ecuador ECU e 80.79 2.0336 0.7584 0.2378 0.5605 0.232247928934214 0.10302992557351301 0.033986585050344 0.009360354997589
14 England ENG d 83.16 2.2045 0.6895 0.3586 0.616 0.334295559372747 0.119695634628552 0.05254272672263901 0.015870824545658
15 Spain ESP b 86.8 2.6166 0.6364 0.0256 0.2469 0.06644891067592 0.041228068613974 0.021962934388540002 0.01009390130355
16 France FRA e 86.13 2.4875 0.6181 0.5353 0.8046 0.458273892075753 0.249733494301043 0.09424009393256 0.039371019782929
17 Germany GER g 88.86 3.1981 0.7783 0.651 0.8706 0.6738510509614891 0.44109850139497103 0.19874015629215502 0.108994161436987
18 Ghana GHA g 77.4 1.9047 0.9113 0.0862 0.3124 0.153223678576268 0.052651089453635 0.016166949299901003 0.003438760898817
19 Greece GRE c 76.83 1.3401 0.5379 0.0184 0.1962 0.086276697629597 0.026637654099848 0.008548755238144 0.001589068515778
20 Honduras HON e 69.73 1.5687 1.1589 0.0595 0.1952 0.04743772668478401 0.013787002728849 0.0029686240783059997 0.0004335265572330001
21 Iran IRN f 70.6 1.2974 0.8887 0.0341 0.1948 0.058059004549415996 0.015697888840785 0.002476378677933 0.000451904577917
22 Italy ITA d 79.39 1.9753 0.8202 0.2188 0.4516 0.208823522543988 0.057301453134959004 0.021147653041268002 0.0052785345288699995
23 Japan JPN c 73.61 2.1362 1.3426 0.0738 0.3014 0.11964136937465901 0.028640872523836004 0.007905590864155 0.001263194952319
24 South Korea KOR h 72.44 1.6916 1.0833 0.1426 0.3847 0.10354588575820699 0.028965812361568 0.0055810387268 0.00099457537326
25 Mexico MEX a 77.55 1.5331 0.6328 0.0302 0.5841 0.167584809197133 0.07472428051699201 0.024664734018087 0.0046485187988809995
26 Netherlands NED b 86.94 2.8146 0.7449 0.6635 0.9586 0.538705535923194 0.357653521424069 0.19408306624177102 0.07271652851009101
27 Nigeria NGA f 75.14 1.6667 0.8891 0.0653 0.3124 0.114833605675026 0.038208920134372 0.007871092585489 0.0017821280864260003
28 Portugal POR g 81.07 2.1479 0.8149 0.164 0.4865 0.27381565282201 0.11217583825235801 0.039647982017121004 0.010667835068116
29 Russia RUS h 79.0 1.656 0.623 0.301 0.6308 0.234131526396559 0.08601369811707299 0.024597113869453 0.005992575683171999
30 Switzerland SUI e 78.06 1.9812 0.9198 0.1674 0.4397 0.15783698080796302 0.063471131811888 0.018818611801503002 0.004399011180537
31 Uruguay URU d 83.23 2.2318 0.7017 0.0843 0.2625 0.13857929752810003 0.041571435688445 0.018625673208727 0.006384514157296
32 USA USA g 77.47 2.0538 1.0128 0.0988 0.3305 0.16426889464272101 0.05746468763255 0.017638073753787 0.003826138387644

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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