home / fivethirtyeight

fivethirtyeight

Custom SQL query returning 24 rows (hide)

rowidteamgroupwspiwspi_offensewspi_defensegroup_firstgroup_secondgroup_third_advancegroup_third_no_advancegroup_fourthsixteenquartersemifinalwin
1 Germany B 95.70604569 3.75786164 0.3874431 1.0 0.0 0.0 0.0 0.0 1.0 0.8199 0.6844 0.4341 0.312
2 USA D 95.27805283 3.60990734 0.4174047 0.8519 0.1302 0.01785 5e-05 0.0 0.99995 0.84825 0.73055 0.4217 0.28915
3 Japan C 92.50588778 2.83311783 0.55572662 0.9973 0.0027 0.0 0.0 0.0 1.0 0.7814 0.39825 0.23755 0.089
4 Brazil E 92.20765171 2.74815648 0.5521339 1.0 0.0 0.0 0.0 0.0 1.0 0.54835 0.2943 0.18195 0.06985
5 Canada A 89.7058039 2.24199953 0.6623747 0.68935 0.12235 0.18825 5e-05 0.0 0.99995 0.72525 0.3954 0.1863 0.06615
6 France F 91.86410328 2.76000286 0.66457899 0.27275 0.48335 0.13285 0.00035 0.1107 0.88895 0.55785 0.28705 0.1343 0.05585
7 Sweden D 91.46821825 2.68688554 0.69540583 0.07375 0.3958 0.2094 0.26445 0.0566 0.67895 0.2972 0.1761 0.0867 0.0326
8 Norway B 89.02880437 2.21857626 0.79569614 0.0 1.0 0.0 0.0 0.0 1.0 0.52855 0.2724 0.10025 0.0235
9 England F 89.23346354 2.20776772 0.73647349 0.50695 0.17265 0.31295 0.0052 0.00225 0.99255 0.51755 0.17965 0.0607 0.0219
10 Australia D 89.2305021 2.4175798 0.96687642 0.0704 0.45895 0.4056 0.0273 0.03775 0.93495 0.28795 0.14275 0.05695 0.01825
11 Netherlands A 86.02741298 1.83711664 1.01192734 0.1542 0.10545 0.60505 0.03095 0.10435 0.8647 0.2935 0.0951 0.03075 0.00755
12 China A 85.29283885 1.44790154 0.72614198 0.1564 0.4999 0.13555 0.0062 0.20195 0.79185 0.40305 0.09205 0.0223 0.00495
13 Switzerland C 84.18821549 1.96139031 1.49125943 0.0019 0.6965 0.3013 0.0003 0.0 0.9997 0.40845 0.0844 0.01685 0.00355
14 Spain E 83.92021382 1.48403159 1.01614249 0.0 0.5402 0.01355 0.08115 0.3651 0.55375 0.1939 0.0263 0.00545 0.00155
15 Cameroon C 80.92597624 1.2852254 1.30118231 0.0008 0.3008 0.69795 0.00045 0.0 0.99955 0.2635 0.0495 0.0084 0.0013
16 South Korea E 83.32780715 1.68204423 1.33603021 0.0 0.35125 0.0138 0.1237 0.51125 0.36505 0.12605 0.0178 0.0033 0.001
17 Nigeria D 86.03518886 1.7752372 0.94266118 0.0039 0.01505 0.06085 0.01455 0.90565 0.0798 0.01515 0.00675 0.0027 0.00085
18 Colombia F 80.02198821 1.04381691 1.18170181 0.2203 0.26175 0.51785 0.0001 0.0 0.9999 0.1951 0.0355 0.00515 0.00055
19 New Zealand A 82.41742402 1.37154141 1.15029009 0.0 0.2723 0.034 0.0 0.6937 0.3063 0.13695 0.0206 0.0029 0.00035
20 Mexico F 81.28958001 1.54454892 1.52594317 0.0 0.08225 0.0307 0.0 0.88705 0.11295 0.0283 0.0101 0.0016 0.0001
21 Costa Rica E 74.47406944 0.98071415 1.95269614 0.0 0.10855 0.07625 0.69155 0.12365 0.1848 0.02005 0.00095 0.0001 0.0
22 Thailand B 68.33002325 0.90011005 2.71244876 0.0 0.0 0.24625 0.75375 0.0 0.24625 0.00375 0.0001 0.0 0.0
23 Ecuador C 55.74511094 0.49999971 3.86419264 0.0 0.0 5e-05 0.0 0.99995 5e-05 0.0 0.0 0.0 0.0
24 Ivory Coast B 71.84368999 1.37917421 2.76116937 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0
Powered by Datasette · Query took 6.477ms