FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where "Foreign_Principal_Termination_Date" is on date 1999-02-28
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Address_1, Registrant_Date (date)
Foreign_Principal 8
- Fabrique Nationale Herstal (formerly: Fabrique Nationale Nouvelle Herstal, S.A.) 1
- Federation of Electric Power Companies of Japan 1
- GIAT Industries, S.A. 1
- Joint Stock Commercial Bank - UNIBEST 1
- Le Gouvernement du Quebec 1
- Ministries of Foreign Affairs, Justice, Tourism & Economic Affairs of the Government of the Commonwealth of Bahamas 1
- New Zealand Meat Board, Washington Office 1
- Pascal Lissouba 1
Country/Location_Represented 8
- BAHAMAS 1
- BELGIUM 1
- CANADA 1
- CONGO, DEMOCRATIC REPUBLIC OF THE 1
- FRANCE 1
- JAPAN 1
- NEW ZEALAND 1
- RUSSIA 1
Registrant_Name 6
City 1
- - 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3028 | 3028 | 1999-02-28 | Fabrique Nationale Herstal (formerly: Fabrique Nationale Nouvelle Herstal, S.A.) | 1993-08-18 | BELGIUM | FN Manufacturing, Inc. 4864 | 1993-08-18 | FN Manufacturing, Inc. | Herstal | ||||
3029 | 3029 | 1999-02-28 | Federation of Electric Power Companies of Japan | 1995-02-14 | JAPAN | Denison, George H. 4991 | 1995-02-14 | Denison, George H. | Washington | DC | |||
3030 | 3030 | 1999-02-28 | GIAT Industries, S.A. | 1993-08-18 | FRANCE | FN Manufacturing, Inc. 4864 | 1993-08-18 | FN Manufacturing, Inc. | Versailles | ||||
3031 | 3031 | 1999-02-28 | Joint Stock Commercial Bank - UNIBEST | 1997-10-27 | RUSSIA | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Moscow | ||||
3032 | 3032 | 1999-02-28 | Le Gouvernement du Quebec | 1994-10-20 | CANADA | Pepper Hamilton, LLP 4968 | 1994-10-20 | Pepper Hamilton, LLP | Quebec | ||||
3033 | 3033 | 1999-02-28 | Ministries of Foreign Affairs, Justice, Tourism & Economic Affairs of the Government of the Commonwealth of Bahamas | 1977-06-24 | BAHAMAS | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | Washington | DC | |||
3034 | 3034 | 1999-02-28 | New Zealand Meat Board, Washington Office | 1998-11-18 | NEW ZEALAND | Witeck-Combs Communications 5289 | 1998-11-18 | Witeck-Combs Communications | 8000 Towers Crescent Drive, Suite 240, Vienna | VA | |||
3035 | 3035 | 1999-02-28 | Pascal Lissouba | 1998-08-17 | CONGO, DEMOCRATIC REPUBLIC OF THE | Merritt Group, Ltd. 5270 | 1998-08-17 | Merritt Group, Ltd. | Surrey |
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]) );