FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
159 rows where Foreign_Principal_Country = "NIGERIA"
This data as json, CSV (advanced)
Registrant_Name >30
- EVANS GROUP, LTD. 4
- HILL & KNOWLTON, INC. 4
- ARENT FOX KINTNER PLOTKIN & KAHN, PLLC 3
- Conover + Gould Strategic Communications, Inc. 3
- International Strategic & Consulting Group, Inc. 3
- BLACK, KELLY, SCRUGGS & HEALEY 2
- Business Council for International Understanding, Inc. (BCIU) 2
- C/R INTERNATIONAL, L.L.C. 2
- KRL International, LLC 2
- RUDER FINN, INC. 2
- Saint-Louis & Johnson, P.C. 2
- ANDERSON & PENDLETON, C.A. 1
- APCO ASSOCIATES, INC. 1
- Adams, Gregory Robert 1
- Alexander Strategy Group 1
- BARRON-BIRRELL, INC. 1
- BKSH & Associates 1
- Ballard Partners 1
- Bridgeway Advocacy, LLC 1
- Carmen Group Incorporated 1
- Coltrin & Associates, Inc. 1
- Corallo Media Strategies, Inc 1
- EAW GROUP, INC. 1
- ECHOLS, RANDALL EDWIN, SR. 1
- EDWARD AYCOTH & COMPANY, INC. 1
- Fleishman-Hillard, Inc. 1
- GoodWorks International, LLC 1
- Greenberg Traurig, LLP 1
- Hudson Consulting Group 1
- J.C. Watts Companies 1
- …
Foreign_Principal_Name >30
- FEDERAL REPUBLIC OF NIGERIA 5
- GOVERNMENT OF NIGERIA 4
- American University of Nigeria 3
- FEDERAL GOVERNMENT OF NIGERIA 3
- ALHAJI MUHAMMADU DIKKO YUSUFU (THROUGH CAPITAL MISSIONS COMP 2
- BASE PETROLEUM 2
- Abubakar, Atiku 1
- Akwa-Ibom State - Federal Republic of Nigeria 1
- Aspiring candidates for presidency 1
- Atiku Abubakar 1
- Atiku Abubakar, Vice President of Nigeria 1
- Bauchi State Government 1
- Bauchi State Government, Nigeria 1
- Bayelsa State Government (Nigeria) 1
- Bayelsa State Government, Federal Republic of Nigeria through Africana Consultants, LLC 1
- Business Council for International Understanding (BCIU) 1
- CHIEF IKINI 1
- CHIEF S.I. ODOGWU 1
- Chagoury, Gilbert R. 1
- Cross Rivers State Government, Federal Republic of Nigeria through Africana Consultants, LLC 1
- EMBASSY OF NIGERIA 1
- Economic & Financial Crimes Commission of Nigeria 1
- Embassy of the Federal Republic of Nigeria 1
- Embassy of the Federal Republic of Nigeria (through Glover Park Group) 1
- Federal Ministry of Commerce Nigeria 1
- Federal Republic of Nigeria 1
- Gilbert Chagoury 1
- Government of Kaduna State, Nigeria 1
- Government of Nigeria, Embassy 1
- His Excellency Ibrahim Saminu Turaki, Governor Jigawa State 1
- …
Document_Type 2
Foreign_Principal_Country 1
- NIGERIA · 67 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
86420 | 86420 | 2022-08-08 | Bridgeway Advocacy, LLC | Bridgeway Advocacy, LLC 7152 | Exhibit AB | Mount Olive LLC | NIGERIA | https://efile.fara.gov/docs/7152-Exhibit-AB-20220808-1.pdf | |
87127 | 87127 | 2022-08-11 | Olufemi Soneye | Mount Olives LLC 7158 | Exhibit AB | Aspiring candidates for presidency | NIGERIA | https://efile.fara.gov/docs/7158-Exhibit-AB-20220811-2.pdf | |
87464 | 87464 | 2014-08-13 | Conover + Gould Strategic Communications, Inc. | Conover + Gould Strategic Communications, Inc. 6205 | Exhibit AB | American University of Nigeria | NIGERIA | https://efile.fara.gov/docs/6205-Exhibit-AB-20140813-2.pdf | |
87907 | 87907 | 1993-08-16 | J.H.S. GROUP, INC. | J.H.S. Group, Inc. 4941 | Exhibit AB | FEDERAL GOVERNMENT OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/4941-Exhibit-AB-19930816-DFVO7E91.pdf | |
88990 | 88990 | 1995-08-22 | SYMMS, LEHN & ASSOCIATES, INC. | Symms, Lehn & Associates, Inc. 4880 | Exhibit AB | GOVERNMENT OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/4880-Exhibit-AB-19950822-DGENHJ02.pdf | |
89002 | 89002 | 1997-08-22 | RUDER FINN, INC. | Ruder Finn, Inc. 1481 | Exhibit AB | IBRAHIM A. GAMBARI AMB. TO PERMANENT REP. - MISSION OF NIGER | NIGERIA | https://efile.fara.gov/docs/1481-Exhibit-AB-19970822-EITN0R05.pdf | |
89492 | 89492 | 2016-08-24 | Conover + Gould Strategic Communications, Inc. | Conover + Gould Strategic Communications, Inc. 6205 | Exhibit AB | American University of Nigeria | NIGERIA | https://efile.fara.gov/docs/6205-Exhibit-AB-20160824-6.pdf | |
90019 | 90019 | 2015-08-27 | Conover + Gould Strategic Communications, Inc. | Conover + Gould Strategic Communications, Inc. 6205 | Exhibit AB | American University of Nigeria | NIGERIA | https://efile.fara.gov/docs/6205-Exhibit-AB-20150827-4.pdf | |
90740 | 90740 | 1996-08-30 | C/R INTERNATIONAL, L.L.C. | C/R International, L.L.C. 5117 | Exhibit AB | BASE PETROLEUM | NIGERIA | https://efile.fara.gov/docs/5117-Exhibit-AB-19960830-DXXJLK03.pdf | |
91404 | 91404 | 2012-08-31 | Whitaker Group, Inc. | Whitaker Group, Inc. 5539 | Exhibit AB | Embassy of the Federal Republic of Nigeria (through Glover Park Group) | NIGERIA | https://efile.fara.gov/docs/5539-Exhibit-AB-20120831-18.pdf | |
94913 | 94913 | 1993-09-01 | WASHINGTON & CHRISTIAN | Washington & Christian 4569 | Exhibit AB | FEDERAL GOVERNMENT OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/4569-Exhibit-AB-19930901-D1WEEO04.pdf | |
95085 | 95085 | 2020-09-01 | NWG Advocacy LLC (formerly NWG Public Affairs LLC) | NWG Advocacy LLC (formerly NWG Public Affairs LLC) 6834 | Exhibit AB | Gilbert Chagoury | NIGERIA | https://efile.fara.gov/docs/6834-Exhibit-AB-20200901-2.pdf | |
96331 | 96331 | 1995-09-08 | APCO ASSOCIATES, INC. | APCO Worldwide, Inc. 4561 | Exhibit AB | GOVERNMENT OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/4561-Exhibit-AB-19950908-DIJYHI03.pdf | |
97159 | 97159 | 1989-09-12 | EVANS GROUP, LTD. | Evans Group, Ltd. 4222 | Exhibit AB | OONI OF IFE | NIGERIA | https://efile.fara.gov/docs/4222-Exhibit-AB-19890912-D1OP8602.pdf | |
97160 | 97160 | 1989-09-12 | EVANS GROUP, LTD. | Evans Group, Ltd. 4222 | Exhibit AB | PRINCE ADEDAPO A. SIJUWADE | NIGERIA | https://efile.fara.gov/docs/4222-Exhibit-AB-19890912-D1OP7Q02.pdf | |
97161 | 97161 | 1989-09-12 | EVANS GROUP, LTD. | Evans Group, Ltd. 4222 | Exhibit AB | PROFESSOR OYOVBAIRE | NIGERIA | https://efile.fara.gov/docs/4222-Exhibit-AB-19890912-D1OP7A02.pdf | |
97353 | 97353 | 2022-09-12 | The Public Policy Advocacy and Research Council | The Public Policy Advocacy and Research Council 7168 | Exhibit AB | Atiku Abubakar | NIGERIA | https://efile.fara.gov/docs/7168-Exhibit-AB-20220912-1.pdf | |
97484 | 97484 | 2013-09-13 | McBee Strategic Consulting, LLC | McBee Strategic Consulting, LLC 6176 | Exhibit AB | Embassy of the Federal Republic of Nigeria | NIGERIA | https://efile.fara.gov/docs/6176-Exhibit-AB-20130913-2.pdf | |
97956 | 97956 | 2005-09-15 | Richard T. Hines Consulting, Inc. | Richard T. Hines Consulting, Inc. 5659 | Exhibit AB | Akwa-Ibom State - Federal Republic of Nigeria | NIGERIA | https://efile.fara.gov/docs/5659-Exhibit-AB-20050915-1.pdf | |
98917 | 98917 | 2006-09-19 | Business Council for International Understanding, Inc. (BCIU) | Business Council for International Understanding, Inc. (BCIU) 5713 | Exhibit AB | Nigerian Investment Promotion Commission (NIPC) | NIGERIA | https://efile.fara.gov/docs/5713-Exhibit-AB-20060919-3.pdf | |
99099 | 99099 | 1995-09-20 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Exhibit AB | CHIEF S.I. ODOGWU | NIGERIA | https://efile.fara.gov/docs/3301-Exhibit-AB-19950920-DOZXFM02.pdf | |
99308 | 99308 | 1992-09-21 | LAW OFFICE OF STEWART & STEWART | Law Office of Stewart & Stewart 4709 | Exhibit AB | NEWPAK VENTURES | NIGERIA | https://efile.fara.gov/docs/4709-Exhibit-AB-19920921-D1XRA602.pdf | |
99389 | 99389 | 2007-09-21 | Watts Consulting Group (J.C. Watts Companies) | Watts Partners (J.C. Watts Companies) 5641 | Exhibit AB | Federal Republic of Nigeria | NIGERIA | https://efile.fara.gov/docs/5641-Exhibit-AB-20070921-11.pdf | |
100426 | 100426 | 2018-09-25 | Ballard Partners | Ballard Partners 6415 | Exhibit AB | People's Democratic Party of Nigeria | NIGERIA | https://efile.fara.gov/docs/6415-Exhibit-AB-20180925-13.pdf | |
101075 | 101075 | 2000-09-28 | International Strategic & Consulting Group, Inc. | International Strategic & Consulting Group, Inc. 5387 | Exhibit AB | Bauchi State Government | NIGERIA | https://efile.fara.gov/docs/5387-Exhibit-AB-20000928-GI65P001.pdf | |
101076 | 101076 | 2000-09-28 | International Strategic & Consulting Group, Inc. | International Strategic & Consulting Group, Inc. 5387 | Exhibit AB | Taraba State Government | NIGERIA | https://efile.fara.gov/docs/5387-Exhibit-AB-20000928-GI65RO01.pdf | |
101077 | 101077 | 2000-09-28 | International Strategic & Consulting Group, Inc. | International Strategic & Consulting Group, Inc. 5387 | Exhibit AB | Yobe State Government | NIGERIA | https://efile.fara.gov/docs/5387-Exhibit-AB-20000928-GI65V901.pdf | |
101376 | 101376 | 2006-09-29 | Adams, Gregory Robert | Adams, Gregory Robert 5771 | Exhibit AB | Ministry of Solid Minerals Development | NIGERIA | https://efile.fara.gov/docs/5771-Exhibit-AB-20060929-1.pdf | |
102565 | 102565 | 2018-09-30 | KRL International, LLC | KRL International, LLC 5788 | Exhibit AB | Retail Express Limited of Lagos, Nigeria | NIGERIA | https://efile.fara.gov/docs/5788-Exhibit-AB-20180930-27.pdf | |
103772 | 103772 | 1984-10-01 | PRATHER, SEEGER, DOOLITTLE & FARMER | Prather, Seeger, Doolittle & Farmer 1815 | Exhibit AB | FEDERAL REPUBLIC OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/1815-Exhibit-AB-19841001-D7PG7302.pdf | |
103816 | 103816 | 1985-10-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Exhibit AB | GOVERNMENT OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/3600-Exhibit-AB-19851001-D0XB2K01.pdf | |
107527 | 107527 | 2010-10-08 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Exhibit AB | Office of the President of the Federal Republic of Nigeria | NIGERIA | https://efile.fara.gov/docs/5801-Exhibit-AB-20101008-10.pdf | |
107687 | 107687 | 1997-10-09 | RUDER FINN, INC. | Ruder Finn, Inc. 1481 | Exhibit AB | PERMANENT MISSION OF NIGERIA TO THE UNITED NATIONS | NIGERIA | https://efile.fara.gov/docs/1481-Exhibit-AB-19971009-EKINKH06.pdf | |
107703 | 107703 | 2001-10-09 | Manchester Trade, Ltd. | Manchester Trade, Ltd. 5438 | Exhibit AB | Federal Ministry of Commerce Nigeria | NIGERIA | https://efile.fara.gov/docs/5438-Exhibit-AB-20011009-H5XZRQ03.pdf | |
107727 | 107727 | 2012-10-09 | Greenberg Traurig, LLP | Greenberg Traurig, LLP 5712 | Exhibit AB | Office of Governor of Bayelsa State, Nigeria through Washington Avenue International LLC | NIGERIA | https://efile.fara.gov/docs/5712-Exhibit-AB-20121009-17.pdf | |
107966 | 107966 | 2012-10-10 | Washington Avenue International LLC | Washington Avenue International LLC 6135 | Exhibit AB | Office of Governor, Bayelsa State of Nigeria | NIGERIA | https://efile.fara.gov/docs/6135-Exhibit-AB-20121010-1.pdf | |
108710 | 108710 | 2005-10-14 | J.C. Watts Companies | Watts Partners (J.C. Watts Companies) 5641 | Exhibit AB | Atiku Abubakar, Vice President of Nigeria | NIGERIA | https://efile.fara.gov/docs/5641-Exhibit-AB-20051014-2.pdf | |
108895 | 108895 | 1998-10-15 | EAW GROUP, INC. | EAW Group, Inc. 5284 | Exhibit AB | FEDERAL REPUBLIC OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/5284-Exhibit-AB-19981015-F2KM7B03.pdf | |
109491 | 109491 | 1999-10-18 | Patton Boggs, L.L.P. | Squire Patton Boggs, LLP 2165 | Exhibit AB | National Council on Privatisation | NIGERIA | https://efile.fara.gov/docs/2165-Exhibit-AB-19991018-HI6KOW01.pdf | |
109771 | 109771 | 2005-10-19 | Business Council for International Understanding, Inc. (BCIU) | Business Council for International Understanding, Inc. (BCIU) 5713 | Exhibit AB | Nigerian Investment Promotion Commission | NIGERIA | https://efile.fara.gov/docs/5713-Exhibit-AB-20051019-1.pdf | |
109843 | 109843 | 2018-10-19 | Corallo Media Strategies, Inc | Corallo Media Strategies, Inc 6602 | Exhibit AB | Chagoury, Gilbert R. | NIGERIA | https://efile.fara.gov/docs/6602-Exhibit-AB-20181019-1.pdf | |
110168 | 110168 | 1991-10-21 | ARENT FOX KINTNER PLOTKIN & KAHN, PLLC | Arent Fox Kintner Plotkin & Kahn, PLLC 2661 | Exhibit AB | FEDERAL REPUBLIC OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/2661-Exhibit-AB-19911021-D054S804.pdf | |
110169 | 110169 | 1991-10-21 | ARENT FOX KINTNER PLOTKIN & KAHN, PLLC | Arent Fox Kintner Plotkin & Kahn, PLLC 2661 | Exhibit AB | LAGOS STATE NIGERIA | NIGERIA | https://efile.fara.gov/docs/2661-Exhibit-AB-19911021-D03YN103.pdf | |
110170 | 110170 | 1991-10-21 | ARENT FOX KINTNER PLOTKIN & KAHN, PLLC | Arent Fox Kintner Plotkin & Kahn, PLLC 2661 | Exhibit AB | LAPEC NIGERIA, LTD. | NIGERIA | https://efile.fara.gov/docs/2661-Exhibit-AB-19911021-D056BD04.pdf | |
110644 | 110644 | 2006-10-23 | Carmen Group Incorporated | Carmen Group Incorporated 5727 | Exhibit AB | Bayelsa State Government (Nigeria) | NIGERIA | https://efile.fara.gov/docs/5727-Exhibit-AB-20061023-2.pdf | |
111326 | 111326 | 2005-10-26 | Saint-Louis & Johnson, P.C. | Saint-Louis & Johnson, P.C. 5717 | Exhibit AB | Bayelsa State Government, Federal Republic of Nigeria through Africana Consultants, LLC | NIGERIA | https://efile.fara.gov/docs/5717-Exhibit-AB-20051026-2.pdf | |
111327 | 111327 | 2005-10-26 | Saint-Louis & Johnson, P.C. | Saint-Louis & Johnson, P.C. 5717 | Exhibit AB | Cross Rivers State Government, Federal Republic of Nigeria through Africana Consultants, LLC | NIGERIA | https://efile.fara.gov/docs/5717-Exhibit-AB-20051026-1.pdf | |
115368 | 115368 | 1990-11-01 | EDWARD AYCOTH & COMPANY, INC. | Edward Aycoth & Company, Inc. 4436 | Exhibit AB | FEDERAL REPUBLIC OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/4436-Exhibit-AB-19901101-D1PPPI02.pdf | |
116633 | 116633 | 1993-11-01 | WILLIAMS, E. FAYE | Williams, E. Faye 4869 | Exhibit AB | FEDERAL GOVERNMENT OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/4869-Exhibit-AB-19931101-D1YHB402.pdf | |
116900 | 116900 | 1992-11-02 | BARRON-BIRRELL, INC. | Barron-Birrell, Inc. 4729 | Exhibit AB | FEDERAL REPUBLIC OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/4729-Exhibit-AB-19921102-D1XT7T02.pdf | |
118037 | 118037 | 2007-11-07 | Hudson Consulting Group | Hudson Consulting Group 5837 | Exhibit AB | Bauchi State Government, Nigeria | NIGERIA | https://efile.fara.gov/docs/5837-Exhibit-AB-20071107-1.pdf | |
118927 | 118927 | 1998-11-12 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Exhibit AB | ALHAJI MUHAMMADU DIKKO YUSUFU (THROUGH CAPITAL MISSIONS COMP | NIGERIA | https://efile.fara.gov/docs/3301-Exhibit-AB-19981112-F390G304.pdf | |
120154 | 120154 | 1998-11-17 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Exhibit AB | ALHAJI MUHAMMADU DIKKO YUSUFU (THROUGH CAPITAL MISSIONS COMP | NIGERIA | https://efile.fara.gov/docs/3301-Exhibit-AB-19981117-F390BL04.pdf | |
121077 | 121077 | 2013-11-21 | Patton Boggs, LLP | Squire Patton Boggs, LLP 2165 | Exhibit AB | Office of the National Security Advisor | NIGERIA | https://efile.fara.gov/docs/2165-Exhibit-AB-20131121-49.pdf | |
121421 | 121421 | 2007-11-23 | KRL International, LLC | KRL International, LLC 5788 | Exhibit AB | Economic & Financial Crimes Commission of Nigeria | NIGERIA | https://efile.fara.gov/docs/5788-Exhibit-AB-20071123-5.pdf | |
124508 | 124508 | 1976-12-01 | ANDERSON & PENDLETON, C.A. | Anderson & Pendleton, C.A. 2696 | Exhibit AB | EMBASSY OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/2696-Exhibit-AB-19761201-D03IR803.pdf | |
126180 | 126180 | 1989-12-01 | EVANS GROUP, LTD. | Evans Group, Ltd. 4222 | Exhibit AB | CHIEF IKINI | NIGERIA | https://efile.fara.gov/docs/4222-Exhibit-AB-19891201-D1OP4702.pdf | |
127880 | 127880 | 1993-12-01 | ECHOLS, RANDALL EDWIN, SR. | Echols, Randall Edwin, Sr. 4873 | Exhibit AB | M.K.O. ABIOLA (NIGERIAN PRESIDENT - ELECT) | NIGERIA | https://efile.fara.gov/docs/4873-Exhibit-AB-19931201-D1YI4D02.pdf | |
128917 | 128917 | 1996-12-04 | C/R INTERNATIONAL, L.L.C. | C/R International, L.L.C. 5117 | Exhibit AB | BASE PETROLEUM | NIGERIA | https://efile.fara.gov/docs/5117-Exhibit-AB-19961204-E4TZCV04.pdf | |
128952 | 128952 | 2006-12-04 | GoodWorks International, LLC | GoodWorks International, LLC 5414 | Exhibit AB | Government of Kaduna State, Nigeria | NIGERIA | https://efile.fara.gov/docs/5414-Exhibit-AB-20061204-13.pdf | |
129050 | 129050 | 2019-12-04 | Mercury Public Affairs, LLC | Mercury Public Affairs, LLC 6170 | Informational Materials | Government of Nigeria, Embassy | NIGERIA | https://efile.fara.gov/docs/6170-Informational-Materials-20191204-211.pdf | |
130502 | 130502 | 1996-12-12 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Exhibit AB | S. I. ODOGWU | NIGERIA | https://efile.fara.gov/docs/3301-Exhibit-AB-19961212-E4290503.pdf | |
130861 | 130861 | 2000-12-14 | BKSH & Associates | BKSH & Associates 5402 | Exhibit AB | His Excellency Ibrahim Saminu Turaki, Governor Jigawa State | NIGERIA | https://efile.fara.gov/docs/5402-Exhibit-AB-20001214-GJVMRM01.pdf | |
131966 | 131966 | 2005-12-19 | Alexander Strategy Group | Alexander Strategy Group 5557 | Exhibit AB | Abubakar, Atiku | NIGERIA | https://efile.fara.gov/docs/5557-Exhibit-AB-20051219-1.pdf | |
132132 | 132132 | 1989-12-20 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Exhibit AB | GOVERNMENT OF NIGERIA | NIGERIA | https://efile.fara.gov/docs/3600-Exhibit-AB-19891220-D0X9Y003.pdf | |
133537 | 133537 | 2006-12-26 | Coltrin & Associates, Inc. | Coltrin & Associates, Inc. 5782 | Exhibit AB | Business Council for International Understanding (BCIU) | NIGERIA | https://efile.fara.gov/docs/5782-Exhibit-AB-20061226-1.pdf | |
133691 | 133691 | 2005-12-27 | Whitaker Group, LLC | Whitaker Group, Inc. 5539 | Exhibit AB | Nigerian Export Promotion Council | NIGERIA | https://efile.fara.gov/docs/5539-Exhibit-AB-20051227-4.pdf |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );