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

14 rows where Registration_Number = 4079

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date)

Foreign_Principal 14

  • China External Trade Development Council 1
  • Consolidated Iron Resources, Ltd. 1
  • Government of Bermuda 1
  • Government of Haiti, Ministry of Finance 1
  • Government of Panama 1
  • Government of Republic of Liberia 1
  • Government of the British Virgin Islands 1
  • Hyundai Corporation 1
  • Hyundai Engineering & Construction Company, Ltd. 1
  • Hyundai Motor Company 1
  • National Patriotic Reconstruction Assembly Government 1
  • Roussel-UCLAF 1
  • STC, PLC 1
  • Secretaria de Comunicaciones y Transportes 1

Country/Location_Represented 10

  • KOREA, SOUTH 3
  • GREAT BRITAIN 2
  • LIBERIA 2
  • BERMUDA 1
  • BRITISH VIRGIN ISLANDS 1
  • FRANCE 1
  • HAITI 1
  • MEXICO 1
  • PANAMA 1
  • TAIWAN 1

State 1

  • - 14

Registrant_Name 1

  • Swidler Berlin Shereff Friedman, LLP 14

City 1

  • - 14
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
1078 1078 1996-01-05 Hyundai Corporation 1994-12-15 KOREA, SOUTH Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Seoul        
1079 1079 1996-01-05 Hyundai Engineering & Construction Company, Ltd. 1994-12-15 KOREA, SOUTH Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Seoul        
1131 1131 1994-01-07 Government of the British Virgin Islands 1992-12-16 BRITISH VIRGIN ISLANDS Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Tortola        
1447 1447 1990-01-21 Government of Haiti, Ministry of Finance 1989-07-07 HAITI Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Port-au-Prince        
3321 3321 1998-03-01 Secretaria de Comunicaciones y Transportes 1996-01-31 MEXICO Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Mexico City        
3691 3691 1995-03-13 Government of Panama 1993-11-05 PANAMA Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Panama City        
5623 5623 1993-04-27 National Patriotic Reconstruction Assembly Government 1991-05-31 LIBERIA Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Monrovia        
6438 6438 1991-05-10 Consolidated Iron Resources, Ltd. 1991-03-15 GREAT BRITAIN Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP London, England        
6689 6689 1990-05-21 Government of Bermuda 1988-11-03 BERMUDA Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Hamilton        
7991 7991 1996-06-21 Hyundai Motor Company 1988-01-07 KOREA, SOUTH Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Seoul        
7992 7992 1996-06-21 Roussel-UCLAF 1993-09-22 FRANCE Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Paris        
8448 8448 1989-06-30 STC, PLC 1988-10-07 GREAT BRITAIN Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP London        
9078 9078 2000-07-07 Government of Republic of Liberia 1997-09-17 LIBERIA Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Monrovia        
10995 10995 1990-08-31 China External Trade Development Council 1989-02-03 TAIWAN Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP Taipai        

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 344.656ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows