FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
35 rows where City = "" and "Registrant_Date" is on date 1985-08-07 sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Foreign_Principal >30
- Government of Jamaica 2
- Aerovias Nacionales de Colombia, S.A. (AVIANCA) 1
- Air China International Corp. 1
- Air Jamaica, Ltd. 1
- Air Malta Company, Ltd. 1
- All Amhara Peoples Organization 1
- Atiku Abubakar 1
- Cayman Islands Government 1
- Central American Bank for Economic Integration 1
- Coordinadora de las Comunidades Afectadas por la Construccion de la Hidroelectrica Chixoy (COCAHICH) 1
- Florida International Bankers Association 1
- Fondo Latinoamericano de Reservas - FLAR 1
- Government of El Salvador 1
- Government of Gibraltar 1
- Government of Jamaica (JAMPRO) 1
- Government of Jamaica, Ministry of Foreign Affairs 1
- Government of the Kingdom of Bahrain 1
- Government of the Republic of Senegal 1
- Government of the Republic of Trinidad & Tabago 1
- Government of the United Kingdom, Embassy 1
- Hitachi, Ltd. 1
- Hotel Suites Alvear 1
- Huzaifah Shabbir Bengal 1
- Jamaica National Export Corporation 1
- Libyan Asset Recovery and Management Office 1
- Llantas Economicas, S.A. 1
- Ministry of Peace, Federal Democratic Republic of Ethiopia 1
- Ministry of Tourism (Jamaica) 1
- Pancanal Shipping Agency, S.A. 1
- Paribas Asset Management, Inc. 1
- …
Country/Location_Represented 23
- JAMAICA 7
- INTERNATIONAL 3
- PANAMA 3
- COLOMBIA 2
- ETHIOPIA 2
- BAHRAIN 1
- BRAZIL 1
- CAYMAN ISLANDS 1
- CHINA 1
- COSTA RICA 1
- EL SALVADOR 1
- FRANCE 1
- GIBRALTAR 1
- GREAT BRITAIN 1
- GUATEMALA 1
- JAPAN 1
- KOREA, SOUTH 1
- LIBYA 1
- MALTA 1
- NIGERIA 1
- SAUDI ARABIA 1
- SENEGAL 1
- TRINIDAD AND TOBAGO 1
Address_1 21 ✖
- - 9
- Kingston 5
- Miami 2
- Panama City 2
- #8 Lake Chad Crescent 1
- Avenida 82 No. 12-18 Piso 7 Bogota 1
- Bogota 1
- British Embassy 3100 Massachusetts Ave., NW 1
- Dakar 1
- Ethio-China Street 1
- Luga 1
- Manama 1
- Medellin 1
- New York 1
- Office of the Chief Minister Government of Gibraltar 1
- P. O. Box 138 #133 Elgin Ave, George Town 1
- P.O. Box 5289 Addis Ababa 1
- Port-of-Spain 1
- San Salvador 1
- Tegucigalpa 1
- Tokyo 1
Registrant_Name 3
City 1
- - · 35 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14909 | 14909 | 1986-12-09 | Hitachi, Ltd. | 1985-08-07 | JAPAN | Teramura International, Inc. 3716 | 1985-08-07 | Teramura International, Inc. | Tokyo | ||||
11971 | 11971 | 1985-09-30 | Paribas Asset Management, Inc. | 1985-08-07 | FRANCE | Chapoton, John E. 3717 | 1985-08-07 | Chapoton, John E. | NY | ||||
104 | 104 | Cayman Islands Government | 2021-03-23 | CAYMAN ISLANDS | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | P. O. Box 138 #133 Elgin Ave, George Town | Grand Cayman, KYI-9000 | ||||
280 | 280 | Government of Gibraltar | 2014-05-14 | GIBRALTAR | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Office of the Chief Minister Government of Gibraltar | No. 6 Convent Place | ||||
438 | 438 | Libyan Asset Recovery and Management Office | 2021-05-28 | LIBYA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | ||||||
703 | 703 | The Ministry of Trade, Industry and Energy of the Republic of Korea | 2022-02-04 | KOREA, SOUTH | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | ||||||
2205 | 2205 | 2021-02-04 | Atiku Abubakar | 2021-02-04 | NIGERIA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | #8 Lake Chad Crescent | Maitama, Abuja, Nigeria | |||
2249 | 2249 | 2003-02-06 | Air China International Corp. | 1998-06-09 | CHINA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | New York | NY | |||
2250 | 2250 | 2003-02-06 | Air Malta Company, Ltd. | 1998-01-29 | MALTA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Luga | ||||
2970 | 2970 | 1991-02-28 | Llantas Economicas, S.A. | 1990-06-05 | PANAMA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Panama City | ||||
3084 | 3084 | 2007-02-28 | Varig Brazilian Airlines | 1989-09-07 | BRAZIL | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Miami | FL | |||
3174 | 3174 | 2008-02-29 | Coordinadora de las Comunidades Afectadas por la Construccion de la Hidroelectrica Chixoy (COCAHICH) | 2006-12-01 | GUATEMALA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | |||||
3400 | 3400 | 1993-03-03 | Government of Jamaica (JAMPRO) | 1989-03-17 | JAMAICA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Kingston | ||||
3401 | 3401 | 1993-03-03 | Ministry of Tourism (Jamaica) | 1991-03-08 | JAMAICA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Kingston | ||||
5645 | 5645 | 1988-04-28 | Air Jamaica, Ltd. | 1987-03-15 | JAMAICA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | |||||
6756 | 6756 | 2022-05-23 | Huzaifah Shabbir Bengal | 2019-07-24 | SAUDI ARABIA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | |||||
7295 | 7295 | 2022-05-31 | Government of the United Kingdom, Embassy | 1999-08-16 | GREAT BRITAIN | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | British Embassy 3100 Massachusetts Ave., NW | DC | |||
7803 | 7803 | 1994-06-14 | Government of Jamaica, Ministry of Foreign Affairs | 1989-09-07 | JAMAICA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Kingston | ||||
8015 | 8015 | 2000-06-22 | Government of Jamaica | 1996-08-15 | JAMAICA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Kingston | ||||
8463 | 8463 | 1990-06-30 | Hotel Suites Alvear | 1990-01-17 | PANAMA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Panama City | ||||
9279 | 9279 | 2001-07-15 | All Amhara Peoples Organization | 2001-07-18 | ETHIOPIA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | P.O. Box 5289 Addis Ababa | ||||
10217 | 10217 | 1998-08-08 | Florida International Bankers Association | 1991-12-19 | INTERNATIONAL | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Miami | FL | |||
10218 | 10218 | 1998-08-08 | Government of the Republic of Senegal | 1994-10-07 | SENEGAL | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Dakar | ||||
10219 | 10219 | 1998-08-08 | Republic of Costa Rica | 1998-04-15 | COSTA RICA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | |||||
10220 | 10220 | 1998-08-08 | Sociedad Aeronautica de Medellin | 1991-03-08 | COLOMBIA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Medellin | ||||
10587 | 10587 | 2006-08-17 | Government of the Kingdom of Bahrain | 2003-12-05 | BAHRAIN | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Manama | ||||
11005 | 11005 | 1990-08-31 | Pancanal Shipping Agency, S.A. | 1989-11-30 | PANAMA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | |||||
11072 | 11072 | 2001-08-31 | Government of El Salvador | 2000-06-02 | EL SALVADOR | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | San Salvador | ||||
11093 | 11093 | 2005-08-31 | Fondo Latinoamericano de Reservas - FLAR | 2004-10-22 | INTERNATIONAL | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Avenida 82 No. 12-18 Piso 7 Bogota | ||||
12898 | 12898 | 2021-10-21 | Ministry of Peace, Federal Democratic Republic of Ethiopia | 2021-04-07 | ETHIOPIA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Ethio-China Street | Addis Ababa, 5608 | |||
13994 | 13994 | 1999-11-15 | Central American Bank for Economic Integration | 1999-02-24 | INTERNATIONAL | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Tegucigalpa | ||||
14456 | 14456 | 1995-11-30 | Government of the Republic of Trinidad & Tabago | 1993-12-17 | TRINIDAD AND TOBAGO | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Port-of-Spain | ||||
16058 | 16058 | 1988-12-31 | Government of Jamaica | 1988-05-31 | JAMAICA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Kingston | ||||
16064 | 16064 | 1988-12-31 | Jamaica National Export Corporation | 1985-08-07 | JAMAICA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | |||||
16820 | 16820 | 2018-12-31 | Aerovias Nacionales de Colombia, S.A. (AVIANCA) | 1985-12-12 | COLOMBIA | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Bogota | CO |
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]) );