FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Termination_Date" is on date 2001-02-28 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8124 | 8124 | 2001-02-28 | 1998-03-26 | Ross | Jessica Burke (D.) | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
8130 | 8130 | 2001-02-28 | 2000-05-15 | Hibey | James F. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8131 | 8131 | 2001-02-28 | 2000-05-15 | Saltsman | Richard H. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8132 | 8132 | 2001-02-28 | 1993-06-23 | Roggensack | Margaret Ellen | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
8134 | 8134 | 2001-02-28 | 1998-09-04 | Keens-Douglas | Che | Eastern Caribbean Investment Promotion Service 4080 | 1988-01-14 | Eastern Caribbean Investment Promotion Service | 3216 New Mexico Avenue, N.W. | Washington | DC | 20016 | |
8135 | 8135 | 2001-02-28 | 1998-09-04 | St. Rose | Nerdin | Eastern Caribbean Investment Promotion Service 4080 | 1988-01-14 | Eastern Caribbean Investment Promotion Service | 3216 New Mexico Avenue, N.W. | Washington | DC | 20016 | |
8144 | 8144 | 2001-02-28 | 1995-10-02 | Arrindell | John V. | Eastern Caribbean Investment Promotion Service 4080 | 1988-01-14 | Eastern Caribbean Investment Promotion Service | 3216 New Mexico Avenue, N.W. | Washington | DC | 20016 | |
8145 | 8145 | 2001-02-28 | 2000-10-23 | Dalley | George A. | Dalley, George A. 5393 | 2000-10-23 | Dalley, George A. | Law Office of George A. Dalley | 1328 Vermont Avenue, N.W. | Washington | DC | 20005-3607 |
8148 | 8148 | 2001-02-28 | 1998-10-30 | Watson | Peter S. | Pillsbury Winthrop L.L.P. 5286 | 1998-10-30 | Pillsbury Winthrop L.L.P. | 1133 Connecticut Avenue, N.W. | Washington | DC | 20036 | |
8149 | 8149 | 2001-02-28 | 1989-11-22 | Leibowitz | Lewis E. | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
8150 | 8150 | 2001-02-28 | 1998-12-22 | Takahashi | Toshio | JFCC, Washington Office 4440 | 1990-11-21 | JFCC, Washington Office | 1120 Connecticut Avenue, NW | Suite 440 | Washington | DC | 20036 |
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]) );