FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "New York" and Short_Form_Last_Name = "Friedman"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Address_1, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 12
- Gramercy Shipping Company Corporation 2
- Netherlands Information Service, New York 1
- Ruder Finn, Inc. 1
- Tea Council of the U.S.A., Inc. 1
- East European Trade Enterprise, Inc. 1
- White & Case, LLP 1
- Fund for the Democratic Movement for Change 1
- DWJ Associates, Inc. 1
- Daniel J. Edelman, Inc. 1
- Kanan, Corbin, Schupak & Aronow, Inc. 1
- DDB Worldwide Communications Group, Inc. 1
- Adam Friedman Associates, LLC 1
Registrant_Name 12
- Gramercy Shipping Company Corporation 2
- Adam Friedman Associates, LLC 1
- DDB Worldwide Communications Group, Inc. 1
- DWJ Associates, Inc. 1
- Daniel J. Edelman, Inc. 1
- East European Trade Enterprise, Inc. 1
- Fund for the Democratic Movement for Change 1
- Kanan, Corbin, Schupak & Aronow, Inc. 1
- Netherlands Information Service, New York 1
- Ruder Finn, Inc. 1
- Tea Council of the U.S.A., Inc. 1
- White & Case, LLP 1
State 1
- NY 13
City 1
- New York · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13684 | 13684 | 1978-04-18 | 1977-04-01 | Friedman | Max J. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
16805 | 16805 | 1968-05-21 | 1966-07-13 | Friedman | Jack J. | East European Trade Enterprise, Inc. 1965 | 1966-02-18 | East European Trade Enterprise, Inc. | 221 West 41st Street | New York | NY | 10037 | |
16937 | 16937 | 1977-05-23 | 1977-05-02 | Friedman | Herbert | Fund for the Democratic Movement for Change 2775 | 1977-04-12 | Fund for the Democratic Movement for Change | C/O Daniel Doron | 58 West 68th Street | New York | NY | 10023 |
18559 | 18559 | 2014-06-01 | 2014-04-30 | Friedman | Adam | Adam Friedman Associates, LLC 6189 | 2013-09-23 | Adam Friedman Associates, LLC | 28 West 44th Street | Suite 1111 | New York | NY | 10017 |
23757 | 23757 | 1965-07-22 | 1964-12-23 | Friedman | Saul | Gramercy Shipping Company Corporation 1765 | 1964-06-25 | Gramercy Shipping Company Corporation | 118 East 28th Street | New York | NY | ||
23758 | 23758 | 1965-07-22 | 1964-12-23 | Friedman | William | Gramercy Shipping Company Corporation 1765 | 1964-06-25 | Gramercy Shipping Company Corporation | 118 East 28th Street | New York | NY | ||
24374 | 24374 | 1994-07-29 | 1980-03-28 | Friedman | Paul L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27888 | 27888 | 1972-08-31 | 1947-03-19 | Friedman | David | Netherlands Information Service, New York 447 | 1947-03-14 | Netherlands Information Service, New York | 711 Third Avenue | New York | NY | 10017 | |
30194 | 30194 | 1987-09-21 | 1978-08-18 | Friedman | Michael L. | DWJ Associates, Inc. 2947 | 1978-08-18 | DWJ Associates, Inc. | 295 Madison Avenue | New York | NY | 10017 | |
35716 | 35716 | 1990-11-13 | 1988-04-19 | Friedman | Adam I. | Kanan, Corbin, Schupak & Aronow, Inc. 4128 | 1988-04-19 | Kanan, Corbin, Schupak & Aronow, Inc. | 820 Second Avenue | New York | NY | 10017 | |
38900 | 38900 | 2004-12-21 | 2005-10-04 | Friedman | Jodi | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
39029 | 39029 | 2009-12-23 | 2009-12-23 | Friedman | Seth | DDB Worldwide Communications Group, Inc. 5968 | 2009-12-23 | DDB Worldwide Communications Group, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
40563 | 40563 | 1989-12-31 | 1971-04-23 | Friedman | Michael L. | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | 420 Lexington Avenue | Suite 825 | New York | NY | 10170 |
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]) );