FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
73 rows where "Date_Stamped" is on date 2019-04-30
This data as json, CSV (advanced)
Registrant_Name 30
- MSLGROUP Americas, LLC 37
- DiNino Associates, LLC 4
- Mercury Public Affairs, LLC 3
- Korea Economic Institute 2
- S.G.R. LLC Government Relations and Lobbying 2
- 6170 1
- Abernathy MacGregor Group, Inc. 1
- Alignment Government Strategies 1
- Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 1
- Barnes & Thornburg LLP 1
- Batra, Ravi 1
- Bayaziddi, Salah 1
- Blue Star Strategies, LLC 1
- Cohen, David B. 1
- Daschle Group, LLC 1
- Dentons US LLP 1
- Department of Culture Tourism - Abu Dhabi (New York Branch) 1
- Dowell Pham Harrison, LLP 1
- Greenwich Media Strategies, LLC 1
- Holland & Knight 1
- International Policy Solutions, LLC 1
- Livingston Group, LLC 1
- Lumen8 Advisors, LLC 1
- Miller & Chevalier Chartered 1
- PASS LLC 1
- Picard Kentz & Rowe, LLP 1
- Potomac International Partners, Inc. 1
- Prime Policy Group 1
- QORVIS LLC 1
- TRG Advisory Services, LLC 1
Foreign_Principal_Name 12
- - 60
- Tourism Promotion Council of the State of Quintana Roo 2
- World Council of Religious Leaders 2
- Abdul Sattar 1
- Embassy of the Republic of Korea through Cornerstone Government Affairs 1
- Embassy of the State of Qatar through Venable LLP 1
- Government of National Accord Libya, Office of the Prime Minister 1
- Korea Development Institute 1
- Korea Institute for International Economic Policy (KIEP) 1
- Mexico Tourism Board 1
- People's Progressive Party (Guyana) 1
- The Democratic Party of Moldova through Cornerstone Government Affairs 1
Foreign_Principal_Country 9
- - 60
- KOREA SOUTH 3
- MEXICO 3
- SAUDI ARABIA 2
- BANGLADESH 1
- GUYANA 1
- LIBYA 1
- MOLDOVA 1
- QATAR 1
Document_Type 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]) );