FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
38 rows where "Date_Stamped" is on date 2019-01-28
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Country
Registrant_Name 15
- Clyde Group, LLC 9
- Prime Policy Group 5
- Lande, Stephen 4
- Akin, Gump, Strauss, Hauer & Feld, LLP 3
- Korea Economic Institute 3
- Shepura, Nathan 3
- Arab Information Center 2
- Pakistan Muslim League (Nawaz) USA 2
- AUX Initiatives LLC 1
- British Virgin Islands Tourist Board 1
- Guidepost Solutions LLC 1
- JETRO, Chicago 1
- Malaysian Investment Development Authority 1
- Mercury Public Affairs, LLC 1
- Mr. John F. Hall, Jr. 1
Foreign_Principal_Name 10
- - 27
- European People's Party 2
- Korea Institute for International Economic Policy (KIEP) 2
- Government of Scotland in North America 1
- Government of the Republic of the Marshall Islands 1
- Japan External Trade Organization (JETRO) 1
- Lord Gregory Barker of Battle PC 1
- Parkington International Inc. (on behalf of Democratic Party Korea) 1
- Presidency of the Democratic Republic of Congo 1
- Wanhua Chemical US Operations LLC 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]) );