FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where City = "" and Registration_Number = 4776
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Address_1, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 17
- Republic of Guyana 2
- Republic of Uganda, Embassy 2
- Agexpront 1
- Democracy & Dignity Foundation 1
- Government of Honduras 1
- Government of Rwanda 1
- Interim Government of National Unity of the Republic of Liberia 1
- Republic of Djibouti 1
- Republic of Guatemala 1
- Republic of Haiti 1
- Republic of Kenya 1
- Republic of Nicaragua 1
- Saharawi Arab Democratic Republic 1
- Supreme Court of Justice of the Republic of Guatemala 1
- United Coconut Association of the Philippines 1
- United Front for Multiparty Democracy in Malawi 1
- United Republic of Tanzania 1
Country/Location_Represented 15
Registrant_Name 1
City 1
- - · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1222 | 1222 | 1994-01-11 | Interim Government of National Unity of the Republic of Liberia | 1993-03-03 | LIBERIA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Monrovia | ||||
1224 | 1224 | 1994-01-11 | United Coconut Association of the Philippines | 1993-03-03 | PHILIPPINES | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Manila | ||||
1841 | 1841 | 2002-01-31 | Republic of Uganda, Embassy | 2001-02-13 | UGANDA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | 5911 16th Street, N.W. | DC | |||
3064 | 3064 | 2004-02-28 | Republic of Haiti | 2003-04-24 | HAITI | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Palais National Port-au-Prince | ||||
4561 | 4561 | 1998-03-31 | Government of Honduras | 1996-04-26 | HONDURAS | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Tegucigalpa | ||||
4737 | 4737 | 2013-03-31 | Republic of Djibouti | 2004-08-10 | DJIBOUTI | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Ministry of Foreign Relations | ||||
4738 | 4738 | 2013-03-31 | Republic of Guyana | 2004-04-09 | GUYANA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Ministry of Foreign Relations Georgetown | ||||
5298 | 5298 | 1995-04-15 | United Republic of Tanzania | 1994-01-11 | TANZANIA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Dar Es Salaam | ||||
5304 | 5304 | 1999-04-15 | Republic of Uganda, Embassy | 1994-01-11 | UGANDA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Entebbe | ||||
7197 | 7197 | 2003-05-31 | Republic of Kenya | 2003-01-06 | KENYA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Nairobi | ||||
12079 | 12079 | 1996-09-30 | Government of Rwanda | 1996-04-26 | RWANDA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Kigali | ||||
12149 | 12149 | 2003-09-30 | Republic of Guatemala | 2000-02-09 | GUATEMALA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Guatemala City | ||||
12585 | 12585 | 2001-10-10 | Agexpront | 2001-04-30 | GUATEMALA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | 15 Avenida 14-72 Zona 13 Guatemala, CA 01013 | ||||
15321 | 15321 | 1994-12-22 | Democracy & Dignity Foundation | 1993-05-20 | FRANCE | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Neuilly/Seine | ||||
15324 | 15324 | 1994-12-22 | Saharawi Arab Democratic Republic | 1993-03-03 | ALGERIA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Tindouf | ||||
15325 | 15325 | 1994-12-22 | Supreme Court of Justice of the Republic of Guatemala | 1993-03-03 | GUATEMALA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Guatemala City | ||||
15326 | 15326 | 1994-12-22 | United Front for Multiparty Democracy in Malawi | 1993-03-03 | MALAWI | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Lusaka | ||||
16403 | 16403 | 1996-12-31 | Republic of Nicaragua | 1993-03-02 | NICARAGUA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Managua | ||||
16507 | 16507 | 2001-12-31 | Republic of Guyana | 1993-03-03 | GUYANA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | Georgetown |
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]) );