FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

25 rows where Registration_Number = 616

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Short_Form_Termination_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • German National Tourist Office · 25 ✖

Registrant_Name 1

City 1

Link rowid ▼ Short_Form_Termination_Date Short_Form_Date Short_Form_Last_Name Short_Form_First_Name Registration_Number Registration_Date Registrant_Name Address_1 Address_2 City State Zip
1462 1462   2021-07-22 Hilchey Luminita German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
1658 1658   2013-08-23 Vella George German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
2436 2436   2013-12-20 Demetrious Susanne German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
2437 2437   2013-12-20 Lindner Ricarda German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
2636 2636 1986-01-01 1975-08-01 Krueger Hermann German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
3143 3143 2022-01-03 2017-01-23 Nuss Linda German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
6780 6780 1971-02-14 1954-03-25 Born Claus Jiergen German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
7823 7823 1955-02-28 1954-03-25 Kronheimer Willy Stephen German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
9149 9149 1973-03-05 1956-07-26 Kumrow Karl A.. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
11489 11489 1979-03-31 1975-08-15 Nykamp Hans W. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
11552 11552 1986-03-31 1975-08-01 Blaettermann Knut Helge German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
11622 11622 1990-03-31 1950-02-28 Baumann Hans J. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
13346 13346 2023-04-14 2017-01-23 Gold Amrei German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
14164 14164 1956-04-27 1952-11-20 Engel Hans M. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
14415 14415 1955-04-30 1951-03-23 Stemmler Klaus German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
16172 16172 1950-05-13 1950-02-28 Moehring Emil A. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
17217 17217 1975-05-27 1971-02-14 Born Claus J. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
17218 17218 1975-05-27 1951-03-23 Warren Ralph C. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
17220 17220 1975-05-27 1973-11-28 Fuertjes Walli J. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
27570 27570 1968-08-28 1950-09-28 Baumann Karl A. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
29653 29653 2014-09-12 2013-12-20 Carter Wibke German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
31065 31065 1990-09-30 1986-12-23 Martin Hans-Jochen German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
38970 38970 2016-12-22 2015-01-16 Huebner Lisa German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
39777 39777 1964-12-31 1955-07-20 Jurim William B. German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018
40892 40892 1995-12-31 1976-08-03 Wuerz Hedy German National Tourist Office 616 1950-02-28 German National Tourist Office 1350 Broadway Suite 440 New York NY 10018

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [FARA_All_ShortForms] (
   [Short_Form_Termination_Date] TEXT,
   [Short_Form_Date] TEXT,
   [Short_Form_Last_Name] TEXT,
   [Short_Form_First_Name] TEXT,
   [Registration_Number] INTEGER,
   [Registration_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])
);