FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
31 rows where Address_1 = "1 Edgewater Plaza"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Registration_Date, Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2589 | 2589 | 1980-01-01 | 1974-06-03 | Richters | Peter | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
3867 | 3867 | 1975-01-16 | 1957-11-14 | Huss | Hermann Diedrich | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
3868 | 3868 | 1975-01-16 | 1957-11-14 | Lampe | Henry Martin | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
6044 | 6044 | 1978-02-03 | 1957-11-14 | Oelsner | John W. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
6774 | 6774 | 1962-02-14 | 1959-12-16 | Trent | John Martin | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
7773 | 7773 | 1981-02-27 | 1974-11-26 | Slizewski | Andrew J. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
9764 | 9764 | 1987-03-13 | 1970-06-10 | Downey | Augustine E. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
9765 | 9765 | 1987-03-13 | 1985-11-12 | Von Beoeczy | Martin | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
9766 | 9766 | 1987-03-13 | 1960-11-22 | Steiner | Annemarie | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
10863 | 10863 | 1981-03-27 | 1970-06-10 | Jankowski | Paul | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
12717 | 12717 | 1978-04-04 | 1977-05-23 | Pouch | Robert H. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
15969 | 15969 | 1988-05-09 | 1983-10-14 | Kruse | Hans Jakob | Hapag-Lloyd, A.G. 3531 | 1983-10-14 | Hapag-Lloyd, A.G. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
15970 | 15970 | 1988-05-09 | 1983-10-14 | vonMaydell | Olaf | Hapag-Lloyd, A.G. 3531 | 1983-10-14 | Hapag-Lloyd, A.G. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
15971 | 15971 | 1988-05-09 | 1983-10-20 | Seiler | Otto J. | Hapag-Lloyd, A.G. 3531 | 1983-10-14 | Hapag-Lloyd, A.G. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
16313 | 16313 | 1961-05-14 | 1957-11-14 | Herrmann | Charlotte Ida | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
18903 | 18903 | 1981-06-05 | 1972-06-05 | Owen | Ivan G. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
19012 | 19012 | 1973-06-07 | 1957-11-14 | Oelsner | Edward C. , Jr. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
22594 | 22594 | 1985-07-05 | 1984-12-28 | Morgenstern | Wolfgang H. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
22836 | 22836 | 1982-07-09 | 1978-05-31 | LaPenna | Gerald J. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
29310 | 29310 | 1984-09-07 | 1959-01-16 | Schmeltzer | John Emile , Jr. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
30890 | 30890 | 1969-09-30 | 1965-12-14 | Junker | Sigrid Luise | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
35738 | 35738 | 1958-11-14 | 1957-11-14 | Matthiessen | Peter | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
35818 | 35818 | 1981-11-15 | 1970-06-10 | Wierda | Donald F. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
36592 | 36592 | 1958-11-30 | 1957-11-14 | Versfelt | Emery L. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
37235 | 37235 | 1958-12-01 | 1957-11-14 | Oelsner | Warren James | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
39890 | 39890 | 1970-12-31 | 1957-11-14 | Hopkins | Theron C. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
39905 | 39905 | 1971-12-31 | 1957-11-14 | Portocarrero | Oscar Valentin | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
40225 | 40225 | 1982-12-31 | 1981-05-20 | DeVoe | Robert J. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
40226 | 40226 | 1982-12-31 | 1981-05-20 | Faustmann | Jutta | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
40230 | 40230 | 1982-12-31 | 1973-06-18 | Oelsner | Edward C. , Jr. | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 | |
40233 | 40233 | 1982-12-31 | 1983-06-20 | Knull | Gebhard | Hapag-Lloyd (America), Inc. 1088 | 1957-11-14 | Hapag-Lloyd (America), Inc. | 1 Edgewater Plaza | Staten Island | NY | 10305 |
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]) );