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

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 2

State 1

Country/Location_Represented 1

  • 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
1295 1295 1946-01-15 Dutch Central Transport Workers' Union 1942-07-15 NETHERLANDS Dutch Central Transport Workers' Union 49 1942-07-15 Dutch Central Transport Workers' Union New York     NY  
1296 1296 1946-01-15 Netherlands Information Bureau 1942-07-15 NETHERLANDS Dutch Central Transport Workers' Union 49 1942-07-15 Dutch Central Transport Workers' Union New York     NY  
3015 3015 1996-02-28 Netherlands Foreign Investment Agency 1992-05-01 NETHERLANDS Mathews & Clark Communications 4659 1992-05-01 Mathews & Clark Communications New York     NY  
5006 5006 1989-04-03 Golden Tulip International 1989-03-15 NETHERLANDS FCB/InterMarketing 3628 1984-11-06 FCB/InterMarketing New York     NY  
5193 5193 1984-04-12 Netherlands National Tourist Organization 1982-12-01 NETHERLANDS North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
5203 5203 1986-04-12 Amsterdam Stock Exchange 1985-09-04 NETHERLANDS North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
7306 7306 1944-06-01 Knickerbocker Weekly (Dutch) 1943-12-01 NETHERLANDS Derso & Kelen 222 1943-12-01 Derso & Kelen New York     NY  
7357 7357 1970-06-01 Netherlands National Tourist Office (ANVV) 1964-05-21 NETHERLANDS Lampert Agency, Inc. 1739 1964-05-21 Lampert Agency, Inc. New York     NY  
7575 7575 1986-06-04 Nedlloyd Lines 1983-06-17 NETHERLANDS Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
8097 8097 1997-06-25 Netherlands Foreign Investment Agency 1990-12-28 NETHERLANDS Ogilvy, Adams & Rinehart, Inc. 4455 1990-12-28 Ogilvy, Adams & Rinehart, Inc. New York     NY  
8144 8144 2002-06-28 Government of the Netherlands, Netherlands Foreign Investment Agency (NFIA) 1997-04-24 NETHERLANDS Ruder Finn, Inc. 1481 1961-09-27 Ruder Finn, Inc. New York     NY  
8184 8184 1945-06-30 Netherland-America Foundation, Inc. 1944-04-29 NETHERLANDS Cecil & Presbrey, Inc. 249 1944-04-29 Cecil & Presbrey, Inc. New York     NY  
8210 8210 1947-06-30 Netherlands Information Bureau 1947-04-11 NETHERLANDS Netherland Publishing Corporation 454 1947-04-11 Netherland Publishing Corporation New York     NY  
8229 8229 1957-06-30 Netherlands Information Bureau 1946-04-22 NETHERLANDS Films of the Nations, Inc. 353 1946-04-22 Films of the Nations, Inc. New York     NY  
8306 8306 1976-06-30 Netherland Information Service 1969-09-09 NETHERLANDS Alden Films, Business Education Films, Films of the Nations 2100 1968-08-12 Alden Films, Business Education Films, Films of the Nations New York     NY  
8950 8950 1945-07-02 E.C. Zimmerman (Trade Commissioner for the Netherlands Indies) 1942-09-21 NETHERLANDS American Spice Trade Association, Inc. 126 1942-09-21 American Spice Trade Association, Inc. New York     NY  
9420 9420 1955-07-22 Christian Palamas 1955-06-27 NETHERLANDS Margold, Stella K. 864 1955-01-04 Margold, Stella K. New York     NY  
9955 9955 1963-08-01 Netherlands Consulate General Commercial Division 1964-01-22 NETHERLANDS Clinton E. Frank, Inc., New York 1601 1963-02-25 Clinton E. Frank, Inc., New York New York     NY  
10092 10092 1963-08-03 KLM Royal Dutch Airlines 1963-02-21 NETHERLANDS Forbes Research, Inc. 1197 1959-02-03 Forbes Research, Inc. New York     NY  
10307 10307 1992-08-12 NVW (U.S.A.) 1989-06-28 NETHERLANDS Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 1981-09-10 Powell, Goldstein, Frazer & Murphy, L.L.P. Scarsdale     NY  
10794 10794 1964-08-28 Netherlands National Tourist Office 1951-02-16 NETHERLANDS Charles W. Hoyt Company, Inc. 361 1946-06-10 Charles W. Hoyt Company, Inc. New York     NY  
10795 10795 1964-08-28 Netherlands-West Indies Tourist Committee 1951-02-16 NETHERLANDS Charles W. Hoyt Company, Inc. 361 1946-06-10 Charles W. Hoyt Company, Inc. New York     NY  
11138 11138 2010-08-31 Netherlands Foreign Investment Agency 2004-03-25 NETHERLANDS Al Paul Lefton Company Inc. 5614 2004-03-25 Al Paul Lefton Company Inc. One Rockefeller Plaza - 11th Floor New York 10020     NY  
11728 11728 1962-09-20 KLM Royal Dutch Airlines 1962-03-20 NETHERLANDS Anderson, Cyrus T. 1529 1962-03-20 Anderson, Cyrus T. New York     NY  
11776 11776 1977-09-23 KLM Royal Dutch Airline 1976-04-19 NETHERLANDS Papo, Madeleine Blanche 2684 1976-04-19 Papo, Madeleine Blanche New York     NY  
12256 12256 2019-09-30 Netherlands Foreign Investment Agency 2019-12-08 NETHERLANDS Luxcore, Ltd. 4901 1994-03-10 Luxcore, Ltd. 666 Third Avenue, 19th Floor   New York NY 10017
12389 12389 2000-10-01 Netherlands Foreign Investment Agency (NFIA) 1999-11-01 NETHERLANDS Axelrod, Andrea G. 5339 1999-11-01 Axelrod, Andrea G. New York     NY  
12597 12597 1984-10-11 Holland-American Cruises 1983-05-04 NETHERLANDS North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
14856 14856 1946-12-07 Netherlands Information Bureau 1946-04-10 NETHERLANDS Groen, Maurice T. 351 1946-04-10 Groen, Maurice T. New York     NY  
14949 14949 1992-12-10 Netherlands Board of Tourism 1992-02-26 NETHERLANDS Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
15516 15516 1942-12-31 Netherlands Information Bureau 1942-07-15 NETHERLANDS Van Den Berge, Petrus Jacobus 48 1942-07-15 Van Den Berge, Petrus Jacobus New York     NY  
16012 16012 1987-12-31 KLM Royal Dutch Airlines 1964-10-29 NETHERLANDS Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
16131 16131 1989-12-31 Netherlands Industrial Commission 1982-06-15 NETHERLANDS Gavin Anderson Doremus & Company 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])
);