FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
67 rows where City = "Washington", State = "DC" and Zip = 20036
This data as json, CSV (advanced)
Suggested facets: Address_2, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Registrant_Name >30
- BGR Government Affairs, LLC 3
- Ogilvy Public Relations Worldwide 3
- AF International, LLC 2
- Covington & Burling, LLP 2
- Finn Partners, Inc. 2
- Parven Pomper Strategies, Inc. 2
- Portland PR Inc. 2
- Quinn Gillespie & Associates, LLC 2
- APCO Worldwide, Inc. 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Alameh, Lara, LLC 1
- BKSH & Associates 1
- Barwari, Delovan 1
- Bell Pottinger USA, Inc. 1
- Berris, Marvin Lou 1
- Bockorny Group, Inc. 1
- Brownstein Hyatt Farber Schreck, LLP 1
- CLS Strategies 1
- Clark Consulting 1
- Cogent Law Group LLP 1
- Davidoff Hutcher & Citron, LLP 1
- Eizenstat, Stuart E. 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- Fierce, Isakowitz & Blalock 1
- Fratelli Group 1
- Gilman Group 1
- Gray Global Advisors, LLC 1
- Hamilton Place Strategies, LLC 1
- Hashi Warsame Abdi-Nur 1
- Herald Group, LLC 1
- …
Foreign_Principal >30
- Embassy of Vietnam 4
- Korea International Trade Association 3
- ProExport Colombia 3
- Republic of the Philippines, Embassy 3
- Embassy of Chile 2
- Embassy of the Republic of Kazakhstan 2
- Komala Representation Office in the U.S. 2
- Bayan Sami Abdul Rahman 1
- Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) 1
- Commonwealth of Australia, Embassy 1
- Designated Victims of the 1998 Embassy Bombings 1
- Embassy of Australia 1
- Embassy of Democratic Republic of Congo 1
- Embassy of Japan through Akin Gump Strauss Hauer & Feld LLP 1
- Embassy of Kazakhstan USA 1
- Embassy of Peru 1
- Embassy of Republic of the Philippines 1
- Embassy of the Kingdom of Morocco 1
- Embassy of the Republic of Indonesia 1
- Embassy of the Republic of Iraq 1
- Embassy of the Republic of Kazakhstan in Washington 1
- Embassy of the Republic of Mali to the United States 1
- Embassy of the Republic of Peru 1
- Embassy of the Republic of Peru through Patton Boggs 1
- Embassy of the Republic of Serbia 1
- Embassy of the Republic of lndonesia 1
- Embassy of the Socialist Republic of Vietnam 1
- Federal Government of Somali 1
- General Delegation of the PLO to the United States 1
- Government of Colombia, Embassy 1
- …
Country/Location_Represented 29
- IRAQ 6
- KAZAKHSTAN 5
- PHILIPPINES 5
- VIETNAM 5
- COLOMBIA 4
- HONG KONG 4
- KOREA, SOUTH 4
- PERU 4
- IRAN 3
- AUSTRALIA 2
- CHILE 2
- CONGO, REPUBLIC OF THE 2
- INDONESIA 2
- JAPAN 2
- KENYA 2
- PALESTINE 2
- AZERBAIJAN 1
- HONDURAS 1
- HUNGARY 1
- LIECHTENSTEIN 1
- MALI 1
- MOROCCO 1
- NAGORNO KARABAKH 1
- NORWAY 1
- POLAND 1
- REPUBLIC OF SOUTH SUDAN 1
- SERBIA 1
- SOMALI DEMOCRATIC REPUBLIC 1
- UZBEKISTAN 1
State 1
- DC · 67 ✖
City 1
- Washington · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
143 | 143 | Designated Victims of the 1998 Embassy Bombings | 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 | |
182 | 182 | Embassy of Peru | 2023-07-20 | PERU | Resolute Public Affairs 7297 | 2023-07-20 | Resolute Public Affairs | 1700 Massachusetts Ave., NW | Washington | DC | 20036 | ||
213 | 213 | Embassy of the Republic of Serbia | 2023-07-28 | SERBIA | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 1333 16th Street, NW | Washington | DC | 20036 | ||
332 | 332 | Hong Kong Trade Development Council | 2022-03-31 | HONG KONG | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 1520 18th Street, NW | Washington | DC | 20036 | ||
401 | 401 | Komala Party of Iranian Kurdistan | 2020-01-23 | IRAN | Cogent Law Group LLP 6786 | 2020-01-23 | Cogent Law Group LLP | 1250 Connecticut Avenue, NW | Suite 700 | Washington | DC | 20036 | |
403 | 403 | Komala Representation Office in the U.S. | 2022-05-25 | IRAN | AF International, LLC 6639 | 2019-02-18 | AF International, LLC | 1250 Connecticut Avenue | Washington | DC | 20036 | ||
405 | 405 | Korea International Trade Association | 2010-03-25 | KOREA, SOUTH | Thomas Capitol Partners, Inc. 5982 | 2010-03-22 | Thomas Capitol Partners, Inc. | 1660 L Street, NW | Suite 401 | Washington | DC | 20036 | |
414 | 414 | Kurdish Regional Government (formerly known as Kurdish Democratic Party) | 2004-06-25 | IRAQ | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 1015 18th Street, N.W. Suite 704 | Washington | DC | 20036 | ||
543 | 543 | Okinawa Prefecture | 2015-06-03 | JAPAN | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 | |
562 | 562 | Polish Investment & Trade Agency | 2018-04-26 | POLAND | Polish Chamber of Commerce in the US 6545 | 2018-04-26 | Polish Chamber of Commerce in the US | 1503 21st Street, NW | Washington | DC | 20036 | ||
688 | 688 | The Embassy of the Republic of Kazakhstan | 2022-07-29 | KAZAKHSTAN | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 1401 16th St NW | Washington | DC | 20036 | ||
995 | 995 | 2006-01-01 | Embassy of the Republic of Iraq | 2005-11-14 | IRAQ | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1801 P Street, NW | Washington | DC | 20036 | |
997 | 997 | 2007-01-01 | Embassy of Vietnam | 2006-12-19 | VIETNAM | Parven Pomper Strategies, Inc. 5781 | 2006-12-19 | Parven Pomper Strategies, Inc. | 1233 20th Street, NW | #400 | Washington | DC | 20036 |
1275 | 1275 | 2014-01-13 | Government of Southern Sudan (GOSS) | 2009-07-20 | REPUBLIC OF SOUTH SUDAN | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 1233 20th Street, NW | Suite 602 | Washington | DC | 20036 |
1547 | 1547 | 2022-01-26 | Ministry of Foreign Relations and International Cooperation of the Republic of Honduras (through the Embassy of Honduras in the United States) | 2021-11-04 | HONDURAS | Yorktown Solutions, LLC 6491 | 2017-11-19 | Yorktown Solutions, LLC | 1220 19th street NW | Suite 320 | Washington | DC | 20036 |
1917 | 1917 | 2019-01-31 | Embassy of Australia | 2018-02-15 | AUSTRALIA | Hamilton Place Strategies, LLC 6526 | 2018-02-15 | Hamilton Place Strategies, LLC | 1601 Massachusetts Avenue, NW | Washington | DC | 20036 | |
2073 | 2073 | 2010-02-01 | ProExport Colombia | 2007-04-05 | COLOMBIA | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | Colombian Government Trade Bureau 1901 L Street, NW | Suite 700 | Washington | DC | 20036 |
2363 | 2363 | 2018-02-10 | Embassy of the Republic of Kazakhstan | 2018-01-11 | KAZAKHSTAN | Portland PR Inc. 6064 | 2011-09-19 | Portland PR Inc. | 1401 16th Street, NW | Washington | DC | 20036 | |
3337 | 3337 | 2008-03-01 | Palestine Liberation Organization Mission to the United States of America | 2007-10-26 | PALESTINE | Alameh, Lara, LLC 5834 | 2007-10-26 | Alameh, Lara, LLC | 1320 18th Street, NW | Suite 200 | Washington | DC | 20036 |
3460 | 3460 | 2009-03-05 | Republic of the Philippines, Embassy | 2008-08-21 | PHILIPPINES | Gilman Group 5879 | 2008-08-21 | Gilman Group | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
3728 | 3728 | 2012-03-14 | Embassy of the Republic of lndonesia | 2012-02-28 | INDONESIA | Quinn Gillespie & Associates, LLC 5753 | 2006-06-01 | Quinn Gillespie & Associates, LLC | 2020 Massachusetts Avenue, NW | Washington | DC | 20036 | |
4128 | 4128 | 2018-03-28 | Government of Peru | 2018-02-12 | PERU | CLS Strategies 6523 | 2018-02-12 | CLS Strategies | 1700 Massachusetts Avenue, NW | Washington | DC | 20036 | |
4732 | 4732 | 2013-03-31 | Government of Hong Kong Special Administrative Region | 2007-05-07 | HONG KONG | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | Commissioner for Economic and Trade Affairs, United States of America | 1520 18th Street, NW | Washington | DC | 20036 |
4740 | 4740 | 2014-03-31 | Embassy of Chile | 2013-04-02 | CHILE | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1732 Massachusetts Avenue, NW | Washington | DC | 20036 | |
4751 | 4751 | 2015-03-31 | SOCAR USA, subsidiary of State Oil Company of Azerbaijan Republic (SOCAR) | 2013-07-28 | AZERBAIJAN | Roberti + White, LLC 6065 | 2011-09-23 | Roberti + White, LLC | 1319 18th Street, NW | Washington | DC | 20036 | |
4960 | 4960 | 2016-04-01 | Government of Hungary, Prime Minister's Office (thru SLI Group, LLC) | 2015-02-04 | HUNGARY | Levick Strategic Communications, LP 6228 | 2014-06-25 | Levick Strategic Communications, LP | 1900 M Street, NW | Suite 400 | Washington | DC | 20036 |
4962 | 4962 | 2017-04-01 | Embassy of the Kingdom of Morocco | 2016-04-01 | MOROCCO | Sorini, Samet & Associates, LLC 5839 | 2007-11-12 | Sorini, Samet & Associates, LLC | 1601 21st Street, NW | Washington | DC | 20036 | |
5238 | 5238 | 2020-04-12 | Federal Government of Somali | 2019-11-27 | SOMALI DEMOCRATIC REPUBLIC | Hashi Warsame Abdi-Nur 6757 | 2019-11-27 | Hashi Warsame Abdi-Nur | 1705 Desales Street, NW | Suite 300 | Washington | DC | 20036 |
5311 | 5311 | 2009-04-15 | Embassy of the Republic of Kazakhstan | 2007-09-27 | KAZAKHSTAN | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 1401 16th Street, NW | Washington | DC | 20036 | |
5667 | 5667 | 2021-04-28 | Kurdistan Regional Government Liaison Office | 2019-12-20 | IRAQ | Barwari, Delovan 6772 | 2019-12-20 | Barwari, Delovan | 1532 16th Street, NW | Washington | DC | 20036 | |
6054 | 6054 | 2009-04-30 | Hong Kong Economic Trade Office (HKETO) | 2007-05-07 | HONG KONG | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | 1520 18th Street, NW | Washington | DC | 20036 | |
6063 | 6063 | 2010-04-30 | Romula V. Manlapig - Commercial Counselor, Embassy | 2009-04-15 | PHILIPPINES | Ki, Fiona 5930 | 2009-04-15 | Ki, Fiona | Philippines Embassy | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 |
6101 | 6101 | 2019-04-30 | Kurdistan Regional Government through PASS-USA | 2018-10-06 | IRAQ | OPC Strategies LLC 6601 | 2018-10-16 | OPC Strategies LLC | 1532 16th Street, NW | Washington | DC | 20036 | |
6121 | 6121 | 2022-04-30 | Republic of Kenya | 2021-04-14 | KENYA | Rational PR, LLC d/b/a Rational 360 6882 | 2020-10-25 | Rational PR, LLC d/b/a Rational 360 | 1616 P Street NW, Suite 340 | Washington | DC | 20036 | |
6655 | 6655 | 2017-05-19 | Korea International Trade Association (KITA) | 2017-05-12 | KOREA, SOUTH | Kim, Nancy Myung-Jin 6430 | 2017-05-12 | Kim, Nancy Myung-Jin | 1660 L Street, NW | Suite 401 | Washington | DC | 20036 |
7225 | 7225 | 2009-05-31 | ProExport Colombia | 2006-11-17 | COLOMBIA | Peck, Madigan, Jones & Stewart, Inc. 5776 | 2006-11-17 | Peck, Madigan, Jones & Stewart, Inc. | 1901L Street, NW | Suite 700 | Washington | DC | 20036 |
7464 | 7464 | 2019-06-01 | Embassy of Democratic Republic of Congo | 2019-03-15 | CONGO, REPUBLIC OF THE | LFA Holdings INC. 6649 | 2019-03-15 | LFA Holdings INC. | 1100 Connecticut Avenue, NW | #725 | Washington | DC | 20036 |
7466 | 7466 | 2020-06-01 | Komala Representation Office in the U.S. | 2019-02-18 | IRAN | AF International, LLC 6639 | 2019-02-18 | AF International, LLC | 1250 Connecticut Avenue, NW | Washington | DC | 20036 | |
7691 | 7691 | 2017-06-08 | Korea International Trade Association | 2017-05-15 | KOREA, SOUTH | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | 1660 L Street, NW | Suite 401 | Washington | DC | 20036 |
8016 | 8016 | 2006-06-22 | Vardan Barseghyan | 2006-06-22 | NAGORNO KARABAKH | Spencer, William H. 5760 | 2006-06-22 | Spencer, William H. | Office of the Nagorno Karabagh Republic | 1140 19th Street, NW Suite 600 | Washington | DC | 20036 |
8671 | 8671 | 2008-06-30 | Embassy of Vietnam | 2008-06-11 | VIETNAM | Parven Pomper Strategies, Inc. 5781 | 2006-12-19 | Parven Pomper Strategies, Inc. | 1233 20th Street, NW | Suite 400 | Washington | DC | 20036 |
8742 | 8742 | 2017-06-30 | Embassy of the Socialist Republic of Vietnam | 2013-12-12 | VIETNAM | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1233 20th Street, NW | Suite 400 | Washington | DC | 20036 |
9892 | 9892 | 2012-07-31 | Embassy of Chile | 2012-06-28 | CHILE | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1732 Massachusetts Avenue, NW | Washington | DC | 20036 | |
9945 | 9945 | 2022-07-31 | Government of Colombia, Embassy | 2019-08-21 | COLOMBIA | Fratelli Group 5867 | 2008-06-03 | Fratelli Group | 1724 Massachusetts Avenue, NW | Washington | DC | 20036 | |
10543 | 10543 | 2010-08-15 | Republic of the Philippines, Embassy | 2008-02-05 | PHILIPPINES | Eizenstat, Stuart E. 5851 | 2008-02-05 | Eizenstat, Stuart E. | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
10544 | 10544 | 2010-08-15 | Republic of the Philippines, Embassy | 2008-02-05 | PHILIPPINES | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
10588 | 10588 | 2012-08-17 | Principality of Liechtenstein, Embassy | 2008-07-08 | LIECHTENSTEIN | Covington & Burling, LLP 5852 | 2008-02-05 | Covington & Burling, LLP | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
11098 | 11098 | 2006-08-31 | Embassy of Republic of the Philippines | 2005-12-23 | PHILIPPINES | Stanton Communications 5724 | 2005-12-23 | Stanton Communications | 1600 Massachusetts Avenue, NW | Washington | DC | 20036 | |
11113 | 11113 | 2007-08-31 | Embassy of the Republic of Peru through Patton Boggs | 2007-08-03 | PERU | James & Hoffman, PC 5822 | 2007-08-03 | James & Hoffman, PC | 1700 Massachusetts Avenue, NW | Washington | DC | 20036 | |
11299 | 11299 | 2006-09-01 | Kurdish Regional Government (KRG) through Barbour Griffith & Rogers, LLC | 2006-05-19 | IRAQ | Herald Group, LLC 5751 | 2006-05-19 | Herald Group, LLC | 1015 18th Street, N.W., Suite 704 | Washington | DC | 20036 | |
12173 | 12173 | 2007-09-30 | Commonwealth of Australia, Embassy | 2007-07-06 | AUSTRALIA | Bockorny Group, Inc. 5819 | 2007-07-06 | Bockorny Group, Inc. | 1601 Massachusetts Avenue, NW | Washington | DC | 20036 | |
12412 | 12412 | 2011-10-01 | Embassy of the Republic of Indonesia | 2011-06-23 | INDONESIA | Quinn Gillespie & Associates, LLC 5753 | 2006-06-01 | Quinn Gillespie & Associates, LLC | 2020 Massachusetts Avenue, NW | Washington | DC | 20036 | |
12413 | 12413 | 2011-10-01 | Hong Kong Trade Development Council through the Amani Group | 2007-05-11 | HONG KONG | Nurnberger & Associates, Inc. 5809 | 2007-05-11 | Nurnberger & Associates, Inc. | 1520 18th Street, NW | Washington | DC | 20036 | |
12423 | 12423 | 2017-10-01 | Ministry of Justice Uzbekistan Embassy | 2017-09-25 | UZBEKISTAN | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1746 Massachusetts Avenue, NW | Washington | DC | 20036 | |
12636 | 12636 | 2011-10-12 | ProExport Colombia | 2011-04-22 | COLOMBIA | Peck, Madigan, Jones & Stewart 6036 | 2011-04-22 | Peck, Madigan, Jones & Stewart | Colombian Government Trade Bureau | 1901 L Street, NW Suite 700 | Washington | DC | 20036 |
13453 | 13453 | 2011-10-31 | General Delegation of the PLO to the United States | 2011-08-12 | PALESTINE | Bell Pottinger USA, Inc. 6056 | 2011-08-12 | Bell Pottinger USA, Inc. | 1320 18th Street, NW | Suite 200 | Washington | DC | 20036 |
14523 | 14523 | 2006-11-30 | Embassy of Vietnam | 2006-05-22 | VIETNAM | Clark Consulting 5611 | 2004-03-12 | Clark Consulting | 1233 20th Street, NW #400 | Washington | DC | 20036 | |
14553 | 14553 | 2014-11-30 | Embassy of the Republic of Mali to the United States | 2013-05-13 | MALI | Davidoff Hutcher & Citron, LLP 6169 | 2013-05-13 | Davidoff Hutcher & Citron, LLP | 2130 R Street, NW | Washington | DC | 20036 | |
14598 | 14598 | 2022-11-30 | Bayan Sami Abdul Rahman | 2022-05-10 | IRAQ | Berris, Marvin Lou 7114 | 2022-05-10 | Berris, Marvin Lou | 1532 16th Street, NW | Washington | DC | 20036 | |
15053 | 15053 | 2017-12-12 | Moise Katumbi through Akin Gump Strauss Hauer & Feld, LLP | 2017-09-28 | CONGO, REPUBLIC OF THE | RMG Africa Advisors, LLC 6470 | 2017-09-28 | RMG Africa Advisors, LLC | 1333 New Hampshire Avenue, NW | Washington | DC | 20036 | |
16600 | 16600 | 2006-12-31 | Embassy of Vietnam | 2006-12-05 | VIETNAM | Fierce, Isakowitz & Blalock 5654 | 2004-10-29 | Fierce, Isakowitz & Blalock | 1233 20th Street, NW | Suite 400 | Washington | DC | 20036 |
16632 | 16632 | 2008-12-31 | Embassy of the Republic of Peru | 2007-02-27 | PERU | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 1700 Massachusetts Avenue, NW | Washington | DC | 20036 | |
16777 | 16777 | 2016-12-31 | Embassy of Japan through Akin Gump Strauss Hauer & Feld LLP | 2016-08-03 | JAPAN | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 1333 New Hampshire Avenue, NW | Washington | DC | 20036 | |
16811 | 16811 | 2017-12-31 | Korea International Trade Association | 2017-10-26 | KOREA, SOUTH | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 1660 L Street, NW #401 | Washington | DC | 20036 | |
16822 | 16822 | 2018-12-31 | Embassy of the Republic of Kazakhstan in Washington | 2018-06-06 | KAZAKHSTAN | Portland PR Inc. 6064 | 2011-09-19 | Portland PR Inc. | 1401 16th Street, NW | Washington | DC | 20036 | |
16871 | 16871 | 2020-12-31 | Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) | 2019-08-23 | NORWAY | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 2000 M Street, NW | Suite 720 | Washington | DC | 20036 |
16896 | 16896 | 2021-12-31 | Embassy of Kazakhstan USA | 2020-05-01 | KAZAKHSTAN | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 1401 16th St. NW | Washington | DC | 20036 |
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]) );