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

10 rows where City = "Seoul"

Search:

descending

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
383	383		Korean Broadcasting System through e-KBS Co., Ltd.	2005-05-17	KOREA, SOUTH	5684 5684	2005-05-17	KBS America, Inc.	18 Yoido-dong, Youngdeungpo-ku		Seoul
384	384		Korean Cultural Heritage Administration through the Overseas Korean Cultural Heritage Foundation	2016-12-01	KOREA, SOUTH	6397 6397	2016-12-01	Overseas Korean Cultural Heritage Foundation, USA	Wise Tower, 19th Floor, 17 Sejong-daero, Joong-gu		Seoul
1362	1362	2009-01-22	Grand National (Hannara) Party of the Republic of Korea	2008-08-20	KOREA, SOUTH	5880 5880	2008-08-20	Gateway Consulting, LLC	Yeomchang-dong 274-17, Gangseo-gu,		Seoul
2992	2992	2012-02-29	Korea International Trade Association (KITA)	2009-02-23	KOREA, SOUTH	5909 5909	2009-02-23	Winston & Strawn, LLP	159-1 Samsung-dong	Gangnam-gu, 135-729	Seoul
5106	5106	2008-04-18	Korea International Trade Association	2007-03-07	KOREA, SOUTH	5797 5797	2007-03-07	Vinson & Elkins, LLP	159-1, Samsung-dong Gangnam-gu 135-729		Seoul
6300	6300	2005-05-17	e-KBS Co., Ltd.	2005-05-17	KOREA, SOUTH	5684 5684	2005-05-17	KBS America, Inc.	18 Yoido-dong, Youngdeungpo-ku		Seoul
12865	12865	2011-10-31	Government of the Republic of Korea, Embassy	2010-03-22	KOREA, SOUTH	5867 5867	2008-06-03	Fratelli Group	37 Sejongno, Jongno-gu		Seoul
14834	14834	2009-12-30	Korea International Trade Association	2007-03-26	KOREA, SOUTH	5673 5673	2005-03-07	Scribe Strategies & Advisors	World Trade Center Building	159-1 Samsung-dong, Kangnam-ku	Seoul
15968	15968	2008-12-31	Korea International Trade Association	2006-10-16	KOREA, SOUTH	5654 5654	2004-10-29	Fierce, Isakowitz & Blalock	KITA, Attn: Team Leader (America's Team)	Trade Tower, World Trade Center 159-1 Samsung-dong, Kangnam-gu	Seoul
15989	15989	2009-12-31	Government of the Republic of Korea	2009-02-23	KOREA, SOUTH	2165 2165	1969-10-09	Squire Patton Boggs, LLP	Blue House, #1, Cheongwadae-ro, Jongno-gu		Seoul

Advanced export

JSON shape: default, array, newline-delimited

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