FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where Registrant_Date = "1987-05-28"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal >30
- Manufacturers' Association of Israel 2
- Aerospatiale Helicopter Corporation 1
- Asia Pacific Economic Cooperation Business Advisory Council Malaysia (ABAC Malaysia) 1
- Asia Pacific Economic Cooperation of the Philippines, Inc. 1
- Bureau of Foreign Trade, Ministry of Economic Affairs, Government of the Republic of China (BOFT) 1
- Dassault Industries, Parent Corporation of Falcon Jet 1
- Falcon Jet Corporation, a Subsidiary of Dassault Industries 1
- Government of Thailand 1
- Government of the Philippines 1
- Government of the Republic of Korea 1
- Government of the Republic of the Philippines Department of Trade and Industry 1
- Industrial Research & Development Corporation, Ltd. 1
- Jose Luis Alberro, Inc. 1
- Korea International Trade Association (formerly: Korean Foreign Trade Association) 1
- MBB Helicopter Corporation 1
- Mexican Electrical Consortium C/O Servicios Condumex, S.A. de C.V. 1
- Ministry of Industry & Trade of the Government of Israel 1
- Ministry of Trade, Government of Indonesia 1
- Multilec, S.A. de C.V. 1
- Negev Phosphates, Ltd. (NPL) 1
- New Zealand Fishing Industry Board/ Fishing Industry Inspection & Certification Council 1
- P.T. Perkebunan, III 1
- Pacific Dunlop, Ltd./Pacific Brands 1
- Pliana, Inc. 1
- Pulsar Internacional, S.A. de C.V. 1
- Samsung Electronics Company, Ltd. 1
- Singapore Trade Development Board 1
- Taiwan Association of Machinery Industry 1
- Turbomeca Engine Corporation 1
- United Nations Conference on Trade & Development (UNCTAD) 1
- …
Country/Location_Represented 15
- ISRAEL 5
- MEXICO 5
- FRANCE 4
- KOREA, SOUTH 3
- PHILIPPINES 3
- INDONESIA 2
- TAIWAN 2
- AUSTRALIA 1
- GERMANY 1
- GERMANY, FEDERAL REPUBLIC OF 1
- INTERNATIONAL 1
- MALAYSIA 1
- NEW ZEALAND 1
- SINGAPORE 1
- THAILAND 1
Registrant_Name 1
City 1
- - 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 87 | Bureau of Foreign Trade, Ministry of Economic Affairs, Government of the Republic of China (BOFT) | 1987-06-23 | TAIWAN | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Washington | DC | ||||
2416 | 2416 | 1993-02-12 | Mexican Electrical Consortium C/O Servicios Condumex, S.A. de C.V. | 1990-11-06 | MEXICO | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Mexico City | ||||
2439 | 2439 | 1992-02-13 | Aerospatiale Helicopter Corporation | 1990-03-15 | FRANCE | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Grand Prairie | TX | |||
2440 | 2440 | 1992-02-13 | Dassault Industries, Parent Corporation of Falcon Jet | 1991-06-28 | FRANCE | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | |||||
2441 | 2441 | 1992-02-13 | Falcon Jet Corporation, a Subsidiary of Dassault Industries | 1992-03-18 | FRANCE | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Paramus | NJ | |||
2442 | 2442 | 1992-02-13 | MBB Helicopter Corporation | 1990-06-27 | GERMANY | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | West Chester | PA | |||
2444 | 2444 | 1992-02-13 | Turbomeca Engine Corporation | 1990-03-15 | FRANCE | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Grand Prairie | TX | |||
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 | ||||
5018 | 5018 | 1991-04-04 | Samsung Electronics Company, Ltd. | 1989-01-19 | KOREA, SOUTH | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Seoul | ||||
5307 | 5307 | 2002-04-15 | Government of the Philippines | 2001-07-16 | PHILIPPINES | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Office of the Executive Secretary Malacanang Palace Manila | ||||
5495 | 5495 | 1992-04-23 | Pliana, Inc. | 1991-02-13 | MEXICO | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Greensboro | NC | |||
5759 | 5759 | 1998-04-29 | Asia Pacific Economic Cooperation of the Philippines, Inc. | 1996-08-09 | PHILIPPINES | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Manila | ||||
5761 | 5761 | 1998-04-29 | Government of the Republic of the Philippines Department of Trade and Industry | 1996-03-14 | PHILIPPINES | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Manila | ||||
5958 | 5958 | 1997-04-30 | Government of the Republic of Korea | 1996-09-19 | KOREA, SOUTH | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Kyungki-do | ||||
5975 | 5975 | 1999-04-30 | Asia Pacific Economic Cooperation Business Advisory Council Malaysia (ABAC Malaysia) | 1998-10-29 | MALAYSIA | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Kuala Lumpur | ||||
5979 | 5979 | 1999-04-30 | New Zealand Fishing Industry Board/ Fishing Industry Inspection & Certification Council | 1993-04-08 | NEW ZEALAND | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Wellington | ||||
6337 | 6337 | 1992-05-05 | Taiwan Association of Machinery Industry | 1991-02-13 | TAIWAN | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Taipei | ||||
6608 | 6608 | 1995-05-16 | Singapore Trade Development Board | 1988-05-27 | SINGAPORE | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | |||||
6711 | 6711 | 1987-05-22 | Manufacturers' Association of Israel | 1987-05-28 | ISRAEL | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Tel-Aviv | ||||
7425 | 7425 | 1995-06-01 | Negev Phosphates, Ltd. (NPL) | 1991-08-29 | ISRAEL | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Ashdod | ||||
8139 | 8139 | 1990-06-28 | Wacker Siltronic Corporation | 1987-06-10 | GERMANY, FEDERAL REPUBLIC OF | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Portland | OR | |||
8141 | 8141 | 1993-06-28 | Multilec, S.A. de C.V. | 1991-06-28 | MEXICO | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | |||||
8142 | 8142 | 1993-06-28 | Pulsar Internacional, S.A. de C.V. | 1991-03-26 | MEXICO | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Garza Garcia | ||||
8524 | 8524 | 1994-06-30 | P.T. Perkebunan, III | 1994-10-07 | INDONESIA | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Sumatra | ||||
11443 | 11443 | 1999-09-08 | Pacific Dunlop, Ltd./Pacific Brands | 1995-06-29 | AUSTRALIA | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Melbourne | ||||
13616 | 13616 | 1998-11-01 | Ministry of Trade, Government of Indonesia | 1994-01-13 | INDONESIA | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Jakarta | ||||
13684 | 13684 | 1987-11-03 | Ministry of Industry & Trade of the Government of Israel | 1987-10-13 | ISRAEL | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Jerusalem | ||||
13760 | 13760 | 1990-11-06 | Industrial Research & Development Corporation, Ltd. | 1987-11-12 | ISRAEL | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Rehovot | ||||
14307 | 14307 | 1990-11-29 | United Nations Conference on Trade & Development (UNCTAD) | 1988-07-26 | INTERNATIONAL | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Geneva | ||||
15312 | 15312 | 1989-12-22 | Government of Thailand | 1989-01-12 | THAILAND | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Bangkok | ||||
15352 | 15352 | 1992-12-23 | Jose Luis Alberro, Inc. | 1991-07-19 | MEXICO | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | |||||
16604 | 16604 | 2006-12-31 | Korea International Trade Association (formerly: Korean Foreign Trade Association) | 1988-04-06 | KOREA, SOUTH | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Washington | DC |
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]) );