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

26 rows where Country/Location_Represented = "FRANCE" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • FRANCE · 26 ✖
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
260 260   Genfit 2018-01-22 FRANCE Meliora Strategy 6510 2018-01-22 Meliora Strategy 1813 13th Street, NW Suite 2 Washington DC 20009
912 912 1988-01-01 Republic of France 1984-10-31 FRANCE Miller & Chevalier, Chartered 3626 1984-10-31 Miller & Chevalier, Chartered       DC  
2408 2408 1991-02-12 Embassy of France 1989-06-22 FRANCE Jones Day 3427 1982-12-10 Jones Day Washington     DC  
3204 3204 1950-03-01 French Consulate 1950-06-05 FRANCE LeRoy & Denslow 27 1942-07-09 LeRoy & Denslow Washington     DC  
4364 4364 1978-03-31 Aerospatiale 1975-08-25 FRANCE Edelman International Corporation 2548 1974-11-29 Edelman International Corporation Washington     DC  
4994 4994 1946-04-03 Mission de la Marine Marchande et des Transports (French Delegation) 1944-04-03 FRANCE Fabre, Leon C. 244 1944-04-03 Fabre, Leon C. Washington     DC  
6164 6164 1979-05-01 Aerospatiale 1978-10-18 FRANCE Edelman International Corporation 2548 1974-11-29 Edelman International Corporation Washington     DC  
6176 6176 1981-05-01 European Aerospace Corporation 1980-12-12 FRANCE Parrish & Company, Inc. 3179 1980-12-12 Parrish & Company, Inc. Washington     DC  
7635 7635 1983-06-06 Aerospatiale, Inc. 1982-04-23 FRANCE Wallace, Sidney A. 3364 1982-04-23 Wallace, Sidney A.       DC  
7647 7647 1976-06-07 Aerospatiale 1975-12-15 FRANCE Daniel J. Edelman, Inc. 2640 1975-12-15 Daniel J. Edelman, Inc. Washington     DC  
7998 7998 1964-06-22 French Military Attache - Air 1967-03-16 FRANCE Diebold Group, Inc. 1700 1967-03-16 Diebold Group, Inc. Washington     DC  
8237 8237 1960-06-30 French Embassy 1954-11-09 FRANCE Levy, Joseph M. 683 1951-09-24 Levy, Joseph M. Washington     DC  
8240 8240 1960-06-30 Roger Seydoux, First Counselor in Charge of Public Relations, French Embassy 1952-10-28 FRANCE Levy, Joseph M. 683 1951-09-24 Levy, Joseph M. Washington     DC  
8391 8391 1985-06-30 Aerospatiale 1983-09-08 FRANCE Hyman Fine & Associates, Ltd. 3273 1981-09-02 Hyman Fine & Associates, Ltd.       DC  
9291 9291 1942-07-16 G. Henry-Haye (French Embassy) 1942-07-16 FRANCE Musa, John L. 50 1942-07-16 Musa, John L. Washington     DC  
9504 9504 1946-07-27 French Committee for National Liberation 1944-02-28 FRANCE Haight, Griffin, Deming & Gardner 56 1942-07-20 Haight, Griffin, Deming & Gardner Washington     DC  
9558 9558 1952-07-28 Government of France 1947-09-29 FRANCE Cox, Oscar S. 341 1946-01-28 Cox, Oscar S. Washington     DC  
9582 9582 1969-07-29 American Nord Aviation, A Division of Nord Aircraft of France 1969-07-29 FRANCE Queensmith Associates Advertising 2154 1969-07-29 Queensmith Associates Advertising Washington     DC  
9804 9804 1994-07-31 French Embassy 1995-02-22 FRANCE DDC Productions, Inc. 2974 1978-11-01 DDC Productions, Inc. Washington     DC  
10999 10999 1990-08-31 Embassy of France 1987-04-20 FRANCE Alexander, Jane 3968 1987-04-20 Alexander, Jane Washington     DC  
12836 12836 2007-10-18 Strauss-Kahn, Dominique 2008-01-22 FRANCE TD International, LLC 5775 2006-11-07 TD International, LLC International Monetary Fund 700 19th Street, NW Washington DC 20431
13397 13397 2001-10-31 CNES, Embassy of France 2001-10-23 FRANCE Jenkins, Taunya B. 5464 2001-10-23 Jenkins, Taunya B. 4101 Reservoir Road N.W. 20007     DC  
13718 13718 1942-11-05 French Embassy 1942-11-05 FRANCE Minor, Gatley & Drury 153 1942-11-05 Minor, Gatley & Drury Washington     DC  
14317 14317 1944-11-30 French Committee for National Liberation 1944-06-24 FRANCE Nathan, Robert R. 268 1944-06-24 Nathan, Robert R. Washington     DC  
15065 15065 1968-12-13 American Nord-Aviation, Inc. 1961-07-26 FRANCE American Surveys 1269 1959-09-15 American Surveys Washington     DC  
15835 15835 1980-12-31 Embassy of France, French Commerical Office 1970-08-10 FRANCE Daniels, Houlihan & Palmeter 2072 1968-01-30 Daniels, Houlihan & Palmeter Washington     DC  

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