FARA_All_ForeignPrincipals

Table actions
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 City = "Washington", Foreign_Principal = "Embassy of the Republic of Korea" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Foreign_Principal 1

  • Embassy of the Republic of Korea · 28 ✖

Country/Location_Represented 1

City 1

  • Washington · 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
207 207   Embassy of the Republic of Korea 2018-01-10 KOREA, SOUTH Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
208 208   Embassy of the Republic of Korea 2017-01-20 KOREA, SOUTH Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 2450 Massachusetts Avenue, NW   Washington DC 20008
209 209   Embassy of the Republic of Korea 2021-01-24 KOREA, SOUTH Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
210 210   Embassy of the Republic of Korea 2010-03-22 KOREA, SOUTH Thomas Capitol Partners, Inc. 5982 2010-03-22 Thomas Capitol Partners, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
1029 1029 2017-01-01 Embassy of the Republic of Korea 2015-02-08 KOREA, SOUTH TwinLogic Strategies, LLP 6276 2015-02-08 TwinLogic Strategies, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
3345 3345 2014-03-01 Embassy of the Republic of Korea 2012-01-06 KOREA, SOUTH Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
3784 3784 2010-03-15 Embassy of the Republic of Korea 2008-09-22 KOREA, SOUTH Arent Fox, LLP 5882 2008-09-22 Arent Fox, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
4964 4964 2018-04-01 Embassy of the Republic of Korea 2015-09-29 KOREA, SOUTH Rokk Solutions, LLC 6320 2015-09-29 Rokk Solutions, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
5441 5441 2022-04-20 Embassy of the Republic of Korea 2019-01-10 KOREA, SOUTH Nelson Mullins Riley & Scarborough, LLP 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
8664 8664 2007-06-30 Embassy of the Republic of Korea 2006-05-26 KOREA, SOUTH Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. 2450 Massachusetts Avenue, N.W.   Washington DC 20008
12175 12175 2007-09-30 Embassy of the Republic of Korea 2006-06-28 KOREA, SOUTH RJI Government Strategies 5671 2005-03-01 RJI Government Strategies 2450 Massachusetts Avenue, NW   Washington DC 20008
13451 13451 2011-10-31 Embassy of the Republic of Korea 2011-10-19 KOREA, SOUTH West Wing Writers, LLC 6072 2011-10-19 West Wing Writers, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008-2850
14905 14905 2014-12-08 Embassy of the Republic of Korea 2014-04-16 KOREA, SOUTH Singer Bonjean Strategies 6216 2014-04-16 Singer Bonjean Strategies 2450 Massachusetts Avenue, NW   Washington DC 20008
15505 15505 2009-12-30 Embassy of the Republic of Korea 2005-10-14 KOREA, SOUTH Scribe Strategies & Advisors 5673 2005-03-07 Scribe Strategies & Advisors 2450 Massachusetts Avenue, NW   Washington DC 20008
16631 16631 2008-12-31 Embassy of the Republic of Korea 2007-06-18 KOREA, SOUTH Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
16692 16692 2011-12-31 Embassy of the Republic of Korea 2010-09-20 KOREA, SOUTH FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 2005-01-31 FGS Global (US) LLC (FKA FGH Holdings LLC) 2450 Massachusetts Avenue, NW   Washington DC 20008
16693 16693 2011-12-31 Embassy of the Republic of Korea 2010-09-24 KOREA, SOUTH Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
16707 16707 2012-12-31 Embassy of the Republic of Korea 2010-09-21 KOREA, SOUTH Singer Bonjean Strategies 6001 2010-09-21 Singer Bonjean Strategies 2450 Massachusetts Avenue, NW   Washington DC 20008
16730 16730 2013-12-31 Embassy of the Republic of Korea 2012-06-06 KOREA, SOUTH West Wing Writers, LLC 6107 2012-06-06 West Wing Writers, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008-2850
16744 16744 2014-12-31 Embassy of the Republic of Korea 2014-03-07 KOREA, SOUTH Cornerstone Government Affairs, LLC 6211 2014-03-07 Cornerstone Government Affairs, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
16745 16745 2014-12-31 Embassy of the Republic of Korea 2014-09-09 KOREA, SOUTH Kasowitz, Benson, Torres and Friedman, LLP 6197 2013-11-19 Kasowitz, Benson, Torres and Friedman, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
16781 16781 2016-12-31 Embassy of the Republic of Korea 2015-02-04 KOREA, SOUTH Harbinger Strategies, LLC 6275 2015-02-04 Harbinger Strategies, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
16782 16782 2016-12-31 Embassy of the Republic of Korea 2014-03-10 KOREA, SOUTH Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 2450 Massachusetts Avenue, NW   Washington DC  
16783 16783 2016-12-31 Embassy of the Republic of Korea 2015-04-17 KOREA, SOUTH BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
16801 16801 2017-12-31 Embassy of the Republic of Korea 2010-05-25 KOREA, SOUTH Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
16823 16823 2018-12-31 Embassy of the Republic of Korea 2012-02-15 KOREA, SOUTH Nickles Group, LLC 6089 2012-02-15 Nickles Group, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
16851 16851 2019-12-31 Embassy of the Republic of Korea 2016-08-23 KOREA, SOUTH Holland & Knight 3718 1985-08-07 Holland & Knight 2450 Massachusetts Avenue, NW   Washington DC 20008
16923 16923 2022-12-31 Embassy of the Republic of Korea 2018-06-26 KOREA, SOUTH BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2450 Massachusetts Avenue, 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])
);