FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Short_Form_Termination_Date" is on date 2009-02-28 and State = "DC"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8229 | 8229 | 2009-02-28 | 2004-01-09 | Yeutter | Clayton | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
8230 | 8230 | 2009-02-28 | 2004-01-13 | Smith | Duncan C. III | Blank Rome, LLP 4929 | 1994-07-22 | Blank Rome, LLP | 600 New Hampshire Avenue, N.W. | Watergate | Washington | DC | 20037 |
8231 | 8231 | 2009-02-28 | 2009-01-27 | Hertel | Dennis M. | PLM Group, LLC 5825 | 2007-08-20 | PLM Group, LLC | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
8232 | 8232 | 2009-02-28 | 2008-02-14 | McMurtry | Vanda | Parven Pomper Strategies, Inc. 5781 | 2006-12-19 | Parven Pomper Strategies, Inc. | 1055 Thomas Jefferson Street, NW | Suite 302 | Washington | DC | 20007 |
8233 | 8233 | 2009-02-28 | 2007-07-05 | Hanson | Natalie | Samuels International Associates, Inc. 4848 | 1993-08-26 | Samuels International Associates, Inc. | 1140 Connecticut Avenue, N.W. | Suite 950 | Washington | DC | 20036 |
8234 | 8234 | 2009-02-28 | 2003-10-28 | Kraker | Marcus A. | Loeffler Group, LLP 5432 | 2001-05-18 | Loeffler Group, LLP | 1801 K Street, NW | Suite 340 | Washington | DC | 20006 |
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]) );