FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where Registration_Number = 3988
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), Registrant_Date (date)
Foreign_Principal
- 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
- 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
City
- - 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75 | 75 | Bureau of Foreign Trade, Ministry of Economic Affairs, Government of the Republic of China (BOFT) | 1987-06-23 | TAIWAN | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Washington | DC | ||||
| 2270 | 2270 | 1993-02-12 | Mexican Electrical Consortium C/O Servicios Condumex, S.A. de C.V. | 1990-11-06 | MEXICO | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Mexico City | ||||
| 2293 | 2293 | 1992-02-13 | Aerospatiale Helicopter Corporation | 1990-03-15 | FRANCE | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Grand Prairie | TX | |||
| 2294 | 2294 | 1992-02-13 | Dassault Industries, Parent Corporation of Falcon Jet | 1991-06-28 | FRANCE | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | |||||
| 2295 | 2295 | 1992-02-13 | Falcon Jet Corporation, a Subsidiary of Dassault Industries | 1992-03-18 | FRANCE | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Paramus | NJ | |||
| 2296 | 2296 | 1992-02-13 | MBB Helicopter Corporation | 1990-06-27 | GERMANY | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | West Chester | PA | |||
| 2298 | 2298 | 1992-02-13 | Turbomeca Engine Corporation | 1990-03-15 | FRANCE | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Grand Prairie | TX | |||
| 2352 | 2352 | 1996-02-14 | Manufacturers' Association of Israel | 1995-08-25 | ISRAEL | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | TelAviv | ||||
| 4763 | 4763 | 1991-04-04 | Samsung Electronics Company, Ltd. | 1989-01-19 | KOREA, SOUTH | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Seoul | ||||
| 5045 | 5045 | 2002-04-15 | Government of the Philippines | 2001-07-16 | PHILIPPINES | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Office of the Executive Secretary Malacanang Palace Manila | ||||
| 5225 | 5225 | 1992-04-23 | Pliana, Inc. | 1991-02-13 | MEXICO | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Greensboro | NC | |||
| 5483 | 5483 | 1998-04-29 | Asia Pacific Economic Cooperation of the Philippines, Inc. | 1996-08-09 | PHILIPPINES | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Manila | ||||
| 5485 | 5485 | 1998-04-29 | Government of the Republic of the Philippines Department of Trade and Industry | 1996-03-14 | PHILIPPINES | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Manila | ||||
| 5681 | 5681 | 1997-04-30 | Government of the Republic of Korea | 1996-09-19 | KOREA, SOUTH | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Kyungki-do | ||||
| 5698 | 5698 | 1999-04-30 | Asia Pacific Economic Cooperation Business Advisory Council Malaysia (ABAC Malaysia) | 1998-10-29 | MALAYSIA | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Kuala Lumpur | ||||
| 5702 | 5702 | 1999-04-30 | New Zealand Fishing Industry Board/ Fishing Industry Inspection & Certification Council | 1993-04-08 | NEW ZEALAND | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Wellington | ||||
| 6041 | 6041 | 1992-05-05 | Taiwan Association of Machinery Industry | 1991-02-13 | TAIWAN | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Taipei | ||||
| 6303 | 6303 | 1995-05-16 | Singapore Trade Development Board | 1988-05-27 | SINGAPORE | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | |||||
| 6404 | 6404 | 1987-05-22 | Manufacturers' Association of Israel | 1987-05-28 | ISRAEL | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Tel-Aviv | ||||
| 7093 | 7093 | 1995-06-01 | Negev Phosphates, Ltd. (NPL) | 1991-08-29 | ISRAEL | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Ashdod | ||||
| 7785 | 7785 | 1990-06-28 | Wacker Siltronic Corporation | 1987-06-10 | GERMANY, FEDERAL REPUBLIC OF | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Portland | OR | |||
| 7787 | 7787 | 1993-06-28 | Multilec, S.A. de C.V. | 1991-06-28 | MEXICO | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | |||||
| 7788 | 7788 | 1993-06-28 | Pulsar Internacional, S.A. de C.V. | 1991-03-26 | MEXICO | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Garza Garcia | ||||
| 8169 | 8169 | 1994-06-30 | P.T. Perkebunan, III | 1994-10-07 | INDONESIA | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Sumatra | ||||
| 11006 | 11006 | 1999-09-08 | Pacific Dunlop, Ltd./Pacific Brands | 1995-06-29 | AUSTRALIA | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Melbourne | ||||
| 13101 | 13101 | 1998-11-01 | Ministry of Trade, Government of Indonesia | 1994-01-13 | INDONESIA | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Jakarta | ||||
| 13161 | 13161 | 1987-11-03 | Ministry of Industry & Trade of the Government of Israel | 1987-10-13 | ISRAEL | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Jerusalem | ||||
| 13237 | 13237 | 1990-11-06 | Industrial Research & Development Corporation, Ltd. | 1987-11-12 | ISRAEL | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Rehovot | ||||
| 13773 | 13773 | 1990-11-29 | United Nations Conference on Trade & Development (UNCTAD) | 1988-07-26 | INTERNATIONAL | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Geneva | ||||
| 14749 | 14749 | 1989-12-22 | Government of Thailand | 1989-01-12 | THAILAND | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | Bangkok | ||||
| 14788 | 14788 | 1992-12-23 | Jose Luis Alberro, Inc. | 1991-07-19 | MEXICO | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | |||||
| 16033 | 16033 | 2006-12-31 | Korea International Trade Association (formerly: Korean Foreign Trade Association) | 1988-04-06 | KOREA, SOUTH | 3988 3988 | 1987-05-28 | Crowell & Moring International, Ltd. | 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) );