FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "New York" and Short_Form_First_Name = "Scott"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 13
- FCB New York 2
- Daniel J. Edelman, Inc. 2
- Quebec Government Office 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- White & Case, LLP 1
- Young & Rubicam, L.P. 1
- IPG DXTRA, Inc 1
- Ketchum Inc. NY 1
- Davidoff Hutcher & Citron, LLP 1
- Adam Friedman Associates, LLC 1
- Finsbury, LLC 1
- White & Case LLP 1
- USSA International LLC 1
Registrant_Name 13
- Daniel J. Edelman, Inc. 2
- FCB New York 2
- Adam Friedman Associates, LLC 1
- Davidoff Hutcher & Citron, LLP 1
- Finsbury, LLC 1
- IPG DXTRA, Inc 1
- Ketchum Inc. NY 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Quebec Government Office 1
- USSA International LLC 1
- White & Case LLP 1
- White & Case, LLP 1
- Young & Rubicam, L.P. 1
State 1
- NY 15
City 1
- New York · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
235 | 235 | 2023-01-29 | Parker Flukinger | Scott | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 | |
771 | 771 | 2023-04-12 | Helfman | Scott | USSA International LLC 7252 | 2023-03-31 | USSA International LLC | 767 5th Avenue, 45th Floor | New York | NY | 10153 | ||
4232 | 4232 | 2014-01-21 | 2013-09-23 | Barocas | Scott | Adam Friedman Associates, LLC 6189 | 2013-09-23 | Adam Friedman Associates, LLC | 28 West 44th Street | Suite 1111 | New York | NY | 10017 |
7261 | 7261 | 2020-02-19 | 2019-07-25 | Hershman | Scott | White & Case LLP 6393 | 2016-11-21 | White & Case LLP | 1221 Avenue of the Americas | New York | NY | 10036 | |
13444 | 13444 | 1991-04-15 | 1990-11-07 | Gross | Scott | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
15087 | 15087 | 2017-04-30 | 2016-03-28 | Etkin | Scott | Finsbury, LLC 6293 | 2015-05-12 | Finsbury, LLC | 3 Columbus Circle, Floor 9 | New York | NY | 10019 | |
15361 | 15361 | 1983-05-01 | 1981-08-27 | Kulok | Scott | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
15527 | 15527 | 2018-05-01 | 2016-08-10 | Schneider | Scott | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
17808 | 17808 | 1995-05-31 | 1995-03-14 | Melanson | Scott | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | 309 West 49th Street | Worldwide Plaza | New York | NY | 10019-7399 |
28537 | 28537 | 2009-08-31 | 2009-05-07 | Thornson | Scott | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
31299 | 31299 | 2002-09-30 | 1994-06-22 | Williams | Scott | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
31995 | 31995 | 2006-10-01 | 2006-05-31 | Lincicome | Scott | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
37053 | 37053 | 2014-11-30 | 2013-05-13 | Klenet | Scott | Davidoff Hutcher & Citron, LLP 6169 | 2013-05-13 | Davidoff Hutcher & Citron, LLP | 605 Third Avenue | 34th Floor | New York | NY | 10158 |
38437 | 38437 | 2013-12-15 | 1989-01-19 | Rosenbit | Scott | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
38643 | 38643 | 2000-12-18 | 1993-03-05 | Tagliarino | Scott | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 |
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]) );