FARA: Foreign Principals by Country

Foreign principals (governments, entities) grouped by country, ranked by number of active registrants.

Custom SQL query returning 50 rows (hide) 

SELECT country, COUNT(*) AS principals, COUNT(DISTINCT registration_number) AS registrants FROM fara_foreign_principals WHERE country IS NOT NULL GROUP BY country ORDER BY principals DESC LIMIT 50

Edit SQL

This data as json, CSV

countryprincipalsregistrants
JAPAN 1176 551
CANADA 817 448
MEXICO 576 313
GREAT BRITAIN 548 331
FRANCE 510 289
KOREA, SOUTH 439 280
GERMANY, FEDERAL REPUBLIC OF 390 142
INTERNATIONAL 337 194
ISRAEL 310 217
USSR 302 163
CHINA 277 196
SAUDI ARABIA 270 184
TAIWAN 268 194
RUSSIA 247 118
DOMINICAN REPUBLIC 237 189
ITALY 230 154
NETHERLANDS 224 135
SWITZERLAND 201 141
TURKEY 195 157
AUSTRALIA 192 139
CUBA 182 108
GERMANY 182 120
HAITI 181 155
POLAND 181 145
BRAZIL 180 108
UKRAINE 180 136
VENEZUELA 180 148
SPAIN 177 129
PHILIPPINES 171 115
PANAMA 169 133
UNITED ARAB EMIRATES 169 107
SOUTH AFRICA 159 128
NIGERIA 156 118
COLOMBIA 155 104
SWEDEN 155 88
HONG KONG 134 100
ARGENTINA 131 98
JAMAICA 131 91
ROMANIA 130 97
INDIA 129 105
PAKISTAN 129 112
QATAR 128 105
IRAQ 121 105
AUSTRIA 120 80
INDONESIA 120 98
CZECHOSLOVAKIA 116 85
GUATEMALA 110 90
THAILAND 105 85
MOROCCO 104 94
BELGIUM 101 65