FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

16,647 rows

✎ View and edit SQL

This data as json, CSV (advanced)

State >30

Country/Location_Represented >30

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
101 101   Cayman Islands Ministry of Financial Services, Commerce & Environment 2021-02-04 CAYMAN ISLANDS Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 133 Elgin Avenue Grand Cayman KYI      
102 102   Chamber of Commerce and Industry of Serbia 2019-11-12 SERBIA Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC Resavska 13-15 Belgrade 11000      
103 103   Chimediin Saikhanbileg 2021-01-26 MONGOLIA Amsterdam & Partners, LLP 6325 2015-10-26 Amsterdam & Partners, LLP          
104 104   China Council for the Promotion of International Trade (CCPIT) 2012-07-06 CHINA Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 1 Fuxingmenwai Street   Beijing 100860    
105 105   China Daily of Beijing, China 1983-04-19 CHINA China Daily Distribution Corporation 3457 1983-04-19 China Daily Distribution Corporation Beijing        
106 106   China National Tourism Administration (formerly: China International Travel Service) 1981-12-30 CHINA China National Tourist Office 3318 1981-12-30 China National Tourist Office Beijing        
107 107   China-United States Exchange Foundation 2011-07-14 CHINA BLJ Worldwide LTD 5875 2008-06-17 BLJ Worldwide LTD          
108 108   China-United States Exchange Foundation 2018-08-31 CHINA Wilson Global Communications, LLC 6584 2018-08-31 Wilson Global Communications, LLC 20/F Yardley Commercial Building, No. 3 Connaught Rd West, SHeung Wan, Hong Kong      
109 109   China-United States Exchange Foundation 2018-11-19 CHINA Capitol Counsel, LLC 6328 2015-11-19 Capitol Counsel, LLC 20/F, Yardley Commercial Building No. 3 Connaught Road West Sheung Wan, Hong Kong      
110 110   City of Sunderland, England 1998-03-01 GREAT BRITAIN Oliver A. Dulle Jr. & Company 5246 1998-03-01 Oliver A. Dulle Jr. & Company Colima Avenue, Sunderland Enterprise Park, Sunderland        
111 111   Civil Movement For a Just Ukraine"(Hromadska Orhanizatsiia Rukh Spravedlyva Ukrayina)" 2021-08-17 UKRAINE Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC          
112 112   Claudio De Simone 2020-04-05 SWITZERLAND Schulman Bhattacharya LLC 6742 2019-10-25 Schulman Bhattacharya LLC Routte des Chenolettes 1660 Chateau Doex      
113 113   Cloud Innovation Ltd. and LARUS Limited 2021-11-19 INTERNATIONAL Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Cloud:c/o Appleby Global Services (Seychelles) Limited Suite 202,2nd Floor,Eden Plaza,Eden Island,Mahe,Seychelles; LARUS: A3,ll/F,TML Tower,Tsuen Wan,N.T, HONG KONG    
114 114   Comision de Promocion del Peru para la Exportacion y el Turismo (PROMPERU) 2022-01-03 PERU Global Nexus LLC 7064 2022-01-03 Global Nexus LLC Cal. Uno Oeste Numero 50 Corpac, Edificio Mincetur-Piso 14, San Isidro Lima    
115 115   Committee on National Security, Defence and Intelligence Verkhovna Rada (Parliament) of Ukraine 2022-04-29 UKRAINE Navigators Global LLC 7112 2022-04-29 Navigators Global LLC 5 Grushevskogo Str   Kyiv-8    
116 116   Commonwealth of Dominica, Office of Ministry of Finance, Industry and Trade 1999-10-12 DOMINICA Commonwealth of Dominica Maritime Registry, Inc. 5334 1999-10-12 Commonwealth of Dominica Maritime Registry, Inc. Rosseau        
117 117   Congo, Democratic Republic of The 2022-01-27 CONGO, DEMOCRATIC REPUBLIC OF THE Vanguard Africa 6411 2017-03-26 Vanguard Africa 3 Boulevard Triomphal, C/ Kasa Vubu Kinshasa      
118 118   Consulate General of Japan in Atlanta 2018-10-15 JAPAN Taylor English Decisions, LLC 6600 2018-10-15 Taylor English Decisions, LLC 3438 Peachtree Road Phipps Tower, Suite 850 Atlanta GA 30326
119 119   Consulate General of Japan in Boston 2014-04-09 JAPAN Policy Agency, LLC 6213 2014-04-09 Policy Agency, LLC Federal Reserve Plaza, 22nd Floor 600 Atlantic Avenue   Boston MA 02210
120 120   Consulate General of Japan in New York 2021-03-30 JAPAN APCO Worldwide LLC 6582 2018-08-22 APCO Worldwide LLC 299 Park Avenue, Suite 19   New York NY 10171
121 121   Consulate General of Japan 2018-07-11 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 299 Park Avenue, 19th Floor   New York NY 10171
122 122   Consulate-General of Japan in Atlanta 2015-09-16 JAPAN McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC          
123 123   Coordination of the Movements of the Azawad (CMA) 2017-10-30 MALI Independent Diplomat, Inc. 5860 2008-04-03 Independent Diplomat, Inc.          
124 124   Corporacion Dinant 2015-03-11 HONDURAS Tricuro, LLC 6285 2015-03-11 Tricuro, LLC Barrio Morazan, Frente a Plantas Tropicales Boulevard Suyapa Tegucigalpa      
125 125   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    
126 126   Costa Rica Investment Promotion Authority 2021-05-07 COSTA RICA Development Counsellors International 4777 1993-03-12 Development Counsellors International Plaza Roble/ Los Balcunes 4th FLoor Escazu San Jose    
127 127   Costa Rica Tourism Board 2018-06-29 COSTA RICA MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC Costado Este del Puente Juan Pablo II Sobre la Autopista General Canas San Jose, 777-1000      
128 128   Czech Ministry of Foreign Affairs 1996-06-21 CZECHIA Czech Center, New York 5115 1996-06-21 Czech Center, New York Praha        
129 129   DEACERO S.A.P.I. de .C,V, (DEACERO) 2022-03-17 MEXICO DEACERO S.A.P.I. de C.V. (DEACERO) 7013 2021-09-07 DEACERO S.A.P.I. de C.V. (DEACERO)          
130 130   DIGITALEUROPE 2022-04-25 BELGIUM Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. Rue de la Science, 14 B-1040 Brussels    
131 131   DIHK DEinternational GmbH 2021-08-30 GERMANY Delegation of German Industry and Commerce in Washington DC, LLC 7002 2021-08-30 Delegation of German Industry and Commerce in Washington DC, LLC Breite Strasse 29   Berlin    
132 132   DPWORLD FZE 2019-12-30 UNITED ARAB EMIRATES Dickens & Madson Canada Inc. 6200 2013-12-11 Dickens & Madson Canada Inc. JAPZA 17 PO BOX 17000 DUBAI    
133 133   Daklak Honeybee Joint Stock Company (DakHoney")" 2022-03-08 VIETNAM White & Case LLP 6393 2016-11-21 White & Case LLP No. 0No.3 Dinh Tien Hoang Street, Tu An Ward, Buon Ma Thuot   City, Dak Lak Province    
134 134   Dalai Lama 1964-03-12 TIBET Office of Tibet 1699 1964-03-14 Office of Tibet Dharamsala        
135 135   Democratic Party of Albania 2018-06-12 ALBANIA Sonoran Policy Group, LLC 6399 2016-12-11 Sonoran Policy Group, LLC Bulevardi Zhan'dark 11 1000 Tirana      
136 136   Democratic Progressive Party 2013-09-06 TAIWAN Taiwan Democratic Progressive Party Mission in the U.S. 6187 2013-09-06 Taiwan Democratic Progressive Party Mission in the U.S. 30 Peiping E. Road 10th Floor Taipei      
137 137   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-19 UNITED KINGDOM Fragomen, Del Rey, Bernsen & Loewy, LLP 6827 2020-05-19 Fragomen, Del Rey, Bernsen & Loewy, LLP 3 Whitehall Place SW1A 2AW London    
138 138   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-27 UNITED KINGDOM Steptoe & Johnson, LLP 6653 2019-03-22 Steptoe & Johnson, LLP          
139 139   Department for International Trade, Government of the United Kingdom (through Linklaters LLP) 2020-05-28 UNITED KINGDOM Harris, Wiltshire & Grannis LLP 6831 2020-05-28 Harris, Wiltshire & Grannis LLP 3 Whitehall Place   London    
140 140   Department for International Trade, Government of the United Kingdom 2020-02-24 UNITED KINGDOM Linklaters LLP 6795 2020-02-24 Linklaters LLP          
141 141   Department for International Trade, Government of the United Kingdom 2020-11-30 UNITED KINGDOM Sidley Austin, LLP 3731 1985-09-13 Sidley Austin, LLP 3 Whitehall Place SW1A ZAW London    
142 142   Department for International Trade, Government of the United Kingdom, through Linklaters LLP 2020-05-28 UNITED KINGDOM Fish & Richardson P.C. 6830 2020-05-28 Fish & Richardson P.C. Three Whitehall Place   London    
143 143   Department of Culture and Tourism - Abu Dhabi 2022-03-29 UNITED ARAB EMIRATES BCW LLC 6227 2014-06-18 BCW LLC PO Box 94000 Nation Towers Offices, Corniche, Abu Dhabi      
144 144   Department of Culture and Tourism - Abu Dhabi 2020-05-20 UNITED ARAB EMIRATES Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC PO Box 94000 Abu Dhabi      
145 145   Department of Culture and Tourism - Abu Dhabi 2021-10-29 UNITED ARAB EMIRATES Development Counsellors International 4777 1993-03-12 Development Counsellors International Nation Towers Offices, Corniche P,O. Box 94000 Abu Dhabi    
146 146   Designated Victims of the Nairobi Embassy Bombing 2022-03-21 KENYA Musolino and Dessel, PLLC 7101 2022-03-21 Musolino and Dessel, PLLC 1615 L Street, NW Suite 440 Washington DC 20036
147 147   Deutsche Telekom, A.G. (formerly: Deutsche Bundespost Telekom) 1990-10-09 GERMANY Deutsche Telekom, Inc. 4419 1990-10-09 Deutsche Telekom, Inc. Friedrich-Ebert-Allee 140 53113 Bonn    
148 148   Deutsche Zentrale fuer Tourismus (German National Tourist Board) 1950-02-28 GERMANY German National Tourist Office 616 1950-02-28 German National Tourist Office          
149 149   Discover Dominica Authority 2018-04-30 DOMINICAN REPUBLIC Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC 1st Floor Financial Centre Roseau, Commonwealth of Dominica      
150 150   Dmytro Firtash 2021-04-18 UKRAINE Davis Goldberg & Galper PLLC 6949 2021-04-18 Davis Goldberg & Galper PLLC c/o Group DF Holdings Limited, 6th Floor, Flat/Office 3&4 3035, Limassol      
151 151   Dr. Alfredo Borrero Vega 2021-03-22 ECUADOR Moonlight International LLC 6941 2021-03-22 Moonlight International LLC AV. Atahualpa, Diagonal Banco del Estado, Sector de la Rumipamba Quito 02 5112121      
152 152   Dr. Reginald Boulos 2021-05-26 HAITI Novitas Communication Inc. 6965 2021-05-26 Novitas Communication Inc. 20, Blvd Toussaint Louverture Boulevard Toussain 6120 Port-au-Prince    
153 153   Dubai Corporation for Tourism and Commerce Marketing 2020-12-01 UNITED ARAB EMIRATES Finn Partners, Inc. 6212 2014-03-10 Finn Partners, Inc. 4th Floor. One Central, The Offices 2, Dubai World Trade Centre. PO Box 594 Dubai    
154 154   Education Above All Foundation (through Portland PR Limited (QFC Branch)) 2020-09-03 QATAR Portland PR Inc. 6064 2011-09-19 Portland PR Inc. P.O. Box 34173 Education City Doha      
155 155   Embassy of Hungary 2020-10-19 HUNGARY Strategic Improvisation Inc. 6880 2020-10-19 Strategic Improvisation Inc. 3910 Shoemaker St NW   Washington DC 20008
156 156   Embassy of Italy 2020-10-14 ITALY S-3 Group 6422 2017-04-26 S-3 Group 300 WHITEHAVEN STREET, NW   Washington DC 20008
157 157   Embassy of Japan 2018-02-10 JAPAN Forbes Tate Partners LLC 6522 2018-02-10 Forbes Tate Partners LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
158 158   Embassy of Japan 2011-03-02 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
159 159   Embassy of Japan 2019-04-09 JAPAN Beacon Policy Advisors LLC 6658 2019-04-09 Beacon Policy Advisors LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
160 160   Embassy of Japan 2020-04-10 JAPAN Patrick,Griffin 6815 2020-04-10 Patrick,Griffin 2520 Massachusetts Avenue, NW   Washington DC 20008
161 161   Embassy of Japan 2020-04-10 JAPAN Tiber Creek Group, Inc. 6816 2020-04-10 Tiber Creek Group, Inc. 2520 Massachusetts Avenue, NW   Washington DC 20008
162 162   Embassy of Japan 2017-04-12 JAPAN CGCN Group 6396 2016-11-30 CGCN Group 2520 Massachusetts Avenue, NW   Washington DC 20008
163 163   Embassy of Japan 2015-04-16 JAPAN Daschle Group, LLC 6280 2015-03-16 Daschle Group, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
164 164   Embassy of Japan 2001-04-19 JAPAN Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100        
165 165   Embassy of Japan 2017-04-26 JAPAN S-3 Group 6422 2017-04-26 S-3 Group 2520 Massachusetts Avenue, NW   Washington DC 20008
166 166   Embassy of Japan 2015-05-08 JAPAN Holland & Knight 3718 1985-08-07 Holland & Knight 2520 Massachusetts Avenue, NW   Washington DC 20008
167 167   Embassy of Japan 2015-05-16 JAPAN Greenfield Law, LLC 6294 2015-05-16 Greenfield Law, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
168 168   Embassy of Japan 2018-05-18 JAPAN RSC Services International LLC 6554 2018-05-18 RSC Services International LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
169 169   Embassy of Japan 2015-09-18 JAPAN Alignment Government Strategies 6317 2015-09-18 Alignment Government Strategies 2520 Massachusetts Avenue, NW   Washington DC 20008
170 170   Embassy of Japan 2013-11-08 JAPAN Parvin, C. Landon 6194 2013-11-08 Parvin, C. Landon 2520 Massachusetts Avenue, NW   Washington DC  
171 171   Embassy of Mexico 2022-01-12 MEXICO Glassman Enterprises, LLC 7069 2022-01-12 Glassman Enterprises, LLC 1911 Pennsylvania Avenue, NW   Washington DC 20006
172 172   Embassy of Mexico 2021-09-07 MEXICO DEACERO S.A.P.I. de C.V. (DEACERO) 7013 2021-09-07 DEACERO S.A.P.I. de C.V. (DEACERO) 1911 Pennsylvania Avenue, NW   Washington DC 20006
173 173   Embassy of Morocco 2018-04-13 MOROCCO ThirdCircle, Inc. 6540 2018-04-13 ThirdCircle, Inc. 1601 21st Street, NW   Washington DC 20009
174 174   Embassy of Morocco 2021-12-01 MOROCCO Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 3508 International Drive, NW   Washington DC 20008
175 175   Embassy of Moroccov (through Brownstein Hatt Farber Schreck, LLP 2021-12-05 MOROCCO Holly Strategies Incorporated 6605 2018-10-31 Holly Strategies Incorporated          
176 176   Embassy of Pakistan 2022-03-26 PAKISTAN Fenton/Arlook LLC 6972 2021-06-10 Fenton/Arlook LLC 3517 International Court NW   Washington DC 20008
177 177   Embassy of Qatar (through contract with Nelson, Mullins, Riley & Scarborough LLP 2021-01-13 QATAR Nurnberger & Associates, Inc. 6907 2021-01-13 Nurnberger & Associates, Inc. 2555 M Street, NW   Washigton DC 20037
178 178   Embassy of Qatar through Nelson Mullins Riley & Scarborough, LLP 2020-02-20 QATAR Holland & Knight 3718 1985-08-07 Holland & Knight 2555 M Street, NW   Washington DC 20037
179 179   Embassy of Qatar 2022-03-07 QATAR Becker & Poliakoff 7089 2022-03-07 Becker & Poliakoff 2555 M Street,NW   Washington DC 20037
180 180   Embassy of Qatar 2018-03-23 QATAR Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP 2555 M Street, NW   Washington DC 20037
181 181   Embassy of Saudi Arabia 2018-06-29 SAUDI ARABIA McKeon Group, Inc. 6391 2016-11-16 McKeon Group, Inc. 601 New Hamphsire Avenue, NW   Washington DC 20037
182 182   Embassy of Thailand, Office of Commercial Affairs 2019-07-09 THAILAND Pilot Rock Global Strategies LLC 6699 2019-07-09 Pilot Rock Global Strategies LLC Office of Commercial Affairs Royal Thai Embassy 1024 Wisconsin Aveune, NW Washington DC 20007
183 183   Embassy of Turkey 2021-06-11 TURKEY Garvey Strategies 6974 2021-06-11 Garvey Strategies 2525 Massachusetts Avenue   Washington DC 20007
184 184   Embassy of the Islamic Republic of Pakistan 2021-11-16 PAKISTAN Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP          
185 185   Embassy of the Kingdom of Bahrain to the United States of America 2018-06-12 BAHRAIN BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 3502 International Drive, NW   Washington DC 20008
186 186   Embassy of the Kingdom of Cambodia 2022-01-21 CAMBODIA Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 4530 16th Street, NW   Washington DC 20011
187 187   Embassy of the Kingdom of Morocco 2021-11-08 MOROCCO Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 3508 International drive NW Washington DC 20008
188 188   Embassy of the Kingdom of Morocco 2021-11-11 MOROCCO Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 3508 International Drive, NW   Washington DC 20008
189 189   Embassy of the Kingdom of Saudi Arabia 2020-11-13 SAUDI ARABIA Off Hill Strategies LLC 6889 2020-11-13 Off Hill Strategies LLC 601 New Hampshire Avenue, NW   Washington DC 20037
190 190   Embassy of the Republic of Argentina 2020-05-07 ARGENTINA Arnold & Porter Kaye Scholer, LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP 1600 New Hampshire Avenue, NW   Washington DC 20009
191 191   Embassy of the Republic of Azerbaijan (through BGR Government Affairs, LLC) 2018-03-05 AZERBAIJAN Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 6535 2018-03-05 Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. 2741 34th Street, NW   Washington DC 20008
192 192   Embassy of the Republic of Azerbaijan to the United States of America 2020-01-31 AZERBAIJAN Stellar Jay Communications 6789 2020-01-31 Stellar Jay Communications 2741 34th Street, NW   Washington DC 20008
193 193   Embassy of the Republic of Azerbaijan 2017-03-20 AZERBAIJAN BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 2741 34th Street, NW   Washington DC 20008
194 194   Embassy of the Republic of Haiti Government of the Republic of Haiti 2019-03-11 HAITI LeBlanc, Johanna 6644 2019-03-11 LeBlanc, Johanna 2311 Massachusetts Avenue, NW   Washington DC 20008
195 195   Embassy of the Republic of Haiti 2021-03-12 HAITI Patino & Associates, P.A. 6937 2021-03-12 Patino & Associates, P.A. 2311 Massachusetts Avenue, NW   Washington DC 20008
196 196   Embassy of the Republic of Haiti 2020-12-09 HAITI Latin America Advisory Group, LLC 6898 2020-12-09 Latin America Advisory Group, LLC 2311 Massachusetts Avenue, NW   Washington DC 20008
197 197   Embassy of the Republic of Iraq 2022-01-01 IRAQ Cogent Strategies LLC 6927 2021-02-23 Cogent Strategies LLC 3421 Massachusetts Ave NW   Washington    
198 198   Embassy of the Republic of Iraq 2018-10-31 IRAQ Holly Strategies Incorporated 6605 2018-10-31 Holly Strategies Incorporated 3421 Massachusetts Avenue, NW   Washington DC 20007
199 199   Embassy of the Republic of Kenya 2017-06-06 KENYA Sonoran Policy Group, LLC 6399 2016-12-11 Sonoran Policy Group, LLC 2249 R Street, NW   Washington DC 20008
200 200   Embassy of the Republic of Korea through Cornerstone Government Affairs 2017-03-14 KOREA, SOUTH DiNino Associates, LLC 6408 2017-03-14 DiNino Associates, LLC 2450 Massachusetts Avenue, NW   Washington DC 20008

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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