FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Short_Form_Termination_Date" is on date 2015-06-30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21816 | 21816 | 2015-06-30 | 2014-01-28 | Lott | Trent | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21818 | 21818 | 2015-06-30 | 2014-03-11 | Verhoff | Geoff | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21819 | 21819 | 2015-06-30 | 2014-04-04 | Thompson | Ryan Day | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21820 | 21820 | 2015-06-30 | 2013-04-08 | Chanin | Michael H. | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
21821 | 21821 | 2015-06-30 | 2013-04-08 | Jesse | Matt | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
21822 | 21822 | 2015-06-30 | 2013-04-08 | Russell | David | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
21830 | 21830 | 2015-06-30 | 2013-05-03 | Wilson | Emily M. | Bryan Cave, LLP 6163 | 2013-04-08 | Bryan Cave, LLP | 1155 F Street, NW | 7th Floor | Washington | DC | 20004 |
21832 | 21832 | 2015-06-30 | 2014-05-18 | Breaux | John B. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21834 | 21834 | 2015-06-30 | 2014-06-11 | Pajor | Ashley Mandolini | General Delegation of the PLO to the US 5244 | 1998-03-18 | General Delegation of the PLO to the US | 1732 Wisconsin Avenue, NW | Washington | DC | 20007 | |
21838 | 21838 | 2015-06-30 | 2014-06-24 | Davis | Lanny J. | Lanny J. Davis & Associates, LLC 6230 | 2014-06-24 | Lanny J. Davis & Associates, LLC | 1900 M Street, NW | Suite 300 | Washington | DC | 20036 |
21839 | 21839 | 2015-06-30 | 2014-06-24 | McManus | Eleanor | Lanny J. Davis & Associates, LLC 6230 | 2014-06-24 | Lanny J. Davis & Associates, LLC | 1900 M Street, NW | Suite 300 | Washington | DC | 20036 |
21840 | 21840 | 2015-06-30 | 1999-07-14 | Brand | Joseph L. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21841 | 21841 | 2015-06-30 | 2014-07-24 | Cantor | Andrew | Peck, Madigan, Jones & Stewart, Inc. 6172 | 2013-06-10 | Peck, Madigan, Jones & Stewart, Inc. | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 |
21842 | 21842 | 2015-06-30 | 2014-07-24 | Murphy | Sheila H. | Peck, Madigan, Jones & Stewart, Inc. 6172 | 2013-06-10 | Peck, Madigan, Jones & Stewart, Inc. | 1300 Connecticut Avenue, NW | Suite 600 | Washington | DC | 20036 |
21843 | 21843 | 2015-06-30 | 1995-07-27 | Deschauer | John J., Jr. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21845 | 21845 | 2015-06-30 | 2012-08-06 | Mirijanian | Peter | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 | |
21847 | 21847 | 2015-06-30 | 2012-10-04 | Cutts | Matthew D. | Squire Patton Boggs, LLP 2165 | 1969-10-09 | Squire Patton Boggs, LLP | 2550 M Street, NW | Washington | DC | 20037-1350 |
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]) );