FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where City = "Seoul" and Country/Location_Represented = "KOREA, SOUTH"
This data as json, CSV (advanced)
Registrant_Name 7
Foreign_Principal 5
State 1
- - 7
Country/Location_Represented 1
- KOREA, SOUTH · 7 ✖
City 1
- Seoul · 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5388 | 5388 | 2008-04-18 | Korea International Trade Association | 2007-03-07 | KOREA, SOUTH | Vinson & Elkins, LLP 5797 | 2007-03-07 | Vinson & Elkins, LLP | 159-1, Samsung-dong Gangnam-gu 135-729 | Seoul | |||
6634 | 6634 | 2005-05-17 | e-KBS Co., Ltd. | 2005-05-17 | KOREA, SOUTH | KBS America, Inc. 5684 | 2005-05-17 | KBS America, Inc. | 18 Yoido-dong, Youngdeungpo-ku | Seoul | |||
12590 | 12590 | 2022-10-10 | Corporate Association of the Gaesong Industrial Complex (CAGIC) at the direction of South Korean consultancy HC & Sons LLC (HC & Sons) | 2021-07-21 | KOREA, SOUTH | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Suite 706 Kbiz Bldg. | 30 Eunhaeng-ro Yeongdeungpo-gu | Seoul | ||
13457 | 13457 | 2011-10-31 | Government of the Republic of Korea, Embassy | 2010-03-22 | KOREA, SOUTH | Fratelli Group 5867 | 2008-06-03 | Fratelli Group | 37 Sejongno, Jongno-gu | Seoul | |||
15506 | 15506 | 2009-12-30 | Korea International Trade Association | 2007-03-26 | KOREA, SOUTH | Scribe Strategies & Advisors 5673 | 2005-03-07 | Scribe Strategies & Advisors | World Trade Center Building | 159-1 Samsung-dong, Kangnam-ku | Seoul | ||
16640 | 16640 | 2008-12-31 | Korea International Trade Association | 2006-10-16 | KOREA, SOUTH | Fierce, Isakowitz & Blalock 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 | ||
16661 | 16661 | 2009-12-31 | Government of the Republic of Korea | 2009-02-23 | KOREA, SOUTH | Squire Patton Boggs, LLP 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]) );