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

27 rows where "Foreign_Principal_Termination_Date" is on date 1999-12-31

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 3

City 1

  • - 27
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
16448 16448 1999-12-31 Korean Traders' Association 1984-12-21 KOREA, SOUTH Korea International Trade Association 3636 1984-12-21 Korea International Trade Association Seoul        
16449 16449 1999-12-31 People's Republic of Mozambique, Embassy 1987-10-13 MOZAMBIQUE Cameron, Bruce P. 4043 1987-09-28 Cameron, Bruce P. Washington     DC  
16450 16450 1999-12-31 Aer Rianta 1999-03-26 IRELAND O'Dwyer, Brian 5308 1999-03-26 O'Dwyer, Brian Shannon Airport, Shannon        
16451 16451 1999-12-31 Congolese Rally for Democracy 1999-10-19 CONGO, REPUBLIC OF THE Barron-Birrell, Inc. 5363 1997-12-09 Barron-Birrell, Inc. Goma        
16452 16452 1999-12-31 Dr. Karl Dobler, Industry Representative Neuchatel Government 1995-02-24 SWITZERLAND Pendred, Russell Jess 4996 1995-02-24 Pendred, Russell Jess Nauchatel        
16453 16453 1999-12-31 Egyptian Tourist Authority 1995-06-13 EGYPT Herman Associates, Inc. 2578 1975-04-22 Herman Associates, Inc. New York     NY  
16454 16454 1999-12-31 Federal Republic of Nigeria 1998-03-03 NIGERIA Davis Manafort & Freedman, Inc. 5240 1998-03-03 Davis Manafort & Freedman, Inc. Abuja        
16455 16455 1999-12-31 German Convention Bureau 1991-12-06 GERMANY Trombone Associates, Inc. 4601 1991-12-06 Trombone Associates, Inc. East Meadow     NY  
16456 16456 1999-12-31 German National Tourist Office 1991-12-06 GERMANY Trombone Associates, Inc. 4601 1991-12-06 Trombone Associates, Inc. New York     NY  
16457 16457 1999-12-31 Government of Guatemala, Embassy 1999-07-29 GUATEMALA Williams & Connolly 5323 1999-07-29 Williams & Connolly 220 R Street, N.W.     DC  
16458 16458 1999-12-31 Government of Iceland, Embassy 1997-12-18 ICELAND Hall, Thomas Forrest 5221 1997-12-18 Hall, Thomas Forrest Washington     DC  
16459 16459 1999-12-31 Government of Portugal, Embassy 1997-02-18 PORTUGAL Cameron, Bruce P. 4043 1987-09-28 Cameron, Bruce P. Washington     DC  
16460 16460 1999-12-31 Government of Switzerland, Embassy 1996-12-19 SWITZERLAND Barbour Griffith & Rogers 5146 1996-12-19 Barbour Griffith & Rogers Washington     DC  
16461 16461 1999-12-31 Government of the Republic of Bolivia, Bolivian Mission to the OAS 2000-06-22 BOLIVIA Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 1819 H Street, N.W., Suite 410     DC  
16462 16462 1999-12-31 Hong Kong Tourism Associates 1999-02-01 HONG KONG West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
16463 16463 1999-12-31 ICEP - Investimentos Comercio e Turismo (Portuguese National Tourist Office) 1994-02-14 PORTUGAL Heyward, Evelyn J. 4893 1994-02-14 Heyward, Evelyn J. Lisbon        
16464 16464 1999-12-31 International Standards Committee 1999-06-15 INTERNATIONAL TransAtlantic Futures, Inc. 5314 1999-06-15 TransAtlantic Futures, Inc. 166 Fleet Street, London        
16465 16465 1999-12-31 Macau Economic Services 1999-08-26 MACAU Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. Rua Dr. Pedro Jose Lobo, n. 1-3 Ed. Luso International, 13 andar        
16466 16466 1999-12-31 Macau Handover Ceremony Coordination Office 1999-09-17 MACAU Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Avenue de Amizada, 207 P.O. Box 1955        
16467 16467 1999-12-31 Office of Deputy Commissioner of Maritime Affairs Bureau of Maritime Affairs, Republic of Liberia 1991-07-01 LIBERIA International Registries, Inc. 4533 1991-07-01 International Registries, Inc. Monrovia        
16468 16468 1999-12-31 Petroleos de Venezuela, S.A. (PDVSA)/Citgo Petroleum Corporation 1999-11-05 VENEZUELA DCS Group 5269 1998-08-13 DCS Group          
16469 16469 1999-12-31 PromPeru 1996-05-17 PERU Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. Lima        
16470 16470 1999-12-31 Republic of the Fiji Islands 1999-05-17 FIJI Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. Washington     DC  
16471 16471 1999-12-31 SAirGroup, AG 1999-12-07 SWITZERLAND Steptoe & Johnson, L.L.P. 3975 1987-05-08 Steptoe & Johnson, L.L.P. CH-8058 Zurich Airport        
16472 16472 1999-12-31 Sandline International 1997-01-29 GREAT BRITAIN McCabe, Bernard J., Jr. 5155 1997-01-29 McCabe, Bernard J., Jr. London        
16473 16473 1999-12-31 Science Times - Overseas Edition (formerly Chinese Science News Overseas Edition) 1997-06-05 CHINA Hai Tian Development U.S.A., Inc. 5143 1996-12-03 Hai Tian Development U.S.A., Inc. Beijing        
16474 16474 1999-12-31 Taipei Economic and Cultural Representative Office in the United States (TECRO) 1999-01-28 TAIWAN Lonie, David Morrison 5298 1999-01-28 Lonie, David Morrison Washington     DC  

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