home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for FARA_All_ForeignPrincipals
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

28 rows where Country/Location_Represented = "PANAMA" and State = "DC"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)

Registrant_Name 26

  • Tew Cardenas, LLP 2
  • Williams & Connolly 2
  • Akin, Gump, Strauss, Hauer & Feld, LLP 1
  • Arthur D. Little, Inc. 1
  • Bellwether Strategies, Inc. 1
  • Bond Donatelli, Inc. 1
  • Capital Services of Washington, Inc. 1
  • Capitol Resources Group 1
  • Clark & Weinstock 1
  • Conover & Company Communications, Inc. 1
  • Daniel J. Edelman, Inc. 1
  • Dow, Lohnes & Albertson, L.L.P. 1
  • Integrated Solutions Group, LLC 1
  • John G. Campbell Consultants, Inc. 1
  • John R. Zagame Associates, Inc. 1
  • Mehlman Vogel Castagnetti, Inc. 1
  • Miller & Chevalier, Chartered 1
  • Parven Pomper Strategies, Inc. 1
  • Potomac Partners DC 1
  • Sawyer Miller Group 1
  • Shepardson, Stern & Kaminsky 1
  • Squire Patton Boggs, LLP 1
  • Susan Davis International & Public Affairs 1
  • Trailblazer Group 1
  • Washington Group 1
  • van Kloberg & Associates, Ltd. 1

Foreign_Principal 16

  • Republic of Panama, Embassy 5
  • Embassy of Panama 4
  • Republic of Panama 4
  • Government of the Republic of Panama 2
  • National Civic Crusade for Panama 2
  • Embassy of the Republic of Panama 1
  • Government of Panama 1
  • Government of Panama, Embassy 1
  • Government of the Republic of Panama (In Exile), Eric Arturo Delvalle, President 1
  • Government of the Republic of Panama, Embassy 1
  • National Civic Crusade for Panama Panama Freedom Foundation 1
  • National Investment Council of Panama 1
  • Republic of Panama (President Eric Arturo Delvalle) 1
  • Republic of Panama, Embassy through the Washington Group 1
  • Republic of Panama, Embassy, 1
  • Republic of Panama/MOFA through BLJ Worldwide 1

City 2

  • - 17
  • Washington 11

State 1

  • DC · 28 ✖

