FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Address_1 = "Washington" and Country/Location_Represented = "GERMANY, FEDERAL REPUBLIC OF" sorted by Registrant_Date
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 9
Registrant_Date (date) 9 ✖
- 1952-05-28 2
- 1952-09-15 2
- 1954-01-21 2
- 1950-08-16 1
- 1951-02-21 1
- 1955-09-14 1
- 1978-05-03 1
- 1978-10-03 1
- 1986-09-25 1
Foreign_Principal 7
- Diplomatic Mission of the Federal Republic of Germany 3
- Embassy of the Federal Republic of Germany 3
- Federal Republic of Germany 2
- Embassy of the Federal Republic of Germany (Cultural Department) 1
- H. Krekeler 1
- John I. Haas Company, Inc./Verband der Hopfenkaufleute und Hopfenveredler e.V. 1
- Peter von Zahn 1
State 1
- DC 12
Country/Location_Represented 1
- GERMANY, FEDERAL REPUBLIC OF · 12 ✖
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2585 | 2585 | 1953-02-16 | Peter von Zahn | 1952-09-19 | GERMANY, FEDERAL REPUBLIC OF | National Lecture Management, Inc. 638 | 1950-08-16 | National Lecture Management, Inc. | Washington | DC | |||
14318 | 14318 | 1951-11-30 | H. Krekeler | 1951-02-21 | GERMANY, FEDERAL REPUBLIC OF | Simon, Hugo Ferdinand 661 | 1951-02-21 | Simon, Hugo Ferdinand | Washington | DC | |||
6882 | 6882 | 1957-05-28 | Diplomatic Mission of the Federal Republic of Germany | 1952-05-28 | GERMANY, FEDERAL REPUBLIC OF | Arnold, Fortas & Porter 728 | 1952-05-28 | Arnold, Fortas & Porter | Washington | DC | |||
6883 | 6883 | 1957-05-28 | Embassy of the Federal Republic of Germany | 1956-12-04 | GERMANY, FEDERAL REPUBLIC OF | Arnold, Fortas & Porter 728 | 1952-05-28 | Arnold, Fortas & Porter | Washington | DC | |||
3740 | 3740 | 1955-03-15 | Diplomatic Mission of the Federal Republic of Germany | 1952-09-15 | GERMANY, FEDERAL REPUBLIC OF | Seger, Gerhart Henry 741 | 1952-09-15 | Seger, Gerhart Henry | Washington | DC | |||
3744 | 3744 | 1961-03-15 | Embassy of the Federal Republic of Germany | 1956-02-20 | GERMANY, FEDERAL REPUBLIC OF | Seger, Gerhart Henry 741 | 1952-09-15 | Seger, Gerhart Henry | Washington | DC | |||
4138 | 4138 | 1968-03-29 | Diplomatic Mission of the Federal Republic of Germany | 1954-01-21 | GERMANY, FEDERAL REPUBLIC OF | Boykin & De Francis 812 | 1954-01-21 | Boykin & De Francis | Washington | DC | |||
4139 | 4139 | 1968-03-29 | Embassy of the Federal Republic of Germany | 1957-07-09 | GERMANY, FEDERAL REPUBLIC OF | Boykin & De Francis 812 | 1954-01-21 | Boykin & De Francis | Washington | DC | |||
11576 | 11576 | 1959-09-14 | Embassy of the Federal Republic of Germany (Cultural Department) | 1955-09-14 | GERMANY, FEDERAL REPUBLIC OF | Friedmann, Eric 910 | 1955-09-14 | Friedmann, Eric | Washington | DC | |||
10803 | 10803 | 1979-08-28 | Federal Republic of Germany | 1978-05-03 | GERMANY, FEDERAL REPUBLIC OF | Sprenger, Paul C. 2893 | 1978-05-03 | Sprenger, Paul C. | Washington | DC | |||
11954 | 11954 | 1981-09-30 | Federal Republic of Germany | 1978-10-03 | GERMANY, FEDERAL REPUBLIC OF | Sprenger, Olson & Shutes, P.A. 2963 | 1978-10-03 | Sprenger, Olson & Shutes, P.A. | Washington | DC | |||
5580 | 5580 | 1987-04-25 | John I. Haas Company, Inc./Verband der Hopfenkaufleute und Hopfenveredler e.V. | 1986-09-25 | GERMANY, FEDERAL REPUBLIC OF | Verstandig & Associates, Inc. 3890 | 1986-09-25 | Verstandig & Associates, Inc. | Washington | DC |
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]) );