FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
135,872 rows sorted by Document_Type
This data as json, CSV (advanced)
Suggested facets: Date_Stamped (date)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name
Registration_Number >30 ✖
- Hill and Knowlton Strategies, LLC 3,049
- Mercury Public Affairs, LLC 1,637
- Daniel J. Edelman, Inc. 1,475
- Squire Patton Boggs, LLP 1,400
- Arnold & Porter Kaye Scholer LLP 1,398
- Akin, Gump, Strauss, Hauer & Feld, LLP 1,085
- McGinnis Lochridge 1,067
- Larson Shannahan Slifka Group, LLC 1,035
- Hogan Lovells US LLP 911
- QORVIS LLC 885
- KBS LA, Inc. 859
- DLA Piper US LLP 855
- Ghebi LLC 821
- Burson-Marsteller 817
- Yorktown Solutions, LLC 817
- Ruder Finn, Inc. 764
- People's Mojahedin of Iran, Washington, D.C. - Press Office 753
- Japan Automobile Manufacturers' Association, Inc. 734
- Quebec Government Office 727
- JETRO, New York 722
- BGR Government Affairs, LLC 721
- Daniel J. Edelman, Inc. 702
- KOTRA 699
- Korea Economic Institute 689
- Government of Dubai, Dept. of Tourism & Commerce Marketing 668
- Hong Kong Government (Industry Department) 639
- White & Case, LLP 615
- Amtorg Trading Corporation 614
- Squire, Sanders & Dempsey, L.L.P. 475
- FGS Global (US) LLC (FKA FGH Holdings LLC) 474
- …
Foreign_Principal_Country >30
- - 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
- …
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]) );