FARA_All_ForeignPrincipals
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" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name 19
- North American Precis Syndicate 8
- Association Films, Inc. 3
- Hill and Knowlton Strategies, LLC 2
- Seger, Gerhart Henry 2
- Albert Woodley Company, Inc. 1
- Clinton E. Frank, Inc. 1
- Davis Public Relations, Inc. 1
- Development Counsellors International, Ltd. 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
- Public Service Audience Planners 1
- Schlesinger, Moritz 1
- Sterling Movies 1
Registrant_Date (date) 19 ✖
- 1977-10-12 8
- 1964-11-06 3
- 1952-09-15 2
- 1981-11-10 2
- 1951-01-10 1
- 1953-02-10 1
- 1961-01-30 1
- 1963-02-12 1
- 1964-01-14 1
- 1964-02-28 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
- 1979-08-23 1
- 1980-08-04 1
Foreign_Principal 17
- German Information Center 6
- German Federal Railroad 4
- German National Tourist Office 4
- City of West Berlin 2
- Lufthansa German Airlines 2
- Borman Williams for Dusseldorf Trade Fair Company 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
- Hamburg 1
- Handelsblatt 1
- Lufthansa Airlines 1
- North German Lloyd 1
- Republic of the City of Hamburg 1
State 1
- NY · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 |
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]) );