FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
135,872 rows
This data as json, CSV (advanced)
Registrant_Name >30
- HILL & KNOWLTON, INC. 939
- Daniel J. Edelman, Inc. 602
- Larson Shannahan Slifka Group, LLC 405
- ARNOLD & PORTER 372
- PEOPLE'S MOJAHEDIN OF IRAN, WASHINGTON, D.C. - PRESS OFFICE 369
- Yorktown Solutions, LLC 367
- Mercury Public Affairs, LLC 331
- Ghebi LLC 326
- DANIEL J. EDELMAN, INC. 306
- KOREAN TELEVISION ENTERPRISES, LTD. 304
- RUDER & FINN, INC. 297
- BURSON-MARSTELLER 290
- JAPAN AUTOMOBILE MANUFACTURERS' ASSOCIATION, INC. 285
- 6672 273
- DUBAI COMMERCE & TOURISM PROMOTION BOARD 263
- Amtorg Trading Corporation 258
- HONG KONG GOVERNMENT (INDUSTRY DEPARTMENT) 243
- Korea Economic Institute 232
- 6170 203
- Squire Patton Boggs, LLP 199
- McGinnis Lochridge 194
- Commonwealth of Dominica Maritime Registry, Inc. 193
- BGR Government Affairs, LLC 192
- Fleishman-Hillard, Inc. 187
- Podesta Group, Inc. 186
- QUEBEC GOVERNMENT HOUSE 186
- Modern Education Services, Inc. 183
- Akin, Gump, Strauss, Hauer & Feld, LLP 182
- JETRO, New York 177
- DLA Piper US LLP 174
- …
Foreign_Principal_Name >30
- - 45,850
- Republika Srpska 463
- Royal Embassy of Saudi Arabia 398
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 341
- All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" 167
- Korea Institute for International Economic Policy (KIEP) 164
- Huawei Technologies USA 123
- Cambodia National Rescue Party 86
- Press TV 84
- Embassy of the United Arab Emirates 82
- Government of Republika Srpska 75
- Chamber of Commerce and Industry of Serbia 67
- Turkey-U.S. Business Council (TAIK) 67
- Government of National Accord Libya, Office of the Prime Minister 65
- Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP 64
- CCTV 63
- DIHK DEinternational GmbH 62
- Embassy of the Republic of Korea 61
- The People's National Party 59
- Korea Trade-Investment Promotion Agency 58
- Kurdistan Regional Government 55
- Embassy of the State of Qatar 51
- Government of the Republic of Honduras (via Gus West Government Affairs Inc.) 49
- Civil Movement "For a Just Ukraine"(Hromadska Orhanizatsiia Rukh Spravedlyva Ukrayina) 46
- Embassy of Japan 46
- Embassy of the Republic of Azerbaijan 46
- People's Daily Overseas Edition 46
- Government of Colombia, Embassy 39
- Embassy of Italy 38
- Q Cyber Technologies Ltd 38
- …
Foreign_Principal_Country >30
- - 45,858
- JAPAN 640
- SAUDI ARABIA 622
- BOSNIA & HERZEGOVINA 547
- KOREA SOUTH 526
- RUSSIA 496
- CHINA 397
- UKRAINE 375
- CANADA 367
- TURKEY 277
- MEXICO 238
- UNITED ARAB EMIRATES 232
- INTERNATIONAL 188
- GERMANY 186
- QATAR 173
- ISRAEL 170
- GREAT BRITAIN 157
- FRANCE 150
- IRAQ 142
- NORWAY 135
- HONDURAS 132
- COLOMBIA 130
- LIBYA 129
- CAMBODIA 124
- TAIWAN 124
- ITALY 110
- IRAN 107
- CYPRUS 103
- JAMAICA 92
- AFGHANISTAN 91
- …
Document_Type 10
- Supplemental Statement 17,570
- Short-Form 16,807
- Exhibit AB 6,189
- Amendment 5,388
- Informational Materials 5,199
- Dissemination Report 3,724
- Registration Statement 1,436
- Exhibit C 861
- Exhibit D 51
- Conflict Provision 5
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]) );