FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where City = "Washington" and Short_Form_Termination_Date = "2000-12-31"
This data as json, CSV (advanced)
Suggested facets: Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41180 | 41180 | 2000-12-31 | 1973-03-02 | Barnard | Robert C. | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | 2000 Pennsylvania Avenue, NW | Washington | DC | 20006-1801 | |
41186 | 41186 | 2000-12-31 | 1999-04-28 | Krasow | Cristina Louise | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
41187 | 41187 | 2000-12-31 | 1999-05-25 | Veress | Bulcsu | Information for Investment Decisions, Inc. (IID) 5312 | 1999-05-25 | Information for Investment Decisions, Inc. (IID) | 818 Connecticut Avenue, N.W. | Suite 850 | Washington | DC | 20006 |
41188 | 41188 | 2000-12-31 | 1998-06-15 | Behrends | Paul D. | Boland & Madigan, Inc. 5147 | 1996-12-30 | Boland & Madigan, Inc. | 700 - 13th Street, N.W. | Suite 350 | Washington | DC | 20005 |
41189 | 41189 | 2000-12-31 | 1998-06-15 | Mcknight | Steven G. | Boland & Madigan, Inc. 5147 | 1996-12-30 | Boland & Madigan, Inc. | 700 - 13th Street, N.W. | Suite 350 | Washington | DC | 20005 |
41191 | 41191 | 2000-12-31 | 1989-06-26 | Grossman | Steven A. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41193 | 41193 | 2000-12-31 | 2000-07-14 | Leibach | Dale W. | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
41195 | 41195 | 2000-12-31 | 1994-08-01 | Devall | James L. | Zuckert, Scoutt & Rasenberger, L.L.P. 4933 | 1994-08-01 | Zuckert, Scoutt & Rasenberger, L.L.P. | 888 - 17th Street, N.W. | Suite 700 | Washington | DC | 20006-3309 |
41197 | 41197 | 2000-12-31 | 1998-10-19 | Adams | Ashley Ann | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
41198 | 41198 | 2000-12-31 | 1999-10-19 | Bernard | Michelle D. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
41199 | 41199 | 2000-12-31 | 1981-11-10 | Hymel | Gary G. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41200 | 41200 | 2000-12-31 | 1990-11-15 | Schule | Robert M. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41203 | 41203 | 2000-12-31 | 1999-11-24 | McCurdy-Mackey | Lisa | Ruder Finn, Inc. 4315 | 1989-11-09 | Ruder Finn, Inc. | 808 - 17th Street, N.W. | Suite 600 | Washington | DC | 20006 |
41208 | 41208 | 2000-12-31 | 1997-12-17 | Pollock | Richard | Shandwick Public Affairs, Inc. 5220 | 1997-12-17 | Shandwick Public Affairs, Inc. | 700 13th Street, N.W. | Suite 1000 | Washington | DC | 20005 |
41212 | 41212 | 2000-12-31 | 1996-12-30 | Madigan | Peter Thomas | Boland & Madigan, Inc. 5147 | 1996-12-30 | Boland & Madigan, Inc. | 700 - 13th Street, N.W. | Suite 350 | Washington | DC | 20005 |
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]) );