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

20 rows where Country/Location_Represented = "DENMARK" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, 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

  • DENMARK · 20 ✖
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
967 967 1996-01-01 Government of Denmark 1993-10-01 DENMARK Marston Webb & Associates, Inc. 4209 1989-01-24 Marston Webb & Associates, Inc. New York     NY  
1676 1676 1961-01-31 Denmark in U.S.A. (Just Lunning, C/O Georg Jensen, Inc.) 1960-10-27 DENMARK Gramercy News, Inc. 1405 1960-10-27 Gramercy News, Inc. New York     NY  
2132 2132 1961-02-03 Scandinavian Travel Commission (Members are: Danish, Finnish, Norwegian & Swedish National Travel Offices) 1957-08-13 DENMARK Caples Company 34 1943-03-03 Caples Company New York     NY  
4348 4348 1975-03-31 Danish National Tourist Office 1973-11-26 DENMARK Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
4349 4349 1975-03-31 Danish National Travel Office 1964-10-29 DENMARK Tribune Films, Inc. 1810 1964-10-29 Tribune Films, Inc. New York     NY  
4402 4402 1983-03-31 Danish National Tourist Office, New York 1975-10-30 DENMARK Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
4412 4412 1983-03-31 Scandanavian National Tourist Offices 1974-08-13 DENMARK Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
5153 5153 1946-04-11 C.H.W. Hasselriis 1945-04-11 DENMARK Friends of Denmark, Inc. 300 1945-04-11 Friends of Denmark, Inc. New York     NY  
5260 5260 1992-04-14 Consulate General of Denmark 1991-09-27 DENMARK Pragma Corporation 4571 1991-09-27 Pragma Corporation New York     NY  
5447 5447 1959-04-21 Provinshandelskammeret (Denmark's Provincial Chamber of Commerce) 1959-04-21 DENMARK Jones, Robert Nagel 1220 1959-04-21 Jones, Robert Nagel New York     NY  
5785 5785 1964-04-30 Scandinavian Travel Commission (Danish, Finnish, Norwegian & Swedish National Travel Offices) 1961-08-01 DENMARK Geyer & Oswald, Inc. 1468 1961-08-01 Geyer & Oswald, Inc. New York     NY  
6155 6155 1973-05-01 Scandinavian National Travel Commission (Danish, Norwegian, & Swedish National Travel Offices) 1952-07-22 DENMARK Freed, William Herzl 735 1952-07-22 Freed, William Herzl New York     NY  
7562 7562 1986-06-04 A.P. Moller-Maersk Line 1983-06-17 DENMARK Billig, Sher & Jones, P.C. 3279 1981-10-06 Billig, Sher & Jones, P.C. New York     NY  
9028 9028 1942-07-06 Danish Travel Information Bureau 1942-07-06 DENMARK Christensen, Valdemar Emil 7 1942-07-06 Christensen, Valdemar Emil New York     NY  
9127 9127 1982-07-09 Danish National Tourist Office 1980-02-06 DENMARK North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
10689 10689 1992-08-23 Royal Danish Consulate General, New York 1975-10-30 DENMARK Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
12982 12982 1968-10-24 Scandinavian Travel Commission (Denmark, Finland, Norway & Sweden) 1964-10-12 DENMARK Clinton E. Frank, Inc., New York 1601 1963-02-25 Clinton E. Frank, Inc., New York New York     NY  
13488 13488 2017-10-31 Visit Denmark 2017-04-21 DENMARK Geoffrey Weill Associates 6421 2017-04-21 Geoffrey Weill Associates 655 Third Avenue Suite 810 New York NY 10017
13906 13906 1992-11-12 Danish Tourist Board 1988-11-23 DENMARK West Glen Communications 4191 1988-11-23 West Glen Communications New York     NY  
14838 14838 1984-12-06 Danish Tourist Board 1984-12-06 DENMARK Donald N. Martin & Company, Inc. 1381 1960-07-29 Donald N. Martin & Company, Inc. 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])
);