FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
130 rows where Registration_Number = 1750 sorted by Foreign_Principal
This data as json, CSV (advanced)
Foreign_Principal 29
- Republic of Honduras 2
- Metal Market & Exchange Company, Ltd. 1
- Metal Market & Exchange Company, Ltd. (London Metal Exchange) 1
- Ministry of Production, Foreign Trade, Investments and Fisheries of the Republic of Ecuador 1
- Ministry of Trade, Industry and Energy of the Republic of Korea (Korean MOTIE) 1
- NOGA Commodities (Overseas), Inc., (U.S. Affiliate of Compagnie NOGA d'Importation et d'Exportation, S.A.) 1
- Nobel Foundation 1
- Office of the Presidency, Republic of El Salvador 1
- Profilo Holding, A.S. 1
- Province of Alberta 1
- Province of Saskatchewan, Saskatchewan Justice 1
- Republic of Kazakhstan 1
- Republic of Panama 1
- Republic of Turkey (Previously Embassy of Turkey) 1
- SSTEK Savunma Sanayi Teknolojileri AS (SSTEK) 1
- Samsung Group 1
- Samuel del Villar 1
- Saskatchewan Mining Development Corporation 1
- State of Israel, Embassy 1
- Suramerica de Aleaciones Laminadas, C.A. (Sural")" 1
- Swiss Cheese Union, Inc. 1
- Switzerland Gruyere Processed Cheese Manufacturers' Association 1
- Table Grape Growers' Association 1
- Thomson-CSF 1
- Union Nacional de Productores de Hortalizos 1
- Uranerz Exploration & Mining, Ltd. 1
- VIASA 1
- Venezolana de Cementos, C.A. 1
- YPF S.A. 1
Country/Location_Represented 16
- CANADA 4
- MEXICO 3
- SWITZERLAND 3
- TURKEY 3
- VENEZUELA 3
- GREAT BRITAIN 2
- HONDURAS 2
- KOREA, SOUTH 2
- ARGENTINA 1
- ECUADOR 1
- EL SALVADOR 1
- FRANCE 1
- ISRAEL 1
- KAZAKHSTAN 1
- PANAMA 1
- SWEDEN 1
City 4
- - 27
- City of Buenos Aires 1
- Quito 1
- San Salvador 1
Registrant_Name 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14801 | 14801 | 1990-12-04 | Metal Market & Exchange Company, Ltd. | 1986-03-14 | GREAT BRITAIN | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | London | ||||
7388 | 7388 | 1983-06-01 | Metal Market & Exchange Company, Ltd. (London Metal Exchange) | 1982-03-18 | GREAT BRITAIN | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | London | ||||
5668 | 5668 | 2022-04-28 | Ministry of Production, Foreign Trade, Investments and Fisheries of the Republic of Ecuador | 2020-11-20 | ECUADOR | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Plataforma Gubernamental Financiera | Amazonas entre Union Nacional de Periodistas y Alfonso Pereira | Quito | ||
490 | 490 | Ministry of Trade, Industry and Energy of the Republic of Korea (Korean MOTIE) | 2020-02-10 | KOREA, SOUTH | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Government Complex-Sejong, 402, Hannuri-daero | Sejong-si, 30118 | ||||
1513 | 1513 | 1994-01-25 | NOGA Commodities (Overseas), Inc., (U.S. Affiliate of Compagnie NOGA d'Importation et d'Exportation, S.A.) | 1993-04-30 | SWITZERLAND | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | New York | NY | |||
898 | 898 | 1987-01-01 | Nobel Foundation | 1983-02-18 | SWEDEN | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Stockholm | ||||
8789 | 8789 | 2022-06-30 | Office of the Presidency, Republic of El Salvador | 2021-04-05 | EL SALVADOR | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Casa Presidencial de El Salvador | Alameda Manuel Enrique Araujo 5500 | San Salvador | ||
14807 | 14807 | 1995-12-04 | Profilo Holding, A.S. | 1985-12-16 | TURKEY | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Istanbul | ||||
14809 | 14809 | 1996-12-04 | Province of Alberta | 1996-02-16 | CANADA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Edmonton, Alberta | ||||
6322 | 6322 | 1988-05-04 | Province of Saskatchewan, Saskatchewan Justice | 1986-10-17 | CANADA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | |||||
585 | 585 | Republic of Honduras | 2023-05-30 | HONDURAS | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Kuwait Blvd, next to the Supreme Court of Justice, Ministry of Foreign Affairs | |||||
16860 | 16860 | 2019-12-31 | Republic of Honduras | 2019-09-23 | HONDURAS | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Barrio El Jazmin | Ave. Cervantes frente a Quinchon Leon Tegucigalpa M.D. C., | |||
7597 | 7597 | 2000-06-04 | Republic of Kazakhstan | 1999-11-12 | KAZAKHSTAN | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | No. 11 Beibit Shalik Street Astawa | ||||
12350 | 12350 | 1985-10-01 | Republic of Panama | 1985-09-25 | PANAMA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | |||||
13614 | 13614 | 1996-11-01 | Republic of Turkey (Previously Embassy of Turkey) | 1993-10-12 | TURKEY | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Ankara | ||||
10572 | 10572 | 2022-08-16 | SSTEK Savunma Sanayi Teknolojileri AS (SSTEK) | 2021-02-16 | TURKEY | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Betepe Mahallesi Yaam Caddesi | Ak Plaza No:7/31 Yenimahalle, Ankara | |||
7586 | 7586 | 1988-06-04 | Samsung Group | 1988-02-11 | KOREA, SOUTH | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Fort Lee | NJ | |||
2216 | 2216 | 1985-02-05 | Samuel del Villar | 1984-09-17 | MEXICO | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | |||||
16074 | 16074 | 1988-12-31 | Saskatchewan Mining Development Corporation | 1985-11-26 | CANADA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Saskatoon | ||||
652 | 652 | State of Israel, Embassy | 1988-01-20 | ISRAEL | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | ||||||
1223 | 1223 | 1994-01-11 | Suramerica de Aleaciones Laminadas, C.A. (Sural")" | 1990-10-10 | VENEZUELA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Caracas | ||||
10825 | 10825 | 1980-08-29 | Swiss Cheese Union, Inc. | 1971-02-18 | SWITZERLAND | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Bern | ||||
6186 | 6186 | 1983-05-01 | Switzerland Gruyere Processed Cheese Manufacturers' Association | 1981-04-07 | SWITZERLAND | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Bern | ||||
14670 | 14670 | 1983-12-01 | Table Grape Growers' Association | 1980-04-24 | MEXICO | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Conora | ||||
7595 | 7595 | 1992-06-04 | Thomson-CSF | 1991-03-12 | FRANCE | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Paris | ||||
6190 | 6190 | 1984-05-01 | Union Nacional de Productores de Hortalizos | 1978-11-15 | MEXICO | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Sinaloa | ||||
16084 | 16084 | 1988-12-31 | Uranerz Exploration & Mining, Ltd. | 1985-11-26 | CANADA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Saskatoon | ||||
14674 | 14674 | 1983-12-01 | VIASA | 1982-06-08 | VENEZUELA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Caracas | ||||
14799 | 14799 | 1989-12-04 | Venezolana de Cementos, C.A. | 1985-08-05 | VENEZUELA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Caracas | ||||
8791 | 8791 | 2022-06-30 | YPF S.A. | 2022-05-06 | ARGENTINA | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Macacha Guemes 515, | City of Buenos Aires |
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]) );