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

11 rows where Foreign_Principal = "Republic of Korea"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 2

Foreign_Principal 1

  • Republic of Korea · 11 ✖

Country/Location_Represented 1

City 1

  • - 11
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
1423 1423 1961-01-20 Republic of Korea 1959-01-23 KOREA, SOUTH Chapman, DiSalle & Friedman 867 1955-01-21 Chapman, DiSalle & Friedman Seoul        
2020 2020 1986-02-01 Republic of Korea 1983-04-20 KOREA, SOUTH Baron/Canning & Company, Inc. 2270 1971-07-23 Baron/Canning & Company, Inc. Seoul        
5572 5572 1968-04-25 Republic of Korea 1968-04-25 KOREA, SOUTH Associated Public Relations Counselors, Inc. 2090 1968-04-25 Associated Public Relations Counselors, Inc. Seoul        
5770 5770 1951-04-30 Republic of Korea 1951-03-15 KOREA, SOUTH McNutt, Paul V. 664 1951-03-15 McNutt, Paul V. Washington     DC  
7381 7381 1982-06-01 Republic of Korea 1981-09-23 KOREA, SOUTH Bershtein, David A. 3277 1981-09-23 Bershtein, David A. Seoul        
7670 7670 1982-06-08 Republic of Korea 1981-02-11 KOREA, SOUTH Wagner & Baroody, Inc. 3198 1981-02-11 Wagner & Baroody, Inc.          
12631 12631 1987-10-12 Republic of Korea 1986-04-23 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       DC  
12885 12885 1955-10-21 Republic of Korea 1955-06-27 KOREA, SOUTH Universal Public Relations 898 1955-06-27 Universal Public Relations Seoul        
14636 14636 1972-12-01 Republic of Korea 1972-10-17 KOREA, SOUTH Smith. E. Del 2385 1972-10-17 Smith. E. Del Washington     DC  
15197 15197 1963-12-18 Republic of Korea 1963-01-11 KOREA, SOUTH Foreign Research & Development Corporation 1589 1963-01-11 Foreign Research & Development Corporation Seoul        
16020 16020 1987-12-31 Republic of Korea 1984-01-31 KOREA, SOUTH Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC          

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])
);