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

37 rows where Foreign_Principal = "Embassy of the Republic of Korea"

View and edit SQL

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

State

City

Foreign_Principal

  • Embassy of the Republic of Korea · 37

Country/Location_Represented

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
186   Embassy of the Republic of Korea 2018-01-10 KOREA, SOUTH 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
187   Embassy of the Republic of Korea 2019-01-10 KOREA, SOUTH 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
188   Embassy of the Republic of Korea 2017-01-20 KOREA, SOUTH 6401 6401 2017-01-20 Cornerstone Government Affairs 2450 Massachusetts Avenue, NW   Washington DC 20008
189   Embassy of the Republic of Korea 2010-03-22 KOREA, SOUTH 5982 5982 2010-03-22 Thomas Capitol Partners, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
190   Embassy of the Republic of Korea 2018-06-26 KOREA, SOUTH 5430 5430 2001-05-10 BGR Government Affairs, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
191   Embassy of the Republic of Korea 2016-08-23 KOREA, SOUTH 3718 3718 1985-08-07 Holland & Knight 2450 Massachusetts Avenue, NW   Washington DC 20008
192   Embassy of the Republic of Korea 2019-12-30 KOREA, SOUTH 5044 5044 1995-09-13 Reed, T. Dean          
926 2000-01-01 Embassy of the Republic of Korea 1995-02-28 KOREA, SOUTH 4539 4539 1991-07-09 Paul, Weiss, Rifkind, Wharton & Garrison Washington     DC  
970 2017-01-01 Embassy of the Republic of Korea 2015-02-08 KOREA, SOUTH 6276 6276 2015-02-08 TwinLogic Strategies, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
3158 2014-03-01 Embassy of the Republic of Korea 2012-01-06 KOREA, SOUTH 1481 1481 1961-09-27 Ruder Finn, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
3210 1995-03-03 Embassy of the Republic of Korea 1992-02-05 KOREA, SOUTH 3320 3320 1982-01-05 Washington International Group, Inc. Washington     DC  
3571 2010-03-15 Embassy of the Republic of Korea 2008-09-22 KOREA, SOUTH 5882 5882 2008-09-22 Arent Fox, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
3887 1977-03-28 Embassy of the Republic of Korea 1977-03-01 KOREA, SOUTH 1678 1678 1964-01-03 Ragan & Mason Washington     DC  
4694 2018-04-01 Embassy of the Republic of Korea 2015-09-29 KOREA, SOUTH 6320 6320 2015-09-29 Rokk Solutions, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
7224 1967-06-06 Embassy of the Republic of Korea 1965-06-09 KOREA, SOUTH 1900 1900 1965-06-09 Gilbert Jonas Company, Inc. Washington     DC  
8238 2007-06-30 Embassy of the Republic of Korea 2006-05-26 KOREA, SOUTH 5303 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. 2450 Massachusetts Avenue, N.W.   Washington DC 20008
9268 1988-07-31 Embassy of the Republic of Korea 1980-04-01 KOREA, SOUTH 3097 3097 1980-04-01 Hess, Clyde Gardner          
11250 1987-09-25 Embassy of the Republic of Korea 1987-11-09 KOREA, SOUTH 3957 3957 1987-04-07 Colby, William E. Washington     DC  
11599 2007-09-30 Embassy of the Republic of Korea 2006-06-28 KOREA, SOUTH 5671 5671 2005-03-01 RJI Government Strategies 2450 Massachusetts Avenue, NW   Washington DC 20008
12212 1989-10-19 Embassy of the Republic of Korea 1989-09-27 KOREA, SOUTH 4292 4292 1989-09-14 Tucker & Associates Washington     DC  
12795 2011-10-31 Embassy of the Republic of Korea 2011-10-19 KOREA, SOUTH 6072 6072 2011-10-19 West Wing Writers, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008-2850
13523 1993-11-24 Embassy of the Republic of Korea 1993-06-17 KOREA, SOUTH 2469 2469 1973-10-23 Burson-Marsteller Washington, DC        
14173 2014-12-08 Embassy of the Republic of Korea 2014-04-16 KOREA, SOUTH 6216 6216 2014-04-16 Singer Bonjean Strategies 2450 Massachusetts Avenue, NW   Washington DC 20008
14747 2009-12-30 Embassy of the Republic of Korea 2005-10-14 KOREA, SOUTH 5673 5673 2005-03-07 Scribe Strategies & Advisors 2450 Massachusetts Avenue, NW   Washington DC 20008
15738 2001-12-31 Embassy of the Republic of Korea 2001-09-10 KOREA, SOUTH 5458 5458 2001-09-10 International Technology and Trade Associates, Inc. (ITTA) 2450 Massachusetts Avenue N.W. 20008     DC  
15873 2008-12-31 Embassy of the Republic of Korea 2007-06-18 KOREA, SOUTH 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
15934 2011-12-31 Embassy of the Republic of Korea 2010-09-20 KOREA, SOUTH 5666 5666 2005-01-31 Glover Park Group, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
15935 2011-12-31 Embassy of the Republic of Korea 2010-09-24 KOREA, SOUTH 3634 3634 1984-11-15 Daniel J. Edelman, Inc. 2450 Massachusetts Avenue, NW   Washington DC 20008
15949 2012-12-31 Embassy of the Republic of Korea 2010-09-21 KOREA, SOUTH 6001 6001 2010-09-21 Singer Bonjean Strategies 2450 Massachusetts Avenue, NW   Washington DC 20008
15972 2013-12-31 Embassy of the Republic of Korea 2012-06-06 KOREA, SOUTH 6107 6107 2012-06-06 West Wing Writers, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008-2850
15985 2014-12-31 Embassy of the Republic of Korea 2014-03-07 KOREA, SOUTH 6211 6211 2014-03-07 Cornerstone Government Affairs, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
15986 2014-12-31 Embassy of the Republic of Korea 2014-09-09 KOREA, SOUTH 6197 6197 2013-11-19 Kasowitz, Benson, Torres and Friedman, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
16021 2016-12-31 Embassy of the Republic of Korea 2015-02-04 KOREA, SOUTH 6275 6275 2015-02-04 Harbinger Strategies, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
16022 2016-12-31 Embassy of the Republic of Korea 2014-03-10 KOREA, SOUTH 6212 6212 2014-03-10 Finn Partners, Inc. 2450 Massachusetts Avenue, NW   Washington DC  
16023 2016-12-31 Embassy of the Republic of Korea 2015-04-17 KOREA, SOUTH 5430 5430 2001-05-10 BGR Government Affairs, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008
16041 2017-12-31 Embassy of the Republic of Korea 2010-05-25 KOREA, SOUTH 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2450 Massachusetts Avenue, NW   Washington DC 20008
16062 2018-12-31 Embassy of the Republic of Korea 2012-02-15 KOREA, SOUTH 6089 6089 2012-02-15 Nickles Group, 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 · Query took 132.294ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history