home / openregs

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 1179 552
CANADA 820 450
MEXICO 581 317
GREAT BRITAIN 548 331
FRANCE 511 290
KOREA, SOUTH 445 281
GERMANY, FEDERAL REPUBLIC OF 390 142
INTERNATIONAL 337 194
ISRAEL 314 220
USSR 302 163
CHINA 278 197
SAUDI ARABIA 273 185
TAIWAN 271 197
RUSSIA 248 119
DOMINICAN REPUBLIC 238 190
ITALY 231 155
NETHERLANDS 224 135
SWITZERLAND 203 143
TURKEY 198 160
AUSTRALIA 196 140
CUBA 185 109
VENEZUELA 185 151
GERMANY 183 120
UKRAINE 183 138
BRAZIL 182 110
HAITI 182 155
POLAND 181 145
SPAIN 179 129
UNITED ARAB EMIRATES 173 109
PHILIPPINES 172 115
PANAMA 169 133
SOUTH AFRICA 159 128
COLOMBIA 156 105
NIGERIA 156 120
SWEDEN 155 88
HONG KONG 135 101
ROMANIA 132 98
ARGENTINA 131 98
JAMAICA 131 91
QATAR 131 106
INDIA 130 106
PAKISTAN 130 113
IRAQ 125 109
INDONESIA 121 99
AUSTRIA 120 80
CZECHOSLOVAKIA 116 85
GUATEMALA 110 90
MOROCCO 108 97
THAILAND 105 85
BELGIUM 102 66
Powered by Datasette · Queries took 6.156ms · Privacy