FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Country/Location_Represented = "KOREA, SOUTH" and Foreign_Principal = "Korea Trade Promotion Corporation"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 13
- Culver International, Inc. 1
- International Public Relations Company, Ltd. 1
- Korea Machinery Corporation 1
- Korea Trade Center, Chicago 1
- Korea Trade Center, Dallas 1
- Korea Trade Center, Detroit 1
- Korea Trade Center, Los Angeles 1
- Korea Trade Center, Miami 1
- Korea Trade Center, New Orleans 1
- Korea Trade Center, San Francisco 1
- Korea Trade Promotion Center, San Juan 1
- Korea Trade Promotion Corporation, Atlanta 1
- Korea Trade Promotion Office, Denver 1
State 1
- - 13
Foreign_Principal 1
- Korea Trade Promotion Corporation · 13 ✖
Country/Location_Represented 1
- KOREA, SOUTH · 13 ✖
City 1
- - 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1126 | 1126 | 1985-01-07 | Korea Trade Promotion Corporation | 1976-02-13 | KOREA, SOUTH | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | Seoul | ||||
2700 | 2700 | 1982-02-22 | Korea Trade Promotion Corporation | 1975-01-10 | KOREA, SOUTH | Korea Trade Promotion Center, San Juan 2552 | 1975-01-10 | Korea Trade Promotion Center, San Juan | Seoul | ||||
5487 | 5487 | 1985-04-23 | Korea Trade Promotion Corporation | 1979-04-24 | KOREA, SOUTH | Korea Trade Center, Detroit 3016 | 1979-05-04 | Korea Trade Center, Detroit | Seoul | ||||
5805 | 5805 | 1975-04-30 | Korea Trade Promotion Corporation | 1974-01-30 | KOREA, SOUTH | Korea Trade Promotion Corporation, Atlanta 2491 | 1974-01-30 | Korea Trade Promotion Corporation, Atlanta | Seoul | ||||
6157 | 6157 | 1975-05-01 | Korea Trade Promotion Corporation | 1973-10-12 | KOREA, SOUTH | Culver International, Inc. 2466 | 1973-10-12 | Culver International, Inc. | Seoul | ||||
6557 | 6557 | 1985-05-15 | Korea Trade Promotion Corporation | 1982-02-24 | KOREA, SOUTH | Korea Machinery Corporation 3335 | 1982-02-24 | Korea Machinery Corporation | |||||
7484 | 7484 | 1975-06-02 | Korea Trade Promotion Corporation | 1974-02-28 | KOREA, SOUTH | Korea Trade Promotion Office, Denver 2499 | 1974-02-28 | Korea Trade Promotion Office, Denver | Seoul | ||||
9307 | 9307 | 1996-07-16 | Korea Trade Promotion Corporation | 1976-01-16 | KOREA, SOUTH | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | Seoul | ||||
10808 | 10808 | 1996-08-28 | Korea Trade Promotion Corporation | 1977-02-28 | KOREA, SOUTH | Korea Trade Center, Miami 2758 | 1977-02-28 | Korea Trade Center, Miami | Seoul | ||||
11221 | 11221 | 1967-09-01 | Korea Trade Promotion Corporation | 1967-10-02 | KOREA, SOUTH | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | |||||
15917 | 15917 | 1984-12-31 | Korea Trade Promotion Corporation | 1979-04-02 | KOREA, SOUTH | Korea Trade Center, New Orleans 3010 | 1979-04-02 | Korea Trade Center, New Orleans | Seoul | ||||
16394 | 16394 | 1996-12-31 | Korea Trade Promotion Corporation | 1975-12-19 | KOREA, SOUTH | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | Seoul | ||||
16395 | 16395 | 1996-12-31 | Korea Trade Promotion Corporation | 1975-12-31 | KOREA, SOUTH | Korea Trade Center, Chicago 2648 | 1975-12-31 | Korea Trade Center, Chicago | 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]) );