Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
This data as json, CSV (advanced)
State
Registrant_Name
Foreign_Principal
Country/Location_Represented
City
| 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 | Common Council of Iraqi and Arabic Tribes | 2014-07-18 | IRAQ | 5974 5974 | 2010-02-18 | Alsalih, Mark K. | Hay Babel, Jadriyah #18 | Baghdad | ||||
| 102 | 102 | Commonwealth of Dominica, Office of Ministry of Finance, Industry and Trade | 1999-10-12 | DOMINICA | 5334 5334 | 1999-10-12 | Commonwealth of Dominica Maritime Registry, Inc. | Rosseau | |||||
| 103 | 103 | Concern Belneftekhim | 2019-11-01 | BELARUS | 6706 6706 | 2019-08-12 | Gencarelli, David F. | pr. Dzerzhinskogo, 73 | 220116 Minsk | ||||
| 104 | 104 | Consulate General for Japan in Los Angeles | 2019-04-09 | JAPAN | 6659 6659 | 2019-04-09 | Community Partners | 350 S. Grand Avenue | Los Angeles | CA | 90071 | ||
| 105 | 105 | Consulate General of Japan in Atlanta | 2018-10-15 | JAPAN | 6600 6600 | 2018-10-15 | Taylor English Decisions, LLC | 3438 Peachtree Road | Phipps Tower, Suite 850 | Atlanta | GA | 30326 | |
| 106 | 106 | Consulate General of Japan in Boston | 2014-04-09 | JAPAN | 6213 6213 | 2014-04-09 | Policy Agency, LLC | Federal Reserve Plaza, 22nd Floor 600 Atlantic Avenue | Boston | MA | 02210 | ||
| 107 | 107 | Consulate General of Japan in New York | 2015-04-16 | JAPAN | 6289 6289 | 2015-04-16 | Marathon Strategies, LLC | 299 Park Avenue | New York | NY | 10171 | ||
| 108 | 108 | Consulate General of Japan | 2018-07-11 | JAPAN | 6170 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 299 Park Avenue, 19th Floor | New York | NY | 10171 | ||
| 109 | 109 | Consulate General of the Dominican Republic | 2019-06-14 | DOMINICAN REPUBLIC | 6691 6691 | 2019-06-14 | Rubenstein Public Relations, Inc. | 1501 Broadway, 4th Floor | New York | NY | 10036 | ||
| 110 | 110 | Consulate-General of Japan in Atlanta | 2015-09-16 | JAPAN | 6295 6295 | 2015-05-19 | McGuireWoods Consulting, LLC | ||||||
| 111 | 111 | Contrasta Global SL | 2020-01-24 | SPAIN | 6305 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | Calle Progreso, 2 Pl Los Olivos | 289906-Getafe, Espana | ||||
| 112 | 112 | Coordination of the Movements of the Azawad (CMA) | 2017-10-30 | MALI | 5860 5860 | 2008-04-03 | Independent Diplomat, Inc. | ||||||
| 113 | 113 | Corporacion Dinant | 2015-03-11 | HONDURAS | 6285 6285 | 2015-03-11 | Tricuro, LLC | Barrio Morazan, Frente a Plantas Tropicales | Boulevard Suyapa Tegucigalpa | ||||
| 114 | 114 | Costa Rica Tourism Board | 2018-06-29 | COSTA RICA | 6492 6492 | 2017-11-27 | MMGY Global, LLC | Costado Este del Puente Juan Pablo II | Sobre la Autopista General Canas San Jose, 777-1000 | ||||
| 115 | 115 | Czech Ministry of Foreign Affairs | 1996-06-21 | CZECHIA | 5115 5115 | 1996-06-21 | Czech Center, New York | Praha | |||||
| 116 | 116 | DPWORLD FZE | 2019-12-30 | UNITED ARAB EMIRATES | 6200 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | JAPZA 17 | PO BOX 17000 | DUBAI | |||
| 117 | 117 | Dalai Lama | 1964-03-12 | TIBET | 1699 1699 | 1964-03-14 | Office of Tibet | Dharamsala | |||||
| 118 | 118 | Decision Support Center of Libya (on behalf of the Libyan National Army) | 2019-05-19 | LIBYA | 6682 6682 | 2019-05-19 | Linden Government Solutions, LLC | Libyan National Army Headquarters | |||||
| 119 | 119 | Delegation of Ukrainian Officials via contract with Ukrainian Guild of Activities via contract with Tricuro, LLC | 2020-09-03 | UKRAINE | 6865 6865 | 2020-09-03 | DC International Advisory, LLC | ||||||
| 120 | 120 | Delegation of Ukrainian officials via a contract with the Ukrainian Guild of Activists | 2020-09-03 | UKRAINE | 6285 6285 | 2015-03-11 | Tricuro, LLC | 220, 35th Floor Klousky Descent 7a | (Carnegie Towers) | Kiev | |||
| 121 | 121 | Delegation of Ukrainian officials via contract with Ukrainian Guild of Activists via Tricuro LLC | 2020-09-04 | UKRAINE | 6737 6737 | 2019-10-07 | Southfive Strategies, LLC | 200, 35th Floor Klousky Descent 7a | Carnegie Towers | Kiev | |||
| 122 | 122 | Democracy News Live | 2020-08-27 | INDIA | 6860 6860 | 2020-08-27 | Babones, Salvatore Jason | H-91, Sector 63 | Noida, Uttar Pradesh 201309 | ||||
| 123 | 123 | Democratic Party of Albania | 2018-06-12 | ALBANIA | 6399 6399 | 2016-12-11 | Sonoran Policy Group, LLC | Bulevardi Zhan'dark 11 | 1000 Tirana | ||||
| 124 | 124 | Democratic Party of Kosovo | 2019-09-30 | KOSOVA | 6730 6730 | 2019-09-30 | Nunberg, Samuel | ||||||
| 125 | 125 | Democratic Progressive Party | 2013-09-06 | TAIWAN | 6187 6187 | 2013-09-06 | Taiwan Democratic Progressive Party Mission in the U.S. | 30 Peiping E. Road 10th Floor | Taipei | ||||
| 126 | 126 | Democratic Republic of Congo through Mer Security and Communications, Ltd. | 2018-02-14 | CONGO, REPUBLIC OF THE | 6399 6399 | 2016-12-11 | Sonoran Policy Group, LLC | 5 Hatzoref Street | Holon, Israel | ||||
| 127 | 127 | Dentsu Public Relations Inc | 2018-10-01 | JAPAN | 5483 5483 | 2002-03-06 | MSLGROUP Americas, LLC | ||||||
| 128 | 128 | Department for International Trade, Government of the United Kingdom (through Linklaters LLP) | 2020-05-19 | UNITED KINGDOM | 6827 6827 | 2020-05-19 | Fragomen, Del Rey, Bernsen & Loewy, LLP | 3 Whitehall Place | SW1A 2AW | London | |||
| 129 | 129 | Department for International Trade, Government of the United Kingdom (through Linklaters LLP) | 2020-05-27 | UNITED KINGDOM | 6653 6653 | 2019-03-22 | Steptoe & Johnson, LLP | ||||||
| 130 | 130 | Department for International Trade, Government of the United Kingdom (through Linklaters LLP) | 2020-05-28 | UNITED KINGDOM | 6831 6831 | 2020-05-28 | Harris, Wiltshire & Grannis LLP | 3 Whitehall Place | London | ||||
| 131 | 131 | Department for International Trade, Government of the United Kingdom | 2020-02-24 | UNITED KINGDOM | 6795 6795 | 2020-02-24 | Linklaters LLP | ||||||
| 132 | 132 | Department for International Trade, Government of the United Kingdom, through Linklaters LLP | 2020-05-28 | UNITED KINGDOM | 6830 6830 | 2020-05-28 | Fish & Richardson P.C. | Three Whitehall Place | London | ||||
| 133 | 133 | Department of Culture and Tourism - Abu Dhabi | 2020-05-20 | UNITED ARAB EMIRATES | 6826 6826 | 2020-05-20 | Brunswick Group LLC | PO Box 94000 | Abu Dhabi | ||||
| 134 | 134 | Deutsche Telekom, A.G. (formerly: Deutsche Bundespost Telekom) | 1990-10-09 | GERMANY | 4419 4419 | 1990-10-09 | Deutsche Telekom, Inc. | Friedrich-Ebert-Allee 140 | 53113 | Bonn | |||
| 135 | 135 | Deutsche Zentrale fuer Tourismus (German National Tourist Board) | 1950-02-28 | GERMANY | 616 616 | 1950-02-28 | German National Tourist Office | ||||||
| 136 | 136 | Direct Media Sarl | 2019-05-07 | TOGO | 6671 6671 | 2019-05-07 | Global Specialty LLC | Rue Satelite, 2eme Maison avant Group CAP Fer, Cacaveli BP 30117 | Lome` | ||||
| 137 | 137 | Direction du Tourisme et des Congres | 1972-04-25 | MONACO | 2327 2327 | 1972-03-21 | Monaco Government Tourist Office | ||||||
| 138 | 138 | Discover Dominica Authority | 2018-04-30 | DOMINICAN REPUBLIC | 6549 6549 | 2018-04-30 | Myriad International Marketing, LLC | 1st Floor Financial Centre | Roseau, Commonwealth of Dominica | ||||
| 139 | 139 | Economic Development Board of the Kingdom of Bahrain | 2018-10-26 | BAHRAIN | 6582 6582 | 2018-08-22 | APCO Worldwide LLC | P.O. Box 11299 Manama | |||||
| 140 | 140 | Education Above All Foundation (through Portland PR Limited (QFC Branch)) | 2020-09-03 | QATAR | 6064 6064 | 2011-09-19 | Portland PR Inc. | ||||||
| 141 | 141 | Embassy of Democratic Republic of Congo | 2019-03-15 | CONGO, REPUBLIC OF THE | 6649 6649 | 2019-03-15 | LFA Holdings INC. | 1100 Connecticut Avenue, NW | #725 | Washington | DC | 20036 | |
| 142 | 142 | Embassy of Ethiopia | 2020-07-14 | ETHIOPIA | 6594 6594 | 2018-09-24 | Barnes & Thornburg LLP | 3506 International Drive, NW | Washington | DC | 20008 | ||
| 143 | 143 | Embassy of Hungary | 2018-11-20 | HUNGARY | 6594 6594 | 2018-09-24 | Barnes & Thornburg LLP | 30901 Shoemaker Street, NW | Washington | DC | 20008 | ||
| 144 | 144 | Embassy of Iraq | 2019-05-13 | IRAQ | 6678 6678 | 2019-05-13 | Gibson, Thomas F. / G.83 LLC | 3421 Massachusetts Avenue, NW | Washington | DC | 20007 | ||
| 145 | 145 | Embassy of Japan | 2018-02-10 | JAPAN | 6522 6522 | 2018-02-10 | Forbes Tate Partners LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 146 | 146 | Embassy of Japan | 2011-03-02 | JAPAN | 3492 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 147 | 147 | Embassy of Japan | 2019-04-09 | JAPAN | 6658 6658 | 2019-04-09 | Beacon Policy Advisors LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 148 | 148 | Embassy of Japan | 2020-04-10 | JAPAN | 6815 6815 | 2020-04-10 | Griffin, Patrick | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 149 | 149 | Embassy of Japan | 2020-04-10 | JAPAN | 6816 6816 | 2020-04-10 | Peck Madigan Jones, Inc. | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 150 | 150 | Embassy of Japan | 2017-04-12 | JAPAN | 6396 6396 | 2016-11-30 | CGCN Group | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 151 | 151 | Embassy of Japan | 2015-04-16 | JAPAN | 6280 6280 | 2015-03-16 | Daschle Group, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 152 | 152 | Embassy of Japan | 2019-04-18 | JAPAN | 6666 6666 | 2019-04-18 | Comeau & Company LLC | ||||||
| 153 | 153 | Embassy of Japan | 2001-04-19 | JAPAN | 2244 2244 | 1971-02-18 | Hogan Lovells US LLP | 2-2-1 Kasumigaseki Chiyoda-ku, Tokyo 100 | |||||
| 154 | 154 | Embassy of Japan | 2017-04-26 | JAPAN | 6422 6422 | 2017-04-26 | S-3 Group | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 155 | 155 | Embassy of Japan | 2015-05-08 | JAPAN | 3718 3718 | 1985-08-07 | Holland & Knight | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 156 | 156 | Embassy of Japan | 2015-05-16 | JAPAN | 6294 6294 | 2015-05-16 | Greenfield Law, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 157 | 157 | Embassy of Japan | 2018-05-18 | JAPAN | 6554 6554 | 2018-05-18 | RSC Services International LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 158 | 158 | Embassy of Japan | 2015-05-19 | JAPAN | 6295 6295 | 2015-05-19 | McGuireWoods Consulting, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 159 | 159 | Embassy of Japan | 2014-05-21 | JAPAN | 5839 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 160 | 160 | Embassy of Japan | 2020-08-04 | JAPAN | 6847 6847 | 2020-08-04 | Seven Letter | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 161 | 161 | Embassy of Japan | 2015-09-18 | JAPAN | 6317 6317 | 2015-09-18 | Alignment Government Strategies | 2520 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 162 | 162 | Embassy of Japan | 2013-11-08 | JAPAN | 6194 6194 | 2013-11-08 | Parvin, C. Landon | 2520 Massachusetts Avenue, NW | Washington | DC | |||
| 163 | 163 | Embassy of Kazakhstan USA | 2020-05-01 | KAZAKHSTAN | 5430 5430 | 2001-05-10 | BGR Government Affairs, LLC | 1401 16th St. NW | Washington | DC | 20036 | ||
| 164 | 164 | Embassy of Morocco | 2018-04-13 | MOROCCO | 6540 6540 | 2018-04-13 | ThirdCircle, Inc. | 1601 21st Street, NW | Washington | DC | 20009 | ||
| 165 | 165 | Embassy of Qatar in the United States (though Pillsbury WInthrop Shaw Pittman LLP) | 2020-08-18 | QATAR | 6857 6857 | 2020-08-18 | Praia Consultants LLC | 2555 M St. NW | Washington | DC | 20037 | ||
| 166 | 166 | Embassy of Qatar through Nelson Mullins Riley & Scarborough, LLP | 2020-02-20 | QATAR | 3718 3718 | 1985-08-07 | Holland & Knight | 2555 M Street, NW | Washington | DC | 20037 | ||
| 167 | 167 | Embassy of Qatar | 2018-03-23 | QATAR | 5198 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | 2555 M Street, NW | Washington | DC | 20037 | ||
| 168 | 168 | Embassy of Saudi Arabia | 2018-06-29 | SAUDI ARABIA | 6391 6391 | 2016-11-16 | McKeon Group, Inc. | 601 New Hamphsire Avenue, NW | Washington | DC | 20037 | ||
| 169 | 169 | Embassy of Thailand, Office of Commercial Affairs | 2019-07-09 | THAILAND | 6699 6699 | 2019-07-09 | Pilot Rock Global Strategies LLC | Office of Commercial Affairs Royal Thai Embassy | 1024 Wisconsin Aveune, NW | Washington | DC | 20007 | |
| 170 | 170 | Embassy of the Bolivarian Republic of Venezuela | 2019-04-12 | VENEZUELA | 5430 5430 | 2001-05-10 | BGR Government Affairs, LLC | Washington | DC | ||||
| 171 | 171 | Embassy of the Bolivarian Republic of Venezuela | 2018-12-15 | VENEZUELA | 6613 6613 | 2018-12-15 | Flores, Leonardo | 1099 30th Street, NW | Washington | DC | 20007 | ||
| 172 | 172 | Embassy of the Islamic Republic of Afghanistan | 2018-09-20 | AFGHANISTAN | 3712 3712 | 1985-08-05 | DLA Piper US LLP | ||||||
| 173 | 173 | Embassy of the Kingdom of Bahrain to the United States of America | 2018-06-12 | BAHRAIN | 5430 5430 | 2001-05-10 | BGR Government Affairs, LLC | 3502 International Drive, NW | Washington | DC | 20008 | ||
| 174 | 174 | Embassy of the Principality of Monaco | 2015-10-14 | MONACO | 5299 5299 | 1999-02-02 | Berliner Corcoran & Rowe, LLP | 3400 International Drive, NW | Washington | DC | 20008 | ||
| 175 | 175 | Embassy of the Republic of Argentina | 2020-05-04 | ARGENTINA | 5666 5666 | 2005-01-31 | Glover Park Group, LLC | 1600 New Hampshire Ave. | Washington | DC | 20009 | ||
| 176 | 176 | Embassy of the Republic of Argentina | 2020-05-07 | ARGENTINA | 1750 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer, LLP | 1600 New Hampshire Avenue, NW | Washington | DC | 20009 | ||
| 177 | 177 | Embassy of the Republic of Azerbaijan (through BGR Government Affairs, LLC) | 2018-03-05 | AZERBAIJAN | 6535 6535 | 2018-03-05 | Baker, Donelson, Bearman, Caldwell & Berkowitz, P.C. | 2741 34th Street, NW | Washington | DC | 20008 | ||
| 178 | 178 | Embassy of the Republic of Azerbaijan to the United States of America | 2020-01-31 | AZERBAIJAN | 6789 6789 | 2020-01-31 | Stellar Jay Communications | 2741 34th Street, NW | Washington | DC | 20008 | ||
| 179 | 179 | Embassy of the Republic of Azerbaijan | 2017-03-20 | AZERBAIJAN | 5430 5430 | 2001-05-10 | BGR Government Affairs, LLC | 2741 34th Street, NW | Washington | DC | 20008 | ||
| 180 | 180 | Embassy of the Republic of Guinea | 2019-08-14 | GUINEA | 6305 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | 2112 Leroy Place, NW | Washington | DC | 20008 | ||
| 181 | 181 | Embassy of the Republic of Haiti Government of the Republic of Haiti | 2019-03-11 | HAITI | 6644 6644 | 2019-03-11 | LeBlanc, Johanna | 2311 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 182 | 182 | Embassy of the Republic of Iraq | 2018-10-31 | IRAQ | 6605 6605 | 2018-10-31 | Holly Strategies Incorporated | 3421 Massachusetts Avenue, NW | Washington | DC | 20007 | ||
| 183 | 183 | Embassy of the Republic of Kenya | 2017-06-06 | KENYA | 6399 6399 | 2016-12-11 | Sonoran Policy Group, LLC | 2249 R Street, NW | Washington | DC | 20008 | ||
| 184 | 184 | Embassy of the Republic of Korea through Cornerstone Government Affairs | 2017-03-14 | KOREA, SOUTH | 6408 6408 | 2017-03-14 | DiNino Associates, LLC | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 185 | 185 | Embassy of the Republic of Korea | 2018-01-10 | KOREA, SOUTH | 2165 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 186 | 186 | Embassy of the Republic of Korea | 2019-01-10 | KOREA, SOUTH | 5928 5928 | 2009-04-10 | Nelson Mullins Riley & Scarborough, LLP | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 187 | 187 | Embassy of the Republic of Korea | 2017-01-20 | KOREA, SOUTH | 6401 6401 | 2017-01-20 | Cornerstone Government Affairs | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 188 | 188 | Embassy of the Republic of Korea | 2010-03-22 | KOREA, SOUTH | 5982 5982 | 2010-03-22 | Thomas Capitol Partners, Inc. | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 189 | 189 | Embassy of the Republic of Korea | 2018-06-26 | KOREA, SOUTH | 5430 5430 | 2001-05-10 | BGR Government Affairs, LLC | 2450 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 190 | 190 | Embassy of the Republic of Korea | 2019-12-30 | KOREA, SOUTH | 5044 5044 | 1995-09-13 | Reed, T. Dean | ||||||
| 191 | 191 | Embassy of the Republic of Turkey | 2018-05-04 | TURKEY | 6170 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 2525 Massachusetts Avenue, NW | Washington | DC | 20008 | ||
| 192 | 192 | Embassy of the Republic of Yemen | 2019-02-27 | YEMEN | 5483 5483 | 2002-03-06 | MSLGROUP Americas, LLC | 2319 Wyoming Avenue, NW | Washington | DC | 20008 | ||
| 193 | 193 | Embassy of the State of Qatar through Venable LLP | 2018-02-02 | QATAR | 6517 6517 | 2018-02-02 | Husch Blackwell Strategies, LLC | 2555 M Street, NW | Washington | DC | 20037 | ||
| 194 | 194 | Embassy of the State of Qatar through Venable LLP | 2018-02-05 | QATAR | 6379 6379 | 2016-09-20 | S.G.R. LLC Government Relations and Lobbying | 2555 M Street, NW | Washington | DC | 20037 | ||
| 195 | 195 | Embassy of the State of Qatar through Venable LLP | 2017-12-08 | QATAR | 6497 6497 | 2017-12-08 | Iron Bridge Strategies LLC | 2555 M Street, NW | Washington | DC | 20037 | ||
| 196 | 196 | Embassy of the State of Qatar | 2019-01-22 | QATAR | 6540 6540 | 2018-04-13 | ThirdCircle, Inc. | 2555 M Street, NW | Washington | DC | 20037 | ||
| 197 | 197 | Embassy of the State of Qatar | 2018-02-05 | QATAR | 5931 5931 | 2009-04-17 | Venable, LLP | 2555 M Street, NW | Washington | DC | 20037 | ||
| 198 | 198 | Embassy of the State of Qatar | 2020-03-20 | QATAR | 6804 6804 | 2020-03-20 | Bridge Builder Communications | 2555 M St NW | Washington | DC | 20037 | ||
| 199 | 199 | Embassy of the State of Qatar | 2020-03-26 | QATAR | 6415 6415 | 2017-04-05 | Ballard Partners | 601 Thirteenth Street NW | Suit 450 | Washington | DC | 20005 | |
| 200 | 200 | Embassy of the State of Qatar | 2018-03-29 | QATAR | 6537 6537 | 2018-03-29 | Lumen8 Advisors, LLC | 2555 M Street, NW | Washington | DC | 20037 |
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) );