FARA_All_ForeignPrincipals
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" sorted by rowid
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 24
- Edelman International Corporation 2
- Levy, Joseph M. 2
- Alexander, Jane 1
- American Surveys 1
- Cox, Oscar S. 1
- DDC Productions, Inc. 1
- Daniel J. Edelman, Inc. 1
- Daniels, Houlihan & Palmeter 1
- Diebold Group, Inc. 1
- Fabre, Leon C. 1
- Haight, Griffin, Deming & Gardner 1
- Hyman Fine & Associates, Ltd. 1
- Jenkins, Taunya B. 1
- Jones Day 1
- LeRoy & Denslow 1
- Meliora Strategy 1
- Miller & Chevalier, Chartered 1
- Minor, Gatley & Drury 1
- Musa, John L. 1
- Nathan, Robert R. 1
- Parrish & Company, Inc. 1
- Queensmith Associates Advertising 1
- TD International, LLC 1
- Wallace, Sidney A. 1
Foreign_Principal 19
- Aerospatiale 4
- French Embassy 3
- Embassy of France 2
- French Committee for National Liberation 2
- Aerospatiale, Inc. 1
- American Nord Aviation, A Division of Nord Aircraft of France 1
- American Nord-Aviation, Inc. 1
- CNES, Embassy of France 1
- Embassy of France, French Commerical Office 1
- European Aerospace Corporation 1
- French Consulate 1
- French Military Attache - Air 1
- G. Henry-Haye (French Embassy) 1
- Genfit 1
- Government of France 1
- Mission de la Marine Marchande et des Transports (French Delegation) 1
- Republic of France 1
- Roger Seydoux, First Counselor in Charge of Public Relations, French Embassy 1
- Strauss-Kahn, Dominique 1
City 2
- - 24
- Washington 2
State 1
- DC · 26 ✖
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
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]) );