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

30 rows where Country/Location_Represented = "GERMANY, FEDERAL REPUBLIC OF" 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, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

Country/Location_Represented 1

  • GERMANY, FEDERAL REPUBLIC OF · 30 ✖

City 1

  • - 30
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
926 926 1990-01-01 German Federal Railroad 1981-03-16 GERMANY, FEDERAL REPUBLIC OF Herman Associates, Inc. 2578 1975-04-22 Herman Associates, Inc. New York     NY  
1502 1502 1971-01-25 North German Lloyd 1967-07-25 GERMANY, FEDERAL REPUBLIC OF International Council of Cruise Lines 2036 1967-07-25 International Council of Cruise Lines New York     NY  
2471 2471 1971-02-14 Government of the Federal Republic of Germany 1963-02-12 GERMANY, FEDERAL REPUBLIC OF Sterling Movies 1597 1963-02-12 Sterling Movies New York     NY  
4292 4292 1954-03-31 German Consul General 1953-02-10 GERMANY, FEDERAL REPUBLIC OF Schlesinger, Moritz 757 1953-02-10 Schlesinger, Moritz New York     NY  
4988 4988 1982-04-02 Lufthansa German Airlines 1981-09-29 GERMANY, FEDERAL REPUBLIC OF Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners East Meadows     NY  
5205 5205 1986-04-12 Borman Williams for Dusseldorf Trade Fair Company 1985-06-14 GERMANY, FEDERAL REPUBLIC OF North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
5850 5850 1990-04-30 City of West Berlin 1987-08-17 GERMANY, FEDERAL REPUBLIC OF North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
6199 6199 1987-05-01 German National Tourist Office 1986-04-23 GERMANY, FEDERAL REPUBLIC OF Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC New York     NY  
8242 8242 1962-06-30 German Information Center 1961-05-08 GERMANY, FEDERAL REPUBLIC OF Seger, Gerhart Henry 741 1952-09-15 Seger, Gerhart Henry New York     NY  
8315 8315 1977-06-30 German National Tourist Office 1975-12-23 GERMANY, FEDERAL REPUBLIC OF Davis Public Relations, Inc. 2647 1975-12-23 Davis Public Relations, Inc. New York     NY  
8842 8842 1973-07-01 Republic of the City of Hamburg 1972-07-10 GERMANY, FEDERAL REPUBLIC OF Europican Marketing, Inc. 2082 1968-02-25 Europican Marketing, Inc. New York     NY  
9130 9130 1982-07-09 German Information Center 1980-02-06 GERMANY, FEDERAL REPUBLIC OF North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
9131 9131 1982-07-09 Hamburg 1979-06-27 GERMANY, FEDERAL REPUBLIC OF North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
9168 9168 1951-07-11 Consulate General of the Federal Republic of (Western) Germany 1951-01-10 GERMANY, FEDERAL REPUBLIC OF Ephraimson, Hans Eduard 654 1951-01-10 Ephraimson, Hans Eduard New York     NY  
9181 9181 1982-07-11 Handelsblatt 1984-03-16 GERMANY, FEDERAL REPUBLIC OF Development Counsellors International, Ltd. 1421 1961-01-30 Development Counsellors International, Ltd.       NY  
10101 10101 1987-08-03 German Information Center 1986-09-30 GERMANY, FEDERAL REPUBLIC OF Michael Klepper Associates, Inc. 3128 1980-08-04 Michael Klepper Associates, Inc. New York     NY  
10920 10920 1981-08-31 German Federal Railroad 1973-04-17 GERMANY, FEDERAL REPUBLIC OF Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
10925 10925 1981-08-31 German Tourist Information Office 1964-11-06 GERMANY, FEDERAL REPUBLIC OF Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York     NY  
10941 10941 1981-08-31 Lufthansa German Airlines 1973-04-17 GERMANY, FEDERAL REPUBLIC OF Association Films, Inc. 1814 1964-11-06 Association Films, Inc. New York City     NY  
11220 11220 1967-09-01 German Information Center 1964-02-28 GERMANY, FEDERAL REPUBLIC OF Marathon International Productions, Inc. 1695 1964-02-28 Marathon International Productions, Inc. New York     NY  
11619 11619 1966-09-15 German Information Center 1962-07-01 GERMANY, FEDERAL REPUBLIC OF Seger, Gerhart Henry 741 1952-09-15 Seger, Gerhart Henry New York     NY  
11924 11924 1970-09-30 F.U.S. Avionics, Inc., a Division of Messerschmitt-Bolkow- Blohm 1969-12-09 GERMANY, FEDERAL REPUBLIC OF MGI Corporation 2175 1969-12-09 MGI Corporation New York     NY  
12596 12596 1984-10-11 German National Tourist Office 1983-05-04 GERMANY, FEDERAL REPUBLIC OF North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate       NY  
12958 12958 1986-10-23 Lufthansa Airlines 1979-06-27 GERMANY, FEDERAL REPUBLIC OF North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate East Meadows     NY  
13006 13006 1989-10-25 City of West Berlin 1989-09-20 GERMANY, FEDERAL REPUBLIC OF North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
13007 13007 1989-10-25 City of West Berlin, New York 1988-07-25 GERMANY, FEDERAL REPUBLIC OF North American Precis Syndicate 2836 1977-10-12 North American Precis Syndicate New York     NY  
15701 15701 1973-12-31 German Federal Railroad 1964-01-14 GERMANY, FEDERAL REPUBLIC OF Albert Woodley Company, Inc. 1679 1964-01-14 Albert Woodley Company, Inc. New York     NY  
15759 15759 1976-12-31 German Federal Railroad 1975-05-28 GERMANY, FEDERAL REPUBLIC OF Clinton E. Frank, Inc. 2586 1975-05-28 Clinton E. Frank, Inc. New York     NY  
15788 15788 1977-12-31 German Information Center 1976-04-01 GERMANY, FEDERAL REPUBLIC OF Kaghan, Theodore 2677 1976-04-01 Kaghan, Theodore New York     NY  
16117 16117 1989-12-31 German National Tourist Office 1987-09-22 GERMANY, FEDERAL REPUBLIC OF Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 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])
);