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

45 rows where Foreign_Principal_Termination_Date = "1993-12-10"

✎ 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), Registrant_Date (date)

Country/Location_Represented 11

State 5

City 1

  • - 45
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
14953 14953 1993-12-10 Asahi Homecast Corporation 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. San Gabriel     CA  
14954 14954 1993-12-10 Asahi Mutual Life Insurance Company 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14955 14955 1993-12-10 Bank of Tokyo, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14956 14956 1993-12-10 Capital Cities/ABC Video Enterprises, Inc. 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. New York     NY  
14957 14957 1993-12-10 Dai-Iche Kangyo Bank, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14958 14958 1993-12-10 Dai-Iche Mutual Life Insurance Company 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14959 14959 1993-12-10 Department of Environment the Government of Catalonia, Spain 1992-05-07 SPAIN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Barcelona        
14960 14960 1993-12-10 Egyptian Tourist Authority 1991-04-08 EGYPT Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
14961 14961 1993-12-10 Electronic Industries Association of Japan 1983-05-27 JAPAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Tokyo        
14962 14962 1993-12-10 Fuji Bank, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14963 14963 1993-12-10 Government of Botswana, Ministry of Local Government & Lands 1991-09-04 BOTSWANA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Gaborone        
14964 14964 1993-12-10 Government of British Columbia, Ministry of Development, Trade & Tourism 1992-03-17 CANADA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC British Columbia        
14965 14965 1993-12-10 Industrial Bank of Japan, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14966 14966 1993-12-10 Itochu Corporation (Formerly: C. Itoh & Company, Ltd.) 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14967 14967 1993-12-10 Itochu International, Inc. (Formerly: C. Itoh & Company (America), Inc.) 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. New York     NY  
14968 14968 1993-12-10 JHC Corporation 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14969 14969 1993-12-10 Japan Airlines Company, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14970 14970 1993-12-10 Japan Travel Bureau 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14971 14971 1993-12-10 John I. Haas, Inc. 1992-08-07 GERMANY Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Washington     DC  
14972 14972 1993-12-10 KDD (Formerly: Kokusai Denshin Denwa Company, Ltd. 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14973 14973 1993-12-10 Long-Term Credit Bank of Japan, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14974 14974 1993-12-10 Marubeni Corporation 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14975 14975 1993-12-10 Media International Corporation 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14976 14976 1993-12-10 Mitsubishi Bank, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14977 14977 1993-12-10 NHK Enterprises (Japan) 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14978 14978 1993-12-10 NHK Enterprises U.S.A., Inc. 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14979 14979 1993-12-10 New York Society for International Affairs/Minister of the Economy, Czech & Slovak Federal Republic 1992-05-07 INTERNATIONAL Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Prague        
14980 14980 1993-12-10 Nova, Corporation of Alberta 1984-08-11 CANADA McHenry & Staffier, P.C. 3304 1981-11-16 McHenry & Staffier, P.C. Alberta        
14981 14981 1993-12-10 Novacor Chemicals 1984-08-11 CANADA McHenry & Staffier, P.C. 3304 1981-11-16 McHenry & Staffier, P.C. Alberta        
14982 14982 1993-12-10 OCS America, Inc. (Formerly: Oversea Courier Service Company, Ltd.) 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14983 14983 1993-12-10 Permanent Mission of Angola to the Organization of American States (OAS) 1992-11-17 ANGOLA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Washington     DC  
14984 14984 1993-12-10 Republic of Uzbekistan 1993-09-28 UZBEKISTAN Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
14985 14985 1993-12-10 Royal Government of Thailand 1993-09-23 THAILAND Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Washington     DC  
14986 14986 1993-12-10 Sacilda 1991-08-19 ANGOLA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Luanda        
14987 14987 1993-12-10 Sakura Bank (Formerly: Taiyo Kobe Mitsui Bank, Ltd. (Formerly: Mitsui Bank, Ltd.) 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14988 14988 1993-12-10 Sanwa Bank, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Osaka        
14989 14989 1993-12-10 Scandinavian Airlines Systems, Inc. 1978-12-12 INTERNATIONAL Film Comm, Inc. 2638 1975-12-10 Film Comm, Inc. Chicago     IL  
14990 14990 1993-12-10 Seiyu, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14991 14991 1993-12-10 State of Israel, Ministry of Industry & Trade 1991-10-21 ISRAEL Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Jerusalem        
14992 14992 1993-12-10 Stelco, Inc. 1992-06-25 CANADA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC Ontario        
14993 14993 1993-12-10 Sumitomo Bank, Ltd. 1991-03-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Osaka        
14994 14994 1993-12-10 T.P. Oceania Party, Ltd. C/O JTB 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14995 14995 1993-12-10 Tokyo Dome Corporation 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        
14996 14996 1993-12-10 Tokyo T.V. Broadcasting Corporation 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Brisbane     CA  
14997 14997 1993-12-10 Yasuda Fire & Marine Insurance Company, Ltd. 1991-11-26 JAPAN NHK Cosmomedia America, Inc. 4490 1991-03-26 NHK Cosmomedia America, Inc. Tokyo        

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])
);