FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
23 rows where Address_1 = "" and Country/Location_Represented = "GERMANY"
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)
Foreign_Principal 23
- Action Press 1
- Association of German Banks 1
- Baden Wuerttemberg International Trade & Investment Office 1
- Berlin Economic Development Corporation 1
- Boehringer Ingelheim GmbH 1
- Boehringer Ingelheim Zentrale, GmbH 1
- City of Hannover, West Germany 1
- Deutsche Bundespost Telekom 1
- Deutsche Messe - und Ausstellungs, A.G. 1
- Deutsche Vereinigung fur eine Christliche Kultur DVCK e.V. 1
- Deutsche Zentrale fuer Tourismus (German National Tourist Board) 1
- Deutscher Industrie - und Handelstag (German National Chamber of Commerce) 1
- EHA Ventilfabrik Wilhelm Fritz KG 1
- Federal Republic of Germany, Ministry of Economics 1
- Free and Hanseatic City of Hamburg 1
- German Consulate General, Chicago 1
- German Consulate General, San Francisco/Los Angeles 1
- German Information Center 1
- German National Tourist Board 1
- German National Tourist Office 1
- IG Metall Germany 1
- Lufthansa German Airlines 1
- Thyssen Nordseewerke GmbH 1
Registrant_Name 21
- Modern Education Services, Inc. 2
- Ruder Finn, Inc. 2
- AC&R Advertising, Inc. 1
- APCO Associates 1
- Barnes, Richardson & Colburn 1
- Burson-Marsteller 1
- FCB/InterMarketing 1
- Foundation for a Christian Civilization, Inc. 1
- Frankl, Wolfe J. 1
- GCI Group, Inc. 1
- Gerich, Walter Raymond 1
- German National Tourist Office 1
- German-American Chamber of Commerce of the Western U.S. 1
- German-American Chamber of Commerce, Inc., New York 1
- J. Woodman Associates, Inc. 1
- Kingsley, Sara 1
- P.W. Anderson & Partners, Inc. 1
- Tromson Monroe Advertising, Inc. 1
- West Glen Communications 1
- White & Case, LLP 1
- Wilkinson, Barker, Knauer & Quinn 1
Registrant_Date (date) 21 ✖
- 1961-09-27 2
- 1964-10-19 2
- 1950-02-28 1
- 1964-11-04 1
- 1973-01-09 1
- 1973-10-23 1
- 1975-03-14 1
- 1977-02-10 1
- 1977-03-09 1
- 1980-12-01 1
- 1981-03-11 1
- 1983-07-07 1
- 1984-05-31 1
- 1984-06-20 1
- 1984-11-06 1
- 1986-04-04 1
- 1986-07-11 1
- 1987-12-16 1
- 1988-11-23 1
- 2019-04-15 1
- 2019-12-02 1
Country/Location_Represented 1
- GERMANY · 23 ✖
City 1
- - 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146 | 146 | Deutsche Zentrale fuer Tourismus (German National Tourist Board) | 1950-02-28 | GERMANY | German National Tourist Office 616 | 1950-02-28 | German National Tourist Office | ||||||
1400 | 1400 | 1990-01-18 | Thyssen Nordseewerke GmbH | 1983-07-07 | GERMANY | Gerich, Walter Raymond 3495 | 1983-07-07 | Gerich, Walter Raymond | |||||
1416 | 1416 | 2018-01-19 | Deutsche Vereinigung fur eine Christliche Kultur DVCK e.V. | 2019-12-02 | GERMANY | Foundation for a Christian Civilization, Inc. 6759 | 2019-12-02 | Foundation for a Christian Civilization, Inc. | |||||
3548 | 3548 | 1991-03-09 | Association of German Banks | 1987-05-15 | GERMANY | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | |||||
3637 | 3637 | 1994-03-11 | German National Tourist Office | 1981-03-11 | GERMANY | AC&R Advertising, Inc. 3211 | 1981-03-11 | AC&R Advertising, Inc. | |||||
3668 | 3668 | 1993-03-12 | Baden Wuerttemberg International Trade & Investment Office | 1987-09-29 | GERMANY | J. Woodman Associates, Inc. 3590 | 1984-05-31 | J. Woodman Associates, Inc. | |||||
3716 | 3716 | 1994-03-14 | German Consulate General, Chicago | 1970-05-20 | GERMANY | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
3718 | 3718 | 1994-03-14 | German Consulate General, San Francisco/Los Angeles | 1984-12-21 | GERMANY | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
4675 | 4675 | 2007-03-31 | Free and Hanseatic City of Hamburg | 2007-05-02 | GERMANY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
6400 | 6400 | 1991-05-08 | Action Press | 1986-05-30 | GERMANY | FCB/InterMarketing 3628 | 1984-11-06 | FCB/InterMarketing | |||||
6444 | 6444 | 2019-05-10 | IG Metall Germany | 2019-04-15 | GERMANY | Kingsley, Sara 6665 | 2019-04-15 | Kingsley, Sara | |||||
7422 | 7422 | 1995-06-01 | Deutsche Bundespost Telekom | 1987-12-16 | GERMANY | Wilkinson, Barker, Knauer & Quinn 4075 | 1987-12-16 | Wilkinson, Barker, Knauer & Quinn | |||||
9187 | 9187 | 2000-07-11 | Boehringer Ingelheim GmbH | 1999-02-23 | GERMANY | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | |||||
11013 | 11013 | 1991-08-31 | Lufthansa German Airlines | 1987-06-18 | GERMANY | APCO Associates 3597 | 1984-06-20 | APCO Associates | |||||
12457 | 12457 | 1991-10-03 | EHA Ventilfabrik Wilhelm Fritz KG | 1983-10-20 | GERMANY | Barnes, Richardson & Colburn 2751 | 1977-02-10 | Barnes, Richardson & Colburn | |||||
12683 | 12683 | 1994-10-14 | Deutsche Messe - und Ausstellungs, A.G. | 1973-03-26 | GERMANY | German-American Chamber of Commerce, Inc., New York 1812 | 1964-11-04 | German-American Chamber of Commerce, Inc., New York | |||||
13392 | 13392 | 2000-10-31 | Deutscher Industrie - und Handelstag (German National Chamber of Commerce) | 1975-03-14 | GERMANY | German-American Chamber of Commerce of the Western U.S. 2563 | 1975-03-14 | German-American Chamber of Commerce of the Western U.S. | |||||
14200 | 14200 | 2003-11-23 | German Information Center | 1988-11-23 | GERMANY | West Glen Communications 4191 | 1988-11-23 | West Glen Communications | NY | ||||
16149 | 16149 | 1990-12-31 | City of Hannover, West Germany | 1986-04-04 | GERMANY | P.W. Anderson & Partners, Inc. 3806 | 1986-04-04 | P.W. Anderson & Partners, Inc. | |||||
16158 | 16158 | 1990-12-31 | German National Tourist Board | 1979-10-10 | GERMANY | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | |||||
16192 | 16192 | 1991-12-31 | Berlin Economic Development Corporation | 1980-12-01 | GERMANY | Frankl, Wolfe J. 3173 | 1980-12-01 | Frankl, Wolfe J. | |||||
16293 | 16293 | 1995-12-31 | Boehringer Ingelheim Zentrale, GmbH | 1987-04-03 | GERMANY | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | |||||
16316 | 16316 | 1995-12-31 | Federal Republic of Germany, Ministry of Economics | 1992-08-04 | GERMANY | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller |
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]) );