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

21 rows where Country/Location_Represented = "GERMANY" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 3

State 1

Country/Location_Represented 1

  • GERMANY · 21 ✖
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
262 262   German National Tourist Office 2018-04-30 GERMANY Myriad International Marketing, LLC 6549 2018-04-30 Myriad International Marketing, LLC 122 East 42nd Street, Suite 2000   New York NY 10168
2222 2222 1993-02-05 Lufthansa German Airlines 1988-11-23 GERMANY West Glen Communications 4191 1988-11-23 West Glen Communications East Meadow     NY  
3463 3463 1943-03-06 Byk, Inc. 1942-09-10 GERMANY Goepel, C.P. 120 1942-09-10 Goepel, C.P. New York     NY  
3636 3636 1994-03-11 German Convention Bureau 1981-03-11 GERMANY AC&R Advertising, Inc. 3211 1981-03-11 AC&R Advertising, Inc. East Meadow     NY  
3717 3717 1994-03-14 German Consulate General, New York 1970-05-20 GERMANY Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc. New York     NY  
5355 5355 1991-04-17 German National Tourist Office 1981-07-30 GERMANY Modern Education Services, Inc. 1803 1964-10-19 Modern Education Services, Inc. New York     NY  
5519 5519 1992-04-24 Kempinski International 1991-12-06 GERMANY Trombone Associates, Inc. 4601 1991-12-06 Trombone Associates, Inc. New York     NY  
5521 5521 2003-04-24 Deutsche Bank, AG, New York Branch 2003-07-03 GERMANY Van Scoyoc Associates, Inc. 5401 2000-12-14 Van Scoyoc Associates, Inc. 1301 Avenue of the Americas New York 10019     NY  
6366 6366 1993-05-06 German Information Center 1992-08-07 GERMANY DS Simon Productions, Inc. 3973 1987-05-06 DS Simon Productions, Inc. New York     NY  
6474 6474 1993-05-12 FCB/LKP for the Berlin Tourist Office 1993-04-07 GERMANY North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
7993 7993 2004-06-21 German Information Center 1984-12-20 GERMANY DDC Productions, Inc. 2974 1978-11-01 DDC Productions, Inc. New York     NY  
10682 10682 1992-08-23 German National Tourist Office, New York 1979-01-01 GERMANY Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners New York     NY  
11042 11042 1996-08-31 German-American Chamber of Commerce 1996-10-23 GERMANY Daniel J. Edelman, Inc. 3657 1985-03-12 Daniel J. Edelman, Inc. New York     NY  
11478 11478 1942-09-10 G.H. Mumm Champagne (Societe Vinicole de Champagne Successors) & Associates, Inc. 1942-09-10 GERMANY Goepel, C.P. 120 1942-09-10 Goepel, C.P. New York     NY  
14200 14200 2003-11-23 German Information Center 1988-11-23 GERMANY West Glen Communications 4191 1988-11-23 West Glen Communications       NY  
16157 16157 1990-12-31 German Convention Bureau 1990-09-10 GERMANY Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. East Meadow     NY  
16165 16165 1990-12-31 Lufthansa German Airlines 1990-02-28 GERMANY Tromson Monroe Advertising, Inc. 2403 1973-01-09 Tromson Monroe Advertising, Inc. New York     NY  
16351 16351 1995-12-31 Lufthansa German Airlines 1991-12-06 GERMANY Trombone Associates, Inc. 4601 1991-12-06 Trombone Associates, Inc. New York     NY  
16455 16455 1999-12-31 German Convention Bureau 1991-12-06 GERMANY Trombone Associates, Inc. 4601 1991-12-06 Trombone Associates, Inc. East Meadow     NY  
16456 16456 1999-12-31 German National Tourist Office 1991-12-06 GERMANY Trombone Associates, Inc. 4601 1991-12-06 Trombone Associates, Inc. New York     NY  
16706 16706 2012-12-31 Deutsche Bahn AG - DB US Holding Corporation 2011-12-23 GERMANY Strategy XXI Group, LLC 6058 2011-08-18 Strategy XXI Group, LLC DB US Holding Corporation 120 White Plains Road Tarrytown NY 10591

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