fivethirtyeight

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

Custom SQL query returning 32 rows (hide)

rowidcountrycountry_idgroupspispi_offensespi_defensewin_groupsixteenquartersemicupwin
1 Algeria ALG h 75.69 2.0383 1.1354 0 1 0 0 0.0 0.0
3 Australia AUS b 67.52 1.7067 1.4224 0 0 0 0 0.0 0.0
4 Belgium BEL h 83.0 1.9837 0.56 1 1 1 0 0.0 0.0
5 Bosnia and Herzegovina BIH f 80.33 2.2891 0.9741 0 0 0 0 0.0 0.0
7 Chile CHI b 86.37 2.5222 0.6192 0 1 0 0 0.0 0.0
8 Ivory Coast CIV c 78.37 2.2487 1.0943 0 0 0 0 0.0 0.0
9 Cameroon CMR a 68.41 1.4796 1.1796 0 0 0 0 0.0 0.0
10 Colombia COL c 89.28 2.6289 0.3912 1 1 1 0 0.0 0.0
11 Costa Rica CRC d 78.46 1.4291 0.503 1 1 1 0 0.0 0.0
12 Croatia CRO a 77.94 2.0434 0.9803 0 0 0 0 0.0 0.0
13 Ecuador ECU e 80.25 1.8009 0.6428 0 0 0 0 0.0 0.0
14 England ENG d 81.08 2.0580000000000003 0.7589 0 0 0 0 0.0 0.0
15 Spain ESP b 86.18 2.5041 0.6247 0 0 0 0 0.0 0.0
16 France FRA e 87.74 2.5769 0.5206 1 1 1 0 0.0 0.0
18 Ghana GHA g 78.42 2.0118 0.9233 0 0 0 0 0.0 0.0
19 Greece GRE c 74.88 1.1942 0.5574 0 1 0 0 0.0 0.0
20 Honduras HON e 65.85 1.4515 1.3143 0 0 0 0 0.0 0.0
21 Iran IRN f 69.4 1.1183 0.8243 0 0 0 0 0.0 0.0
22 Italy ITA d 78.43 1.8231 0.7883 0 0 0 0 0.0 0.0
23 Japan JPN c 72.96 2.0424 1.3278 0 0 0 0 0.0 0.0
24 South Korea KOR h 65.24 1.528 1.4169999999999998 0 0 0 0 0.0 0.0
25 Mexico MEX a 79.88 1.6378 0.5549 0 1 0 0 0.0 0.0
27 Nigeria NGA f 76.23 1.6538 0.8162 0 1 0 0 0.0 0.0
28 Portugal POR g 79.8 2.1765 0.9369 0 0 0 0 0.0 0.0
29 Russia RUS h 76.55 1.4491 0.6437 0 0 0 0 0.0 0.0
30 Switzerland SUI e 79.66 2.189 0.9557 0 1 0 0 0.0 0.0
31 Uruguay URU d 80.97 2.1157 0.8062 0 1 0 0 0.0 0.0
32 USA USA g 78.21 2.0084 0.9359999999999999 0 1 0 0 0.0 0.0
2 Argentina ARG f 89.59 2.7122 0.4067 1 1 1 1 0.5665734284941171 0.19675234917287598
6 Brazil BRA a 90.82 3.1191 0.4996 1 1 1 1 0.7323374160233229 0.5413234222288761
17 Germany GER g 88.66 2.9216 0.633 1 1 1 1 0.26766258397667697 0.136910746036295
26 Netherlands NED b 87.46 2.7141 0.6326 1 1 1 1 0.433426571505883 0.12501348256195302
Powered by Datasette · Query took 1.824ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub