fivethirtyeight

Custom SQL query returning 101 rows (hide)

rowidcountryconfederationpopulation_sharetv_audience_sharegdp_weighted_share
1 United States CONCACAF 4.5 4.3 11.3
2 Japan AFC 1.9 4.9 9.1
3 China AFC 19.5 14.8 7.3
4 Germany UEFA 1.2 2.9 6.3
5 Brazil CONMEBOL 2.8 7.1 5.4
6 United Kingdom UEFA 0.9 2.1 4.2
7 Italy UEFA 0.9 2.1 4.0
8 France UEFA 0.9 2.0 4.0
9 Russia UEFA 2.1 3.1 3.5
10 Spain UEFA 0.7 1.8 3.1
11 South Korea AFC 0.7 1.8 3.0
12 Indonesia AFC 3.5 6.7 2.9
13 Mexico CONCACAF 1.7 3.2 2.6
14 Turkey UEFA 1.1 2.3 2.0
15 Thailand AFC 1.0 2.4 1.6
16 Argentina CONMEBOL 0.6 1.5 1.6
17 Netherlands UEFA 0.2 0.6 1.5
18 Poland UEFA 0.6 1.2 1.3
19 Saudi Arabia AFC 0.4 0.5 1.2
20 Taiwan AFC 0.3 0.5 1.0
21 Canada CONCACAF 0.5 0.5 1.0
22 Colombia CONMEBOL 0.7 1.6 0.9
23 Venezuela CONMEBOL 0.4 1.0 0.9
24 South Africa CAF 0.7 1.3 0.8
25 Malaysia AFC 0.4 0.7 0.7
26 Switzerland UEFA 0.1 0.3 0.7
27 Nigeria CAF 2.3 2.6 0.7
28 Belgium UEFA 0.2 0.3 0.7
29 Sweden UEFA 0.1 0.3 0.7
30 Vietnam AFC 1.3 2.6 0.6
31 Iran AFC 1.1 0.7 0.6
32 Chile CONMEBOL 0.3 0.6 0.6
33 Romania UEFA 0.3 0.7 0.6
34 Austria UEFA 0.1 0.3 0.6
35 Singapore AFC 0.1 0.2 0.6
36 Australia AFC 0.3 0.3 0.5
37 Greece UEFA 0.2 0.3 0.5
38 Portugal UEFA 0.2 0.4 0.5
39 India AFC 17.6 2.0 0.5
40 Czech Republic UEFA 0.2 0.3 0.5
41 Egypt CAF 1.1 0.8 0.5
42 Denmark UEFA 0.1 0.2 0.5
43 Norway UEFA 0.1 0.1 0.4
44 Peru CONMEBOL 0.4 0.8 0.4
45 Ukraine UEFA 0.7 0.9 0.4
46 Iraq AFC 0.5 0.5 0.4
47 Hungary UEFA 0.1 0.3 0.4
48 Kazakhstan UEFA 0.2 0.3 0.3
49 Finland UEFA 0.1 0.2 0.3
50 Ireland UEFA 0.1 0.1 0.3
51 Algeria CAF 0.5 0.4 0.3
52 Cuba CONCACAF 0.2 0.3 0.3
53 Ecuador CONMEBOL 0.2 0.5 0.3
54 Slovakia UEFA 0.1 0.2 0.3
55 Qatar AFC 0.0 0.0 0.2
56 Kuwait AFC 0.0 0.1 0.2
57 Bulgaria UEFA 0.1 0.2 0.2
58 Serbia UEFA 0.1 0.3 0.2
59 Belarus UEFA 0.1 0.2 0.2
60 Hong Kong AFC 0.1 0.1 0.2
61 Croatia UEFA 0.1 0.1 0.1
62 Oman AFC 0.0 0.0 0.1
63 Dominica Republic CONCACAF 0.1 0.2 0.1
64 Azerbaijan UEFA 0.1 0.1 0.1
65 New Zealand OFC 0.1 0.1 0.1
66 Lithuania UEFA 0.0 0.1 0.1
67 Slovenia UEFA 0.0 0.1 0.1
68 Uruguay CONMEBOL 0.0 0.1 0.1
69 Costa Rica CONCACAF 0.1 0.2 0.1
70 Uzbekistan AFC 0.4 0.5 0.1
71 Yemen CAF 0.3 0.4 0.1
72 Israel UEFA 0.1 0.1 0.1
73 El Salvador CONCACAF 0.1 0.2 0.1
74 Syria AFC 0.3 0.3 0.1
75 Pakistan AFC 2.5 0.4 0.1
76 Guatemala CONCACAF 0.2 0.2 0.1
77 Paraguay CONMEBOL 0.1 0.2 0.1
78 Panama CONCACAF 0.1 0.1 0.1
79 Bosnia-Herzegovina UEFA 0.1 0.1 0.1
80 Cambodia AFC 0.2 0.5 0.1
81 Ivory Coast CAF 0.3 0.4 0.1
82 Macau AFC 0.0 0.0 0.1
83 Latvia UEFA 0.0 0.1 0.1
84 Lebanon AFC 0.1 0.1 0.1
85 Jordan AFC 0.1 0.1 0.1
86 Honduras CONCACAF 0.1 0.3 0.1
87 Brunei AFC 0.0 0.0 0.1
88 Albania UEFA 0.0 0.1 0.1
89 Turkmenistan AFC 0.1 0.1 0.1
90 Angola CAF 0.3 0.1 0.1
91 Estonia UEFA 0.0 0.0 0.0
92 Bahrain AFC 0.0 0.0 0.0
93 Nepal AFC 0.4 0.4 0.0
94 Cyprus UEFA 0.0 0.0 0.0
95 Ghana CAF 0.4 0.2 0.0
96 Mauritius CAF 0.0 0.0 0.0
97 Macedonia UEFA 0.0 0.1 0.0
98 Kenya CAF 0.6 0.3 0.0
99 Trinidad &Tobago CONCACAF 0.0 0.0 0.0
100 Philippines AFC 1.4 0.1 0.0
101 Bolivia CONMEBOL 0.1 0.1 0.0
Powered by Datasette · Query took 1.05ms