FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and Short_Form_First_Name = "Richard J."
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 10
- Ruder Finn, Inc. 2
- Chinese Information Service 1
- DDB Worldwide Communications Group, Inc. 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- McCann-Erickson, Inc. 1
- Milbank, Tweed, Hadley & McCloy 1
- Keating Group, Inc. 1
- Kekst & Company, Inc. 1
- Dilenschneider Group 1
- Cleary Gottlieb Steen & Hamilton LLP 1
Registrant_Name 10
- Ruder Finn, Inc. 2
- Chinese Information Service 1
- Cleary Gottlieb Steen & Hamilton LLP 1
- DDB Worldwide Communications Group, Inc. 1
- Dilenschneider Group 1
- Keating Group, Inc. 1
- Kekst & Company, Inc. 1
- McCann-Erickson, Inc. 1
- Milbank, Tweed, Hadley & McCloy 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
State 1
- NY 11
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6545 | 6545 | 1992-02-10 | 1977-03-01 | Wight | Richard J. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
9636 | 9636 | 1993-03-11 | 1984-10-22 | Keating | Richard J. | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | 331 Madison Avenue | 8th Floor | New York | NY | 10017 |
13075 | 13075 | 1987-04-10 | 1987-01-05 | Rothstein | Richard J. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
15320 | 15320 | 1971-05-01 | 1970-05-08 | Schure | Richard J. | Chinese Information Service 402 | 1946-11-26 | Chinese Information Service | 159 Lexington Avenue | New York | NY | 10016 | |
20198 | 20198 | 2021-06-24 | 2021-05-25 | Cooper | Richard J. | Cleary Gottlieb Steen & Hamilton LLP 6964 | 2021-05-25 | Cleary Gottlieb Steen & Hamilton LLP | One Liberty Plaza | New York | NY | 10006 | |
22268 | 22268 | 1997-07-01 | 1997-06-27 | Kosmicki | Richard J. | Dilenschneider Group 5188 | 1997-06-27 | Dilenschneider Group | 200 Park Avenue | 26th Floor | New York | NY | 10166 |
27959 | 27959 | 1977-08-31 | 1967-06-19 | Blake | Richard J. | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
32163 | 32163 | 1992-10-02 | 1990-02-21 | Wolff | Richard J. | Kekst & Company, Inc. 4342 | 1990-02-21 | Kekst & Company, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
32359 | 32359 | 1987-10-06 | 1981-02-23 | Cunningham | Richard J. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
36651 | 36651 | 1982-11-30 | 1980-11-20 | Keegan | Richard J. | DDB Worldwide Communications Group, Inc. 1066 | 1957-09-16 | DDB Worldwide Communications Group, Inc. | 437 Madison Avenue | New York | NY | 10022 | |
38377 | 38377 | 1979-12-15 | 1979-11-15 | Meylan | Richard J. | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | 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]) );