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 Foreign_Principal
This data as json, CSV (advanced)
Registrant_Name >30
- D&F All Americas Investors, Inc. 4
- L.A. Motley & Company 3
- Samuel E. Stavisky & Associates, Inc. 3
- Arnold & Porter Kaye Scholer LLP 2
- Burson-Marsteller 2
- CDN International, Inc. 2
- Development & Resources Corporation 2
- Feldman, Maurice 2
- Hill and Knowlton Strategies, LLC 2
- Pan-American Coffee Bureau 2
- Shaw, Pittman, Potts & Trowbridge 2
- A.S. Nemir Associates 1
- APCO Associates 1
- Agendas International, Inc. 1
- American Continental Group 1
- Anderson, Hibey & Blair 1
- BerlinRosen, Ltd. 1
- Bernard Preyer Company 1
- Birnbaum, Martin T. 1
- Chadbourne & Parke 1
- Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 1
- Coudert Brothers 1
- Daniels, Houlihan & Palmeter 1
- Fierce, Isakowitz & Blalock 1
- Flanagan Group, Inc. 1
- Fleishman-Hillard, Inc. 1
- Foster Garvey PC 1
- Gadsby, Maguire & Hannah 1
- Galland, Kharasch, Morse & Garfinkle, P.C. 1
- Graham & James, L.L.P. 1
- …
Registrant_Date (date) >30 ✖
- 1949-07-12 4
- 1962-04-02 3
- 1985-08-15 3
- 1946-12-06 2
- 1956-08-02 2
- 1957-12-13 2
- 1959-05-12 2
- 1964-06-04 2
- 1973-10-23 2
- 1981-11-10 2
- 2010-06-28 2
- 1942-08-14 1
- 1952-12-02 1
- 1954-09-01 1
- 1958-10-22 1
- 1959-08-10 1
- 1961-01-03 1
- 1961-09-27 1
- 1962-03-09 1
- 1963-04-09 1
- 1964-10-08 1
- 1967-03-01 1
- 1968-01-30 1
- 1969-10-09 1
- 1970-11-24 1
- 1973-01-09 1
- 1975-06-10 1
- 1978-03-17 1
- 1978-07-18 1
- 1979-08-09 1
- …
Foreign_Principal_Registration_Date (date) >30 ✖
- 1949-07-12 4
- 1988-10-12 2
- 1994-04-22 2
- 1943-03-18 1
- 1953-05-25 1
- 1954-09-01 1
- 1958-10-22 1
- 1959-03-02 1
- 1959-05-12 1
- 1959-08-10 1
- 1960-03-01 1
- 1960-04-15 1
- 1961-01-03 1
- 1962-03-09 1
- 1963-04-09 1
- 1964-10-08 1
- 1965-08-16 1
- 1967-03-01 1
- 1967-09-20 1
- 1969-02-12 1
- 1970-11-24 1
- 1970-12-09 1
- 1972-04-14 1
- 1973-05-01 1
- 1975-04-14 1
- 1975-06-10 1
- 1976-03-11 1
- 1976-04-26 1
- 1978-01-18 1
- 1981-11-20 1
- …
Foreign_Principal >30
- Government of Brazil 6
- Forjas Taurus, S.A. 3
- Instituto Brasileiro de Siderurgia 3
- Instituto Brasileiro do Cafe (Brazilian Coffee Institute) 2
- Republic of Brazil 2
- Social Communication Secretariat of the Office of the President of the Republic of Brazil 2
- Transbrasil, S.A., Linhas Aereas 2
- Vice President Aureliano Chaves 2
- Embraer, S.A., Inc. 1
- Embratur - Brazilian Tourist Board 1
- Embratur/Brazilian Tourism Authority 1
- Empresa Brasileira de Aeronautica S.A. (Embraer) 1
- Federal District 1
- Federal Union of Brazil, Ministry of Interior 1
- Federation of Industries of the State of Sao Paulo (FIESP) 1
- Federation of the Industries of the State of Sao Paulo 1
- Fides Foundation 1
- Gabriel Safdie 1
- Global Trader International 1
- Government of Brazil (Brazilian Aeronautical Commission - Agency of the Ministry of Aeronautics) 1
- Government of Brazil (Brazilian Aeronautical Commission) 1
- Governo do Estado do Amazonas 1
- H. Stern, S.A. 1
- Horizontes, LTDA 1
- Industrias Quimicas Reunidas, S.A. (ORQUIMA) 1
- Instituto Brasileiro do Cafe' 1
- Instituto Brasiliero De Turismo (Embratur) 1
- Instituto de Acucar e do Alcol 1
- Instituto do Acurcar e do Alcool 1
- Inter-American Public Relations, Ltd. 1
- …
City 5
- - 70
- Brasilia 2
- Sao Paulo 1
- Sao Paulo, SP 1
- Sao Paulo-SP 1
Country/Location_Represented 1
- BRAZIL · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12797 | 12797 | 1985-10-17 | Embraer, S.A., Inc. | 1978-01-18 | BRAZIL | Santarelli, Donald E. 2929 | 1978-07-18 | Santarelli, Donald E. | |||||
7825 | 7825 | 1984-06-15 | Embratur - Brazilian Tourist Board | 1976-04-26 | BRAZIL | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | |||||
1329 | 1329 | 1987-01-15 | Embratur/Brazilian Tourism Authority | 1986-09-02 | BRAZIL | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | |||||
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 | ||||
1230 | 1230 | 1950-01-12 | Federal District | 1949-07-12 | BRAZIL | D&F All Americas Investors, Inc. 581 | 1949-07-12 | D&F All Americas Investors, Inc. | |||||
9566 | 9566 | 1973-07-28 | Federal Union of Brazil, Ministry of Interior | 1973-05-01 | BRAZIL | Development & Resources Corporation 969 | 1956-08-02 | Development & Resources Corporation | Brasilia | ||||
16679 | 16679 | 2010-12-31 | Federation of Industries of the State of Sao Paulo (FIESP) | 2009-09-08 | BRAZIL | Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 5950 | 2009-09-08 | Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock | Av. Paulista, 1313-4th Fl. | 0311-023 | Sao Paulo | ||
16633 | 16633 | 2008-12-31 | Federation of the Industries of the State of Sao Paulo | 2008-08-01 | BRAZIL | Fierce, Isakowitz & Blalock 5654 | 2004-10-29 | Fierce, Isakowitz & Blalock | Av. Paulista, 1313-4th Fl. | 0311-923 | Sao Paulo, SP | ||
14169 | 14169 | 1993-11-22 | Fides Foundation | 1988-11-01 | BRAZIL | Agendas International, Inc. 3524 | 1983-09-30 | Agendas International, Inc. | Sao Paulo | ||||
4484 | 4484 | 1990-03-31 | Forjas Taurus, S.A. | 1989-03-09 | BRAZIL | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | Porto Alegre | ||||
13119 | 13119 | 1988-10-29 | Forjas Taurus, S.A. | 1988-10-12 | BRAZIL | William Russell & Associates, Inc. 4135 | 1988-04-27 | William Russell & Associates, Inc. | |||||
13981 | 13981 | 1988-11-15 | Forjas Taurus, S.A. | 1988-10-12 | BRAZIL | Wellford, Wegman & Hoff 3278 | 1981-10-06 | Wellford, Wegman & Hoff | Porto Alegre | ||||
9758 | 9758 | 1989-07-31 | Gabriel Safdie | 1988-07-28 | BRAZIL | Chadbourne & Parke 3490 | 1983-06-24 | Chadbourne & Parke | New York | NY | |||
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 | |||
4059 | 4059 | 1986-03-26 | Government of Brazil | 1976-03-11 | BRAZIL | Daniels, Houlihan & Palmeter 2072 | 1968-01-30 | Daniels, Houlihan & Palmeter | |||||
7392 | 7392 | 1984-06-01 | Government of Brazil | 1981-11-20 | BRAZIL | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | |||||
7964 | 7964 | 1991-06-20 | Government of Brazil | 1991-03-26 | BRAZIL | APCO Associates 3597 | 1984-06-20 | APCO Associates | Brasilia | ||||
9017 | 9017 | 1991-07-05 | Government of Brazil | 1991-06-21 | BRAZIL | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Brasilia | ||||
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 | ||||
16257 | 16257 | 1994-12-31 | Government of Brazil | 1987-07-09 | BRAZIL | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | |||||
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 | |||
5346 | 5346 | 1975-04-17 | Government of Brazil (Brazilian Aeronautical Commission) | 1970-12-09 | BRAZIL | Shaw, Pittman, Potts & Trowbridge 1226 | 1959-05-12 | Shaw, Pittman, Potts & Trowbridge | Rio de Janeiro | ||||
7617 | 7617 | 2019-06-05 | Governo do Estado do Amazonas | 2019-06-05 | BRAZIL | Interamerica Group 6687 | 2019-06-05 | Interamerica Group | Avenida Brasil, 3925 - Compensa II, Manaus, Amazonas | CEP69036 | |||
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 | ||||
12209 | 12209 | 2012-09-30 | Horizontes, LTDA | 2012-04-26 | BRAZIL | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
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 | ||||
2110 | 2110 | 1995-02-02 | Instituto Brasileiro de Siderurgia | 1988-08-28 | BRAZIL | Willkie, Farr & Gallagher 3765 | 1985-12-26 | Willkie, Farr & Gallagher | 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 | ||||
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 | ||||
8395 | 8395 | 1985-06-30 | Instituto Brasileiro do Cafe (Brazilian Coffee Institute) | 1975-04-14 | BRAZIL | Samuel E. Stavisky & Associates, Inc. 1531 | 1962-04-02 | Samuel E. Stavisky & Associates, Inc. | New York | NY | |||
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 | ||||
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 | ||||
13169 | 13169 | 1997-10-30 | Instituto Brasiliero De Turismo (Embratur) | 1998-01-30 | BRAZIL | Zemi Communications, L.L.C. 5120 | 1996-07-01 | Zemi Communications, L.L.C. | Brazilia | ||||
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 | ||||
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 | ||||
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 | ||||
7824 | 7824 | 1983-06-15 | Interbras, Petrobras Comercio International S/A | 1982-12-14 | BRAZIL | Granados, Juan Antonio 3432 | 1982-12-14 | Granados, Juan Antonio | |||||
10320 | 10320 | 1984-08-13 | International PetChemco, Inc. | 1984-06-13 | BRAZIL | Rogers & Wells, LLP 3428 | 1982-12-10 | Rogers & Wells, LLP | New York | NY | |||
353 | 353 | Invest SP - Agencia Paulista de Promocao de Investimentos e Competitividade | 2021-12-06 | BRAZIL | Invest SP USA, LLC 7054 | 2021-12-06 | Invest SP USA, LLC | Av. Escola Politecnica, 82 | Sao Paulo CEP | ||||
11090 | 11090 | 2004-08-31 | LACTEC | 2004-05-18 | BRAZIL | Schmeltzer, Aptaker & Shepard, P.C. 5304 | 1999-03-02 | Schmeltzer, Aptaker & Shepard, P.C. | ATTN: Luciliane Ribeiro Centro Politecnico da UFPR Caixa Postal 19067 - CEP 81531-980 Curitiba, P | ||||
5090 | 5090 | 1967-04-08 | Lloyd Brasileiro | 1964-10-08 | BRAZIL | Purrington & McConnell 1800 | 1964-10-08 | Purrington & McConnell | Rio de Janeiro | ||||
8976 | 8976 | 1961-07-03 | Luis Correa da Silva, Brazilian Trade Bureau | 1961-01-03 | BRAZIL | Martial International Corporation 1417 | 1961-01-03 | Martial International Corporation | Montreal | ||||
2461 | 2461 | 1945-02-14 | M. Agostini & CIA. Ltda | 1943-03-18 | BRAZIL | Bernard Preyer Company 96 | 1942-08-14 | Bernard Preyer Company | |||||
14692 | 14692 | 1988-12-01 | MULTI-MDLC | 1987-12-03 | BRAZIL | Flanagan Group, Inc. 4067 | 1987-12-03 | Flanagan Group, Inc. | Brasilia | ||||
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 | |||
7716 | 7716 | 1975-06-10 | Ministry of Planning, Government of Brazil | 1975-06-10 | BRAZIL | Murden & Company, Inc. 2589 | 1975-06-10 | Murden & Company, Inc. | |||||
15186 | 15186 | 1992-12-17 | National Department of Waterborne Transport (DNTA) (Formerly) Brazilian Natl Superintendency of Merchant Marine | 1983-05-20 | BRAZIL | Hoppel, Mayer & Coleman 3470 | 1983-05-20 | Hoppel, Mayer & Coleman | NY | ||||
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 | ||||
4004 | 4004 | 1998-03-23 | Petrobras America, Inc. | 1996-04-11 | BRAZIL | Graham & James, L.L.P. 3275 | 1981-09-23 | Graham & James, L.L.P. | Houston | TX | |||
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 | ||||
3835 | 3835 | 1960-03-17 | Republic of Brazil | 1960-04-15 | BRAZIL | Feldman, Maurice 1094 | 1957-12-13 | Feldman, Maurice | New York | NY | |||
7020 | 7020 | 1959-05-31 | Republic of Brazil | 1959-03-02 | BRAZIL | Feldman, Maurice 1094 | 1957-12-13 | Feldman, Maurice | New York | NY | |||
15678 | 15678 | 1970-12-31 | Sao Paulo Textile Association | 1970-11-24 | BRAZIL | Coudert Brothers 2222 | 1970-11-24 | Coudert Brothers | 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 | ||||
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 | ||||
11802 | 11802 | 1992-09-24 | Siderbras | 1989-06-23 | BRAZIL | International Advisory Services Group, Ltd. 4267 | 1989-06-23 | International Advisory Services Group, Ltd. | Brasilia | ||||
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 | ||||
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 | ||||
1376 | 1376 | 2019-01-16 | Social Communication Secretariat of the Office of the President of the Republic of Brazil | 2009-03-16 | BRAZIL | Fleishman-Hillard, Inc. 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | Esplanada dos Ministerios | Bloco A-6 Andar, Gabinete | Brasilia | ||
16837 | 16837 | 2018-12-31 | Social Communication Secretariat of the Office of the President of the Republic of Brazil | 2010-06-28 | BRAZIL | CDN International, Inc. 5992 | 2010-06-28 | CDN International, Inc. | Esokabada Dis Nubusteruis Bloco A 6 Andar - Gabinete | Brasilia | |||
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 | |||
1231 | 1231 | 1950-01-12 | State of Parana | 1949-07-12 | BRAZIL | D&F All Americas Investors, Inc. 581 | 1949-07-12 | D&F All Americas Investors, Inc. | |||||
1232 | 1232 | 1950-01-12 | State of Pernambuco | 1949-07-12 | BRAZIL | D&F All Americas Investors, Inc. 581 | 1949-07-12 | D&F All Americas Investors, Inc. | |||||
1233 | 1233 | 1950-01-12 | State of Sao Paulo | 1949-07-12 | BRAZIL | D&F All Americas Investors, Inc. 581 | 1949-07-12 | D&F All Americas Investors, Inc. | |||||
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 | ||||
6669 | 6669 | 1988-05-20 | Transbrasil Airlines, Inc. | 1987-02-20 | BRAZIL | L.A. Motley & Company 3723 | 1985-08-15 | L.A. Motley & Company | Miami | FL | |||
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 | ||||
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 | ||||
12287 | 12287 | 2022-09-30 | UNICA (AKA União da Indústria de Cana de Acucar/ Brazilian Sugarcane Industry Association | 2021-10-21 | BRAZIL | Steptoe & Johnson, LLP 6653 | 2019-03-22 | Steptoe & Johnson, LLP | Avenida Brigadeiro Faria lima, 2179 10. Andar- | Jardim Paulistano | Sao Paulo-SP | ||
4985 | 4985 | 1968-04-02 | United States of Brazil | 1967-03-01 | BRAZIL | Gadsby, Maguire & Hannah 2008 | 1967-03-01 | Gadsby, Maguire & Hannah | Brasilia | ||||
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 | ||||
3084 | 3084 | 2007-02-28 | Varig Brazilian Airlines | 1989-09-07 | BRAZIL | Holland & Knight 3718 | 1985-08-07 | Holland & Knight | Miami | FL | |||
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 | ||||
2942 | 2942 | 1985-02-28 | Vice President Aureliano Chaves | 1984-07-20 | BRAZIL | Paul Buiar Associates, Inc. 3604 | 1984-07-20 | Paul Buiar Associates, Inc. | Brazilia | ||||
4159 | 4159 | 1984-03-30 | Vice President Aureliano Chaves | 1984-02-07 | BRAZIL | Public Affairs Analysts, Inc. 3558 | 1984-02-07 | Public Affairs Analysts, Inc. | Brasilia |
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]) );