FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
410 rows where "Date_Stamped" is on date 1992-07-01
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name, Foreign_Principal_Country, Date_Stamped
Registrant_Name >30
- DUBAI COMMERCE & TOURISM PROMOTION BOARD 30
- KOREAN TELEVISION ENTERPRISES, LTD. 22
- HONG KONG GOVERNMENT (INDUSTRY DEPARTMENT) 20
- HILL & KNOWLTON, INC. 9
- GOLD AND LIEBENGOOD 8
- GUYANA REPUBLICAN PARTY 8
- JETRO, ATLANTA 8
- OGILVY ADAMS & RINEHART, INC. 8
- OROMO LIBERATION FRONT, NORTH AMERICA OFFICE 8
- ST. LUCIA NATIONAL DEVELOPMENT CORPORATION 8
- ALDEN FILMS, BUSINESS EDUCATION FILMS, FILMS OF THE NATIONS 7
- DANIEL J. EDELMAN, INC. 7
- GOVERNMENT OF HONG KONG INDUSTRY DEPARTMENT 7
- JETRO, DENVER 5
- KEINER & DUMONT, P.C. 5
- PALESTINE AFFAIRS CENTER 5
- SANDLUND, PETER GUSTAF 5
- FORUM ON AMERICAN-IRANIAN RELATIONS FOUNDATION 4
- Wunder, Knight, Levine, Thelen & Forscey, PLLC 4
- BUSINESS NETWORK CORPORATION 3
- CAMPBELL, FALK & SELBY 3
- GCI GROUP, INC. 3
- JAPAN ECONOMIC INSTITUTE OF AMERICA 3
- SCHMERTZ COMPANY, INC. 3
- SIDLEY & AUSTIN 3
- SMITH, LAWRENCE G. 3
- THORNTON, HARKLEY R. 3
- VAN NESS FELDMAN, A PROFESSIONAL CORPORATION 3
- (UNITA) NATIONAL UNION FOR TOTAL INDEP ANGOLA 2
- ACEVSKI, LJUBICA Z. 2
- …
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]) );