FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
33 rows where Registration_Number = 508
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 30
- Cuban Sugar Cane Growers' Association 2
- Government of Kuwait, Ministry of Oil 2
- National Cuban Sugar Mill Owners' Association 2
- Aceitunas de Mesa, S.A. 1
- Aquitaine Oil Corporation 1
- Ariana Afghan Airlines Company, Ltd. 1
- BNS, Inc. 1
- Banque Nationale de Paris 1
- Chambers of Commerce of Venezuela 1
- Colonial Sugar Refining Company, Ltd. 1
- Comite Franc-Dollar 1
- Conseil National du Patronat Francais 1
- Embassy of Japan 1
- European Atomic Energy Commission 1
- European Economic Commission 1
- Government of Kuwait, Ministry of Finance 1
- Government of the French Republic 1
- Government of the Philippines 1
- High Authority, European Coal & Steel Community 1
- Institute of International Bankers 1
- Iran National Airlines Corporation 1
- Ministry of Communications and Transportation of Mexico 1
- Ministry of Finance & Public Credit of Mexico 1
- Ministry of Finance of the Republic of Iraq 1
- Ministry of Foreign Relations of Mexico 1
- Petroleos de Venezuela, S.A. 1
- Peugeot, S.A. 1
- Republic of Liberia through the Ministry of Finance 1
- State of Kuwait 1
- Venezuelan Trade Mission to the First U.S. International Fair 1
Country/Location_Represented 17
- FRANCE 6
- CUBA 4
- KUWAIT 4
- MEXICO 3
- VENEZUELA 3
- BELGIUM 2
- AFGHANISTAN 1
- AUSTRALIA 1
- GREAT BRITAIN 1
- INTERNATIONAL 1
- IRAN 1
- IRAQ 1
- JAPAN 1
- LIBERIA 1
- LUXEMBOURG 1
- PHILIPPINES 1
- SPAIN 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1067 | 1067 | 1983-01-04 | Government of Kuwait, Ministry of Oil | 1982-03-08 | KUWAIT | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Kuwait City | ||||
2093 | 2093 | 1968-02-02 | Cuban Sugar Cane Growers' Association | 1958-02-19 | CUBA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Havana | ||||
2094 | 2094 | 1968-02-02 | National Cuban Sugar Mill Owners' Association | 1958-02-19 | CUBA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Havana | ||||
2095 | 2095 | 1968-02-02 | Aquitaine Oil Corporation | 1966-02-21 | FRANCE | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | New Orleans | LA | |||
2096 | 2096 | 1968-02-02 | Conseil National du Patronat Francais | 1952-02-20 | FRANCE | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Paris | ||||
2098 | 2098 | 1968-02-02 | European Atomic Energy Commission | 1959-11-10 | BELGIUM | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Brussels | ||||
2099 | 2099 | 1968-02-02 | European Economic Commission | 1959-03-23 | BELGIUM | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Brussels | ||||
2100 | 2100 | 1968-02-02 | Government of the French Republic | 1948-01-19 | FRANCE | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Paris | ||||
2101 | 2101 | 1968-02-02 | High Authority, European Coal & Steel Community | 1954-08-18 | LUXEMBOURG | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | |||||
6256 | 6256 | 1966-05-02 | Embassy of Japan | 1963-07-17 | JAPAN | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Washington | DC | |||
6944 | 6944 | 1988-05-30 | Government of the Philippines | 1987-01-20 | PHILIPPINES | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Manila | ||||
7008 | 7008 | 1956-05-31 | Cuban Sugar Cane Growers' Association | 1955-02-02 | CUBA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Havana | ||||
7009 | 7009 | 1956-05-31 | National Cuban Sugar Mill Owners' Association | 1955-02-02 | CUBA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Havana | ||||
8225 | 8225 | 1956-06-30 | Comite Franc-Dollar | 1953-02-27 | FRANCE | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Paris | ||||
8410 | 8410 | 1986-06-30 | Peugeot, S.A. | 1985-11-01 | FRANCE | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Paris | ||||
8674 | 8674 | 2008-06-30 | Republic of Liberia through the Ministry of Finance | 2007-07-30 | LIBERIA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Minister of Finance | Broad and Mechlin Streets | Monrovia | ||
9355 | 9355 | 1954-07-19 | Chambers of Commerce of Venezuela | 1950-11-09 | VENEZUELA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Caracas | ||||
9463 | 9463 | 1985-07-25 | Government of Kuwait, Ministry of Oil | 1983-01-06 | KUWAIT | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Kuwait City | ||||
10199 | 10199 | 1966-08-08 | Iran National Airlines Corporation | 1964-06-19 | IRAN | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Tehran | ||||
10627 | 10627 | 1950-08-20 | Venezuelan Trade Mission to the First U.S. International Fair | 1950-12-26 | VENEZUELA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Chicago | IL | |||
10664 | 10664 | 1994-08-22 | Colonial Sugar Refining Company, Ltd. | 1961-07-31 | AUSTRALIA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Sydney | ||||
11696 | 11696 | 1966-09-18 | Ariana Afghan Airlines Company, Ltd. | 1965-08-13 | AFGHANISTAN | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Kabul | ||||
12666 | 12666 | 1980-10-14 | Government of Kuwait, Ministry of Finance | 1980-07-29 | KUWAIT | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | London | ||||
12697 | 12697 | 1970-10-15 | Aceitunas de Mesa, S.A. | 1970-06-25 | SPAIN | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Seville | ||||
13855 | 13855 | 1998-11-09 | Ministry of Communications and Transportation of Mexico | 1996-03-21 | MEXICO | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Mexico City | ||||
13856 | 13856 | 1998-11-09 | Ministry of Finance & Public Credit of Mexico | 1991-04-04 | MEXICO | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Mexico City | ||||
15365 | 15365 | 1984-12-24 | Banque Nationale de Paris | 1976-05-06 | FRANCE | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Paris | ||||
15485 | 15485 | 1988-12-30 | BNS, Inc. | 1988-04-18 | GREAT BRITAIN | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Irving | TX | |||
15980 | 15980 | 1986-12-31 | Petroleos de Venezuela, S.A. | 1986-05-29 | VENEZUELA | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Caracas | ||||
16337 | 16337 | 1995-12-31 | Institute of International Bankers | 1994-05-20 | INTERNATIONAL | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | New York | NY | |||
16443 | 16443 | 1998-12-31 | Ministry of Foreign Relations of Mexico | 1996-05-10 | MEXICO | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Mexico City | ||||
16611 | 16611 | 2006-12-31 | State of Kuwait | 1990-08-13 | KUWAIT | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Washington | DC | |||
16714 | 16714 | 2012-12-31 | Ministry of Finance of the Republic of Iraq | 2004-07-15 | IRAQ | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Ministry of Finance Palestine Street Baghdad |
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]) );