FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where "Foreign_Principal_Termination_Date" is on date 2022-05-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Address_2, Zip, Registrant_Date (date)
Foreign_Principal 9
- African Development Bank 1
- Bahaa Hariri thru CT Solutions & Private Advisory Ltd. 1
- Discover Dominica Authority 1
- Government of Ethiopia 1
- Government of National Unity of Libya 1
- Government of the United Kingdom, Embassy 1
- Ministry of Foreign Affairs and International Trade of Zimbabwe 1
- N.S.O. Group Technologies Ltd. 1
- U.S.- China Transpacific Foundation 1
Country/Location_Represented 9
- CHINA 1
- COTE D'IVOIRE (IVORY COAST) 1
- DOMINICAN REPUBLIC 1
- ETHIOPIA 1
- GREAT BRITAIN 1
- ISRAEL 1
- LEBANON 1
- LIBYA 1
- ZIMBABWE 1
Registrant_Name 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7290 | 7290 | 2022-05-31 | African Development Bank | 2021-11-01 | COTE D'IVOIRE (IVORY COAST) | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | Avenue Joseph Anoma, 01 B.P. 1387 | Abidjan, Ivory Coast | |||
7292 | 7292 | 2022-05-31 | Discover Dominica Authority | 2018-04-30 | DOMINICAN REPUBLIC | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 1st Floor Financial Centre | Roseau, Commonwealth of Dominica | |||
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 | |||
7296 | 7296 | 2022-05-31 | Ministry of Foreign Affairs and International Trade of Zimbabwe | 2021-11-01 | ZIMBABWE | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | P.O. Box 4240, Munhumutapa Building, Samora Machel | Sam Nujoma Street | Harare | ||
7297 | 7297 | 2022-05-31 | N.S.O. Group Technologies Ltd. | 2022-03-10 | ISRAEL | Rabinowitz, Inc. d/b/a Bluelight Strategies 7094 | 2022-03-10 | Rabinowitz, Inc. d/b/a Bluelight Strategies | 9 Hamada St. Gav-Yam, North Building P.O.B. 4166 | Herzliya | |||
7298 | 7298 | 2022-05-31 | U.S.- China Transpacific Foundation | 2017-09-15 | CHINA | Capitol Counsel, LLC 6328 | 2015-11-19 | Capitol Counsel, LLC | 11920 Southern Highlands Parkway | Suite 301 | Las Vegas | NV | 89141 |
7291 | 7291 | 2022-05-31 | Bahaa Hariri thru CT Solutions & Private Advisory Ltd. | 2021-09-03 | LEBANON | CTF Global LLC 7008 | 2021-09-03 | CTF Global LLC | 20 Grosvenor Square | W1K 6LE | London | ||
7294 | 7294 | 2022-05-31 | Government of National Unity of Libya | 2021-11-01 | LIBYA | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | Tarik al Seka, Ben Ashour District | Tripoli | |||
7293 | 7293 | 2022-05-31 | Government of Ethiopia | 2021-11-01 | ETHIOPIA | Actum International UK Limited 7033 | 2021-11-01 | Actum International UK Limited | United States Embassy of Ethiopia | 3506 International Drive, N.W. | Washington | DC | 20008 |
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]) );