fifa/fifa_countries_audience

191 rows sorted by confederation

View and edit SQL

Suggested facets: confederation, population_share, tv_audience_share, gdp_weighted_share

Link rowid country confederation ▼ population_share tv_audience_share gdp_weighted_share
2 Japan AFC 1.9 4.9 9.1
3 China AFC 19.5 14.8 7.3
11 South Korea AFC 0.7 1.8 3.0
12 Indonesia AFC 3.5 6.7 2.9
15 Thailand AFC 1.0 2.4 1.6
19 Saudi Arabia AFC 0.4 0.5 1.2
20 Taiwan AFC 0.3 0.5 1.0
25 Malaysia AFC 0.4 0.7 0.7
30 Vietnam AFC 1.3 2.6 0.6
31 Iran AFC 1.1 0.7 0.6
35 Singapore AFC 0.1 0.2 0.6
36 Australia AFC 0.3 0.3 0.5
39 India AFC 17.6 2.0 0.5
46 Iraq AFC 0.5 0.5 0.4
55 Qatar AFC 0.0 0.0 0.2
56 Kuwait AFC 0.0 0.1 0.2
60 Hong Kong AFC 0.1 0.1 0.2
62 Oman AFC 0.0 0.0 0.1
70 Uzbekistan AFC 0.4 0.5 0.1
74 Syria AFC 0.3 0.3 0.1
75 Pakistan AFC 2.5 0.4 0.1
80 Cambodia AFC 0.2 0.5 0.1
82 Macau AFC 0.0 0.0 0.1
84 Lebanon AFC 0.1 0.1 0.1
85 Jordan AFC 0.1 0.1 0.1
87 Brunei AFC 0.0 0.0 0.1
89 Turkmenistan AFC 0.1 0.1 0.1
92 Bahrain AFC 0.0 0.0 0.0
93 Nepal AFC 0.4 0.4 0.0
100 Philippines AFC 1.4 0.1 0.0
102 Laos AFC 0.1 0.2 0.0
105 Afghanistan AFC 0.4 0.3 0.0
110 Sri Lanka AFC 0.3 0.1 0.0
111 Myanmar AFC 0.8 0.1 0.0
114 Bangladesh AFC 2.2 0.1 0.0
117 North Korea AFC 0.4 0.2 0.0
119 Tajikistan AFC 0.1 0.1 0.0
123 Palestine AFC 0.1 0.1 0.0
124 Kyrgyzstan AFC 0.1 0.1 0.0
125 Mongolia AFC 0.0 0.0 0.0
133 Tunisia AFC 0.2 0.0 0.0
158 Maldives AFC 0.0 0.0 0.0
176 Timor AFC 0.0 0.0 0.0
24 South Africa CAF 0.7 1.3 0.8
27 Nigeria CAF 2.3 2.6 0.7
41 Egypt CAF 1.1 0.8 0.5
51 Algeria CAF 0.5 0.4 0.3
71 Yemen CAF 0.3 0.4 0.1
81 Ivory Coast CAF 0.3 0.4 0.1
90 Angola CAF 0.3 0.1 0.1
95 Ghana CAF 0.4 0.2 0.0
96 Mauritius CAF 0.0 0.0 0.0
98 Kenya CAF 0.6 0.3 0.0
107 Cameroon CAF 0.3 0.2 0.0
108 Senegal CAF 0.2 0.2 0.0
115 Zambia CAF 0.2 0.1 0.0
116 Morocco CAF 0.5 0.1 0.0
118 Botswana CAF 0.0 0.0 0.0
121 Uganda CAF 0.5 0.2 0.0
122 Libya CAF 0.1 0.0 0.0
127 Tanzania CAF 0.7 0.1 0.0
130 Sudan CAF 0.5 0.1 0.0
131 Gabon CAF 0.0 0.0 0.0
132 Madagascar CAF 0.3 0.1 0.0
134 Ethiopia CAF 1.3 0.2 0.0
135 Zimbabwe CAF 0.2 0.1 0.0
136 Namibia CAF 0.0 0.0 0.0
141 Congo DR CAF 0.9 0.2 0.0
142 Burkina Faso CAF 0.2 0.1 0.0
143 Guinea CAF 0.2 0.1 0.0
147 Mali CAF 0.2 0.0 0.0
150 Equatorial Guinea CAF 0.0 0.0 0.0
151 Mozambique CAF 0.3 0.1 0.0
152 Seychelles CAF 0.0 0.0 0.0
153 Cape Verde CAF 0.0 0.0 0.0
154 Benin CAF 0.1 0.0 0.0
155 Swaziland CAF 0.0 0.0 0.0
159 Niger CAF 0.2 0.1 0.0
162 Togo CAF 0.1 0.0 0.0
163 Burundi CAF 0.1 0.1 0.0
164 Congo, Rep. CAF 0.1 0.0 0.0
166 Chad CAF 0.2 0.0 0.0
167 Eritrea CAF 0.1 0.0 0.0
169 Lesotho CAF 0.0 0.0 0.0
171 Malawi CAF 0.2 0.0 0.0
172 Sierra Leone CAF 0.1 0.0 0.0
173 Mauritania CAF 0.1 0.0 0.0
178 Rwanda CAF 0.2 0.0 0.0
179 Somalia CAF 0.1 0.0 0.0
180 Gambia CAF 0.0 0.0 0.0
182 Guinea-Bissau CAF 0.0 0.0 0.0
183 Central African Republic CAF 0.1 0.0 0.0
188 Liberia CAF 0.1 0.0 0.0
1 United States CONCACAF 4.5 4.3 11.3
13 Mexico CONCACAF 1.7 3.2 2.6
21 Canada CONCACAF 0.5 0.5 1.0
52 Cuba CONCACAF 0.2 0.3 0.3
63 Dominica Republic CONCACAF 0.1 0.2 0.1
69 Costa Rica CONCACAF 0.1 0.2 0.1
73 El Salvador CONCACAF 0.1 0.2 0.1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "fifa/fifa_countries_audience" (
"country" TEXT,
  "confederation" TEXT,
  "population_share" REAL,
  "tv_audience_share" REAL,
  "gdp_weighted_share" REAL
);
Powered by Datasette · Query took 17.494ms