FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where Address_1 = "New York", Country/Location_Represented = "KOREA, SOUTH" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 11
Foreign_Principal 10
- Jiewon Park 2
- Ambassador Soo Young Lee (Republic of Korea Delegation to the United Nations) 1
- Honorable Ben C. Limb 1
- Korea National Tourism Corporation, New York 1
- Korea Trade Promotion Center 1
- Korean Overseas Information Service thru Korean Cultural Service 1
- Korean Trade Promotion Center 1
- Korean Traders' Association 1
- Poongsan Metal America Corporation 1
- Republic of Korea Observer Mission to the United Nations 1
State 1
- NY · 11 ✖
Country/Location_Represented 1
- KOREA, SOUTH · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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
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]) );