FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
57 rows where "Date_Stamped" is on date 2022-07-29
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name, Foreign_Principal_Country
Registrant_Name >30
- Brownstein Hyatt Farber Schreck, LLP 12
- Quebec Government Office 7
- Richardson, Eric N 3
- Squire Patton Boggs, LLP 3
- Daniel J. Edelman, Inc. 2
- Global Security and Innovative Strategies, LLC 2
- Hai Tian Development U.S.A., Inc. 2
- Holland & Knight 2
- Representative of the Turkish Republic of Northern Cyprus 2
- Arnold & Porter Kaye Scholer LLP 1
- BCW LLC 1
- BGR Government Affairs, LLC 1
- California Strategies, LLC 1
- Camstoll Group, LLC 1
- Czech Center, New York 1
- Diab, Mahmoud 1
- Fratelli Group 1
- Friends of Sinn Fein, Inc. 1
- Ghebi LLC 1
- IPG DXTRA, Inc 1
- JETRO, Atlanta 1
- King & Spalding LLP 1
- Latin America Advisory Group, LLC 1
- Malaysian Palm Oil Council (f/k/a American Palm Oil Council) 1
- McGinnis Lochridge 1
- Okinawa Prefecture DC Office, Inc. 1
- RM Broadcasting, LLC 1
- Sochua Mu Leiper 1
- World Zionist Organization - American Section, Inc. 1
- Xin Min International, Inc. 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]) );