FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Address_1 = "New York" and Country/Location_Represented = "GERMANY, FEDERAL REPUBLIC OF" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 17
- Hill and Knowlton Strategies, LLC 2
- North American Precis Syndicate 2
- Seger, Gerhart Henry 2
- Albert Woodley Company, Inc. 1
- Association Films, Inc. 1
- Clinton E. Frank, Inc. 1
- Davis Public Relations, Inc. 1
- Ephraimson, Hans Eduard 1
- Europican Marketing, Inc. 1
- Herman Associates, Inc. 1
- International Council of Cruise Lines 1
- Kaghan, Theodore 1
- MGI Corporation 1
- Marathon International Productions, Inc. 1
- Michael Klepper Associates, Inc. 1
- Schlesinger, Moritz 1
- Sterling Movies 1
Registrant_Date (date) 17 ✖
- 1952-09-15 2
- 1977-10-12 2
- 1981-11-10 2
- 1951-01-10 1
- 1953-02-10 1
- 1963-02-12 1
- 1964-01-14 1
- 1964-02-28 1
- 1964-11-06 1
- 1967-07-25 1
- 1968-02-25 1
- 1969-12-09 1
- 1975-04-22 1
- 1975-05-28 1
- 1975-12-23 1
- 1976-04-01 1
- 1980-08-04 1
Foreign_Principal 12
- German Information Center 5
- German Federal Railroad 3
- German National Tourist Office 3
- City of West Berlin 1
- City of West Berlin, New York 1
- Consulate General of the Federal Republic of (Western) Germany 1
- F.U.S. Avionics, Inc., a Division of Messerschmitt-Bolkow- Blohm 1
- German Consul General 1
- German Tourist Information Office 1
- Government of the Federal Republic of Germany 1
- North German Lloyd 1
- Republic of the City of Hamburg 1
State 1
- NY 20
Country/Location_Represented 1
- GERMANY, FEDERAL REPUBLIC OF · 20 ✖
City 1
- - 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );