FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

22 rows where Registration_Number = 945

Search:

descending

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	City	State	Zip
2475	2475	1978-01-01	1976-09-03	Proske	Wieland	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
2478	2478	1979-01-01	1978-08-09	Cleff-Klages	Karin	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
3918	3918	1965-01-20	1964-08-28	Stein	Hans	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
4712	4712	1981-01-31	1976-08-10	Mennacher	Johann	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
4764	4764	1989-01-31	1956-04-12	Arnold	Juergen W.	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
4783	4783	1990-01-31	1989-03-02	Saade	Raafat	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
4784	4784	1990-01-31	1977-03-09	Lemke	Hartmut	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
13576	13576	1965-04-30	1963-12-09	Lange	Edith	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
15678	15678	1991-05-20	1984-04-05	Bullock	Lynne	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
15681	15681	1991-05-20	1984-12-11	Hadad	Karin	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
16167	16167	1963-05-28	1956-04-12	Koch	Heinz	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
17853	17853	1964-06-09	1964-01-30	Cotsis	Renate Elizabeth	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
22816	22816	1966-07-29	1966-08-17	Staneck	Ingrid	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
23870	23870	1968-08-01	1965-08-23	Theiding	Helmuth Wilhelm Adolf	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
25851	25851	1970-08-28	1968-08-16	Klessen	Helga Julia	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
26373	26373	1986-08-31	1975-09-26	Krueger	Hermann	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
27421	27421	1967-09-05	1963-12-09	Klinkenborg	Heinz Gerhard	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
30429	30429	1976-10-06	1965-08-23	Ladwig	Harry Friedrich Karl	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
32018	32018	1965-10-30	1965-02-16	Dieterle	Helga	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
33070	33070	1983-11-03	1983-10-21	Hillebrand	Renate	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
34081	34081	1982-11-22	1980-04-09	Simpson	Cindy	945 945	1956-04-12	German Federal Railroad	747 Third Avenue	New York	NY	10017
34472	34472	1974-11-30	1956-04-12	Wenzel	Joachim H.	945 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)
);