fivethirtyeight

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

Custom SQL query returning 24 rows (hide)

rowidteamgroupwspiwspi_offensewspi_defensegroup_firstgroup_secondgroup_third_advancegroup_third_no_advancegroup_fourthsixteenquartersemifinalwin
1 Germany B 95.98584208 3.87817709 0.39069487 1 0 0 0 0 1 1 0.71625 0.4313 0.3287
2 USA D 95.17155166 3.54513451 0.39500423 1 0 0 0 0 1 1 0.87945 0.4397 0.3122
3 Japan C 92.28608175 2.770739 0.55658903 1 0 0 0 0 1 1 0.6195 0.3595 0.1228
4 Canada A 89.39820846 2.16137846 0.64956983 1 0 0 0 0 1 1 0.5769 0.28115 0.0822
5 France F 92.45938809 2.87121709 0.61450578 1 0 0 0 0 1 1 0.28375 0.11235 0.0631
6 Australia D 89.48423979 2.40622156 0.89733403 0 1 0 0 0 1 1 0.3805 0.17975 0.04465
7 England F 89.44996873 2.27096064 0.75733956 0 1 0 0 0 1 1 0.4231 0.1796 0.0419
8 China A 85.39163083 1.48348049 0.74762304 0 1 0 0 0 1 1 0.12055 0.01665 0.00445
9 Colombia F 80.22853762 1.07485766 1.18290426 0 0 1 0 0 1 0 0.0 0.0 0.0
10 Sweden D 91.3173372 2.67554072 0.72731706 0 0 1 0 0 1 0 0.0 0.0 0.0
11 Netherlands A 86.3493937 1.87821216 0.99563144 0 0 1 0 0 1 0 0.0 0.0 0.0
12 Cameroon C 81.15332719 1.28924313 1.26876041 0 1 0 0 0 1 0 0.0 0.0 0.0
13 Norway B 88.89282507 2.20550309 0.81478397 0 1 0 0 0 1 0 0.0 0.0 0.0
14 Brazil E 91.68669993 2.59357117 0.53525905 1 0 0 0 0 1 0 0.0 0.0 0.0
15 South Korea E 83.18267502 1.68034235 1.35958853 0 1 0 0 0 1 0 0.0 0.0 0.0
16 Switzerland C 83.69083781 1.87652891 1.48656887 0 0 1 0 0 1 0 0.0 0.0 0.0
17 Spain E 83.4537739 1.46410265 1.07613093 0 0 0 0 1 0 0 0.0 0.0 0.0
18 Thailand B 68.35123343 0.89770412 2.70560584 0 0 0 1 0 0 0 0.0 0.0 0.0
19 New Zealand A 82.82143389 1.48116673 1.20289329 0 0 0 0 1 0 0 0.0 0.0 0.0
20 Ivory Coast B 71.89190995 1.3806396 2.75509191 0 0 0 0 1 0 0 0.0 0.0 0.0
21 Costa Rica E 74.73457668 0.9351499 1.86442296 0 0 0 1 0 0 0 0.0 0.0 0.0
22 Mexico F 80.42516164 1.48580621 1.60142078 0 0 0 0 1 0 0 0.0 0.0 0.0
23 Nigeria D 85.84528046 1.71207232 0.91191163 0 0 0 0 1 0 0 0.0 0.0 0.0
24 Ecuador C 57.66963152 0.4860502 3.60848496 0 0 0 0 1 0 0 0.0 0.0 0.0
Powered by Datasette · Query took 1.348ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub