FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
354 rows where "Date_Stamped" is on date 1991-02-01 sorted by Foreign_Principal_Name
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country, Date_Stamped
Foreign_Principal_Name 30
- - 325
- AUSTRALIAN BARLEY BOARD 1
- BARBADOS BOARD OF TOURISM 1
- CANADIAN CONSULATE GENERAL 1
- CORPORACION NACIONAL DE TURISMO DE COLOMBIA 1
- DEUTSCHE BANK, A.G. 1
- EMBASSY OF THE REPUBLIC OF TURKEY 1
- FAIR TRADE CENTER 1
- FONDO DE PROMOCION DE EXPORTACIONES DE COLOMBIA 1
- GOVERNMENT OF CANADA 1
- GOVERNMENT OF CHILE 1
- INDO-AMERICAN CHAMBER OF COMMERCE 1
- INTERBANK (ULUSLARARASI ENDUSTRI VE TICARET BANKASI) 1
- INTERNATIONAL BUSINESS COMMUNICATIONS, INC. 1
- JAPAN FOUNDATION 1
- MINISTER SAUD NASIR AL-SABAH 1
- MINOLTA CAMERA COMPANY, LTD. 1
- NISSAN MOTOR COMPANY, LTD. 1
- PORT AUTHORITY OF JAMAICA 1
- RELAX INTERNATIONAL 1
- REPUBLIC OF GUATEMALA 1
- REPUBLIC OF ROMANIA 1
- REPUBLIC OF SOUTH KOREA 1
- SCIENCE & TECHNOLOGY FOUNDATION OF JAPAN 1
- SECRETARIAT OF COMMERCE & INDUSTRIAL DEVELOPMENT OF MEXICO 1
- STC, PLC 1
- THOMSON-CSF, INC. 1
- UNDERWRITERS AT LLOYD'S, LONDON 1
- UNITED ENGINEERING STEELS, LTD. 1
- WELSH DEVELOPMENT AGENCY 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]) );