FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
29 rows where Foreign_Principal_Termination_Date = "1996-02-14" sorted by Address_1
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2525 | 2525 | 1996-02-14 | Thapawong International Company, Ltd. | 1995-08-23 | THAILAND | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | Bangkok | ||||
2501 | 2501 | 1996-02-14 | Swiss Bankers' Association | 1992-10-13 | SWITZERLAND | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Basle | ||||
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 | ||||
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 | ||||
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 | |||
2526 | 2526 | 1996-02-14 | Vitro, S.A. | 1993-11-01 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Garza Garcia | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
2508 | 2508 | 1996-02-14 | Cemex, S.A. | 1994-06-08 | MEXICO | Manatt, Phelps & Phillips 3736 | 1985-09-20 | Manatt, Phelps & Phillips | Monterrey | ||||
2505 | 2505 | 1996-02-14 | CSR, Ltd. | 1991-03-13 | AUSTRALIA | Winston & Strawn 3869 | 1986-08-13 | Winston & Strawn | North Sydney | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
2518 | 2518 | 1996-02-14 | Joint Shipping Conference | 1991-08-01 | INTERNATIONAL | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | Washington | DC | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );