home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

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

35 rows where Foreign_Principal_Termination_Date = "1996-12-31"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foreign_Principal >30

  • Korea Trade Promotion Corporation 2
  • Austrian National Tourist Office 1
  • British American Tobacco Company, Ltd., (BAT), South America Branch 1
  • Central African Republic 1
  • Cineplex Odeon Corporation 1
  • Consulate General Republic of Croatia 1
  • Democratic Republic of Sao Tome & Principe 1
  • Domtar, Inc. 1
  • Dubai Commerce & Tourism Promotion Board 1
  • Federal Government of Nigeria 1
  • Federation of Bosnia-Herzegovina 1
  • Finnish Tourist Board 1
  • France Edition (Formerly: Bureau du Livre Francais & Office of Technical & Scientific Cultural Affairs) 1
  • Gabonese Republic 1
  • Government of the Republic of the Maldives 1
  • Government of the Sultanate of Oman 1
  • Henri Damase Omgba 1
  • Industry Canada 1
  • Islamic State of Afghanistan/Mission in U.S. 1
  • Japan Auto Parts Industries Association 1
  • Malta National Tourist Office 1
  • Ministry of Commerce of the Kingdom of Cambodia 1
  • Ministry of Tourism of the Republic of Uzbekistan (Uzbekistan National Company) 1
  • Mitsubishi Electric Corporation (Through Universal Public Relations) 1
  • National Fertilizer Company of Nigeria, Ltd. 1
  • Nintendo of America 1
  • Pan-Alberta Gas, Ltd. 1
  • Republic of Nicaragua 1
  • Republic of Togo, Minister of Foreign Affairs 1
  • Republic of the Congo, Office of the President 1
  • …

Registrant_Name 29

  • Washington & Christian 4
  • GCI Group, Inc. 2
  • PSC International, Ltd. 2
  • Squire Patton Boggs, LLP 2
  • Brock Group 1
  • Burson-Marsteller 1
  • CANAMCO 1
  • Foley Hoag, LLP 1
  • French Book Office 1
  • Gillies & Zaiser, Inc. 1
  • Herman Associates, Inc. 1
  • IPG DXTRA, Inc 1
  • Jennings, John M. 1
  • Karen Weiner Escalera Associates, Inc. 1
  • Korea Trade Center, Chicago 1
  • Korea Trade Center, Los Angeles 1
  • Law Office of Stewart & Stewart 1
  • M. Silver Associates, Inc. 1
  • Mark A. Siegel & Associates, Inc. 1
  • McLaughlin & Morgan, Inc. 1
  • Reed, T. Dean 1
  • Rockey Company, Inc. 1
  • Ruder Finn, Inc. 1
  • Sandler & Travis Trade Advisory Services, Inc. 1
  • Saskatchewan Economic Diversification & Trade Office 1
  • Saunders & Company 1
  • Uzbekistan Government Tourist Board 1
  • Van Ness, Feldman, A Professional Corporation 1
  • Washington Strategic Consulting Group, Inc. 1

Country/Location_Represented 27

  • CANADA 5
  • JAPAN 3
  • KOREA, SOUTH 2
  • NIGERIA 2
  • AFGHANISTAN 1
  • AUSTRIA 1
  • BOSNIA & HERZEGOVINA 1
  • CAMBODIA 1
  • CAMEROON 1
  • CENTRAL AFRICAN REPUBLIC 1
  • CONGO, DEMOCRATIC REPUBLIC OF THE 1
  • CROATIA 1
  • FINLAND 1
  • FRANCE 1
  • GABON 1
  • GREAT BRITAIN 1
  • MALDIVES 1
  • MALTA 1
  • NICARAGUA 1
  • OMAN 1
  • RUSSIA 1
  • SAO TOME AND PRINCIPE 1
  • SWITZERLAND 1
  • THAILAND 1
  • TOGO 1
  • UNITED ARAB EMIRATES 1
  • UZBEKISTAN 1

State 6

  • - 27
  • NY 3
  • DC 2
  • OH 1
  • PA 1
  • WA 1

