FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
59 rows where Country/Location_Represented = "CONGO, DEMOCRATIC REPUBLIC OF THE" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 51
- Barron-Birrell, Inc. 3
- Garrett & Company 3
- I.S.I. Enterprises, Inc. 3
- Courville Consultants, LLC 2
- van Kloberg & Associates, Ltd. 2
- Aaron Poynton 1
- Abandelwa, Jacques 1
- Abramoff, Jack Alan 1
- Avenue Strategies, LLC 1
- Baker & McKenzie 1
- Ballard Partners 1
- Brownstein Hyatt Farber Schreck, LLP 1
- Buckley Pell Associates, Inc. 1
- CLS Strategies 1
- DCI Group AZ, LLC 1
- Dickens & Madson Canada Inc. 1
- Empire Solutions Consulting, LLC 1
- Endsight Consulting LLC 1
- Eurafrica Communications, Inc. 1
- FGS Global (US) LLC (FKA FGH Holdings LLC) 1
- Future Pact LLC 1
- Gray Global Advisors, LLC 1
- Greystone Global Strategies 1
- Hannaford Company, Inc. 1
- Herman J. Cohen & Associates 1
- Isaiah King 1
- Ivkovic, Milos 1
- Keesing, John Maurice 1
- King & Spalding LLP 1
- Livingston Group, LLC 1
- Loeffler Group, LLP 1
- MPD Consultants, LLC 1
- Manatt, Phelps & Phillips 1
- McKenna & Cuneo 1
- Merritt Group, Ltd. 1
- Milburn McCarty Associates, Inc. 1
- Moffett Group, LLC 1
- O'Neill and Associates, LLC 1
- Overseas Regional Surveys Associates 1
- PSC International, Ltd. 1
- Pepper, Hamilton & Scheetz 1
- Platt, Edwin Alan 1
- Rasky Baerlein Strategic Communications, Inc. 1
- Sanitas International, LLC 1
- Saunders, Gerald N. 1
- Scribe Strategies & Advisors, Inc. 1
- Semmes, Bowen & Semmes 1
- Squire, Sanders & Dempsey, L.L.P. 1
- Trout Cacheris, PLLC 1
- Vanguard Africa 1
- Washington International Group, Inc. 1
Foreign_Principal 50
- Republic of Congo 5
- Eurafrica Communications, Inc. 2
- Government of the Congo 2
- Pascal Lissouba 2
- Republic of the Congo 2
- The Honorable Moise Katumbi Chapwe 2
- Ambassador Serge Mombouli 1
- Circle of Democrats and Republicans of Congo aka Cercle des Democrates et Republicains du Congo 1
- Comoil, S.A. 1
- Congo, Democratic Republic of The 1
- Costel Iancu 1
- Denis Sassou Nguesso, President of the Republic of Congo, through Trout Cacheris PLLC 1
- Denis Sassou Nguesso, President of the Republic of the Congo 1
- Denis Sassou-Nguesso 1
- Denis Sassou-Nguesso, President of The Republic of the Congo 1
- Embassy of Democratic Republic Congo 1
- Embassy of the Republic of Congo 1
- Government of Democratic Republic of Congo 1
- Government of the Democratic Republic of the Congo 1
- Government of the Republic of the Congo 1
- Government of the Republic of the Congo (Leopoldville) 1
- Government of the Republic of the Congo via Empire Solutions LLC 1
- Government of the Republic of the Congo, Office of the President 1
- H.E. Benjamin Bongoulou 1
- Honorable Minister Andre Okombi Salissa - Republic of Congo 1
- Martin Fayulu 1
- Masuka Fifi Saini 1
- Ministere de la Defense Nationale, Republique du Congo 1
- Ministry of Communication and Medias of the Democratic Republic of Congo 1
- Moise Katumbi 1
- Moise Katumbi Chapwe 1
- Office of President of Republic of Congo through Amani Group 1
- Office of President of the Republic of Congo through Trout Cacheris 1
- Office of the President of the National Assembly 1
- Office of the President of the Republic of Congo through Trout Cacheris, PLLC 1
- Office of the President, Congo Republic 1
- Office of the President, Denis Sassou-Nguesso 1
- Parti des democrates pour le developpement du Congo (PDDCO) 1
- President Pascal Lissouba 1
- President of Republic of Congo, through Loeffler Group LLP 1
- President of the Republic of Congo, through Amani Group LLP 1
- Republic of Congo - Brazzaville via Obermayer and Adams, LLP 1
- Republic of Congo through Obermayer and Adams 1
- Republic of the Congo President Denis Sassou-Nguesso 1
- Republic of the Congo through PSC International, Ltd., its public affairs agent 1
- Republic of the Congo, Central Government 1
- Republic of the Congo, Office of the President 1
- The Government of the Democratic Republic of Congo 1
- The Government of the Democratic Republic of the Congo, Ministry of Communications and Media 1
- The Honorable Moise Katumbi Chapwe through King & Spalding LLP 1
Foreign_Principal_Termination_Date 44 ✖
- - 14
- 1991-03-31 2
- 1992-03-31 2
- 1962-11-09 1
- 1963-06-30 1
- 1964-12-04 1
- 1965-06-02 1
- 1967-07-10 1
- 1990-02-28 1
- 1991-04-30 1
- 1992-05-15 1
- 1992-12-02 1
- 1993-06-10 1
- 1993-06-23 1
- 1993-10-14 1
- 1994-02-04 1
- 1994-09-29 1
- 1994-10-04 1
- 1995-02-06 1
- 1995-04-20 1
- 1995-10-13 1
- 1996-12-31 1
- 1998-04-30 1
- 1999-02-28 1
- 2002-12-31 1
- 2004-10-31 1
- 2008-07-28 1
- 2009-02-28 1
- 2009-05-31 1
- 2009-12-01 1
- 2009-12-31 1
- 2011-02-18 1
- 2011-03-17 1
- 2011-03-30 1
- 2011-03-31 1
- 2011-09-30 1
- 2014-06-15 1
- 2017-06-21 1
- 2018-04-30 1
- 2018-12-31 1
- 2019-04-01 1
- 2020-12-31 1
- 2021-11-15 1
- 2022-04-30 1
City 8
- - 45
- Washington 4
- Brazzaville 2
- Brussels 2
- Kinshasa 2
- New York 2
- Bucharest 1
- Kinshasha 1
Country/Location_Represented 1
- CONGO, DEMOCRATIC REPUBLIC OF THE · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16882 | 16882 | 2020-12-31 | Office of the President of the National Assembly | 2020-08-04 | CONGO, DEMOCRATIC REPUBLIC OF THE | Greystone Global Strategies 6846 | 2020-08-04 | Greystone Global Strategies | People's Palace | Kinshasa | |||
16821 | 16821 | 2018-12-31 | Circle of Democrats and Republicans of Congo aka Cercle des Democrates et Republicains du Congo | 2018-03-01 | CONGO, DEMOCRATIC REPUBLIC OF THE | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 45 Mabida Street, Makelekele, | ||||
16655 | 16655 | 2009-12-31 | Denis Sassou Nguesso, President of the Republic of Congo, through Trout Cacheris PLLC | 2006-10-06 | CONGO, DEMOCRATIC REPUBLIC OF THE | CLS Strategies 5774 | 2006-10-06 | CLS Strategies | |||||
16519 | 16519 | 2002-12-31 | Government of the Congo | 2002-09-16 | CONGO, DEMOCRATIC REPUBLIC OF THE | Barron-Birrell, Inc. 5363 | 1997-12-09 | Barron-Birrell, Inc. | Office of the Congo | ||||
16405 | 16405 | 1996-12-31 | Republic of the Congo, Office of the President | 1993-02-04 | CONGO, DEMOCRATIC REPUBLIC OF THE | PSC International, Ltd. 4559 | 1991-08-28 | PSC International, Ltd. | |||||
14778 | 14778 | 1964-12-04 | Ministere de la Defense Nationale, Republique du Congo | 1962-08-20 | CONGO, DEMOCRATIC REPUBLIC OF THE | Keesing, John Maurice 1091 | 1957-11-27 | Keesing, John Maurice | Leopoldville | ||||
14756 | 14756 | 1992-12-02 | Office of the President, Congo Republic | 1991-04-05 | CONGO, DEMOCRATIC REPUBLIC OF THE | Eurafrica Communications, Inc. 4497 | 1991-04-05 | Eurafrica Communications, Inc. | |||||
14723 | 14723 | 2009-12-01 | Office of President of the Republic of Congo through Trout Cacheris | 2008-09-25 | CONGO, DEMOCRATIC REPUBLIC OF THE | Gray Global Advisors, LLC 5806 | 2007-05-07 | Gray Global Advisors, LLC | Brazzaville | ||||
14006 | 14006 | 2021-11-15 | Moise Katumbi Chapwe | 2021-07-30 | CONGO, DEMOCRATIC REPUBLIC OF THE | Platt, Edwin Alan 6984 | 2021-07-30 | Platt, Edwin Alan | Winston Churchill 194 | Brussels | |||
13843 | 13843 | 1962-11-09 | Government of the Republic of the Congo (Leopoldville) | 1961-11-09 | CONGO, DEMOCRATIC REPUBLIC OF THE | Overseas Regional Surveys Associates 1490 | 1961-11-09 | Overseas Regional Surveys Associates | |||||
13417 | 13417 | 2004-10-31 | Republic of Congo | 2000-06-22 | CONGO, DEMOCRATIC REPUBLIC OF THE | Manatt, Phelps & Phillips 5171 | 1997-04-11 | Manatt, Phelps & Phillips | |||||
12678 | 12678 | 1993-10-14 | Office of the President, Denis Sassou-Nguesso | 1989-08-08 | CONGO, DEMOCRATIC REPUBLIC OF THE | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | |||||
12647 | 12647 | 1995-10-13 | Republic of the Congo | 1995-06-13 | CONGO, DEMOCRATIC REPUBLIC OF THE | Barron-Birrell, Inc. 4729 | 1992-11-02 | Barron-Birrell, Inc. | |||||
12469 | 12469 | 1994-10-04 | Republic of Congo | 1994-10-04 | CONGO, DEMOCRATIC REPUBLIC OF THE | Buckley Pell Associates, Inc. 4957 | 1994-10-04 | Buckley Pell Associates, Inc. | |||||
12204 | 12204 | 2011-09-30 | Republic of Congo - Brazzaville via Obermayer and Adams, LLP | 2011-03-22 | CONGO, DEMOCRATIC REPUBLIC OF THE | Empire Solutions Consulting, LLC 6027 | 2011-03-22 | Empire Solutions Consulting, LLC | Obermayer and Adams, LLP | 1123 Broadway, Suite 1117 | New York | NY | 10010 |
11896 | 11896 | 1994-09-29 | Republic of the Congo through PSC International, Ltd., its public affairs agent | 1993-08-05 | CONGO, DEMOCRATIC REPUBLIC OF THE | Semmes, Bowen & Semmes 4842 | 1993-08-05 | Semmes, Bowen & Semmes | Beaufort | SC | |||
9573 | 9573 | 2008-07-28 | Office of the President of the Republic of Congo through Trout Cacheris, PLLC | 2006-10-06 | CONGO, DEMOCRATIC REPUBLIC OF THE | Livingston Group, LLC 5356 | 2000-01-31 | Livingston Group, LLC | |||||
9151 | 9151 | 1967-07-10 | Government of the Congo | 1965-01-07 | CONGO, DEMOCRATIC REPUBLIC OF THE | Saunders, Gerald N. 1838 | 1965-01-07 | Saunders, Gerald N. | Leopoldville | ||||
8247 | 8247 | 1963-06-30 | Republic of the Congo, Central Government | 1962-02-06 | CONGO, DEMOCRATIC REPUBLIC OF THE | Milburn McCarty Associates, Inc. 1514 | 1962-02-06 | Milburn McCarty Associates, Inc. | Leopoldville | ||||
8037 | 8037 | 1993-06-23 | H.E. Benjamin Bongoulou | 1992-12-18 | CONGO, DEMOCRATIC REPUBLIC OF THE | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | |||||
7995 | 7995 | 2017-06-21 | Costel Iancu | 2017-06-21 | CONGO, DEMOCRATIC REPUBLIC OF THE | Abramoff, Jack Alan 6439 | 2017-06-21 | Abramoff, Jack Alan | Global Structures Group | Benjamin Franklin St., No. 9, Et. 3, Ap. 6, Sector 1, | Bucharest | ||
7860 | 7860 | 2014-06-15 | Honorable Minister Andre Okombi Salissa - Republic of Congo | 2014-05-16 | CONGO, DEMOCRATIC REPUBLIC OF THE | Rasky Baerlein Strategic Communications, Inc. 6222 | 2014-05-16 | Rasky Baerlein Strategic Communications, Inc. | 1 Rue Mboko Moungali | ||||
7733 | 7733 | 1993-06-10 | Republic of the Congo | 1992-09-23 | CONGO, DEMOCRATIC REPUBLIC OF THE | Pepper, Hamilton & Scheetz 4707 | 1992-09-23 | Pepper, Hamilton & Scheetz | |||||
7479 | 7479 | 1965-06-02 | Republic of Congo | 1962-07-19 | CONGO, DEMOCRATIC REPUBLIC OF THE | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | Washington | DC | |||
7224 | 7224 | 2009-05-31 | President of the Republic of Congo, through Amani Group LLP | 2008-10-06 | CONGO, DEMOCRATIC REPUBLIC OF THE | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | |||||
6570 | 6570 | 1992-05-15 | Republic of Congo | 1991-12-11 | CONGO, DEMOCRATIC REPUBLIC OF THE | van Kloberg & Associates, Ltd. 3466 | 1983-05-09 | van Kloberg & Associates, Ltd. | |||||
6122 | 6122 | 2022-04-30 | The Honorable Moise Katumbi Chapwe | 2021-09-16 | CONGO, DEMOCRATIC REPUBLIC OF THE | DCI Group AZ, LLC 6278 | 2015-03-03 | DCI Group AZ, LLC | Winston Churchill 194 | 1000 Brussels | |||
6094 | 6094 | 2018-04-30 | Embassy of the Republic of Congo | 2015-11-13 | CONGO, DEMOCRATIC REPUBLIC OF THE | Courville Consultants, LLC 6327 | 2015-11-13 | Courville Consultants, LLC | 1720 16th Street Ave, NW | Washington | DC | 20009 | |
5970 | 5970 | 1998-04-30 | Pascal Lissouba | 1997-12-09 | CONGO, DEMOCRATIC REPUBLIC OF THE | Barron-Birrell, Inc. 5363 | 1997-12-09 | Barron-Birrell, Inc. | Brazzaville | ||||
5863 | 5863 | 1991-04-30 | Comoil, S.A. | 1990-07-16 | CONGO, DEMOCRATIC REPUBLIC OF THE | I.S.I. Enterprises, Inc. 4399 | 1990-07-16 | I.S.I. Enterprises, Inc. | |||||
5434 | 5434 | 1995-04-20 | President Pascal Lissouba | 1994-09-27 | CONGO, DEMOCRATIC REPUBLIC OF THE | Herman J. Cohen & Associates 4952 | 1994-09-27 | Herman J. Cohen & Associates | |||||
4968 | 4968 | 2019-04-01 | Ambassador Serge Mombouli | 2018-11-05 | CONGO, DEMOCRATIC REPUBLIC OF THE | Courville Consultants, LLC 6606 | 2018-11-05 | Courville Consultants, LLC | 1720 16th Street, NW | Washington | DC | 20009 | |
4714 | 4714 | 2011-03-31 | Office of President of Republic of Congo through Amani Group | 2008-10-17 | CONGO, DEMOCRATIC REPUBLIC OF THE | Moffett Group, LLC 5802 | 2007-04-17 | Moffett Group, LLC | Brazzaville | ||||
4515 | 4515 | 1992-03-31 | Eurafrica Communications, Inc. | 1991-05-07 | CONGO, DEMOCRATIC REPUBLIC OF THE | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Washington | DC | |||
4514 | 4514 | 1992-03-31 | Eurafrica Communications, Inc. | 1991-05-03 | CONGO, DEMOCRATIC REPUBLIC OF THE | I.S.I. Enterprises, Inc. 4399 | 1990-07-16 | I.S.I. Enterprises, Inc. | Washington | DC | |||
4509 | 4509 | 1991-03-31 | Republic of the Congo President Denis Sassou-Nguesso | 1990-07-16 | CONGO, DEMOCRATIC REPUBLIC OF THE | I.S.I. Enterprises, Inc. 4399 | 1990-07-16 | I.S.I. Enterprises, Inc. | |||||
4498 | 4498 | 1991-03-31 | Denis Sassou-Nguesso, President of The Republic of the Congo | 1990-07-25 | CONGO, DEMOCRATIC REPUBLIC OF THE | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Brazzaville | ||||
4237 | 4237 | 2011-03-30 | Denis Sassou-Nguesso | 2006-02-21 | CONGO, DEMOCRATIC REPUBLIC OF THE | Trout Cacheris, PLLC 5733 | 2006-02-21 | Trout Cacheris, PLLC | Brazzaville | ||||
3853 | 3853 | 2011-03-17 | Government of the Republic of the Congo via Empire Solutions LLC | 2011-03-15 | CONGO, DEMOCRATIC REPUBLIC OF THE | Sanitas International, LLC 5963 | 2009-11-18 | Sanitas International, LLC | 1123 Broadway, Suite 1117 | New York | NY | 10010 | |
3086 | 3086 | 2009-02-28 | President of Republic of Congo, through Loeffler Group LLP | 2008-10-09 | CONGO, DEMOCRATIC REPUBLIC OF THE | MPD Consultants, LLC 5540 | 2003-02-25 | MPD Consultants, LLC | |||||
3035 | 3035 | 1999-02-28 | Pascal Lissouba | 1998-08-17 | CONGO, DEMOCRATIC REPUBLIC OF THE | Merritt Group, Ltd. 5270 | 1998-08-17 | Merritt Group, Ltd. | Surrey | ||||
2959 | 2959 | 1990-02-28 | Denis Sassou Nguesso, President of the Republic of the Congo | 1989-08-11 | CONGO, DEMOCRATIC REPUBLIC OF THE | Garrett & Company 4279 | 1989-08-11 | Garrett & Company | |||||
2660 | 2660 | 2011-02-18 | Republic of Congo through Obermayer and Adams | 2011-02-18 | CONGO, DEMOCRATIC REPUBLIC OF THE | O'Neill and Associates, LLC 6020 | 2011-02-18 | O'Neill and Associates, LLC | 4891 Colorado Avenue, NW | Washington | DC | 20011 | |
2247 | 2247 | 1995-02-06 | Government of the Republic of the Congo | 1993-03-05 | CONGO, DEMOCRATIC REPUBLIC OF THE | McKenna & Cuneo 4530 | 1991-06-20 | McKenna & Cuneo | |||||
2200 | 2200 | 1994-02-04 | Government of the Republic of the Congo, Office of the President | 1993-02-09 | CONGO, DEMOCRATIC REPUBLIC OF THE | Washington International Group, Inc. 3320 | 1982-01-05 | Washington International Group, Inc. | |||||
698 | 698 | The Honorable Moise Katumbi Chapwe | 2021-06-08 | CONGO, DEMOCRATIC REPUBLIC OF THE | King & Spalding LLP 6501 | 2017-12-21 | King & Spalding LLP | Winston Churhill 194 | 1000 Brussels | ||||
697 | 697 | The Honorable Moise Katumbi Chapwe through King & Spalding LLP | 2021-07-15 | CONGO, DEMOCRATIC REPUBLIC OF THE | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | Winston Churchill 194 | 1000 Brussels | ||||
694 | 694 | The Government of the Democratic Republic of the Congo, Ministry of Communications and Media | 2022-03-25 | CONGO, DEMOCRATIC REPUBLIC OF THE | Scribe Strategies & Advisors, Inc. 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | ||||||
693 | 693 | The Government of the Democratic Republic of Congo | 2020-05-08 | CONGO, DEMOCRATIC REPUBLIC OF THE | Baker & McKenzie 6821 | 2020-05-08 | Baker & McKenzie | Kinshasa | |||||
582 | 582 | Republic of Congo | 2018-07-24 | CONGO, DEMOCRATIC REPUBLIC OF THE | Dickens & Madson Canada Inc. 6200 | 2013-12-11 | Dickens & Madson Canada Inc. | Office of the President, Republic of Congo | Brazzaville | ||||
554 | 554 | Parti des democrates pour le developpement du Congo (PDDCO) | 2021-04-28 | CONGO, DEMOCRATIC REPUBLIC OF THE | Abandelwa, Jacques 6950 | 2021-04-28 | Abandelwa, Jacques | No 4 Mbudi Fleuve Avenue | Mont Ngafula, Kinshasa | ||||
493 | 493 | Moise Katumbi | 2021-08-05 | CONGO, DEMOCRATIC REPUBLIC OF THE | Ivkovic, Milos 6987 | 2021-08-05 | Ivkovic, Milos | Winston Churchill 194 | Brussels | ||||
461 | 461 | Ministry of Communication and Medias of the Democratic Republic of Congo | 2022-03-18 | CONGO, DEMOCRATIC REPUBLIC OF THE | Ballard Partners 7070 | 2022-01-13 | Ballard Partners | 83 Avenue Tabu-Ley | Kinshasa | ||||
453 | 453 | Masuka Fifi Saini | 2023-04-05 | CONGO, DEMOCRATIC REPUBLIC OF THE | Aaron Poynton 7254 | 2023-04-05 | Aaron Poynton | Hotel du Gouvernement (2 Niveau) | Route Kazemba Kolwezi, Lualaba | ||||
452 | 452 | Martin Fayulu | 2022-01-27 | CONGO, DEMOCRATIC REPUBLIC OF THE | Future Pact LLC 7074 | 2022-01-27 | Future Pact LLC | 3 Boulevard Triomphal, Commune de Kasa Vubu | Kinshasa | ||||
300 | 300 | Government of the Democratic Republic of the Congo | 2022-04-14 | CONGO, DEMOCRATIC REPUBLIC OF THE | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | Ministry of Finance | Kinshasha | ||||
278 | 278 | Government of Democratic Republic of Congo | 2021-12-09 | CONGO, DEMOCRATIC REPUBLIC OF THE | Endsight Consulting LLC 7056 | 2021-12-09 | Endsight Consulting LLC | Ministry of Finance | Kinshasa | ||||
157 | 157 | Embassy of Democratic Republic Congo | 2023-01-30 | CONGO, DEMOCRATIC REPUBLIC OF THE | Isaiah King 7224 | 2023-01-30 | Isaiah King | 1100 Connecticut Avenue, NW | Washington | DC | 20036 | ||
123 | 123 | 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 |
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]) );