FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
135,872 rows sorted by Short_Form_Name
This data as json, CSV (advanced)
Suggested facets: Date_Stamped (date)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name
Foreign_Principal_Country 251
- - 107,075
- SAUDI ARABIA 1,910
- JAPAN 1,648
- KOREA SOUTH 1,345
- BOSNIA & HERZEGOVINA 1,292
- RUSSIA 1,268
- CHINA 1,172
- CANADA 942
- UKRAINE 850
- TURKEY 693
- UNITED ARAB EMIRATES 616
- MEXICO 573
- GERMANY 467
- GREAT BRITAIN 466
- NORWAY 441
- ISRAEL 431
- INTERNATIONAL 407
- TAIWAN 400
- QATAR 399
- FRANCE 374
- IRAQ 347
- LIBYA 343
- CAMBODIA 337
- COLOMBIA 300
- ITALY 285
- HAITI 261
- ANGOLA 245
- AZERBAIJAN 243
- HONDURAS 232
- MOROCCO 229
- SERBIA 228
- PANAMA 212
- AUSTRALIA 198
- GEORGIA 197
- HONG KONG 196
- CONGO DEMOCRATIC REPUBLIC OF THE 195
- CYPRUS 195
- CONGO REPUBLIC OF THE 185
- SWITZERLAND 181
- INDIA 176
- SOUTH AFRICA 169
- AFGHANISTAN 167
- IRAN 167
- JAMAICA 165
- NIGERIA 159
- VENEZUELA 159
- PHILIPPINES 158
- SOMALI DEMOCRATIC REPUBLIC 149
- BRAZIL 148
- IRELAND 141
- BANGLADESH 138
- DOMINICAN REPUBLIC 137
- BELGIUM 133
- KAZAKHSTAN 133
- MALAYSIA 131
- MARSHALL ISLANDS 126
- GUYANA 124
- THAILAND 121
- ARUBA 119
- EL SALVADOR 114
- PAKISTAN 114
- ARGENTINA 112
- BERMUDA 103
- ETHIOPIA 101
- SPAIN 99
- EGYPT 96
- BAHAMAS 94
- HUNGARY 93
- NETHERLANDS 92
- POLAND 90
- GERMANY FEDERAL REPUBLIC OF 89
- UZBEKISTAN 89
- SWEDEN 85
- CAYMAN ISLANDS 84
- ICELAND 83
- UNITED KINGDOM 82
- BAHRAIN 80
- LIBERIA 80
- AUSTRIA 79
- INDONESIA 79
- ZIMBABWE 79
- ROMANIA 74
- SINGAPORE 72
- CHILE 71
- BIAFRA 70
- ECUADOR 67
- PERU 66
- SUDAN 66
- KUWAIT 65
- BARBADOS 64
- GUATEMALA 64
- COTE D'IVOIRE IVORY COAST 61
- DENMARK 60
- KENYA 59
- KOSOVA 59
- COSTA RICA 58
- LEBANON 55
- PALAU 55
- USSR 55
- NICARAGUA 54
- MOLDOVA 53
- SRI LANKA 51
- GREECE 48
- BULGARIA 47
- ARMENIA 46
- CAMEROON 46
- GABON 46
- YEMEN 46
- JORDAN 45
- TRINIDAD AND TOBAGO 45
- NEW ZEALAND 44
- ALBANIA 43
- NAGORNO KARABAKH 40
- PORTUGAL 40
- SCOTLAND 40
- ALGERIA 39
- SYRIA 39
- CZECHIA 38
- CROATIA 37
- FINLAND 37
- BRITISH VIRGIN ISLANDS 36
- ERITREA 36
- NETHERLANDS ANTILLES 36
- MAURITIUS 34
- MONACO 33
- VIETNAM 33
- LUXEMBOURG 32
- SAINT LUCIA 32
- EQUATORIAL GUINEA 31
- NORTHERN IRELAND 31
- BOLIVIA 30
- UGANDA 27
- YUGOSLAVIA 27
- SENEGAL 26
- ANTIGUA & BARBUDA 25
- PALESTINE 25
- TOGO 24
- MALAWI 23
- VANUATU 23
- GHANA 22
- BELARUS 21
- CZECHOSLOVAKIA 21
- MACEDONIA 21
- MICRONESIA 21
- TUNISIA 21
- MONGOLIA 20
- RWANDA 20
- SOUTH SUDAN 20
- MOZAMBIQUE 19
- GRENADA 18
- MONTENEGRO 18
- MYANMAR BURMA 18
- LIECHTENSTEIN 17
- NAMIBIA 17
- CURACAO 16
- ZAIRE 16
- FIJI 15
- MALI 15
- OMAN 14
- TANZANIA 14
- BELIZE 13
- BENIN 13
- BURKINA FASO 13
- LAOS 13
- SIERRA LEONE 13
- SLOVENIA 13
- TIMOR-LESTE 13
- GUINEA 12
- MALTA 12
- SWAZILAND 12
- TURKS AND CAICOS ISLANDS 12
- CHAD 11
- MALDIVES 11
- MAURITANIA 11
- SLOVAKIA 11
- TIBET 11
- ZAMBIA 11
- DOMINICA 10
- LITHUANIA 10
- REPUBLIC OF SOUTH SUDAN 10
- ST KITTS AND NEVIS 10
- URUGUAY 10
- ANGUILLA 9
- BRUNEI 9
- BURUNDI 9
- PARAGUAY 9
- TIMOR-LESTE EAST TIMOR 9
- BOTSWANA 8
- GAMBIA THE 8
- GIBRALTAR 8
- LATVIA 8
- LESOTHO 8
- MACAU 8
- SAINT VINCENT AND THE GRENADINES 8
- SEYCHELLES 8
- KOREA REPUBLIC OF 7
- KYRGYZSTAN 7
- PAPUA NEW GUINEA 7
- SOMALILAND 7
- SURINAME 7
- CHANNEL ISLANDS 6
- MONTSERRAT 6
- NIGER 6
- SAHARAWI ARAB DEMOCRATIC REPUBLIC 6
- TONGA 6
- BONAIRE 5
- BOPHUTHATSWANA 5
- CABO VERDE 5
- DJIBOUTI 5
- ISLE OF MAN 5
- NAURU 5
- SOMALIA 5
- CENTRAL AFRICAN REPUBLIC 4
- GERMAN DEMOCRATIC REPUBLIC 4
- KOREA NORTH 4
- NEPAL 4
- TAJIKISTAN 4
- CONGO BRAZZAVILLE 3
- CUBA 3
- ESTONIA 3
- GUERNSEY 3
- GUINEA-BISSAU 3
- MADAGASCAR 3
- SAMOA 3
- ST MARTIN 3
- TAHITI 3
- CEYLON SRI LANKA 2
- CONGO KINSHASA ZAIRE 2
- ENGLAND 2
- NEW CALEDONIA 2
- ST EUSTATIUS 2
- TRANSKEI 2
- TURKMENISTAN 2
- YEMEN PEOPLES DEMOCRATIC REPUBLIC OF YEMEN 2
- ANDORRA 1
- BRITISH WEST INDIES 1
- COMORO ISLANDS 1
- CZECH REPUBLIC 1
- GUADELOUPE & MARTINIQUE 1
- KOREA DEMOCRATIC PEOPLES REPUBLIC OF 1
- PORTUGUESE TIMOR 1
- PUERTO RICO 1
- SAN MARINO 1
- SAO TOME AND PRINCIPE 1
- SPANISH SAHARA 1
- ST BARTHELEMY 1
- SULU AND NORTH BORNEO 1
- UNITED STATES 1
- VATICAN CITY 1
- VIRGIN ISLANDS 1
- WESTERN SAMOA 1
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );