FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

18 rows where Country/Location_Represented = "BRAZIL" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Number, Registrant_Date, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

Country/Location_Represented 1

  • BRAZIL · 18 ✖

City 1

  • - 18
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
2107 2107 1984-02-02 Banco do Brasil, S.A. 1983-08-12 BRAZIL T.J. Ross & Associates, Inc. 3508 1983-08-12 T.J. Ross & Associates, Inc. New York     NY  
2412 2412 1993-02-12 Banco do Brasil, S.A., for the Brazilian Ministry of Finance 1985-12-26 BRAZIL Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher New York     NY  
3612 3612 1993-03-11 Brazilian-American Chamber of Commerce 1987-05-26 BRAZIL Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3835 3835 1960-03-17 Republic of Brazil 1960-04-15 BRAZIL Feldman, Maurice 1094 1957-12-13 Feldman, Maurice New York     NY  
4321 4321 1967-03-31 Brazilian Coffee Institute, New York 1967-01-27 BRAZIL Samuel E. Stavisky & Associates, Inc. 1531 1962-04-02 Samuel E. Stavisky & Associates, Inc. New York     NY  
4327 4327 1968-03-31 Dominium International, Inc. 1967-08-30 BRAZIL James S. Vlasto Associates 2044 1967-08-30 James S. Vlasto Associates 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  
7036 7036 1968-05-31 Dominium International, Inc. 1967-08-29 BRAZIL Eisenberg, Milton 2042 1967-08-29 Eisenberg, Milton New York     NY  
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  
9758 9758 1989-07-31 Gabriel Safdie 1988-07-28 BRAZIL Chadbourne & Parke 3490 1983-06-24 Chadbourne & Parke New York     NY  
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  
10834 10834 1984-08-30 Brazilian Government Trade Bureau 1978-11-01 BRAZIL International Marketing Group 2540 1974-10-22 International Marketing Group New York     NY  
12624 12624 1987-10-12 Brazilian National Tourist Agency 1986-11-16 BRAZIL North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
12774 12774 1985-10-16 Banco do Brasil, S.A., for the Brazilian Ministry of Finance 1983-09-02 BRAZIL Wald, Harkrader & Ross 3241 1981-05-10 Wald, Harkrader & Ross       NY  
14322 14322 1956-11-30 Brazilian Delegation to the United Nations 1955-12-23 BRAZIL Frontaura, Pablo 926 1955-12-23 Frontaura, Pablo New York     NY  
14338 14338 1968-11-30 Brazilian Coffee Institute 1968-10-09 BRAZIL Samuel E. Stavisky & Associates, Inc. 1531 1962-04-02 Samuel E. Stavisky & Associates, Inc. New York     NY  
14601 14601 1943-12-01 Brazilian Government Trade Bureau 1953-06-11 BRAZIL Drysdale Roche Gibson Associates, Inc. 772 1953-06-11 Drysdale Roche Gibson Associates, Inc. New York     NY  
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  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);