FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
634 rows where "Date_Stamped" is on date 1993-06-01
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country, Date_Stamped
Foreign_Principal_Name 30
- - 604
- EMBASSY OF HUNGARY 2
- A.C.E. INSURANCE COMPANY (BERMUDA) LTD. 1
- AJINOMOTO U.S.A., INC. 1
- AUSTRALIAN MEAT & LIVESTOCK CORPORATION 1
- CANADIAN CONSULATE GENERAL 1
- CENTER FOR DEVELOPMENT & HEALTH 1
- CENTRAL AMERICAN & CARIBBEAN TEXTILE & APPAREL COUNCIL 1
- CHINA EXTERNAL TRADE DEVELOPMENT COUNCIL 1
- COMITE DE SOPORTE AL COMERCIO (COSOSCO) 1
- CYPRUS TOURISM ORGANIZATION 1
- ELMECO, S.A. 1
- EMBASSY OF THE REPUBLIC OF KOREA 1
- EMBASSY OF THE REPUBLIC OF PANAMA 1
- ENVIRONMENTAL PROTECTION ADMINISTRATION 1
- EUROCOLUMBUS RAUMFAHRTGESELLSCHAFT, MBH 1
- FONTANA BLEU, S.P.A. 1
- GEC ALSTHOM, N.V. 1
- GOVERNMENT OF HAITI 1
- INSTITUTE FOR DEVELOPMENT & SECURITY OF THE REPUBLIC OF 1
- JAPAN AUTOMOBILE MANUFACTURERS' ASSOCIATION, INC. 1
- KINGDOM OF SAUDI ARABIA 1
- MAGAL SECURITY SYSTEMS, LTD. 1
- MAURITIUS CHAMBER OF AGRICULTURE & MAURITIUS SUGAR 1
- OFFICE OF THE PRESIDENT OF UKRAINE 1
- OFFICE OF THE PRESIDENT OF UKRAINE THROUGH P/C ADVISORS, 1
- REPUBLIC OF ALGERIA 1
- REPUBLIC OF NAMIBIA 1
- STENTOR TELECOM POLICY, INC. 1
- TELECOMMUNICACIONES INTERNACIONALES DE MEXICO 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]) );