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

29 rows where "Foreign_Principal_Termination_Date" is on date 1996-02-14

✎ 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)

Foreign_Principal 28

  • Cameco Corporation 2
  • All Nippon Airways Company, Ltd. 1
  • Asociacion Colombiana de Exportadores de Flores (Asocoflores 1
  • Asosiasi Panel Kayu Indonesia (APKINDO")" 1
  • CSR, Ltd. 1
  • Cemex, S.A. 1
  • Council of European & Japanese National Shipowners' Association (CENSA")" 1
  • Electronics Industries Association of Japan, IC/User's Committees 1
  • GEC-Marconi, Ltd. 1
  • Hitachi, Ltd. 1
  • Hotelconsult SHCC Colleges 1
  • Hyundai (Motor America) 1
  • International Association of Independent Tanker Owners (Intertanko) 1
  • Islamic Republic of Pakistan (Through MQS, Inc.) 1
  • Israel Aircraft Industries 1
  • Japan Automobile Manufacturers' Association, Inc. 1
  • Japan Federation of Construction Contractors, Inc. 1
  • Joint Shipping Conference 1
  • Komatsu Corporation 1
  • Kyocera Corporation 1
  • Manufacturers' Association of Israel 1
  • North West Water Process, Inc. 1
  • Samsung Corporation 1
  • South Africa Sugar Association 1
  • Stelco, Inc. 1
  • Swiss Bankers' Association 1
  • Thapawong International Company, Ltd. 1
  • Vitro, S.A. 1

Registrant_Name 15

  • Global U.S.A., Inc. 6
  • JWI, LLC 3
  • Manatt, Phelps & Phillips 3
  • Akin, Gump, Strauss, Hauer & Feld, LLP 2
  • Dow, Lohnes & Albertson, L.L.P. 2
  • McDermott, Will & Emery 2
  • Sher & Blackwell 2
  • Winston & Strawn 2
  • Crowell & Moring International, LLC 1
  • Eckert, Seamans, Cherin & Mellott 1
  • Fraas, Phillip L. 1
  • Grandey, Gerald W. 1
  • Morris J. Amitay, P.C. 1
  • Willkie, Farr & Gallagher 1
  • Wilmer, Cutler & Pickering 1

Country/Location_Represented 15

  • JAPAN 7
  • CANADA 3
  • GREAT BRITAIN 2
  • INTERNATIONAL 2
  • ISRAEL 2
  • KOREA, SOUTH 2
  • MEXICO 2
  • SWITZERLAND 2
  • AUSTRALIA 1
  • COLOMBIA 1
  • INDONESIA 1
  • NORWAY 1
  • PAKISTAN 1
  • SOUTH AFRICA 1
  • THAILAND 1

State 4

  • - 26
  • CA 1
  • DC 1
  • WI 1

City 1

  • - 29
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
2498 2498 1996-02-14 Electronics Industries Association of Japan, IC/User's Committees 1995-05-17 JAPAN McDermott, Will & Emery 4818 1993-06-22 McDermott, Will & Emery Tokyo        
2499 2499 1996-02-14 Japan Automobile Manufacturers' Association, Inc. 1993-06-14 JAPAN Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Tokyo        
2500 2500 1996-02-14 Manufacturers' Association of Israel 1995-08-25 ISRAEL Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC TelAviv        
2501 2501 1996-02-14 Swiss Bankers' Association 1992-10-13 SWITZERLAND Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering Basle        
2502 2502 1996-02-14 All Nippon Airways Company, Ltd. 1984-09-13 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Tokyo        
2503 2503 1996-02-14 Asociacion Colombiana de Exportadores de Flores (Asocoflores 1995-08-10 COLOMBIA Manatt, Phelps & Phillips 3736 1985-09-20 Manatt, Phelps & Phillips Bogota        
2504 2504 1996-02-14 Asosiasi Panel Kayu Indonesia (APKINDO")" 1995-07-17 INDONESIA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Jakarta        
2505 2505 1996-02-14 CSR, Ltd. 1991-03-13 AUSTRALIA Winston & Strawn 3869 1986-08-13 Winston & Strawn North Sydney        
2506 2506 1996-02-14 Cameco Corporation 1994-05-27 CANADA Winston & Strawn 3869 1986-08-13 Winston & Strawn Saskatchewan        
2507 2507 1996-02-14 Cameco Corporation 1995-06-05 CANADA Grandey, Gerald W. 5030 1995-06-05 Grandey, Gerald W. Saskatoon        
2508 2508 1996-02-14 Cemex, S.A. 1994-06-08 MEXICO Manatt, Phelps & Phillips 3736 1985-09-20 Manatt, Phelps & Phillips Monterrey        
2509 2509 1996-02-14 Council of European & Japanese National Shipowners' Association (CENSA")" 1995-02-02 INTERNATIONAL Sher & Blackwell 4576 1991-08-01 Sher & Blackwell London        
2510 2510 1996-02-14 GEC-Marconi, Ltd. 1995-08-23 GREAT BRITAIN JWI, LLC 4990 1995-02-06 JWI, LLC Middlesex        
2511 2511 1996-02-14 Hitachi, Ltd. 1985-09-05 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Tokyo        
2512 2512 1996-02-14 Hotelconsult SHCC Colleges 1995-09-13 SWITZERLAND Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. LeBouvert        
2513 2513 1996-02-14 Hyundai (Motor America) 1987-06-10 KOREA, SOUTH Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Garden Grove     CA  
2514 2514 1996-02-14 International Association of Independent Tanker Owners (Intertanko) 1995-10-11 NORWAY Eckert, Seamans, Cherin & Mellott 5057 1995-10-11 Eckert, Seamans, Cherin & Mellott Oslo        
2515 2515 1996-02-14 Islamic Republic of Pakistan (Through MQS, Inc.) 1995-09-28 PAKISTAN JWI, LLC 4990 1995-02-06 JWI, LLC Karachi        
2516 2516 1996-02-14 Israel Aircraft Industries 1993-08-03 ISRAEL Morris J. Amitay, P.C. 4838 1993-08-03 Morris J. Amitay, P.C. Tel Aviv        
2517 2517 1996-02-14 Japan Federation of Construction Contractors, Inc. 1987-07-10 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Tokyo        
2518 2518 1996-02-14 Joint Shipping Conference 1991-08-01 INTERNATIONAL Sher & Blackwell 4576 1991-08-01 Sher & Blackwell Washington     DC  
2519 2519 1996-02-14 Komatsu Corporation 1983-07-22 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Tokyo        
2520 2520 1996-02-14 Kyocera Corporation 1984-03-24 JAPAN Global U.S.A., Inc. 3489 1983-06-24 Global U.S.A., Inc. Kyoto        
2521 2521 1996-02-14 North West Water Process, Inc. 1995-07-14 GREAT BRITAIN McDermott, Will & Emery 4818 1993-06-22 McDermott, Will & Emery Waukesha     WI  
2522 2522 1996-02-14 Samsung Corporation 1995-07-18 KOREA, SOUTH Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP Seoul        
2523 2523 1996-02-14 South Africa Sugar Association 1995-11-13 SOUTH AFRICA Fraas, Phillip L. 5073 1995-11-13 Fraas, Phillip L. Durban        
2524 2524 1996-02-14 Stelco, Inc. 1984-01-17 CANADA Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Ontario        
2525 2525 1996-02-14 Thapawong International Company, Ltd. 1995-08-23 THAILAND JWI, LLC 4990 1995-02-06 JWI, LLC Bangkok        
2526 2526 1996-02-14 Vitro, S.A. 1993-11-01 MEXICO Manatt, Phelps & Phillips 3736 1985-09-20 Manatt, Phelps & Phillips Garza Garcia        

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 298.581ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history