Country/Location_Represented 1

  • PANAMA · 28 ✖
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
593 593   Republic of Panama 2022-09-07 PANAMA Potomac Partners DC 7164 2022-09-07 Potomac Partners DC Embassy of the Republic of Panama in the U.S. 2862 McGill Terrace, NW Washington DC 20008
1004 1004 2009-01-01 Embassy of Panama 2008-05-02 PANAMA Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2862 McGill Terrace, NW   Washington DC 20008
1009 1009 2009-01-01 Republic of Panama, Embassy 2005-09-30 PANAMA Washington Group 5711 2005-09-30 Washington Group 2862 McGill Terrace, NW   Washington DC 20008
3690 3690 1991-03-13 National Civic Crusade for Panama Panama Freedom Foundation 1988-09-13 PANAMA Capital Services of Washington, Inc. 4175 1988-09-13 Capital Services of Washington, Inc. Washington     DC  
6201 6201 1988-05-01 Government of the Republic of Panama (In Exile), Eric Arturo Delvalle, President 1988-03-03 PANAMA Sawyer Miller Group 3777 1986-02-12 Sawyer Miller Group Washington     DC  
6377 6377 1992-05-07 Government of the Republic of Panama 1990-01-30 PANAMA Williams & Connolly 4225 1989-03-14 Williams & Connolly Washington     DC  
6436 6436 1989-05-10 Republic of Panama (President Eric Arturo Delvalle) 1989-03-14 PANAMA Williams & Connolly 4225 1989-03-14 Williams & Connolly Embassy, Washington     DC  
6485 6485 1995-05-12 Embassy of the Republic of Panama 1993-06-02 PANAMA van Kloberg & Associates, Ltd. 3466 1983-05-09 van Kloberg & Associates, Ltd. Washington     DC  
6589 6589 2012-05-15 Republic of Panama, Embassy 2011-05-24 PANAMA Mehlman Vogel Castagnetti, Inc. 6042 2011-05-24 Mehlman Vogel Castagnetti, Inc. 2862 McGill Terrace, NW   Washington DC 20008
7162 7162 1997-05-31 Government of Panama, Embassy 1997-02-19 PANAMA Shepardson, Stern & Kaminsky 5158 1997-02-19 Shepardson, Stern & Kaminsky Washington     DC  
7269 7269 2017-05-31 Government of the Republic of Panama, Embassy 2016-10-04 PANAMA Bellwether Strategies, Inc. 6382 2016-10-04 Bellwether Strategies, Inc. 2682 McGill Terrace, NW   Washington DC 20008
7281 7281 2018-05-31 Republic of Panama/MOFA through BLJ Worldwide 2016-10-27 PANAMA Trailblazer Group 6385 2016-10-27 Trailblazer Group Embassy of Panama 2862 McGill Terrace, NW Washington DC 20008
8399 8399 1985-06-30 National Investment Council of Panama 1983-07-15 PANAMA Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP Washington     DC  
8460 8460 1990-06-30 Government of Panama 1990-06-20 PANAMA Capitol Resources Group 4386 1990-06-20 Capitol Resources Group Washington     DC  
8660 8660 2006-06-30 Republic of Panama, Embassy 2005-03-23 PANAMA Tew Cardenas, LLP 5562 2003-06-10 Tew Cardenas, LLP 2862 McGill Terrace, NW     DC  
8676 8676 2009-06-30 Embassy of Panama 2007-03-22 PANAMA Parven Pomper Strategies, Inc. 5781 2006-12-19 Parven Pomper Strategies, Inc. 2862 McGill Terrace, NW   Washington DC 20008
8684 8684 2009-06-30 Republic of Panama, Embassy through the Washington Group 2008-02-27 PANAMA Integrated Solutions Group, LLC 5855 2008-02-27 Integrated Solutions Group, LLC 2862 McGill Terrace, NW   Washington DC 20008
8685 8685 2009-06-30 Republic of Panama, Embassy 2009-02-17 PANAMA Clark & Weinstock 5914 2009-03-06 Clark & Weinstock 2862 McGill Terrace, NW   Washington DC 20008
9763 9763 1989-07-31 Republic of Panama 1989-02-14 PANAMA Bond Donatelli, Inc. 4215 1989-02-14 Bond Donatelli, Inc. Embassy, Washington     DC  
9764 9764 1989-07-31 Republic of Panama 1989-02-14 PANAMA John R. Zagame Associates, Inc. 4216 1989-02-14 John R. Zagame Associates, Inc. Embassy, Washington     DC  
11257 11257 1987-09-01 Government of the Republic of Panama 1986-07-29 PANAMA Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. Washington     DC  
11263 11263 1987-09-01 National Civic Crusade for Panama 1987-07-01 PANAMA Susan Davis International & Public Affairs 3444 1983-02-16 Susan Davis International & Public Affairs Washington     DC  
11295 11295 2004-09-01 Republic of Panama, Embassy 2004-03-29 PANAMA Tew Cardenas, LLP 5562 2003-06-10 Tew Cardenas, LLP Amb. Roberto Alfaro 2862 McGill Terrance N.W. 20008     DC  
11920 11920 1967-09-30 Republic of Panama 1967-06-26 PANAMA Arthur D. Little, Inc. 2032 1967-06-26 Arthur D. Little, Inc. Washington     DC  
12714 12714 1988-10-15 National Civic Crusade for Panama 1987-07-22 PANAMA John G. Campbell Consultants, Inc. 4015 1987-07-22 John G. Campbell Consultants, Inc. Washington     DC  
13612 13612 1995-11-01 Embassy of Panama 1995-09-04 PANAMA Conover & Company Communications, Inc. 5047 1995-09-04 Conover & Company Communications, Inc. Washington     DC  
14722 14722 2009-12-01 Embassy of Panama 2007-05-01 PANAMA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2862 McGill Terrace, NW   Washington DC 20008
16608 16608 2006-12-31 Republic of Panama, Embassy, 2006-06-29 PANAMA Miller & Chevalier, Chartered 5365 2000-04-03 Miller & Chevalier, Chartered 2862 McGill Terrace, NW   Washington DC 20008

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 343.351ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows