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

79 rows where Country/Location_Represented = "FRANCE" and State = "NY"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

Country/Location_Represented 1

  • FRANCE · 79 ✖
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
1840 1840 2002-01-31 Nice Convention and Visitors Bureau (through Mondotels, Inc.) 1998-06-18 FRANCE Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
2182 2182 1977-02-04 Air France 1975-08-04 FRANCE Rogers & Wells 2598 1975-08-04 Rogers & Wells New York     NY  
2373 2373 1965-02-11 French National Railroads 1964-05-05 FRANCE Byrde, Richard & Pound 1722 1964-05-05 Byrde, Richard & Pound New York     NY  
2374 2374 1974-02-11 French National Railroads 1971-08-06 FRANCE Baker & Hartel, Inc. 2273 1971-08-06 Baker & Hartel, Inc. New York     NY  
2467 2467 1971-02-14 French National Railroads 1964-06-25 FRANCE Sterling Movies 1597 1963-02-12 Sterling Movies New York     NY  
2474 2474 1971-02-14 R.W. Schofield Associates, Inc. 1964-06-25 FRANCE Sterling Movies 1597 1963-02-12 Sterling Movies New York     NY  
3607 3607 1993-03-11 Air France 1987-05-26 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc.       NY  
3618 3618 1993-03-11 France-Tourisme 1989-06-23 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3619 3619 1993-03-11 French Alps Commission 1991-09-24 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3620 3620 1993-03-11 French Government Tourist Office 1989-06-23 FRANCE Keating Group, Inc. 2478 1973-11-23 Keating Group, Inc. New York     NY  
3651 3651 1968-03-12 French Government Tourist Office 1967-05-04 FRANCE Savage, John 2024 1967-05-04 Savage, John New York     NY  
3715 3715 1994-03-14 French Government Tourist Office 1971-03-25 FRANCE Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc.       NY  
4025 4025 1943-03-25 French Information Center, Inc. 1942-12-09 FRANCE Maurois, Andre' 162 1942-12-09 Maurois, Andre' New York     NY  
4882 4882 1983-04-01 French Industrial Development Agency 1981-10-27 FRANCE Elgin Press, Inc. 3297 1981-10-27 Elgin Press, Inc. New York     NY  
5209 5209 1986-04-12 Foods & Wines from France 1979-06-27 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5639 5639 1966-04-28 French Government Tourist Office 1965-10-28 FRANCE Savage, John 1934 1965-10-28 Savage, John New York     NY  
5810 5810 1978-04-30 Eurailpass c/o French National Railroads 1974-03-07 FRANCE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
5881 5881 1992-04-30 French Government Tourist Office 1992-03-27 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
6124 6124 1946-05-01 Comite Francais de Liberation Nationale 1943-10-25 FRANCE France Amerique Corporation 218 1943-10-25 France Amerique Corporation New York     NY  
6476 6476 1993-05-12 French Government Tourist Office 1993-04-07 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
6975 6975 1989-05-30 Sidamer Corporation 1988-08-18 FRANCE Government Research Corporation 4170 1988-08-18 Government Research Corporation New York     NY  
7027 7027 1963-05-31 R.W. Schofield Associates 1963-02-12 FRANCE Sterling Movies 1597 1963-02-12 Sterling Movies New York     NY  
7038 7038 1968-05-31 French Government Tourist Office 1967-10-06 FRANCE Bell & Stanton, Inc. 2054 1967-10-06 Bell & Stanton, Inc. New York     NY  
7067 7067 1988-05-31 Thomson-CSF, Inc. 1987-04-03 FRANCE Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. New York     NY  
7100 7100 1991-05-31 Eurail Pass C/O French Rail, Inc. - Mr. Dagobert Scher 1991-04-08 FRANCE West Glen Communications 4191 1988-11-23 West Glen Communications White Plains     NY  
7310 7310 1944-06-01 Pour la Victoire (Free French Weekly) 1943-12-01 FRANCE Derso & Kelen 222 1943-12-01 Derso & Kelen New York     NY  
7940 7940 1997-06-19 Aderly 1990-10-30 FRANCE Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. New York     NY  
8010 8010 1994-06-22 Paribas Corporation 1992-07-07 FRANCE Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP New York     NY  
8236 8236 1960-06-30 French Delegation to the United Nations 1960-06-07 FRANCE Levy, Joseph M. 683 1951-09-24 Levy, Joseph M. New York     NY  
8238 8238 1960-06-30 Michel Dumont, Director, French Embassy Press & Information Service 1951-09-24 FRANCE Levy, Joseph M. 683 1951-09-24 Levy, Joseph M. New York     NY  
8282 8282 1971-06-30 French Government Tourist Office 1970-10-20 FRANCE Ogilvy & Mather, Inc. 1826 1964-12-03 Ogilvy & Mather, Inc. New York     NY  
8331 8331 1980-06-30 French Government Tourist Office 1971-09-08 FRANCE Needham, Harper & Steers Advertising, Inc. 1748 1964-06-03 Needham, Harper & Steers Advertising, Inc. New York     NY  
9129 9129 1982-07-09 French Government Tourist Office 1979-06-27 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
9314 9314 1947-07-17 French Press & Information Service 1945-07-17 FRANCE L'Echo de l'Quest, Inc. 309 1945-07-17 L'Echo de l'Quest, Inc. New York     NY  
9505 9505 1946-07-27 French Line, Inc. 1943-10-15 FRANCE Haight, Griffin, Deming & Gardner 56 1942-07-20 Haight, Griffin, Deming & Gardner New York     NY  
9527 9527 1960-07-27 French Colonial Supply Mission (for the Account of the Governor of Martinique) (F.W.I.) 1944-07-29 FRANCE Compagnie Generale Transatlantique (French Line) 62 1942-07-27 Compagnie Generale Transatlantique (French Line) New York     NY  
9705 9705 1969-07-31 Eurailpass 1965-01-13 FRANCE Mutch Haberman Howard, Inc. 1842 1965-01-13 Mutch Haberman Howard, Inc. New York     NY  
9706 9706 1969-07-31 French National Railroads 1965-01-13 FRANCE Mutch Haberman Howard, Inc. 1842 1965-01-13 Mutch Haberman Howard, Inc. New York     NY  
9973 9973 1979-08-01 French Industrial Development Agency 1979-04-09 FRANCE Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
10140 10140 1985-08-05 Paribas Corporation 1984-04-20 FRANCE Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP New York     NY  
10916 10916 1981-08-31 French Embassy 1972-12-21 FRANCE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
10917 10917 1981-08-31 French Line 1974-03-07 FRANCE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
10918 10918 1981-08-31 French National Railroads 1971-08-24 FRANCE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York     NY  
10953 10953 1981-08-31 R.W. Schofield & Associates 1971-08-24 FRANCE Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
11135 11135 2010-08-31 Air France 2004-11-01 FRANCE Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. 125 West 55th Street New York 10019     NY  
11273 11273 1989-09-01 French National Railroads 1980-12-15 FRANCE Brasseau Advertising 3180 1980-12-15 Brasseau Advertising New York     NY  
11316 11316 1944-09-02 No foreign principal listed (Works on own behalf by the permission from the French Commander in Chief) 1944-03-02 FRANCE Maurois, Andre' 238 1944-03-02 Maurois, Andre' New York     NY  
11509 11509 1972-09-11 Robert W. Schofield & Associates 1970-12-29 FRANCE Forum Group, Ltd. 2232 1970-12-29 Forum Group, Ltd. Brooklyn     NY  
11623 11623 1974-09-15 French Line 1967-07-25 FRANCE International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
11720 11720 1991-09-19 Paribas Corporation 1987-03-31 FRANCE Rogers & Wells, LLP 3428 1982-12-10 Rogers & Wells, LLP New York     NY  
11938 11938 1976-09-30 European Aerospace Corporation (Formerly: French Aerospace Corporation) 1971-01-31 FRANCE Robert B. Meyersburg Company 2242 1971-01-31 Robert B. Meyersburg Company New York     NY  
11971 11971 1985-09-30 Paribas Asset Management, Inc. 1985-08-07 FRANCE Chapoton, John E. 3717 1985-08-07 Chapoton, John E.       NY  
12322 12322 1976-10-01 French National Railroads 1974-11-04 FRANCE Spiro & Associates, Inc. 2545 1974-11-04 Spiro & Associates, Inc. New York     NY  
12433 12433 1942-10-02 French Information Center, Inc. 1942-10-29 FRANCE Cartier, Pierre C. 150 1942-10-29 Cartier, Pierre C. New York     NY  
12691 12691 1942-10-15 Teleradio News Agency 1942-10-15 FRANCE D'Aumale, Claude 141 1942-10-15 D'Aumale, Claude New York     NY  
12698 12698 1970-10-15 French National Railroads 1970-08-17 FRANCE Mutch Haberman Howard, Inc. 1842 1965-01-13 Mutch Haberman Howard, Inc. New York     NY  
12884 12884 1942-10-21 French Information Center, Inc. 1942-10-21 FRANCE Finley, Blanche 145 1942-10-21 Finley, Blanche New York     NY  
12941 12941 1942-10-23 French Information Center, Inc. 1942-10-23 FRANCE Le Branchu, Jean-Yves 148 1942-10-23 Le Branchu, Jean-Yves New York     NY  
13012 13012 1989-10-25 Eurailpass 1987-02-28 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13014 13014 1989-10-25 French Government Tourist Office 1985-04-18 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
13589 13589 1991-11-01 French Government Tourist Office 1991-03-29 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
13867 13867 1992-11-10 French Government Tourist Office 1992-07-23 FRANCE North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
14074 14074 1976-11-19 Air France 1976-11-23 FRANCE Rinfret Associates, Inc. 2736 1976-11-23 Rinfret Associates, Inc. New York     NY  
14259 14259 1982-11-26 Aeroport de Paris 1981-12-03 FRANCE Publicity, Inc. 3314 1981-12-03 Publicity, Inc.       NY  
14332 14332 1967-11-30 French Expositions in the U.S., Inc. 1965-03-12 FRANCE Coudert Brothers 1811 1964-11-02 Coudert Brothers New York     NY  
14334 14334 1967-11-30 Renault, Inc. 1964-11-02 FRANCE Coudert Brothers 1811 1964-11-02 Coudert Brothers New York     NY  
14335 14335 1967-11-30 Sud Aviation Corporation 1964-11-02 FRANCE Coudert Brothers 1811 1964-11-02 Coudert Brothers New York     NY  
14337 14337 1967-11-30 Unity Fire & General Insurance Company 1964-11-02 FRANCE Coudert Brothers 1811 1964-11-02 Coudert Brothers New York     NY  
14397 14397 1989-11-30 Sidamer Corporation 1989-05-31 FRANCE Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
14886 14886 1945-12-08 Syndicat Des Marins De France 1945-06-08 FRANCE Syndicat Des Marins De France 305 1945-06-08 Syndicat Des Marins De France New York     NY  
14895 14895 1981-12-08 French National Railroads 1961-07-11 FRANCE J. Sutherland Gould Associates 1408 1960-11-04 J. Sutherland Gould Associates New York     NY  
15002 15002 1942-12-11 French Information Center, Inc. 1942-12-11 FRANCE Polk, Frank L. 163 1942-12-11 Polk, Frank L. New York     NY  
15264 15264 1994-12-20 France Telecom & Deutsche Telekom 1994-07-25 FRANCE IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc New York     NY  
15647 15647 1966-12-31 Chambre de Commerce Francaise de New York 1943-01-01 FRANCE French Chamber of Commerce of the U.S., Inc. 167 1943-01-01 French Chamber of Commerce of the U.S., Inc. New York     NY  
15655 15655 1967-12-31 EURAILPASS 1961-07-11 FRANCE J. Sutherland Gould Associates 1408 1960-11-04 J. Sutherland Gould Associates New York     NY  
15787 15787 1977-12-31 French Industrial Development Agency 1976-05-03 FRANCE Morrow, Thomas F. 2689 1976-05-03 Morrow, Thomas F. New York     NY  
16187 16187 1991-12-31 Aerospatiale 1991-10-12 FRANCE International Public Relations Company, Ltd. 1967 1966-03-14 International Public Relations Company, Ltd.       NY  
16202 16202 1991-12-31 Hachette U.S.A., Inc. 1991-04-01 FRANCE Jones Day 3427 1982-12-10 Jones Day New York     NY  
16816 16816 2017-12-31 Paris and Ile-de-France through Atout France 2017-05-24 FRANCE Quinn & Co. of NY LTD. 6433 2017-05-24 Quinn & Co. of NY LTD. 825 Third Avenue, 29th Floor   New York NY 10022

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