FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where City = "New York" and Registration_Number = 945
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Short_Form_First_Name 21 ✖
- Karin 2
- Cindy 1
- Edith 1
- Hans 1
- Harry Friedrich Karl 1
- Hartmut 1
- Heinz 1
- Heinz Gerhard 1
- Helga 1
- Helga Julia 1
- Helmuth Wilhelm Adolf 1
- Hermann 1
- Ingrid 1
- Joachim H. 1
- Johann 1
- Juergen W. 1
- Lynne 1
- Raafat 1
- Renate 1
- Renate Elizabeth 1
- Wieland 1
State 1
- NY 22
Registration_Number 1
- German Federal Railroad · 22 ✖
Registrant_Name 1
City 1
- New York · 22 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2581 | 2581 | 1978-01-01 | 1976-09-03 | Proske | Wieland | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
2584 | 2584 | 1979-01-01 | 1978-08-09 | Cleff-Klages | Karin | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
4152 | 4152 | 1965-01-20 | 1964-08-28 | Stein | Hans | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
4978 | 4978 | 1981-01-31 | 1976-08-10 | Mennacher | Johann | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
5030 | 5030 | 1989-01-31 | 1956-04-12 | Arnold | Juergen W. | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
5049 | 5049 | 1990-01-31 | 1989-03-02 | Saade | Raafat | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
5050 | 5050 | 1990-01-31 | 1977-03-09 | Lemke | Hartmut | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
14450 | 14450 | 1965-04-30 | 1963-12-09 | Lange | Edith | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
16756 | 16756 | 1991-05-20 | 1984-04-05 | Bullock | Lynne | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
16759 | 16759 | 1991-05-20 | 1984-12-11 | Hadad | Karin | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
17271 | 17271 | 1963-05-28 | 1956-04-12 | Koch | Heinz | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
19087 | 19087 | 1964-06-09 | 1964-01-30 | Cotsis | Renate Elizabeth | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
24349 | 24349 | 1966-07-29 | 1966-08-17 | Staneck | Ingrid | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
25469 | 25469 | 1968-08-01 | 1965-08-23 | Theiding | Helmuth Wilhelm Adolf | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
27573 | 27573 | 1970-08-28 | 1968-08-16 | Klessen | Helga Julia | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
28101 | 28101 | 1986-08-31 | 1975-09-26 | Krueger | Hermann | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
29196 | 29196 | 1967-09-05 | 1963-12-09 | Klinkenborg | Heinz Gerhard | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
32351 | 32351 | 1976-10-06 | 1965-08-23 | Ladwig | Harry Friedrich Karl | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
34015 | 34015 | 1965-10-30 | 1965-02-16 | Dieterle | Helga | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
35157 | 35157 | 1983-11-03 | 1983-10-21 | Hillebrand | Renate | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
36208 | 36208 | 1982-11-22 | 1980-04-09 | Simpson | Cindy | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 | |
36629 | 36629 | 1974-11-30 | 1956-04-12 | Wenzel | Joachim H. | German Federal Railroad 945 | 1956-04-12 | German Federal Railroad | 747 Third Avenue | New York | NY | 10017 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );