FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

18 rows where "Foreign_Principal_Termination_Date" is on date 1982-01-01

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)

State 3

City 1

  • - 18
Link rowid ▼ Foreign_Principal_Termination_Date Foreign_Principal Foreign_Principal_Registration_Date Country/Location_Represented Registration_Number Registrant_Date Registrant_Name Address_1 Address_2 City State Zip
839 839 1982-01-01 People's Republic of China 1980-10-27 CHINA Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
840 840 1982-01-01 Anglo-American Corporation of South Africa, Ltd. 1965-05-20 SOUTH AFRICA Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
841 841 1982-01-01 Brazilian Consulate General, Los Angeles 1976-09-27 BRAZIL Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Los Angeles     CA  
842 842 1982-01-01 British-American Chamber of Commerce 1974-12-31 GREAT BRITAIN Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
843 843 1982-01-01 Colon Free Zone 1962-03-23 PANAMA Warren Weil Public Relations 1530 1962-03-23 Warren Weil Public Relations Colon        
844 844 1982-01-01 Constructora Nacional de Carros de Ferrocarril, S.A. 1978-08-29 MEXICO Berry, Max N. 2216 1970-10-30 Berry, Max N.          
845 845 1982-01-01 Consulate General of Japan, New York 1979-03-05 JAPAN Philip S. Goodman, Inc. 3003 1979-03-05 Philip S. Goodman, Inc.       NY  
846 846 1982-01-01 Hsinchu Science Based Industrial Park Administration 1980-12-30 TAIWAN Graydon Associates, Inc. 2639 1975-12-10 Graydon Associates, Inc. Taipei        
847 847 1982-01-01 Island Government of Curacao 1964-10-19 CURACAO Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
848 848 1982-01-01 Metropolitan Council of the Central District 1980-02-20 HONDURAS Inter-American Associates, Inc. 3091 1980-02-20 Inter-American Associates, Inc. Tegucigalpa        
849 849 1982-01-01 Office of Secretary of State for Tourism of the Dominican Republic 1980-01-22 DOMINICAN REPUBLIC Martin Ryan Haley & Associates, Inc. 2727 1976-10-18 Martin Ryan Haley & Associates, Inc.          
850 850 1982-01-01 Portuguese Government Trade Office 1981-10-21 PORTUGAL Harshe-Rotman & Druck, Inc. 3292 1981-11-21 Harshe-Rotman & Druck, Inc.       NY  
851 851 1982-01-01 Province of Nova Scotia 1964-10-19 CANADA Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
852 852 1982-01-01 Province of Ontario 1964-10-19 CANADA Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
853 853 1982-01-01 Swedish Institute for Cultural Relations 1973-10-16 SWEDEN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
854 854 1982-01-01 Tea Association (Central Africa), Ltd. 1971-07-15 MALAWI Tea Council of the U.S.A., Inc. 1853 1965-02-10 Tea Council of the U.S.A., Inc. Blantyre        
855 855 1982-01-01 U.S.-Japan Trade Council 1975-08-01 JAPAN Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.          
856 856 1982-01-01 United Nations Industrial Development Organization 1980-02-29 INTERNATIONAL Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ForeignPrincipals] (
   [Foreign_Principal_Termination_Date] TEXT,
   [Foreign_Principal] TEXT,
   [Foreign_Principal_Registration_Date] TEXT,
   [Country/Location_Represented] TEXT,
   [Registration_Number] INTEGER,
   [Registrant_Date] TEXT,
   [Registrant_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);