FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
175 rows where Country/Location_Represented = "BRAZIL" sorted by Address_1
This data as json, CSV (advanced)
Registrant_Name >30
- L.A. Motley & Company 9
- Lynch, Wilde & Company, Inc. 5
- Pan-American Coffee Bureau 3
- Willkie, Farr & Gallagher 3
- Agendas International, Inc. 2
- BerlinRosen, Ltd. 2
- Bishop, Cook, Purcell & Reynolds 2
- Cassidy & Associates, Inc. 2
- Curtis J. Hoxter, Inc. 2
- Hill and Knowlton Strategies, LLC 2
- Klein & Saks 2
- Pehle, Riemer, Luxford & Naiden 2
- Samuel E. Stavisky & Associates, Inc. 2
- A.S. Nemir Associates 1
- American Continental Group 1
- Anderson, Hibey & Blair 1
- Arter, Hadden & Hemmendinger 1
- Beverly, James E. 1
- Biaiek, Robert W. 1
- Birnbaum, Martin T. 1
- Burson-Marsteller 1
- Butrick, Richard P. 1
- CDN International, Inc. 1
- Coudert Brothers 1
- Daniel J. Edelman, Inc. 1
- Daniels, Houlihan & Palmeter 1
- Development & Resources Corporation 1
- EMB, Ltd. 1
- Fasturn, Inc. 1
- Galland, Kharasch, Morse & Garfinkle, P.C. 1
- …
Registrant_Date (date) >30 ✖
- 1985-08-15 9
- 1959-07-02 5
- 1946-12-06 3
- 1985-12-26 3
- 1947-02-17 2
- 1958-01-28 2
- 1962-04-02 2
- 1979-08-17 2
- 1981-11-10 2
- 1983-09-30 2
- 1989-05-25 2
- 2020-02-06 2
- 1946-01-25 1
- 1951-10-08 1
- 1952-12-02 1
- 1954-09-01 1
- 1956-08-02 1
- 1957-02-21 1
- 1958-10-22 1
- 1959-05-12 1
- 1959-06-03 1
- 1959-08-10 1
- 1959-09-10 1
- 1959-09-15 1
- 1961-09-27 1
- 1962-03-09 1
- 1963-04-09 1
- 1963-04-10 1
- 1963-05-21 1
- 1965-01-11 1
- …
Foreign_Principal >30
- Embassy of Brazil 5
- Brazil Section of the U.S. - Brazil Business Council 2
- Companhia de Navegacao Maritima NETUMAR 2
- Instituto Brasileiro de Siderurgia 2
- Transbrasil, S.A., Linhas Aereas 2
- 342 Association 1
- ABECITRUS (Associacao Brasileira dos Exportadores de Citricos) 1
- Alcantara Machado Comercio e Empreendimentos Comercio e, Ltda. 1
- Assocaicao Nationale Fabricantes de Papel e Celulose 1
- Associacao Brasileira de Ferroligas (ABRAFE) 1
- Associacao Brasileira de Productores de Ferro Ligas (ABRAFE) 1
- Associacao Brasileira de Productores de Ferro Ligas ABRAFE"" 1
- Associacao Nacional dos Fabricantes de Papel e Celulose ANFPC 1
- Association of Brazilian Exporters (Associacao de Exportadores Brasileiros) 1
- Banco Nacional de Disenvolvimento Economico a Social-BNDES 1
- Banco Nacional do Desenvolvimento Economico 1
- Banco de Brasil, S.A. 1
- Banco do Estado de Sao Paulo, S.A. 1
- Better Communications Inc. 1
- Brazil-U.S. Business Council 1
- Brazil-U.S. Business Council (CEBEU) 1
- Brazilian Embassy 1
- Brazilian Ethanol Producers' Special Committee 1
- Brazilian Naval Commission 1
- Brazilian Sugar & Alcohol Institute 1
- CNPq - Conselho Nacional de Desenvolvimento Cientifico e Tecnologico 1
- Carlos Alberto A. de Carvalho Pinto - Governor of the State of Sao Paulo, Brazil 1
- Centrais Eletricas Brasileiras, S.A. (Eletrobras) 1
- Centrais Eletricas do Sul do Brasil, S.A. 1
- Central Eletrica de Furnas, S.A. 1
- …
Country/Location_Represented 1
- BRAZIL · 75 ✖
City 1
- - 75
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5454 | 5454 | 1986-04-21 | Instituto do Acurcar e do Alcool | 1962-03-09 | BRAZIL | A.S. Nemir Associates 1524 | 1962-03-09 | A.S. Nemir Associates | Rio de Janeiro | ||||
6515 | 6515 | 1993-05-13 | Banco Nacional de Disenvolvimento Economico a Social-BNDES | 1992-05-28 | BRAZIL | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | Rio de Janeiro | ||||
6683 | 6683 | 1963-05-21 | Companhia Progresso do Estado da Guanabara (COPEG) | 1963-05-21 | BRAZIL | Biaiek, Robert W. 1634 | 1963-05-21 | Biaiek, Robert W. | Rio de Janeiro | ||||
7522 | 7522 | 1961-06-03 | Diarios Associados, Ltd. | 1960-02-11 | BRAZIL | Klein & Saks 1234 | 1959-06-03 | Klein & Saks | Rio de Janeiro | ||||
7744 | 7744 | 1985-06-11 | Brazilian Sugar & Alcohol Institute | 1983-05-10 | BRAZIL | McLeod, Michael R. 3467 | 1983-05-10 | McLeod, Michael R. | Rio de Janeiro | ||||
8053 | 8053 | 1960-06-24 | Inter-American Public Relations, Ltd. | 1959-08-10 | BRAZIL | Birnbaum, Martin T. 1252 | 1959-08-10 | Birnbaum, Martin T. | Rio de Janeiro | ||||
8359 | 8359 | 1983-06-30 | Association of Brazilian Exporters (Associacao de Exportadores Brasileiros) | 1981-08-05 | BRAZIL | Arter, Hadden & Hemmendinger 1001 | 1957-02-21 | Arter, Hadden & Hemmendinger | Rio de Janeiro | ||||
8408 | 8408 | 1986-06-30 | Instituto Brasileiro de Siderurgia | 1984-10-19 | BRAZIL | Anderson, Hibey & Blair 3208 | 1981-03-09 | Anderson, Hibey & Blair | Rio de Janeiro | ||||
8517 | 8517 | 1994-06-30 | Brazil Section of the U.S. - Brazil Business Council | 1994-02-28 | BRAZIL | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Rio de Janeiro | ||||
9650 | 9650 | 1956-07-31 | Industrias Quimicas Reunidas, S.A. (ORQUIMA) | 1954-09-01 | BRAZIL | Klein & Saks 844 | 1954-09-01 | Klein & Saks | Rio de Janeiro | ||||
9656 | 9656 | 1963-07-31 | Public Relations Department, Standard Propaganda, S.A. | 1963-04-09 | BRAZIL | Robert L. Bliss & Company, Inc. 1616 | 1963-04-09 | Robert L. Bliss & Company, Inc. | Rio de Janeiro | ||||
9785 | 9785 | 1991-07-31 | Companhia de Navegacao Maritima NETUMAR | 1990-10-05 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Rio de Janeiro | ||||
10766 | 10766 | 1994-08-26 | Brazil Section of the U.S. - Brazil Business Council | 1994-02-15 | BRAZIL | Law Offices of Robert K. Kelley 4754 | 1993-01-19 | Law Offices of Robert K. Kelley | Rio de Janeiro | ||||
11613 | 11613 | 1962-09-15 | Development Bank of Brazil | 1959-09-15 | BRAZIL | EMB, Ltd. 1270 | 1959-09-15 | EMB, Ltd. | Rio de Janeiro | ||||
11996 | 11996 | 1988-09-30 | H. Stern, S.A. | 1988-09-09 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Rio de Janeiro | ||||
12540 | 12540 | 1953-10-08 | Companhia Hidro Electrica do Sao Francisco | 1951-10-08 | BRAZIL | Moloney, William John 686 | 1951-10-08 | Moloney, William John | Rio de Janeiro | ||||
12602 | 12602 | 1986-10-11 | Sugar & Alcohol Institute | 1985-12-04 | BRAZIL | Skadden, Arps, Slate, Meagher & Flom 3746 | 1985-10-15 | Skadden, Arps, Slate, Meagher & Flom | Rio de Janeiro | ||||
12998 | 12998 | 1985-10-25 | Instituto Brasileiro de Siderurgia | 1983-09-29 | BRAZIL | Villares Overseas Corporation 3523 | 1983-09-29 | Villares Overseas Corporation | Rio de Janeiro | ||||
13138 | 13138 | 1993-10-29 | Transbrasil, S.A., Linhas Aereas | 1990-10-19 | BRAZIL | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | 1978-03-17 | LeBoeuf, Lamb, Greene & MacRae, L.L.P. | Rio de Janeiro | ||||
13256 | 13256 | 1989-10-31 | Brazil-U.S. Business Council (CEBEU) | 1988-09-19 | BRAZIL | Bishop, Cook, Purcell & Reynolds 3050 | 1979-08-17 | Bishop, Cook, Purcell & Reynolds | Rio de Janeiro | ||||
13259 | 13259 | 1989-10-31 | Companhia Siderurgica da Guanabara (COSIGUA) | 1989-07-05 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Rio de Janeiro | ||||
14054 | 14054 | 1975-11-18 | CNPq - Conselho Nacional de Desenvolvimento Cientifico e Tecnologico | 1975-11-18 | BRAZIL | Beverly, James E. 2629 | 1975-11-18 | Beverly, James E. | Rio de Janeiro | ||||
14615 | 14615 | 1958-12-01 | Instituto Brasileiro do Cafe (Brazilian Coffee Institute) | 1958-10-22 | BRAZIL | Martial & Company, Inc. 1182 | 1958-10-22 | Martial & Company, Inc. | Rio de Janeiro | ||||
14843 | 14843 | 1994-12-06 | VARIG, S.A. | 1994-04-22 | BRAZIL | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | Rio de Janeiro | ||||
14926 | 14926 | 1994-12-09 | Varig, S.A. | 1994-04-22 | BRAZIL | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Rio de Janeiro | ||||
15339 | 15339 | 1974-12-23 | Centrais Eletricas Brasileiras, S.A. (Eletrobras) | 1968-02-06 | BRAZIL | Lynch, Wilde & Company, Inc. 1242 | 1959-07-02 | Lynch, Wilde & Company, Inc. | Rio de Janeiro | ||||
15341 | 15341 | 1974-12-23 | Centrais Eletricas do Sul do Brasil, S.A. | 1971-02-14 | BRAZIL | Lynch, Wilde & Company, Inc. 1242 | 1959-07-02 | Lynch, Wilde & Company, Inc. | Rio de Janeiro | ||||
15342 | 15342 | 1974-12-23 | Central Eletrica de Furnas, S.A. | 1959-07-02 | BRAZIL | Lynch, Wilde & Company, Inc. 1242 | 1959-07-02 | Lynch, Wilde & Company, Inc. | Rio de Janeiro | ||||
15343 | 15343 | 1974-12-23 | Companhia Auxiliar de Empresas Eletricas Brasileiras | 1967-02-28 | BRAZIL | Lynch, Wilde & Company, Inc. 1242 | 1959-07-02 | Lynch, Wilde & Company, Inc. | Rio de Janeiro | ||||
15344 | 15344 | 1974-12-23 | Companhia Hidro Eletrica do Sao Francisco | 1959-07-02 | BRAZIL | Lynch, Wilde & Company, Inc. 1242 | 1959-07-02 | Lynch, Wilde & Company, Inc. | Rio de Janeiro | ||||
15610 | 15610 | 1961-12-31 | Instituto de Acucar e do Alcol | 1960-03-01 | BRAZIL | Squire, Sanders & Dempsey, L.L.P. 746 | 1952-12-02 | Squire, Sanders & Dempsey, L.L.P. | Rio de Janeiro | ||||
15745 | 15745 | 1976-12-31 | Departamento Nacional do Cafe' | 1946-12-06 | BRAZIL | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Rio de Janeiro | ||||
15747 | 15747 | 1976-12-31 | Instituto Brasileiro do Cafe' | 1953-05-25 | BRAZIL | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Rio de Janeiro | ||||
15760 | 15760 | 1976-12-31 | Government of Brazil | 1965-08-16 | BRAZIL | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | Rio de Janeiro | ||||
16103 | 16103 | 1989-12-31 | Companhia de Navegacao Maritima NETUMAR | 1988-11-18 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Rio de Janeiro | ||||
4055 | 4055 | 1986-03-26 | Associacao Brasileira de Productores de Ferro Ligas ABRAFE"" | 1978-03-17 | BRAZIL | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | Rio de Janiero | ||||
11217 | 11217 | 1964-09-01 | Banco de Brasil, S.A. | 1963-09-03 | BRAZIL | Pehle, Riemer, Luxford & Naiden 439 | 1947-02-17 | Pehle, Riemer, Luxford & Naiden | Rio de Janiero | ||||
13698 | 13698 | 1966-11-04 | Banco Nacional do Desenvolvimento Economico | 1963-03-26 | BRAZIL | Pehle, Riemer, Luxford & Naiden 439 | 1947-02-17 | Pehle, Riemer, Luxford & Naiden | Rio de Janiero | ||||
14704 | 14704 | 1995-12-01 | Brazil-U.S. Business Council | 1994-07-07 | BRAZIL | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Rio de Janiero | ||||
15814 | 15814 | 1979-12-31 | Associacao Brasileira de Productores de Ferro Ligas (ABRAFE) | 1979-11-26 | BRAZIL | Fasturn, Inc. 2944 | 1978-08-09 | Fasturn, Inc. | Rio de Jeniero | ||||
14316 | 14316 | 2012-11-29 | State of Minas Gerais | 2012-12-03 | BRAZIL | CDN International, Inc. 5992 | 2010-06-28 | CDN International, Inc. | Rodovia Prefeito Americo Gianetti, s/n | Serra Verde - Predio Gerais 31630-901 Belo Horizonte, MG | |||
2253 | 2253 | 2020-02-06 | Marae Investimentos LTDA | 2020-02-06 | BRAZIL | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | Rua Amauri | 255, 5 Andar Jardim Europa, Sao Paulo, SP, 01406-200 | |||
16588 | 16588 | 2005-12-31 | Global Trader International | 2005-07-29 | BRAZIL | American Continental Group 5695 | 2005-07-08 | American Continental Group | Rua Helena, 140 2nd Floor | Sao Paulo, SP 04552-050 | |||
1094 | 1094 | 1989-01-06 | Eluma, S.A., Industria e Comercio | 1988-12-28 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Santo Andre | ||||
931 | 931 | 1991-01-01 | Companhia Siderurgica Paulista (COSIPA) | 1986-06-25 | BRAZIL | Willkie, Farr & Gallagher 3765 | 1985-12-26 | Willkie, Farr & Gallagher | Sao Paulo | ||||
1213 | 1213 | 1988-01-11 | Banco do Estado de Sao Paulo, S.A. | 1971-02-17 | BRAZIL | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | Sao Paulo | ||||
1737 | 1737 | 1990-01-31 | Assocaicao Nationale Fabricantes de Papel e Celulose | 1989-03-13 | BRAZIL | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Sao Paulo | ||||
2786 | 2786 | 1997-02-25 | Embraer - Empresa Brasileira de Aeronautica, S.A. | 1997-02-25 | BRAZIL | Zemi Communications, L.L.C. 5120 | 1996-07-01 | Zemi Communications, L.L.C. | Sao Paulo | ||||
3211 | 3211 | 1960-03-01 | Carlos Alberto A. de Carvalho Pinto - Governor of the State of Sao Paulo, Brazil | 1959-09-10 | BRAZIL | Butrick, Richard P. 1267 | 1959-09-10 | Butrick, Richard P. | Sao Paulo | ||||
3559 | 3559 | 1993-03-09 | ABECITRUS (Associacao Brasileira dos Exportadores de Citricos) | 1988-12-14 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Sao Paulo | ||||
3562 | 3562 | 1993-03-09 | Sharp, S.A., Equipamentos Electronicos | 1988-01-14 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Sao Paulo | ||||
3848 | 3848 | 1995-03-17 | Associacao Nacional dos Fabricantes de Papel e Celulose ANFPC | 1989-03-30 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Sao Paulo | ||||
4478 | 4478 | 1990-03-31 | Centro das Industrias do Estado de Sao Paulo | 1990-08-13 | BRAZIL | Bishop, Cook, Purcell & Reynolds 3050 | 1979-08-17 | Bishop, Cook, Purcell & Reynolds | Sao Paulo | ||||
5137 | 5137 | 1986-04-10 | Associacao Brasileira de Ferroligas (ABRAFE) | 1985-12-26 | BRAZIL | Willkie, Farr & Gallagher 3765 | 1985-12-26 | Willkie, Farr & Gallagher | Sao Paulo | ||||
5230 | 5230 | 1993-04-12 | Persico Pizzamiglio, S.A. | 1988-06-30 | BRAZIL | O'Melveny & Myers 3346 | 1982-03-12 | O'Melveny & Myers | Sao Paulo | ||||
5791 | 5791 | 1969-04-30 | Sindicato da Industria de Cafe' Soluvel do Estado de Sao Paulo, Sao Paulo, Brazil | 1969-02-12 | BRAZIL | Samuel E. Stavisky & Associates, Inc. 1531 | 1962-04-02 | Samuel E. Stavisky & Associates, Inc. | Sao Paulo | ||||
6527 | 6527 | 1984-05-14 | Alcantara Machado Comercio e Empreendimentos Comercio e, Ltda. | 1981-03-09 | BRAZIL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | Sao Paulo | ||||
6545 | 6545 | 1968-05-15 | Sindicato da Industria de Cafe' Soluvel de Sao Paulo, Brazil | 1967-09-20 | BRAZIL | Samuel E. Stavisky & Associates, Inc. 1531 | 1962-04-02 | Samuel E. Stavisky & Associates, Inc. | Sao Paulo | ||||
8131 | 8131 | 1987-06-27 | Brazilian Ethanol Producers' Special Committee | 1985-12-26 | BRAZIL | Willkie, Farr & Gallagher 3765 | 1985-12-26 | Willkie, Farr & Gallagher | Sao Paulo | ||||
13276 | 13276 | 1990-10-31 | Transbrasil, S.A., Linhas Aereas | 1990-09-10 | BRAZIL | Galland, Kharasch, Morse & Garfinkle, P.C. 4006 | 1987-06-23 | Galland, Kharasch, Morse & Garfinkle, P.C. | Sao Paulo | ||||
14045 | 14045 | 1993-11-17 | Better Communications Inc. | 1993-01-21 | BRAZIL | Pagonis & Donnelly Group, Inc. 3692 | 1985-06-20 | Pagonis & Donnelly Group, Inc. | Sao Paulo | ||||
14169 | 14169 | 1993-11-22 | Fides Foundation | 1988-11-01 | BRAZIL | Agendas International, Inc. 3524 | 1983-09-30 | Agendas International, Inc. | Sao Paulo | ||||
14339 | 14339 | 1972-11-30 | Serete, S.A., Engenharia | 1972-04-14 | BRAZIL | Development & Resources Corporation 969 | 1956-08-02 | Development & Resources Corporation | Sao Paulo | ||||
15678 | 15678 | 1970-12-31 | Sao Paulo Textile Association | 1970-11-24 | BRAZIL | Coudert Brothers 2222 | 1970-11-24 | Coudert Brothers | Sao Paulo | ||||
5984 | 5984 | 2000-04-30 | Empresa Brasileira de Aeronautica S.A. (Embraer) | 1999-01-14 | BRAZIL | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Sate of Sao Paulo | ||||
2453 | 2453 | 1998-02-13 | Companhia de Navegacao Alianca, S.A. | 1997-11-07 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | South Plainfield | NJ | |||
2252 | 2252 | 2020-02-06 | 342 Association | 2020-02-06 | BRAZIL | BerlinRosen, Ltd. 6791 | 2020-02-06 | BerlinRosen, Ltd. | Visconde de Itauna 362 | Rio de Janeiro RJ 22460140 | |||
4921 | 4921 | 1990-04-01 | Embassy of Brazil | 1987-02-12 | BRAZIL | Agendas International, Inc. 3524 | 1983-09-30 | Agendas International, Inc. | Washington | DC | |||
5368 | 5368 | 1946-04-18 | Brazilian Embassy | 1946-01-25 | BRAZIL | Gordon, John W. 340 | 1946-01-25 | Gordon, John W. | Washington | DC | |||
5499 | 5499 | 1995-04-23 | Embassy of Brazil | 1995-04-04 | BRAZIL | Cassidy & Associates, Inc. 4259 | 1989-05-25 | Cassidy & Associates, Inc. | Washington | DC | |||
8998 | 8998 | 1963-07-04 | Brazilian Naval Commission | 1963-04-10 | BRAZIL | McHugh, Donald Patrick 1617 | 1963-04-10 | McHugh, Donald Patrick | Washington | DC | |||
13918 | 13918 | 1970-11-13 | Government of Brazil (Brazilian Aeronautical Commission - Agency of the Ministry of Aeronautics) | 1959-05-12 | BRAZIL | Shaw, Pittman, Potts & Trowbridge 1226 | 1959-05-12 | Shaw, Pittman, Potts & Trowbridge | Washington | DC | |||
14633 | 14633 | 1971-12-01 | Embassy of Brazil | 1972-07-05 | BRAZIL | Curtis J. Hoxter, Inc. 1111 | 1958-01-28 | Curtis J. Hoxter, Inc. | Washington | DC | |||
14634 | 14634 | 1971-12-01 | Embassy of Brazil | 1960-10-31 | BRAZIL | Curtis J. Hoxter, Inc. 1111 | 1958-01-28 | Curtis J. Hoxter, Inc. | Washington | DC | |||
14936 | 14936 | 1971-12-10 | Embassy of Brazil | 1971-11-23 | BRAZIL | Murden & Company, Inc. 2290 | 1971-11-23 | Murden & Company, Inc. | Washington | DC |
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]) );