FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where State = "DC" and Zip = 20006
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 24
- QORVIS LLC 2
- Alexander Beckles, L.L.C. 1
- Alpaytac, Inc. 1
- Amano, Kathy Y. 1
- American Business Development Group 1
- BGR Government Affairs, LLC 1
- Brownstein Hyatt Farber Schreck, LLP 1
- Cassidy & Associates, Inc. 1
- DEACERO S.A.P.I. de C.V. (DEACERO) 1
- Daniel J. Edelman, Inc. 1
- DuSable Capital Management, LLC 1
- Federalist Group, an Ogilvy PR Worldwide Company 1
- Glassman Enterprises, LLC 1
- Greenberg Traurig, LLP 1
- Herrick, Feinstein LLP 1
- Hyde Park Communications, Inc. 1
- Kurdistan Regional Government - Liaison Office - USA 1
- LB International Solutions, LLC 1
- Park Strategies, LLC 1
- Podesta Group, Inc. 1
- Prime Policy Group 1
- Quintairos, Prieto, Wood & Boyer, P.A. 1
- Slocum & Boddie, PLLC 1
- TS Navigations, LLC 1
Foreign_Principal 17
- Kurdistan Regional Government 7
- Embassy of Mexico 2
- Turkish Republic of Northern Cyprus (TRNC) Washington DC Office 2
- Atiku Abubakar through Weidenfeld Law Group 1
- Embassy of Mexico through Kuykendall & Associates 1
- Embassy of the Republic of Turkey 1
- Foreign Minister Jun Shimml with the Embassy of Japan 1
- Government of Malaysia 1
- Government of Trinidad and Tobago (through Ainsley Gill & Associates) 1
- His Excellency Andry Nirina Rajoelina, President of the High Transitional Authority of the Republic of Madagascar 1
- Mr. Salman Al-Ansari (through Saudi American Public Relation Affairs Committee, Inc.) 1
- National Council of Resistance of Iran-U.S. Representative Office 1
- Republic of Palau, Embassy 1
- Republic of Trinidad and Tobago through Ainsley Gill and Associates 1
- Turkish Republic of Northern Cyprus (T.R.N.C.")" 1
- Turkish Republic of Northern Cyprus (TRNC) 1
- Washington, DC, Representative office of Taiwan's KMT-PFP d/b/a KMT-PFP U.S.A. 1
Country/Location_Represented 13
- IRAQ 7
- CYPRUS 3
- MEXICO 3
- TRINIDAD AND TOBAGO 2
- TURKEY 2
- IRAN 1
- JAPAN 1
- MADAGASCAR 1
- MALAYSIA 1
- NIGERIA 1
- PALAU 1
- SAUDI ARABIA 1
- TAIWAN 1
City 2
- Washington 24
- Washington, 1
State 1
- DC · 25 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
176 | 176 | Embassy of Mexico | 2022-01-12 | MEXICO | Glassman Enterprises, LLC 7069 | 2022-01-12 | Glassman Enterprises, LLC | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | ||
177 | 177 | Embassy of Mexico | 2021-09-07 | MEXICO | DEACERO S.A.P.I. de C.V. (DEACERO) 7013 | 2021-09-07 | DEACERO S.A.P.I. de C.V. (DEACERO) | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | ||
418 | 418 | Kurdistan Regional Government | 2006-09-12 | IRAQ | Slocum & Boddie, PLLC 5765 | 2006-09-12 | Slocum & Boddie, PLLC | 1634 Eye Street, NW | Suite 210 | Washington | DC | 20006 | |
419 | 419 | Kurdistan Regional Government | 2006-12-28 | IRAQ | Kurdistan Regional Government - Liaison Office - USA 5783 | 2006-12-28 | Kurdistan Regional Government - Liaison Office - USA | 1634 Eye Street, NW | Suite 210 | Washington | DC | 20006 | |
514 | 514 | National Council of Resistance of Iran-U.S. Representative Office | 2021-06-28 | IRAN | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 1747 Pennsylvania Avenue, NW | Suite 1125 | Washington | DC | 20006 | |
727 | 727 | Turkish Republic of Northern Cyprus (TRNC) Washington DC Office | 2023-01-03 | CYPRUS | LB International Solutions, LLC 6210 | 2014-03-03 | LB International Solutions, LLC | 1667 K Street NW, Suite 690 | Washington | DC | 20006 | ||
728 | 728 | Turkish Republic of Northern Cyprus (TRNC) Washington DC Office | 2023-01-23 | TURKEY | Alexander Beckles, L.L.C. 6939 | 2021-03-13 | Alexander Beckles, L.L.C. | 1667 K Street NW, Suite 690 Washington, DC 20006 | Washington, | DC | 20006 | ||
4779 | 4779 | 2019-03-31 | Embassy of Mexico through Kuykendall & Associates | 2009-02-02 | MEXICO | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 1911 Pennsylvania Avenue, NW | Washington | DC | 20006 | |
5605 | 5605 | 2012-04-26 | His Excellency Andry Nirina Rajoelina, President of the High Transitional Authority of the Republic of Madagascar | 2012-04-26 | MADAGASCAR | Quintairos, Prieto, Wood & Boyer, P.A. 6098 | 2012-04-26 | Quintairos, Prieto, Wood & Boyer, P.A. | c/o U.S. FED | 1717 Pennsylvania Avenue, NW Suite 1025 | Washington | DC | 20006 |
6238 | 6238 | 2012-05-01 | Kurdistan Regional Government | 2009-06-15 | IRAQ | TS Navigations, LLC 5943 | 2009-06-15 | TS Navigations, LLC | 1634 Eye Street, NW | Suite 210 | Washington | DC | 20006 |
6635 | 6635 | 2016-05-17 | Kurdistan Regional Government | 2009-06-23 | IRAQ | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1634 Eye Street, NW | Suite 210 | Washington | DC | 20006 |
7250 | 7250 | 2015-05-31 | Embassy of the Republic of Turkey | 2014-05-23 | TURKEY | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | 2525 Massachusetts Avenue, NW | Washington | DC | 20006 | |
7504 | 7504 | 2013-06-02 | Kurdistan Regional Government | 2007-10-01 | IRAQ | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | 1634 Eye Street, NW | Suite 210 | Washington | DC | 20006 |
7598 | 7598 | 2019-06-04 | Turkish Republic of Northern Cyprus (TRNC) | 2016-09-19 | CYPRUS | Prime Policy Group 6377 | 2016-09-19 | Prime Policy Group | 1667 K Street, NW | Washington | DC | 20006 | |
11726 | 11726 | 2017-09-19 | Mr. Salman Al-Ansari (through Saudi American Public Relation Affairs Committee, Inc.) | 2017-08-15 | SAUDI ARABIA | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | c/o SAPRAC Inc. | 1101 30th Street, NW Suite 315 | Washington | DC | 20006 |
12453 | 12453 | 2014-10-02 | Government of Malaysia | 2013-09-26 | MALAYSIA | DuSable Capital Management, LLC 6190 | 2013-09-26 | DuSable Capital Management, LLC | 1701 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 |
12835 | 12835 | 2007-10-18 | Washington, DC, Representative office of Taiwan's KMT-PFP d/b/a KMT-PFP U.S.A. | 2007-09-20 | TAIWAN | Park Strategies, LLC 5830 | 2007-09-20 | Park Strategies, LLC | 1700 Pennsylvania Avenue, NW | Suite 400 | Washington | DC | 20006 |
13445 | 13445 | 2009-10-31 | Atiku Abubakar through Weidenfeld Law Group | 2008-05-30 | NIGERIA | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 888 17th Street, NW | Suite 900 | Washington | DC | 20006 |
13458 | 13458 | 2011-10-31 | Kurdistan Regional Government | 2007-05-14 | IRAQ | American Business Development Group 5810 | 2007-05-14 | American Business Development Group | 1634 Eye Street, NW | Suite 210 | Washington | DC | 20006 |
14534 | 14534 | 2010-11-30 | Foreign Minister Jun Shimml with the Embassy of Japan | 2009-11-17 | JAPAN | Amano, Kathy Y. 5972 | 2009-11-17 | Amano, Kathy Y. | 2520 Massachusetts Avenue, NW | Washington | DC | 20006 | |
14558 | 14558 | 2015-11-30 | Turkish Republic of Northern Cyprus (T.R.N.C.")" | 2013-09-09 | CYPRUS | Herrick, Feinstein LLP 6185 | 2013-09-09 | Herrick, Feinstein LLP | Office of the Representative T.R.N.C. | 1667 K Street, NW., Suite 690 | Washington | DC | 20006 |
16593 | 16593 | 2005-12-31 | Government of Trinidad and Tobago (through Ainsley Gill & Associates) | 2005-09-16 | TRINIDAD AND TOBAGO | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 1627 K Street, NW | #901 | Washington | DC | 20006 |
16609 | 16609 | 2006-12-31 | Republic of Trinidad and Tobago through Ainsley Gill and Associates | 2006-03-31 | TRINIDAD AND TOBAGO | Federalist Group, an Ogilvy PR Worldwide Company 5628 | 2004-06-17 | Federalist Group, an Ogilvy PR Worldwide Company | 1627 K Street, NW | Suite 901 | Washington | DC | 20006 |
16644 | 16644 | 2008-12-31 | Republic of Palau, Embassy | 2008-02-22 | PALAU | Hyde Park Communications, Inc. 5854 | 2008-02-22 | Hyde Park Communications, Inc. | 1700 Pennsylvania Avenue, NW | Suite 400 | Washington | DC | 20006 |
16663 | 16663 | 2009-12-31 | Kurdistan Regional Government | 2009-05-22 | IRAQ | Cassidy & Associates, Inc. 5643 | 2004-09-10 | Cassidy & Associates, Inc. | 1634 Eye Street, NW | Suite 210 | Washington | DC | 20006 |
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]) );