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

21 rows where Country/Location_Represented = "KOREA, SOUTH" and State = "NY"

✖
✖
✖

✎ 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)

Foreign_Principal 20

  • Jiewon Park 2
  • Ambassador Soo Young Lee (Republic of Korea Delegation to the United Nations) 1
  • Government of South Korea 1
  • Honorable Ben C. Limb 1
  • Korea International Trade Association 1
  • Korea International Trade Association, Inc. 1
  • Korea National Tourism Corporation 1
  • Korea National Tourism Corporation, New York 1
  • Korea Trade Promotion Center 1
  • Korea Trade and Investment Promotion Agency (KOTRA) 1
  • Korea Trade-Investment Promotion Agency 1
  • Korea Trade-Investment Promotion Agency (KOTRA) 1
  • Korea Trade-lnvestment Promotion Agency (KOTRA) 1
  • Korean Cultural Service 1
  • Korean Overseas Information Service thru Korean Cultural Service 1
  • Korean Trade Promotion Center 1
  • Korean Traders' Association 1
  • Poongsan Metal America Corporation 1
  • Postal Savings and Insurance Development Institute (POSID) 1
  • Republic of Korea Observer Mission to the United Nations 1

Registrant_Name 16

  • KWR International, Inc. 4
  • K&L Gates, LLP 2
  • North American Precis Syndicate 2
  • Alcalde & Fay 1
  • David E. Morey 1
  • Finn Partners, Inc. 1
  • Freshman, C. Arnold 1
  • Gowran International, Ltd. 1
  • Hill & Knowlton, Inc. 1
  • Jack Raymond & Company, Inc. 1
  • John C. Metcalfe & Associates, Inc. 1
  • MacVane, John 1
  • Mario Trombone Associates, Inc. 1
  • Oliver, Robert T. 1
  • Public Service Audience Planners 1
  • Solter, Myron W. 1

City 2

  • - 15
  • New York 6

State 1

  • NY · 21 ✖

Country/Location_Represented 1

  • KOREA, SOUTH · 21 ✖
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
3710 3710 1985-03-14 Korean Cultural Service 1985-03-14 KOREA, SOUTH Jack Raymond & Company, Inc. 3659 1985-03-14 Jack Raymond & Company, Inc.       NY  
4136 4136 1965-03-29 Korea Trade Promotion Center 1964-04-28 KOREA, SOUTH Mario Trombone Associates, Inc. 1719 1964-04-28 Mario Trombone Associates, Inc. New York     NY  
4354 4354 1976-03-31 Korean Traders' Association 1975-04-07 KOREA, SOUTH Hill & Knowlton, Inc. 2574 1975-04-07 Hill & Knowlton, Inc. New York     NY  
5237 5237 2017-04-12 Korea International Trade Association, Inc. 2017-01-23 KOREA, SOUTH K&L Gates, LLP 6331 2015-12-18 K&L Gates, LLP 460 Park Avenue   New York NY 10022
6041 6041 2008-04-30 Korea Trade-Investment Promotion Agency 2008-04-07 KOREA, SOUTH KWR International, Inc. 5119 1996-07-02 KWR International, Inc. 460 Park Avenue   New York NY 10023
7254 7254 2015-05-31 Korea International Trade Association 2015-04-15 KOREA, SOUTH Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 460 Park Avenue, 4th Floor   New York NY 10022
7495 7495 1993-06-02 Jiewon Park 1992-01-30 KOREA, SOUTH Gowran International, Ltd. 4417 1990-10-03 Gowran International, Ltd. New York     NY  
8940 8940 2017-07-01 Postal Savings and Insurance Development Institute (POSID) 2015-12-18 KOREA, SOUTH K&L Gates, LLP 6331 2015-12-18 K&L Gates, LLP 150 East 52nd Street 7th Floor New York NY 10024
9469 9469 1999-07-25 Korean Overseas Information Service thru Korean Cultural Service 1999-06-29 KOREA, SOUTH Alcalde & Fay 5317 1999-06-29 Alcalde & Fay New York     NY  
9514 9514 1959-07-27 Honorable Ben C. Limb 1957-10-10 KOREA, SOUTH John C. Metcalfe & Associates, Inc. 838 1954-07-27 John C. Metcalfe & Associates, Inc. New York     NY  
9866 9866 2006-07-31 Korea Trade-Investment Promotion Agency (KOTRA) 2006-06-28 KOREA, SOUTH KWR International, Inc. 5119 1996-07-02 KWR International, Inc. 460 Park Avenue   New York NY 10022
10732 10732 1980-08-25 Poongsan Metal America Corporation 1978-08-15 KOREA, SOUTH Freshman, C. Arnold 2946 1978-08-15 Freshman, C. Arnold New York     NY  
11333 11333 1988-09-02 Korean Trade Promotion Center 1969-05-09 KOREA, SOUTH Solter, Myron W. 1970 1966-03-22 Solter, Myron W. New York     NY  
12628 12628 1987-10-12 Government of South Korea 1987-05-01 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
12629 12629 1987-10-12 Korea National Tourism Corporation 1982-07-16 KOREA, SOUTH North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
12765 12765 1980-10-16 Republic of Korea Observer Mission to the United Nations 1980-07-03 KOREA, SOUTH MacVane, John 3121 1980-07-03 MacVane, John New York     NY  
14061 14061 2002-11-18 Korea Trade and Investment Promotion Agency (KOTRA) 2002-11-06 KOREA, SOUTH KWR International, Inc. 5119 1996-07-02 KWR International, Inc. 460 Park Avenue New York 10022     NY  
14088 14088 1962-11-20 Ambassador Soo Young Lee (Republic of Korea Delegation to the United Nations) 1961-11-24 KOREA, SOUTH Oliver, Robert T. 1493 1961-11-24 Oliver, Robert T. New York     NY  
15271 15271 2007-12-20 Korea Trade-lnvestment Promotion Agency (KOTRA) 2007-12-06 KOREA, SOUTH KWR International, Inc. 5119 1996-07-02 KWR International, Inc. 460 Park Avenue   New York NY 10022
15937 15937 1985-12-31 Korea National Tourism Corporation, New York 1976-09-27 KOREA, SOUTH Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
16237 16237 1992-12-31 Jiewon Park 1992-07-09 KOREA, SOUTH David E. Morey 4688 1992-07-09 David E. Morey New York     NY  

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 303.418ms · 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