FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Foreign_Principal_Termination_Date" is on date 2021-03-31
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Registrant_Date (date)
Registrant_Name 14
- BGR Government Affairs, LLC 1
- CCO Communications LLC 1
- Comeau & Company LLC 1
- Community Partners 1
- Copper Strategies LLC 1
- DCI Group AZ, LLC 1
- Dentons US LLP 1
- Finn Partners, Inc. 1
- Foley Hoag, LLP 1
- Fratelli Group 1
- McGuireWoods Consulting, LLC 1
- Mercury Public Affairs, LLC 1
- Sanitas International, Inc. 1
- Waxman Consulting, Inc. DBA Waxman Strategies 1
Foreign_Principal_Registration_Date (date) 14 ✖
- 2007-05-25 1
- 2014-03-10 1
- 2015-03-20 1
- 2015-05-19 1
- 2016-12-14 1
- 2019-04-09 1
- 2019-04-18 1
- 2019-08-23 1
- 2019-10-01 1
- 2019-10-17 1
- 2020-01-16 1
- 2020-02-12 1
- 2020-10-09 1
- 2020-10-30 1
Foreign_Principal 13
- Embassy of Japan 2
- Aidenvironment (under grant from the Norwegian Agency for Development Cooperation) 1
- Consulate General for Japan in Los Angeles 1
- Embassy of Armenia to the United States 1
- Government of Honduras 1
- Government of Japan, Embassy 1
- Government of the People's Democratic Republic of Algeria, Embassy 1
- Jamaica Tourist Board 1
- Kurdistan Regional Government 1
- Nicaraguans for Security & Prosperity 1
- Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB 1
- OCP S.A. (through OCP North America, Inc.) 1
- Political Union of Citizens Georgian Dream - Democratic Georgia 1
Country/Location_Represented 11
City 7
- - 5
- Washington 4
- Casablanca 1
- Chicago 1
- Killeen 1
- Los Angeles 1
- Tbilisi 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4798 | 4798 | 2021-03-31 | Government of the People's Democratic Republic of Algeria, Embassy | 2007-05-25 | ALGERIA | Foley Hoag, LLP 4776 | 1993-03-02 | Foley Hoag, LLP | 2118 Kalorama Road, NW | Washington | DC | 20008 | |
4799 | 4799 | 2021-03-31 | Aidenvironment (under grant from the Norwegian Agency for Development Cooperation) | 2019-08-23 | NORWAY | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | Barentszplein 7 1013 NJ Amsterdam Netherlands | ||||
4800 | 4800 | 2021-03-31 | Consulate General for Japan in Los Angeles | 2019-04-09 | JAPAN | Community Partners 6659 | 2019-04-09 | Community Partners | 350 S. Grand Avenue | Los Angeles | CA | 90071 | |
4801 | 4801 | 2021-03-31 | Embassy of Armenia to the United States | 2020-10-30 | ARMENIA | Copper Strategies LLC 6884 | 2020-10-30 | Copper Strategies LLC | 2225 R St NW | Washington | DC | 20008 | |
4802 | 4802 | 2021-03-31 | Embassy of Japan | 2019-04-18 | JAPAN | Comeau & Company LLC 6666 | 2019-04-18 | Comeau & Company LLC | |||||
4803 | 4803 | 2021-03-31 | Embassy of Japan | 2015-05-19 | JAPAN | McGuireWoods Consulting, LLC 6295 | 2015-05-19 | McGuireWoods Consulting, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4804 | 4804 | 2021-03-31 | Government of Honduras | 2020-01-16 | HONDURAS | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | Bulevar Kuwait, atras de la Corte Suprema de Justicia | Tegucigalpa | |||
4805 | 4805 | 2021-03-31 | Government of Japan, Embassy | 2016-12-14 | JAPAN | Fratelli Group 5867 | 2008-06-03 | Fratelli Group | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | |
4806 | 4806 | 2021-03-31 | Jamaica Tourist Board | 2014-03-10 | JAMAICA | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 64 Knutsford Blvd. Kingston 5 | ||||
4807 | 4807 | 2021-03-31 | Kurdistan Regional Government | 2015-03-20 | IRAQ | Dentons US LLP 6284 | 2015-03-20 | Dentons US LLP | Erbil | ||||
4808 | 4808 | 2021-03-31 | Nicaraguans for Security & Prosperity | 2019-10-17 | NICARAGUA | Sanitas International, Inc. 6530 | 2018-03-07 | Sanitas International, Inc. | 500 N. Michigan Ave. STE 600 | Chicago | IL | 60611 | |
4809 | 4809 | 2021-03-31 | Nnamdi Kanu Leader of the Indigenous People of Biafra IPOB | 2019-10-01 | BIAFRA | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | Nnamdi Kanu | 7432 East Trimmier Road | Killeen | TX | 76542 |
4810 | 4810 | 2021-03-31 | OCP S.A. (through OCP North America, Inc.) | 2020-10-09 | MOROCCO | CCO Communications LLC 6874 | 2020-10-09 | CCO Communications LLC | 2-4, Rue Al Abtal, Hay Erraha | Casablanca | |||
4811 | 4811 | 2021-03-31 | Political Union of Citizens Georgian Dream - Democratic Georgia | 2020-02-12 | GEORGIA | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | Erekle II square 3 | 36 ANton Katalikosi st. | Tbilisi |
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]) );