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

13 rows where "Foreign_Principal_Termination_Date" is on date 1992-06-30

✎ View and edit SQL

This data as json, CSV (advanced)

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

Country/Location_Represented 10

State 4

City 1

  • - 13
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
8494 8494 1992-06-30 European People's Party/European Union of Christian Democrats 1989-04-28 INTERNATIONAL DC International, Inc. 4210 1989-01-25 DC International, Inc. Brussels        
8495 8495 1992-06-30 AEC Forest Products 1992-02-26 CANADA APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. Edmonton, Alberta        
8496 8496 1992-06-30 Australian Trade Commission 1989-01-24 AUSTRALIA Marston Webb & Associates, Inc. 4209 1989-01-24 Marston Webb & Associates, Inc. New York     NY  
8497 8497 1992-06-30 China External Trade Development Council (CETRA) 1992-03-05 TAIWAN GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. Taipei        
8498 8498 1992-06-30 Christian Democrat Organization of the Americas 1989-04-28 INTERNATIONAL DC International, Inc. 4210 1989-01-25 DC International, Inc. Caracas        
8499 8499 1992-06-30 Eduardo M. Cojuangco, Jr. 1989-12-04 PHILIPPINES Chwat/Weigend Associates 4320 1989-12-04 Chwat/Weigend Associates Manila        
8500 8500 1992-06-30 Embassy of the Federal Republic of Nigeria (State of Kanu) 1992-03-12 NIGERIA van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
8501 8501 1992-06-30 Environmental Protection Administration 1992-02-10 TAIWAN Hoyle, Brian Jervey 4618 1992-02-10 Hoyle, Brian Jervey Taipei        
8502 8502 1992-06-30 Helicopter Line, Tourist & Publicity Department Formerly The New Zealand Govt. - Tourist & Publicity Dept. 1951-04-23 NEW ZEALAND New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office Dunedin        
8503 8503 1992-06-30 Nassau/Cable Beach/Paradise Island Promotion Board 1991-09-05 BAHAMAS M. Silver Associates, Inc. 3131 1980-07-15 M. Silver Associates, Inc. Coral Cables     FL  
8504 8504 1992-06-30 Republic of Slovenia 1991-07-26 SLOVENIA Kaminsky, Phyllis 4549 1991-07-26 Kaminsky, Phyllis Ljubljana        
8505 8505 1992-06-30 Royal Trustco, Ltd. 1989-04-17 CANADA Jones Day 3427 1982-12-10 Jones Day Ontario        
8506 8506 1992-06-30 Thomson-CSF, S.A. 1992-04-06 FRANCE Jones Day 3427 1982-12-10 Jones Day Paris        

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