City 1

  • - 35
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
16375 16375 1996-12-31 Austrian National Tourist Office 1989-05-31 AUSTRIA Herman Associates, Inc. 2578 1975-04-22 Herman Associates, Inc. New York     NY  
16376 16376 1996-12-31 British American Tobacco Company, Ltd., (BAT), South America Branch 1995-09-21 GREAT BRITAIN Brock Group 4310 1989-10-23 Brock Group Staines        
16377 16377 1996-12-31 Central African Republic 1994-06-14 CENTRAL AFRICAN REPUBLIC PSC International, Ltd. 4559 1991-08-28 PSC International, Ltd. Bangui        
16378 16378 1996-12-31 Cineplex Odeon Corporation 1996-09-06 CANADA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Toronto, Onatrio        
16379 16379 1996-12-31 Consulate General Republic of Croatia 1995-09-13 CROATIA Reed, T. Dean 5044 1995-09-13 Reed, T. Dean East Lake     OH  
16380 16380 1996-12-31 Democratic Republic of Sao Tome & Principe 1993-06-03 SAO TOME AND PRINCIPE Washington & Christian 4569 1991-09-20 Washington & Christian          
16381 16381 1996-12-31 Domtar, Inc. 1996-02-20 CANADA GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Montreal, Quebec        
16382 16382 1996-12-31 Dubai Commerce & Tourism Promotion Board 1995-12-15 UNITED ARAB EMIRATES McLaughlin & Morgan, Inc. 5088 1995-12-15 McLaughlin & Morgan, Inc. Philadelphia     PA  
16383 16383 1996-12-31 Federal Government of Nigeria 1993-09-14 NIGERIA Washington & Christian 4569 1991-09-20 Washington & Christian Lagos        
16384 16384 1996-12-31 Federation of Bosnia-Herzegovina 1996-10-15 BOSNIA & HERZEGOVINA Burson-Marsteller 2469 1973-10-23 Burson-Marsteller Serajevo        
16385 16385 1996-12-31 Finnish Tourist Board 1987-09-25 FINLAND Karen Weiner Escalera Associates, Inc. 3405 1982-08-27 Karen Weiner Escalera Associates, Inc. Helsinki        
16386 16386 1996-12-31 France Edition (Formerly: Bureau du Livre Francais & Office of Technical & Scientific Cultural Affairs) 1984-03-13 FRANCE French Book Office 3566 1984-03-13 French Book Office          
16387 16387 1996-12-31 Gabonese Republic 1993-01-28 GABON Washington & Christian 4569 1991-09-20 Washington & Christian Libreville        
16388 16388 1996-12-31 Government of the Republic of the Maldives 1994-08-09 MALDIVES Mark A. Siegel & Associates, Inc. 4200 1989-01-06 Mark A. Siegel & Associates, Inc.          
16389 16389 1996-12-31 Government of the Sultanate of Oman 1980-10-15 OMAN Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
16390 16390 1996-12-31 Henri Damase Omgba 1994-07-05 CAMEROON Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Nevilly-sur-Seine        
16391 16391 1996-12-31 Industry Canada 1996-07-23 CANADA CANAMCO 3884 1986-09-19 CANAMCO Ottawa        
16392 16392 1996-12-31 Islamic State of Afghanistan/Mission in U.S. 1996-12-04 AFGHANISTAN Jennings, John M. 5142 1996-12-04 Jennings, John M. Washington     DC  
16393 16393 1996-12-31 Japan Auto Parts Industries Association 1987-06-12 JAPAN IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc Tokyo        
16394 16394 1996-12-31 Korea Trade Promotion Corporation 1975-12-19 KOREA, SOUTH Korea Trade Center, Los Angeles 2646 1975-12-19 Korea Trade Center, Los Angeles Seoul        
16395 16395 1996-12-31 Korea Trade Promotion Corporation 1975-12-31 KOREA, SOUTH Korea Trade Center, Chicago 2648 1975-12-31 Korea Trade Center, Chicago Seoul        
16396 16396 1996-12-31 Malta National Tourist Office 1993-12-06 MALTA Gillies & Zaiser, Inc. 4872 1993-12-06 Gillies & Zaiser, Inc. New York     NY  
16397 16397 1996-12-31 Ministry of Commerce of the Kingdom of Cambodia 1996-05-31 CAMBODIA Sandler & Travis Trade Advisory Services, Inc. 4699 1992-07-31 Sandler & Travis Trade Advisory Services, Inc. Phnom Phem        
16398 16398 1996-12-31 Ministry of Tourism of the Republic of Uzbekistan (Uzbekistan National Company) 1996-12-12 UZBEKISTAN Uzbekistan Government Tourist Board 5145 1996-12-12 Uzbekistan Government Tourist Board Tashkent        
16399 16399 1996-12-31 Mitsubishi Electric Corporation (Through Universal Public Relations) 1987-07-28 JAPAN Saunders & Company 3440 1983-02-08 Saunders & Company Tokyo        
16400 16400 1996-12-31 National Fertilizer Company of Nigeria, Ltd. 1993-06-24 NIGERIA Washington & Christian 4569 1991-09-20 Washington & Christian Port Harcourt        
16401 16401 1996-12-31 Nintendo of America 1992-12-30 JAPAN Rockey Company, Inc. 4594 1991-11-14 Rockey Company, Inc. Redmond     WA  
16402 16402 1996-12-31 Pan-Alberta Gas, Ltd. 1994-08-11 CANADA Van Ness, Feldman, A Professional Corporation 4696 1992-07-27 Van Ness, Feldman, A Professional Corporation Calgary, Alberta        
16403 16403 1996-12-31 Republic of Nicaragua 1993-03-02 NICARAGUA Foley Hoag, LLP 4776 1993-03-02 Foley Hoag, LLP Managua        
16404 16404 1996-12-31 Republic of Togo, Minister of Foreign Affairs 1995-03-20 TOGO Washington Strategic Consulting Group, Inc. 4694 1992-07-17 Washington Strategic Consulting Group, Inc. Lome        
16405 16405 1996-12-31 Republic of the Congo, Office of the President 1993-02-04 CONGO, DEMOCRATIC REPUBLIC OF THE PSC International, Ltd. 4559 1991-08-28 PSC International, Ltd.          
16406 16406 1996-12-31 Sandoz Pharma, Ltd. 1993-05-04 SWITZERLAND Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. Basel        
16407 16407 1996-12-31 Saskatchewan Department of Trade & Investment Government of Saskatchewan, Canada 1990-04-02 CANADA Saskatchewan Economic Diversification & Trade Office 4361 1990-04-02 Saskatchewan Economic Diversification & Trade Office Regina, Saskatchewan        
16408 16408 1996-12-31 Tepko M. International 1992-09-21 RUSSIA Law Office of Stewart & Stewart 4709 1992-09-21 Law Office of Stewart & Stewart Moscow        
16409 16409 1996-12-31 Tourism Authority of Thailand 1996-06-11 THAILAND M. Silver Associates, Inc. 3131 1980-07-15 M. Silver Associates, Inc. New York     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])
);
Powered by Datasette · Queries took 302.759ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history