FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
32 rows where Address_2 = "10th Floor" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Zip, Short_Form_Termination_Date (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1101 | 1101 | 2010-05-25 | Wieck | Reinhard | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 | |
1125 | 1125 | 2004-05-28 | Hussong | Annette | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 | |
1148 | 1148 | 2003-05-30 | Hedberg | James I. | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 | |
1149 | 1149 | 2017-05-30 | Anderson | Thomas McKee | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 | |
5755 | 5755 | 1987-02-01 | 1986-09-04 | Reston | Thomas B. | Darius International, Inc. 3713 | 1985-08-06 | Darius International, Inc. | 311 East 72nd Street | 10th Floor | New York | NY | 10021 |
6746 | 6746 | 2004-02-13 | 1997-10-02 | Breitfeld | Julie S. | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
6815 | 6815 | 1991-02-14 | 1990-12-07 | Chizhik | Vladimir | U.S.A. Expo, Inc. 4445 | 1990-12-07 | U.S.A. Expo, Inc. | 440 Park Avenue, South | 10th Floor | New York | NY | 10016 |
8974 | 8974 | 1998-03-02 | 1996-04-04 | Strauss | Andrea | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
14219 | 14219 | 2017-04-27 | 2013-05-29 | Calascione | Joseph Salvatore | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
14937 | 14937 | 2006-04-30 | 2007-07-31 | Bergman | Edward | Business Council for International Understanding, Inc. (BCIU) 5713 | 2005-10-19 | Business Council for International Understanding, Inc. (BCIU) | 1212 Avenue of the Americas | 10th Floor | New York | NY | 10036 |
14941 | 14941 | 2006-04-30 | 2005-10-19 | Tichansky | Peter J. | Business Council for International Understanding, Inc. (BCIU) 5713 | 2005-10-19 | Business Council for International Understanding, Inc. (BCIU) | 1212 Avenue of the Americas | 10th Floor | New York | NY | 10036 |
18101 | 18101 | 2013-05-31 | 1999-03-04 | Frowein | Henrike | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
18977 | 18977 | 1988-06-06 | 1986-03-07 | Rosenbaum | Alvin | Darius International, Inc. 3713 | 1985-08-06 | Darius International, Inc. | 311 East 72nd Street | 10th Floor | New York | NY | 10021 |
18979 | 18979 | 1988-06-06 | 1985-08-06 | Emerson | Peter V. | Darius International, Inc. 3713 | 1985-08-06 | Darius International, Inc. | 311 East 72nd Street | 10th Floor | New York | NY | 10021 |
21281 | 21281 | 1997-06-30 | 1990-10-09 | Wirz | Herbert | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
21355 | 21355 | 2000-06-30 | 1993-05-19 | Weintraub | Alan M. | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
21356 | 21356 | 2000-06-30 | 1993-05-19 | Zalaznick | Barry | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
21643 | 21643 | 2009-06-30 | 2001-08-08 | Jakubek | Wolfgang P. | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
21896 | 21896 | 2018-06-30 | 1996-03-26 | Shingleton | A. Bradley | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
22293 | 22293 | 2001-07-01 | 1997-10-02 | Tegge | Andreas | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
24959 | 24959 | 2000-07-31 | 1993-05-19 | Kelly | Paul | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
34387 | 34387 | 1997-10-31 | 1996-03-26 | Mai | Klaus | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
36885 | 36885 | 2000-11-30 | 1993-05-19 | Dunworth | Gerald J. | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
36886 | 36886 | 2000-11-30 | 1993-05-19 | Flaherty | John F. | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
36887 | 36887 | 2000-11-30 | 1993-05-19 | Grassi | Paolo S. | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
36888 | 36888 | 2000-11-30 | 1993-05-19 | McGivney | James H. | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
36889 | 36889 | 2000-11-30 | 1993-05-19 | Ruffino | Stephen F. | Gibney, Anthony & Flaherty, L.L.P. 4805 | 1993-05-19 | Gibney, Anthony & Flaherty, L.L.P. | 665 Fifth Avenue | 10th Floor | New York | NY | 10022-5305 |
39134 | 39134 | 2006-12-26 | 2007-03-14 | Coltrin | Stephen H. | Coltrin & Associates, Inc. 5782 | 2006-12-26 | Coltrin & Associates, Inc. | 1212 Avenue of the Americas | 10th Floor | New York | NY | 10036 |
39135 | 39135 | 2006-12-26 | 2007-03-14 | Thatcher | Brad | Coltrin & Associates, Inc. 5782 | 2006-12-26 | Coltrin & Associates, Inc. | 1212 Avenue of the Americas | 10th Floor | New York | NY | 10036 |
41164 | 41164 | 1999-12-31 | 1990-10-09 | Hassenbein | Donald | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
41355 | 41355 | 2004-12-31 | 2004-05-28 | Hedberg | Jeffrey A. | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
41866 | 41866 | 2013-12-31 | 2005-05-19 | Statz | Klaus-Peter | Deutsche Telekom, Inc. 4419 | 1990-10-09 | Deutsche Telekom, Inc. | One Rockefeller Plaza | 10th Floor | New York | NY | 10020 |
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]) );