List of all foreign principals (active and terminated)

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

33 rows where Country/Location_Represented = "NETHERLANDS" and State = "NY"

View and edit SQL

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

City

State

Country/Location_Represented

  • NETHERLANDS · 33
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
1201 1946-01-15 Dutch Central Transport Workers' Union 1942-07-15 NETHERLANDS 49 49 1942-07-15 Dutch Central Transport Workers' Union New York     NY  
1202 1946-01-15 Netherlands Information Bureau 1942-07-15 NETHERLANDS 49 49 1942-07-15 Dutch Central Transport Workers' Union New York     NY  
2877 1996-02-28 Netherlands Foreign Investment Agency 1992-05-01 NETHERLANDS 4659 4659 1992-05-01 Mathews & Clark Communications New York     NY  
4798 1989-04-03 Golden Tulip International 1989-03-15 NETHERLANDS 3628 3628 1984-11-06 FCB/InterMarketing New York     NY  
4981 1984-04-12 Netherlands National Tourist Organization 1982-12-01 NETHERLANDS 2836 2836 1977-10-12 North American Precis Syndicate New York     NY  
4991 1986-04-12 Amsterdam Stock Exchange 1985-09-04 NETHERLANDS 2836 2836 1977-10-12 North American Precis Syndicate       NY  
7030 1944-06-01 Knickerbocker Weekly (Dutch) 1943-12-01 NETHERLANDS 222 222 1943-12-01 Derso & Kelen New York     NY  
7081 1970-06-01 Netherlands National Tourist Office (ANVV) 1964-05-21 NETHERLANDS 1739 1739 1964-05-21 Lampert Agency, Inc. New York     NY  
7292 1986-06-04 Nedlloyd Lines 1983-06-17 NETHERLANDS 3279 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
7801 1997-06-25 Netherlands Foreign Investment Agency 1990-12-28 NETHERLANDS 4455 4455 1990-12-28 Ogilvy, Adams & Rinehart, Inc. New York     NY  
7848 2002-06-28 Government of the Netherlands, Netherlands Foreign Investment Agency (NFIA) 1997-04-24 NETHERLANDS 1481 1481 1961-09-27 Ruder Finn, Inc. New York     NY  
7887 1945-06-30 Netherland-America Foundation, Inc. 1944-04-29 NETHERLANDS 249 249 1944-04-29 Cecil & Presbrey, Inc. New York     NY  
7913 1947-06-30 Netherlands Information Bureau 1947-04-11 NETHERLANDS 454 454 1947-04-11 Netherland Publishing Corporation New York     NY  
7932 1957-06-30 Netherlands Information Bureau 1946-04-22 NETHERLANDS 353 353 1946-04-22 Films of the Nations, Inc. New York     NY  
8009 1976-06-30 Netherland Information Service 1969-09-09 NETHERLANDS 2100 2100 1968-08-12 Alden Films, Business Education Films, Films of the Nations New York     NY  
8631 1945-07-02 E.C. Zimmerman (Trade Commissioner for the Netherlands Indies) 1942-09-21 NETHERLANDS 126 126 1942-09-21 American Spice Trade Association, Inc. New York     NY  
9094 1955-07-22 Christian Palamas 1955-06-27 NETHERLANDS 864 864 1955-01-04 Margold, Stella K. New York     NY  
9617 1963-08-01 Netherlands Consulate General Commercial Division 1964-01-22 NETHERLANDS 1601 1601 1963-02-25 Clinton E. Frank, Inc., New York New York     NY  
9751 1963-08-03 KLM Royal Dutch Airlines 1963-02-21 NETHERLANDS 1197 1197 1959-02-03 Forbes Research, Inc. New York     NY  
9964 1992-08-12 NVW (U.S.A.) 1989-06-28 NETHERLANDS 3274 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Scarsdale     NY  
10436 1964-08-28 Netherlands National Tourist Office 1951-02-16 NETHERLANDS 361 361 1946-06-10 Charles W. Hoyt Company, Inc. New York     NY  
10437 1964-08-28 Netherlands-West Indies Tourist Committee 1951-02-16 NETHERLANDS 361 361 1946-06-10 Charles W. Hoyt Company, Inc. New York     NY  
10779 2010-08-31 Netherlands Foreign Investment Agency 2004-03-25 NETHERLANDS 5614 5614 2004-03-25 Al Paul Lefton Company Inc. One Rockefeller Plaza - 11th Floor New York 10020     NY  
11351 1962-09-20 KLM Royal Dutch Airlines 1962-03-20 NETHERLANDS 1529 1529 1962-03-20 Anderson, Cyrus T. New York     NY  
11398 1977-09-23 KLM Royal Dutch Airline 1976-04-19 NETHERLANDS 2684 2684 1976-04-19 Papo, Madeleine Blanche New York     NY  
11867 2019-09-30 Netherlands Foreign Investment Agency 2019-12-08 NETHERLANDS 4901 4901 1994-03-10 Luxcore, Ltd. 666 Third Avenue, 19th Floor   New York NY 10017
11973 2000-10-01 Netherlands Foreign Investment Agency (NFIA) 1999-11-01 NETHERLANDS 5339 5339 1999-11-01 Axelrod, Andrea G. New York     NY  
12173 1984-10-11 Holland-American Cruises 1983-05-04 NETHERLANDS 2836 2836 1977-10-12 North American Precis Syndicate       NY  
14381 1946-12-07 Netherlands Information Bureau 1946-04-10 NETHERLANDS 351 351 1946-04-10 Groen, Maurice T. New York     NY  
14474 1992-12-10 Netherlands Board of Tourism 1992-02-26 NETHERLANDS 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
15024 1942-12-31 Netherlands Information Bureau 1942-07-15 NETHERLANDS 48 48 1942-07-15 Van Den Berge, Petrus Jacobus New York     NY  
15520 1987-12-31 KLM Royal Dutch Airlines 1964-10-29 NETHERLANDS 1810 1810 1964-10-29 Tribune Films, Inc. New York     NY  
15639 1989-12-31 Netherlands Industrial Commission 1982-06-15 NETHERLANDS 3378 3378 1982-06-15 Gavin Anderson Doremus & Company New York     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])
);