FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_Last_Name = "Elliott"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 10
- Hill and Knowlton Strategies, LLC 3
- Bennett Associates, Inc. 1
- Surrey, Karasik, Gould and Efron 1
- Needham, Harper & Steers Advertising, Inc. 1
- Ogilvy & Mather, Inc. 1
- Bildersee Public Relations, Inc. 1
- Hogan Lovells US LLP 1
- A.F. Sabo Associates, Inc. 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Caplin & Drysdale, Chartered 1
Registrant_Name 10
- Hill and Knowlton Strategies, LLC 3
- A.F. Sabo Associates, Inc. 1
- Bennett Associates, Inc. 1
- Bildersee Public Relations, Inc. 1
- Caplin & Drysdale, Chartered 1
- Hogan Lovells US LLP 1
- Needham, Harper & Steers Advertising, Inc. 1
- Ogilvy & Mather, Inc. 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Surrey, Karasik, Gould and Efron 1
City 2
- New York 6
- Washington 6
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2814 | 2814 | 2003-01-01 | 2001-05-15 | Elliott | Kevin R. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
8688 | 8688 | 1972-03-01 | 1968-08-16 | Elliott | Robert R. | Surrey, Karasik, Gould and Efron 1178 | 1958-10-09 | Surrey, Karasik, Gould and Efron | Woodward Building | Washington | DC | 20005 | |
12866 | 12866 | 1969-04-07 | 1964-06-03 | Elliott | Sylvia Lillian | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
20836 | 20836 | 1971-06-30 | 1971-08-06 | Elliott | John , Jr. | Ogilvy & Mather, Inc. 1826 | 1964-12-03 | Ogilvy & Mather, Inc. | 2 East 48th Street | New York | NY | 10017 | |
21578 | 21578 | 2006-06-30 | 2006-08-14 | Elliott | Kevin R. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
28406 | 28406 | 2002-08-31 | 1988-03-29 | Elliott | Robert J. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
33606 | 33606 | 1987-10-25 | 1986-04-25 | Elliott | Robert H. , Jr. | Caplin & Drysdale, Chartered 3821 | 1986-04-25 | Caplin & Drysdale, Chartered | 1 Thomas Circle, N.W. | Washington | DC | 20005 | |
36244 | 36244 | 1981-11-23 | 1981-10-29 | Elliott | George A. , III | A.F. Sabo Associates, Inc. 3115 | 1980-06-27 | A.F. Sabo Associates, Inc. | 575 Lexington Avenue | Suite 2200 | New York | NY | 10022 |
36405 | 36405 | 2019-11-25 | 2019-04-05 | Elliott | Kevin | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
36467 | 36467 | 1967-11-27 | 1967-10-24 | Elliott | Robert F. | Bildersee Public Relations, Inc. 2058 | 1967-10-24 | Bildersee Public Relations, Inc. | 18 East 41st Street | New York | NY | 10017 | |
38490 | 38490 | 1965-12-16 | 1963-08-08 | Elliott | Robert Irwin | Bennett Associates, Inc. 1140 | 1958-05-08 | Bennett Associates, Inc. | 605 Third Avenue | New York | NY | 10016 | |
40605 | 40605 | 1990-12-31 | 1985-02-04 | Elliott | Richard S. | Paul, Weiss, Rifkind, Wharton & Garrison 3647 | 1985-02-04 | Paul, Weiss, Rifkind, Wharton & Garrison | 1285 Avenue of the Americas | New York | NY | 10019 |
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]) );