home / fivethirtyeight

Menu
  • GraphQL API

fivethirtyeight

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

Custom SQL query returning 32 rows (hide)

This data as json, copyable, CSV

rowidcountrycountry_idgroupspispi_offensespi_defensewin_groupsixteenquartersemicupwin
1 Algeria ALG h 63.41 1.1202 1.1642 0.0555 0.1963 0.036780895058992 0.007677398475572 0.001020113499434 0.00013144804098
2 Argentina ARG f 90.0 2.8542 0.4498 0.7365 0.9229 0.664796448676131 0.463611764557936 0.294145786085739 0.134268940764052
3 Australia AUS b 69.47 1.638 1.232 0.0023 0.028 0.002338868676836 0.000696787252544 0.000154974779931 2.5537700391e-05
4 Belgium BEL h 82.0 2.1387 0.7397 0.4882 0.7733 0.352992884740186 0.14909657332427 0.058471171125942 0.016270857229176
5 Bosnia and Herzegovina BIH f 80.32 2.3119 0.9862 0.1618 0.5669 0.264722097149243 0.113653245827749 0.033675278504948 0.009753098661943
6 Brazil BRA a 91.64 3.3933 0.559 0.9687 0.998 0.809526071815375 0.700023476224802 0.566452864593203 0.459236251410148
7 Chile CHI b 86.71 2.7085 0.7041 0.4074 0.7718 0.370268312556236 0.234569690883614 0.125596359801523 0.047685946826532
8 Ivory Coast CIV c 78.89 2.2468 1.0484 0.2329 0.5399 0.248678673705927 0.076672869464821 0.02827593444071 0.006874377277919
9 Cameroon CMR a 71.33 1.4802 0.9908 0.0017 0.0406 0.010596202167917 0.003574240572196 0.000910329009373 0.000125624687101
10 Colombia COL c 85.82 2.1806 0.4532 0.5228 0.7838 0.45942818699435 0.157618202940715 0.077098888107021 0.030056348724907
11 Costa Rica CRC d 74.07 1.3226 0.6996 0.0925 0.2607 0.100172060873432 0.020040613788269 0.005826035625585 0.001168511637762
12 Croatia CRO a 76.13 1.7849 0.9129 0.0016 0.3714 0.121862190073512 0.049687274372621 0.015845231368468 0.002750102491457
13 Ecuador ECU e 80.64 2.0295 0.7689 0.2397 0.5682 0.233393776579798 0.103303005295502 0.034923921157472 0.009487086308756
14 England ENG d 83.2 2.2051 0.689 0.3368 0.6331 0.350877439324714 0.129574406849317 0.05702526413735 0.017499015554612
15 Spain ESP b 89.13 2.6874 0.4467 0.0533 0.3007 0.106346234828585 0.071885700849707 0.042343640888002 0.021500871731755
16 France FRA e 86.13 2.4862 0.6189 0.5369 0.8015 0.455035014880634 0.246013853155826 0.094090614642979 0.039565907075767
17 Germany GER g 88.88 3.194 0.7751 0.6706 0.8833 0.684593663677859 0.448062149938048 0.201017254250532 0.111935903665949
18 Ghana GHA g 77.22 1.908 0.9282 0.0891 0.316 0.154879091349284 0.053243113856098 0.016926270765174 0.003536351240539
19 Greece GRE c 76.79 1.3365 0.5396 0.1405 0.3794 0.152016582287465 0.042583682001699 0.013610225572134 0.002738313387584
20 Honduras HON e 69.6 1.5609 1.162 0.0528 0.1834 0.044428920362229 0.013085771557332 0.003040829875745 0.000426953154642
21 Iran IRN f 70.63 1.2971 0.8882 0.0326 0.1882 0.056197564212007 0.015170953218345 0.002458131496099 0.000454441704566
22 Italy ITA d 79.51 1.9842 0.8202 0.2015 0.4534 0.215544342462408 0.061615691954578 0.022943496243145 0.005853805835686
23 Japan JPN c 73.48 2.1293 1.3485 0.1038 0.2969 0.105639052954327 0.026131519907867 0.007247790136863 0.001167890913985
24 South Korea KOR h 72.41 1.69 1.0862 0.1476 0.3929 0.105255659759807 0.029588234023322 0.005945628396935 0.001057480534099
25 Mexico MEX a 76.93 1.5518 0.6892 0.028 0.59 0.196952471182887 0.081478640478858 0.026443476878122 0.004760306451994
26 Netherlands NED b 82.5 2.3138 0.8173 0.537 0.8995 0.382109648698712 0.201910872679034 0.087231507293444 0.024459262071407
27 Nigeria NGA f 75.23 1.6678 0.8866 0.0691 0.322 0.119321429185419 0.039854579736677 0.008519420090973 0.001937669604364
28 Portugal POR g 81.0 2.1386 0.8161 0.1537 0.4738 0.265621107795196 0.109082064634083 0.040302365931125 0.010616242495647
29 Russia RUS h 79.01 1.6554 0.6238 0.3087 0.6375 0.237601289698803 0.087242911080294 0.026150311870358 0.006295593081855
30 Switzerland SUI e 78.09 1.9841 0.9216 0.1706 0.4469 0.162104748954499 0.065299971798067 0.020219380708881 0.004703574874327
31 Uruguay URU d 83.33 2.2379 0.6999 0.3692 0.6528 0.367643661397344 0.141936329779359 0.063691008853354 0.019776043096311
32 USA USA g 77.42 2.0473 1.0141 0.0866 0.3269 0.162275407919881 0.056014409520873 0.018396493869439 0.003880241763788
Powered by Datasette · Queries took 17.482ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette