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

35 rows where 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, Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)

Registrant_Name >30

  • Akin, Gump, Strauss, Hauer & Feld, LLP 2
  • BGR Government Affairs, LLC 2
  • Singer Bonjean Strategies 2
  • West Wing Writers, LLC 2
  • Arent Fox, LLP 1
  • Brownstein Hyatt Farber Schreck, LLP 1
  • Colby, William E. 1
  • Cornerstone Government Affairs 1
  • Cornerstone Government Affairs, LLC 1
  • Daniel J. Edelman, Inc. 1
  • FGS Global (US) LLC (FKA FGH Holdings LLC) 1
  • Finn Partners, Inc. 1
  • Gilbert Jonas Company, Inc. 1
  • Harbinger Strategies, LLC 1
  • Holland & Knight 1
  • International Technology and Trade Associates, Inc. (ITTA) 1
  • Kasowitz, Benson, Torres and Friedman, LLP 1
  • Nelson Mullins Riley & Scarborough, LLP 1
  • Nickles Group, LLC 1
  • Paul, Weiss, Rifkind, Wharton & Garrison 1
  • RJI Government Strategies 1
  • Ragan & Mason 1
  • Rokk Solutions, LLC 1
  • Ruder Finn, Inc. 1
  • Sandler, Travis & Rosenberg, P.A. 1
  • Scribe Strategies & Advisors 1
  • Squire Patton Boggs, LLP 1
  • Thomas Capitol Partners, Inc. 1
  • Tucker & Associates 1
  • TwinLogic Strategies, LLP 1
  • …

City 2

  • Washington 28
  • - 7

State 1

  • DC · 35 ✖

Foreign_Principal 1

  • Embassy of the Republic of Korea · 35 ✖

Country/Location_Represented 1

  • KOREA, SOUTH 35
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
985 985 2000-01-01 Embassy of the Republic of Korea 1995-02-28 KOREA, SOUTH Paul, Weiss, Rifkind, Wharton & Garrison 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison Washington     DC  
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
3407 3407 1995-03-03 Embassy of the Republic of Korea 1992-02-05 KOREA, SOUTH Washington International Group, Inc. 3320 1982-01-05 Washington International Group, Inc. Washington     DC  
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
4113 4113 1977-03-28 Embassy of the Republic of Korea 1977-03-01 KOREA, SOUTH Ragan & Mason 1678 1964-01-03 Ragan & Mason Washington     DC  
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
7629 7629 1967-06-06 Embassy of the Republic of Korea 1965-06-09 KOREA, SOUTH Gilbert Jonas Company, Inc. 1900 1965-06-09 Gilbert Jonas Company, Inc. Washington     DC  
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
11815 11815 1987-09-25 Embassy of the Republic of Korea 1987-11-09 KOREA, SOUTH Colby, William E. 3957 1987-04-07 Colby, William E. Washington     DC  
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
12855 12855 1989-10-19 Embassy of the Republic of Korea 1989-09-27 KOREA, SOUTH Tucker & Associates 4292 1989-09-14 Tucker & Associates Washington     DC  
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
16496 16496 2001-12-31 Embassy of the Republic of Korea 2001-09-10 KOREA, SOUTH International Technology and Trade Associates, Inc. (ITTA) 5458 2001-09-10 International Technology and Trade Associates, Inc. (ITTA) 2450 Massachusetts Avenue N.W. 20008     DC  
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])
);
Powered by Datasette · Queries took 330.414ms · 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