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. 1,827
- Daniel J. Edelman, Inc. 1,078
- Mercury Public Affairs, LLC 755
- Larson Shannahan Slifka Group, LLC 754
- PEOPLE'S MOJAHEDIN OF IRAN, WASHINGTON, D.C. - PRESS OFFICE 679
- Yorktown Solutions, LLC 677
- ARNOLD & PORTER 669
- Ghebi LLC 616
- KOREAN TELEVISION ENTERPRISES, LTD. 616
- JAPAN AUTOMOBILE MANUFACTURERS' ASSOCIATION, INC. 562
- DANIEL J. EDELMAN, INC. 528
- Amtorg Trading Corporation 501
- BURSON-MARSTELLER 493
- DUBAI COMMERCE & TOURISM PROMOTION BOARD 491
- RUDER & FINN, INC. 490
- McGinnis Lochridge 483
- BGR Government Affairs, LLC 466
- HONG KONG GOVERNMENT (INDUSTRY DEPARTMENT) 440
- Korea Economic Institute 438
- Hogan Lovells US LLP 417
- 6672 380
- Akin, Gump, Strauss, Hauer & Feld, LLP 379
- Squire Patton Boggs, LLP 379
- Modern Education Services, Inc. 378
- Hill & Knowlton, Inc. 348
- WHITE & CASE 343
- APCO Worldwide, Inc. 341
- Ogilvy Public Relations Worldwide 338
- Fleishman-Hillard, Inc. 324
- NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. 323
- …
Foreign_Principal_Name >30
- - 84,537
- Republika Srpska 853
- Royal Embassy of Saudi Arabia 742
- Federal State Unitary Enterprise Rossiya Segodnya International Information Agency 649
- Korea Institute for International Economic Policy (KIEP) 323
- All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" 309
- Huawei Technologies USA 241
- Royal Embassy of Saudi Arabia, Washington, D.C. 238
- People's Daily Overseas Edition 195
- Government of National Accord Libya, Office of the Prime Minister 170
- Cambodia National Rescue Party 161
- Chamber of Commerce and Industry of Serbia 155
- Embassy of Japan 151
- Turkey-U.S. Business Council (TAIK) 149
- Government of Republika Srpska 147
- Embassy of the United Arab Emirates 137
- China Daily of Beijing, China 134
- Korea Ministry of Trade, Industry and Energy through K&L Gates, LLP 127
- Embassy of the Republic of Azerbaijan 117
- Kurdistan Regional Government 110
- DIHK DEinternational GmbH 109
- Korea Trade-Investment Promotion Agency 109
- CCTV 108
- Embassy of the State of Qatar 105
- Embassy of the Republic of Korea 91
- Press TV 85
- Department of Culture and Tourism - Abu Dhabi 84
- Republic of Angola 83
- Q Cyber Technologies Ltd 81
- Aidenvironment (under grant from the Norwegian Agency for Development Cooperation) 77
- …
Foreign_Principal_Country >30
- - 84,569
- SAUDI ARABIA 1,425
- JAPAN 1,321
- BOSNIA & HERZEGOVINA 1,015
- KOREA SOUTH 981
- RUSSIA 966
- CHINA 933
- CANADA 717
- UKRAINE 684
- TURKEY 536
- UNITED ARAB EMIRATES 467
- MEXICO 431
- NORWAY 339
- GERMANY 337
- ISRAEL 329
- QATAR 326
- GREAT BRITAIN 322
- INTERNATIONAL 320
- FRANCE 300
- LIBYA 289
- CAMBODIA 279
- TAIWAN 274
- IRAQ 268
- COLOMBIA 225
- ITALY 217
- HAITI 198
- SERBIA 191
- AZERBAIJAN 186
- ANGOLA 182
- HONDURAS 178
- …
Document_Type 10
- Short-Form 31,416
- Supplemental Statement 31,377
- Exhibit AB 11,948
- Informational Materials 10,415
- Amendment 10,191
- Dissemination Report 7,101
- Registration Statement 2,697
- Exhibit C 1,636
- Exhibit D 98
- Conflict Provision 7
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]) );