FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where Document_Type = "Short-Form" and Registrant_Name = "German National Tourist Office"
This data as json, CSV (advanced)
These facets timed out: Foreign_Principal_Country
Registrant_Name 1
- German National Tourist Office · 28 ✖
Foreign_Principal_Name 1
- - 28
Document_Type 1
- Short-Form · 28 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
5784 | 5784 | 2015-01-16 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Huebner, Lisa | https://efile.fara.gov/docs/616-Short-Form-20150116-18.pdf | ||
7007 | 7007 | 2017-01-23 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Gold, Amrei | https://efile.fara.gov/docs/616-Short-Form-20170123-22.pdf | ||
7008 | 7008 | 2017-01-23 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Nuss, Linda | https://efile.fara.gov/docs/616-Short-Form-20170123-20.pdf | ||
16160 | 16160 | 1971-02-14 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Born ,Claus J. | Available-FARA-Public-Office | ||
19468 | 19468 | 1950-02-28 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Baumann ,Hans J. | Available-FARA-Public-Office | ||
19469 | 19469 | 1950-02-28 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Moehring ,Emil A. | Available-FARA-Public-Office | ||
30126 | 30126 | 1951-03-23 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Stemmler ,Klaus | Available-FARA-Public-Office | ||
30127 | 30127 | 1951-03-23 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Warren ,Ralph C. | Available-FARA-Public-Office | ||
30590 | 30590 | 1954-03-25 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Born ,Claus J. | Available-FARA-Public-Office | ||
30591 | 30591 | 1954-03-25 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Kronheimer, Willy Stephen | Available-FARA-Public-Office | ||
77253 | 77253 | 1955-07-20 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Jurim ,William B. | Available-FARA-Public-Office | ||
78034 | 78034 | 2021-07-22 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Hilchey, Luminita | https://efile.fara.gov/docs/616-Short-Form-20210722-24.pdf | ||
78766 | 78766 | 1956-07-26 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Kumrow ,Karl A.. | Available-FARA-Public-Office | ||
81893 | 81893 | 1975-08-01 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Blaettermann ,Knut Helge | Available-FARA-Public-Office | ||
81894 | 81894 | 1975-08-01 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Krueger ,Hermann | Available-FARA-Public-Office | ||
84995 | 84995 | 1976-08-03 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Wuerz, Hedy | Available-FARA-Public-Office | ||
87514 | 87514 | 1973-08-14 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Warren ,Ralph C. | Available-FARA-Public-Office | ||
87674 | 87674 | 1975-08-15 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Nykamp ,Hans W. | Available-FARA-Public-Office | ||
89266 | 89266 | 2013-08-23 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Vella, George | https://efile.fara.gov/docs/616-Short-Form-20130823-8.pdf | ||
95471 | 95471 | 1973-09-04 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Baumann ,Hans J. | Available-FARA-Public-Office | ||
101000 | 101000 | 1950-09-28 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Baumann ,Karl A. | Available-FARA-Public-Office | ||
120732 | 120732 | 1952-11-20 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Engel ,Hans M. | Available-FARA-Public-Office | ||
122193 | 122193 | 1973-11-28 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Fuertjes ,Walli J. | Available-FARA-Public-Office | ||
132248 | 132248 | 2013-12-20 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Carter, Wibke | https://efile.fara.gov/docs/616-Short-Form-20131220-14.pdf | ||
132249 | 132249 | 2013-12-20 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Demetrious, Susanne | https://efile.fara.gov/docs/616-Short-Form-20131220-12.pdf | ||
132250 | 132250 | 2013-12-20 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Lindner, Ricarda | https://efile.fara.gov/docs/616-Short-Form-20131220-10.pdf | ||
132251 | 132251 | 2013-12-20 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Vella, George | https://efile.fara.gov/docs/616-Short-Form-20131220-16.pdf | ||
133060 | 133060 | 1986-12-23 | German National Tourist Office | German National Tourist Office 616 | Short-Form | Martin, Hans-Jochen | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );