fivethirtyeight

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

Custom SQL query returning 32 rows (show)

rowidcountrycountry_idgroupspispi_offensespi_defensewin_groupsixteenquartersemicupwin
1 Algeria ALG h 75.78 2.0371 1.1288 0 1 0 0 0.0 0.0
2 Argentina ARG f 89.55 2.7778 0.4523 1 1 1 1 0.551426183133153 0.19279433227981302
3 Australia AUS b 67.48 1.6932 1.4136 0 0 0 0 0.0 0.0
4 Belgium BEL h 83.39 2.0625 0.5815 1 1 1 0 0.0 0.0
5 Bosnia and Herzegovina BIH f 80.27 2.28 0.9725 0 0 0 0 0.0 0.0
6 Brazil BRA a 90.84 3.1211 0.5006 1 1 1 1 0.7323952338924029 0.536714258545463
7 Chile CHI b 86.41 2.5199 0.6144 0 1 0 0 0.0 0.0
8 Ivory Coast CIV c 78.36 2.2481 1.0948 0 0 0 0 0.0 0.0
9 Cameroon CMR a 68.4 1.4804 1.1804 0 0 0 0 0.0 0.0
10 Colombia COL c 89.29 2.6309 0.39299999999999996 1 1 1 0 0.0 0.0
11 Costa Rica CRC d 78.12 1.5056 0.5816 1 1 1 0 0.0 0.0
12 Croatia CRO a 77.95 2.0444 0.9804 0 0 0 0 0.0 0.0
13 Ecuador ECU e 80.2 1.7948 0.6429 0 0 0 0 0.0 0.0
14 England ENG d 81.06 2.0549 0.7585 0 0 0 0 0.0 0.0
15 Spain ESP b 86.26 2.4998 0.6155 0 0 0 0 0.0 0.0
16 France FRA e 87.74 2.5758 0.5206 1 1 1 0 0.0 0.0
17 Germany GER g 88.68 2.9235 0.634 1 1 1 1 0.267604766107597 0.134419672494964
18 Ghana GHA g 78.44 2.0108 0.9211 0 0 0 0 0.0 0.0
19 Greece GRE c 74.83 1.1857 0.5541 0 1 0 0 0.0 0.0
20 Honduras HON e 65.77 1.4471 1.3155 0 0 0 0 0.0 0.0
21 Iran IRN f 69.33 1.1118 0.823 0 0 0 0 0.0 0.0
22 Italy ITA d 78.43 1.819 0.7859999999999999 0 0 0 0 0.0 0.0
23 Japan JPN c 72.87 2.029 1.3238 0 0 0 0 0.0 0.0
24 South Korea KOR h 65.27 1.5264 1.4137 0 0 0 0 0.0 0.0
25 Mexico MEX a 79.89 1.6288 0.5484 0 1 0 0 0.0 0.0
26 Netherlands NED b 87.75 2.8653 0.6958 1 1 1 1 0.44857381686684705 0.13607173667976
27 Nigeria NGA f 76.13 1.6419 0.8144 0 1 0 0 0.0 0.0
28 Portugal POR g 79.82 2.1783 0.9372 0 0 0 0 0.0 0.0
29 Russia RUS h 76.6 1.4475 0.6395 0 0 0 0 0.0 0.0
30 Switzerland SUI e 79.64 2.1847 0.9552 0 1 0 0 0.0 0.0
31 Uruguay URU d 80.97 2.1056 0.8004 0 1 0 0 0.0 0.0
32 USA USA g 78.24 2.0031 0.9302 0 1 0 0 0.0 0.0
Powered by Datasette · Query took 1.059ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub