FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
187 rows where Country/Location_Represented = "TURKEY"
This data as json, CSV (advanced)
Registrant_Name >30
- Finn Partners, Inc. 3
- North American Precis Syndicate 3
- APCO Worldwide, Inc. 2
- Arnold & Porter Kaye Scholer LLP 2
- Ballard Partners 2
- Greenberg Traurig, LLP 2
- Gur, Nazmi 2
- Hill and Knowlton Strategies, LLC 2
- Mercer & Associates, Inc. 2
- Modern Education Services, Inc. 2
- 30 Point Strategies, LLC 1
- 5W Public Relations, LLC 1
- APCO Associates 1
- Abernathy/MacGregor Group, Inc. 1
- Advanced Advocacy, LLC 1
- Alpaytac, Inc. 1
- Association Films, Inc. 1
- Avenue Strategies, LLC 1
- BCW LLC 1
- Baytan, Ihsan 1
- Belvedere Strategies 1
- C/R International, L.L.C. 1
- Capitol Counsel, LLC 1
- Capitoline/MS&L 1
- DCS Group 1
- Danovitch, Sylvia Eisner 1
- Daschle Group, LLC 1
- Doremus & Company 1
- Dudley, Henry A. 1
- Durak, Ahmet Unal 1
- …
Foreign_Principal >30
- Republic of Turkey 7
- Embassy of the Republic of Turkey 4
- Republic of Turkey, Embassy 4
- Embassy of Turkey 3
- Government of Turkey, Embassy 3
- Republic of Turkey through Amsterdam & Partners, LLP 3
- Turkish Tourism & Information Office 3
- Government of Turkey 2
- Government of the Republic of Turkey, Embassy 2
- Ministry of Culture and Tourism of Turkey 2
- Profilo Holding, A.S. 2
- Ali Arslan, MP 1
- BDP (Peace and Democracy Party) 1
- DTP (Democratic Society Party) 1
- Embassy of Republic of Turkey thru Gephardt Group Government Affairs 1
- Embassy of the Republic of Turkey (through Fleishman-Hillard) 1
- GCI Group for the Quincentennial Foundation of Istanbul 1
- Genc Parti Genel Merkezy 1
- Genc Siviller Associaton 1
- Government of Turkey, Embassy through DLA Piper, LLP 1
- Government of Turkey, Embassy, through the Livingston Group, LLC 1
- Greenberg Traurig, LLP on behalf of the Republic of Turkey 1
- Inovo BV 1
- Inovo BV through Flynn Intel Group, Inc. 1
- Interbank Anonim Sirketi 1
- Istanbul Iron and Steel Exporters Association 1
- Ministry of Foreign Affairs, Government of Turkey 1
- Ministry of Tourism of Republic of Turkey 1
- Mouhammad Zaher Badaraany 1
- Office of the Prime Minister Mesut Yilmaz - Republic of Turkey 1
- …
City 5
- - 55
- Washington 19
- New York 3
- Ankara 2
- Istanbul 1
Country/Location_Represented 1
- TURKEY · 80 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11016 | 11016 | 1991-08-31 | Profilo Holding, A.S. | 1985-12-18 | TURKEY | APCO Associates 3597 | 1984-06-20 | APCO Associates | Istanbul | ||||
11059 | 11059 | 1998-08-31 | Government of the Republic of Turkey, Embassy | 1998-08-17 | TURKEY | People's Revolutionary Party 5271 | 1998-08-17 | People's Revolutionary Party | Washington | DC | |||
11116 | 11116 | 2007-08-31 | Government of Turkey, Embassy | 2000-02-16 | TURKEY | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 2525 Massachusetts Avenue, N.W. 20008 | DC | |||
11143 | 11143 | 2011-08-31 | Istanbul Iron and Steel Exporters Association | 2010-05-24 | TURKEY | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 34197 Yenibosna Bahcelievler | Istanbul | |||
11227 | 11227 | 1976-09-01 | Turkish Industrialists & Businessmen Association | 1976-03-05 | TURKEY | Gray, Kenneth J. 2665 | 1976-03-05 | Gray, Kenneth J. | Istanbul | ||||
11238 | 11238 | 1981-09-01 | Republic of Turkey | 1975-09-11 | TURKEY | Dudley, Henry A. 2607 | 1975-09-11 | Dudley, Henry A. | Washington | DC | |||
11283 | 11283 | 1994-09-01 | Embassy of the Republic of Turkey | 1990-01-18 | TURKEY | Washington Group 4332 | 1990-01-18 | Washington Group | Washington | DC | |||
11302 | 11302 | 2007-09-01 | Government of Turkey, Embassy, through the Livingston Group, LLC | 2000-02-14 | TURKEY | Solarz Associates 5358 | 2000-02-14 | Solarz Associates | 2525 Massachusetts Avenue, N.W. 20008 | DC | |||
11404 | 11404 | 1976-09-07 | Turkish Airlines, Inc. | 1975-08-21 | TURKEY | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Istanbul | ||||
11517 | 11517 | 2015-09-11 | iFilm Media Group | 2015-09-11 | TURKEY | Grieboski Global Strategies, LLC 6315 | 2015-09-08 | Grieboski Global Strategies, LLC | Mahmutbey Mah. ISTOC - C Plaza 1. Kat D:8 | Bagcilar, Istanbul | |||
11569 | 11569 | 1994-09-13 | Penajans/DMB & B Ticaret, A.S. Aysegul Dora, Chairman | 1993-05-04 | TURKEY | Manning, Selvage & Lee 4684 | 1992-06-10 | Manning, Selvage & Lee | Istanbul | ||||
11661 | 11661 | 2006-09-15 | Genc Parti Genel Merkezy | 2006-03-07 | TURKEY | IEP Advisors, LLP 5735 | 2006-03-07 | IEP Advisors, LLP | Ankara | ||||
11689 | 11689 | 2015-09-17 | Undersecretariat for Defense Industry (SSM) Turkish Ministry of National Defense) | 2012-12-12 | TURKEY | Ozbek, Ferah 6145 | 2012-12-12 | Ozbek, Ferah | |||||
11822 | 11822 | 2015-09-25 | Turk Hava Yollari, A.O. (Turkish Airlines) | 2015-05-21 | TURKEY | Golin/Harris International, Inc. 6296 | 2015-05-21 | Golin/Harris International, Inc. | 350 Fifth Avenue, Suite 7510 | New York | NY | 10118 | |
11837 | 11837 | 1985-09-26 | Republic of Turkey | 1980-09-26 | TURKEY | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | Ankara | ||||
12088 | 12088 | 1997-09-30 | Office of the Prime Minister, Republic of Turkey | 1994-12-01 | TURKEY | Abernathy/MacGregor Group, Inc. 4834 | 1992-12-11 | Abernathy/MacGregor Group, Inc. | Ankara | ||||
12249 | 12249 | 2018-09-30 | Republic of Turkey through Amsterdam & Partners LLP | 2017-03-10 | TURKEY | Advanced Advocacy, LLC 6407 | 2017-03-10 | Advanced Advocacy, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
12263 | 12263 | 2021-09-30 | People's Democracy Party (HDP) | 2017-09-09 | TURKEY | Ozcan, Giran 6460 | 2017-09-09 | Ozcan, Giran | Barbaros Mh. Tahran Cd. Buklum Sk. No: 117 Kavaklidere/Cankaya | ANKARA | |||
12419 | 12419 | 2013-10-01 | Embassy of the Republic of Turkey (through Fleishman-Hillard) | 2009-10-30 | TURKEY | 30 Point Strategies, LLC 5884 | 2008-10-06 | 30 Point Strategies, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
12471 | 12471 | 1994-10-04 | Turkish Ministry of Tourism | 1992-06-08 | TURKEY | Henry J. Kaufman & Associates, Inc. 4093 | 1988-02-19 | Henry J. Kaufman & Associates, Inc. | Washington | DC | |||
12600 | 12600 | 1984-10-11 | Turkish Tourism & Information Office | 1983-05-04 | TURKEY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12650 | 12650 | 2016-10-13 | Republic of Turkey through Amsterdam & Partners, LLP | 2016-06-03 | TURKEY | Signal Group Consulting, LLC 6297 | 2015-06-02 | Signal Group Consulting, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
12734 | 12734 | 2014-10-15 | Genc Siviller Associaton | 2014-09-30 | TURKEY | Alpaytac, Inc. 6224 | 2014-05-23 | Alpaytac, Inc. | Istiklal Cd. Abdullah Sk. Zafer Apt. No:3 Daire:7 | Taksim/Istanbul | |||
12782 | 12782 | 2019-10-16 | Turkiye Halk Bankasi Anonim Sirketi (Halkbank, Inc.) | 2017-08-28 | TURKEY | Ballard Partners 6415 | 2017-04-05 | Ballard Partners | Barbaros Mahellesi Sebboy Sokak No:4 Atasehir | ||||
12798 | 12798 | 1987-10-17 | Government of Turkey | 1986-11-16 | TURKEY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
12965 | 12965 | 2020-10-23 | Embassy of the Republic of Turkey | 2018-05-04 | TURKEY | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
13086 | 13086 | 2020-10-27 | Republic of Turkey | 2014-08-12 | TURKEY | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
13142 | 13142 | 2017-10-29 | Republic of Turkey through Amsterdam & Partners, LLP | 2017-05-25 | TURKEY | 5W Public Relations, LLC 6434 | 2017-05-25 | 5W Public Relations, LLC | 601 13th Street, NW | 11th Floor South | Washington | DC | 20005 |
13147 | 13147 | 2020-10-29 | Turkish Aerospace | 2020-07-24 | TURKEY | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | Fethiye Mahallesi, Havaclhk Bulvan, No:17, | Kahramankazan, 06800, Ankara, | |||
13336 | 13336 | 1994-10-31 | Turkish Ministry of Tourism & Information | 1991-06-04 | TURKEY | Merkley Newman Harty 4525 | 1991-06-04 | Merkley Newman Harty | New York | NY | |||
13370 | 13370 | 1997-10-31 | Republic of Turkey | 1992-01-31 | TURKEY | Capitoline/MS&L 4529 | 1991-06-20 | Capitoline/MS&L | Washington | DC | |||
13485 | 13485 | 2017-10-31 | Republic of Turkey through Amsterdam & Partners, LLP | 2017-04-28 | TURKEY | Gonzalez, Jason Brent 6424 | 2017-04-28 | Gonzalez, Jason Brent | The Homer Building | 601 13th Street, NW 11th Floor South | Washington | DC | 20005 |
13495 | 13495 | 2018-10-31 | Turkey-U.S. Business Council (TAIK) (through Mercury Public Affairs, LLC) | 2018-07-17 | TURKEY | Riverwood Strategies, LLC 6577 | 2018-07-17 | Riverwood Strategies, LLC | River Plaza Buyukdere No. 13/10 34394 Levent/IST | ||||
13526 | 13526 | 1959-11-01 | Government of Turkey | 1955-09-08 | TURKEY | Mintzer, George J. 908 | 1955-09-08 | Mintzer, George J. | Ankara | ||||
13614 | 13614 | 1996-11-01 | Republic of Turkey (Previously Embassy of Turkey) | 1993-10-12 | TURKEY | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Ankara | ||||
13749 | 13749 | 2020-11-05 | Greenberg Traurig, LLP on behalf of the Republic of Turkey | 2019-01-19 | TURKEY | Venable, LLP 5931 | 2009-04-17 | Venable, LLP | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
13825 | 13825 | 1988-11-08 | Embassy of Turkey | 1972-05-09 | TURKEY | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
13868 | 13868 | 1992-11-10 | GCI Group for the Quincentennial Foundation of Istanbul | 1992-07-23 | TURKEY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
13929 | 13929 | 2012-11-13 | Mouhammad Zaher Badaraany | 2012-11-13 | TURKEY | Syrian Future Movement 6143 | 2012-11-13 | Syrian Future Movement | |||||
13936 | 13936 | 1977-11-14 | Turkish Tourism & Information Office | 1973-05-10 | TURKEY | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
13970 | 13970 | 1982-11-15 | Embassy of the Republic of Turkey | 1981-07-20 | TURKEY | Jack McDonald Associates, Inc. 3038 | 1979-07-13 | Jack McDonald Associates, Inc. | Washington | DC | |||
14000 | 14000 | 2016-11-15 | Inovo BV through Flynn Intel Group, Inc. | 2017-03-07 | TURKEY | S.G.R. LLC Government Relations and Lobbying 6379 | 2016-09-20 | S.G.R. LLC Government Relations and Lobbying | INOVO BV - 27 Adireaanstraat, 3581 SC Utrecht | ||||
14001 | 14001 | 2016-11-15 | Inovo BV | 2017-03-07 | TURKEY | Flynn Intel Group, Inc. 6406 | 2017-03-07 | Flynn Intel Group, Inc. | 47 Adriaanstraat, 3581 SC Utrecht | ||||
14002 | 14002 | 2017-11-15 | Republic of Turkey on behalf of Amsterdam & Partners, LLP | 2017-09-29 | TURKEY | Stroud Communications 6471 | 2017-09-29 | Stroud Communications | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
14004 | 14004 | 2018-11-15 | Republic of Turkey | 2017-05-19 | TURKEY | Ballard Partners 6415 | 2017-04-05 | Ballard Partners | Dr. Sadik Ahmet Cad. No:8 Balgat/ANKARA 06100 | ||||
14064 | 14064 | 2010-11-18 | Government of Turkey, Embassy through DLA Piper, LLP | 2009-03-27 | TURKEY | Mercer & Associates, Inc. 5923 | 2009-03-27 | Mercer & Associates, Inc. | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
14065 | 14065 | 2010-11-18 | Government of Turkey, Embassy | 2010-11-18 | TURKEY | Mercer & Associates, Inc. 5923 | 2009-03-27 | Mercer & Associates, Inc. | |||||
14351 | 14351 | 1977-11-30 | Turkish Tourism & Information Office | 1973-07-24 | TURKEY | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | New York City | ||||
14363 | 14363 | 1984-11-30 | Embassy of Turkey | 1984-03-09 | TURKEY | Danovitch, Sylvia Eisner 3563 | 1984-03-09 | Danovitch, Sylvia Eisner | DC | ||||
14400 | 14400 | 1990-11-30 | Turkish Apparel Exporters' Association | 1990-01-31 | TURKEY | World Trade Link 4317 | 1989-11-22 | World Trade Link | Istanbul | ||||
14471 | 14471 | 1997-11-30 | Government of Turkey, Embassy | 1994-06-09 | TURKEY | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Washington | DC | |||
14480 | 14480 | 1998-11-30 | Turkish Industrialists' & Businessman's Association (TUSIAD) | 1998-11-13 | TURKEY | C/R International, L.L.C. 5117 | 1996-07-02 | C/R International, L.L.C. | Istanbul | ||||
14807 | 14807 | 1995-12-04 | Profilo Holding, A.S. | 1985-12-16 | TURKEY | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | Istanbul | ||||
14925 | 14925 | 1994-12-09 | Republic of Turkey | 1983-06-21 | TURKEY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Washington | DC | |||
15111 | 15111 | 2009-12-14 | BDP (Peace and Democracy Party) | 2010-01-14 | TURKEY | Gur, Nazmi 5955 | 2009-10-07 | Gur, Nazmi | BDP Baris Manco Cad. 32. Sk. No: 37 | Balgat-Ankara | |||
15112 | 15112 | 2009-12-14 | DTP (Democratic Society Party) | 2009-10-07 | TURKEY | Gur, Nazmi 5955 | 2009-10-07 | Gur, Nazmi | Baris Manco Cad. 37. Sk, No: 32 | BALGAT-ANKARA | Ankara | ||
15144 | 15144 | 1998-12-15 | Government of the Republic of Turkey, Embassy | 1998-08-13 | TURKEY | DCS Group 5269 | 1998-08-13 | DCS Group | Tulsa | OK | |||
15147 | 15147 | 1998-12-15 | Republic of Turkey, Embassy | 1997-10-15 | TURKEY | Strauss, Joseph A. 5214 | 1997-10-15 | Strauss, Joseph A. | Washington | DC | |||
15148 | 15148 | 1998-12-15 | Republic of Turkey, Embassy | 1997-10-15 | TURKEY | Durak, Ahmet Unal 5215 | 1997-10-15 | Durak, Ahmet Unal | Washington | DC | |||
15216 | 15216 | 2018-12-18 | Undersecretariat for Defense Industry (SSM) Turkish Ministry of National Defense | 2016-11-30 | TURKEY | Baytan, Ihsan 6395 | 2016-11-30 | Baytan, Ihsan | Inonu Bulvari, Kirazlidere Mevkii, Suleyman Emin Caddesi No: 6-7 | Bahcelievler 06100 Ankara | |||
15255 | 15255 | 1993-12-20 | Ministry of Tourism of Republic of Turkey | 1991-08-06 | TURKEY | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | Ankara | ||||
15278 | 15278 | 1955-12-21 | Turkish Information Office | 1955-12-21 | TURKEY | Sherman, Alexander 925 | 1955-12-21 | Sherman, Alexander | New York | NY | |||
16184 | 16184 | 1990-12-31 | Turkish Tourism Information Office | 1991-01-08 | TURKEY | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | New York | NY | |||
16239 | 16239 | 1992-12-31 | Quincentennial Foundation of Istanbul | 1990-02-12 | TURKEY | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | Istanbul | ||||
16263 | 16263 | 1994-12-31 | Interbank Anonim Sirketi | 1994-01-05 | TURKEY | Winston & Strawn 3869 | 1986-08-13 | Winston & Strawn | Istanbul | ||||
16423 | 16423 | 1997-12-31 | Office of the Prime Minister Mesut Yilmaz - Republic of Turkey | 1997-12-29 | TURKEY | Varney, Kevin P. 5223 | 1997-12-27 | Varney, Kevin P. | Ankara | ||||
16725 | 16725 | 2012-12-31 | Turkish Culture & Tourism Office | 2010-03-12 | TURKEY | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 821 United Nations Plaza, 4th Floor | New York | NY | 10017 | |
16774 | 16774 | 2015-12-31 | Turkish Culture and Tourist Office | 2014-03-10 | TURKEY | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 825 3rd Avenue | New York | NY | 10022 | |
16779 | 16779 | 2016-12-31 | Embassy of Republic of Turkey thru Gephardt Group Government Affairs | 2016-06-14 | TURKEY | Belvedere Strategies 6360 | 2016-06-14 | Belvedere Strategies | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16791 | 16791 | 2016-12-31 | Republic of Turkey (through Gephardt Group Government Affairs LLC) | 2015-11-19 | TURKEY | Capitol Counsel, LLC 6328 | 2015-11-19 | Capitol Counsel, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16792 | 16792 | 2016-12-31 | Republic of Turkey, Embassy | 2008-07-21 | TURKEY | Gephardt Group Government Affairs, LLC 5874 | 2008-07-21 | Gephardt Group Government Affairs, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16793 | 16793 | 2016-12-31 | Republic of Turkey, Embassy | 2016-07-29 | TURKEY | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16802 | 16802 | 2017-12-31 | Embassy of the Republic of Turkey | 2017-05-09 | TURKEY | BCW LLC 6227 | 2014-06-18 | BCW LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16813 | 16813 | 2017-12-31 | Ministry of Culture and Tourism of Turkey | 2017-10-26 | TURKEY | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | Ismet Inonu Bulvari, No: 32 | Emek, Ankara, 06100 | |||
16814 | 16814 | 2017-12-31 | Ministry of Foreign Affairs, Government of Turkey | 2017-12-21 | TURKEY | King & Spalding LLP 6501 | 2017-12-21 | King & Spalding LLP | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16831 | 16831 | 2018-12-31 | Ministry of Culture and Tourism of Turkey | 2018-10-24 | TURKEY | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | Ismet Inonu Bulvari No:32 | Emek Ankara 06100 | |||
16835 | 16835 | 2018-12-31 | Republic of Turkey through Greenberg Traurig | 2017-01-18 | TURKEY | Daschle Group, LLC 6280 | 2015-03-16 | Daschle Group, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | |
16867 | 16867 | 2020-12-31 | Ali Arslan, MP | 2020-10-07 | TURKEY | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | Grand National Assembly of Turkey | Ankara | |||
16897 | 16897 | 2021-12-31 | Embassy of Turkey | 2021-09-19 | TURKEY | MWM Murray Consulting, LLC 7016 | 2021-09-19 | MWM Murray Consulting, LLC | 2525 Massachusetts Ave NW | Washington | DC | 20008 | |
16931 | 16931 | 2022-12-31 | Republic of Turkey | 2022-01-04 | TURKEY | The Van Aucker Group 7066 | 2022-01-04 | The Van Aucker Group | 2525 Massachusetts Ave NW | Washington | DC | 20008 |
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]) );