FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "Washington" and "Short_Form_Termination_Date" is on date 2012-06-30
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21696 | 21696 | 2012-06-30 | 2011-03-02 | Paulsen | Zachary | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21698 | 21698 | 2012-06-30 | 2009-05-08 | Mansfield | Carolyn | Endeavor Law Firm, PC 5934 | 2009-05-08 | Endeavor Law Firm, PC | 1775 Pennsylvania Avenue, NW | Washington | DC | 20006 | |
21700 | 21700 | 2012-06-30 | 2005-06-23 | Tucker | Jamie | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
21701 | 21701 | 2012-06-30 | 2011-07-29 | Brathwaite | Paul | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
21702 | 21702 | 2012-06-30 | 2011-07-29 | James | Claudia | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
21704 | 21704 | 2012-06-30 | 2010-09-30 | Pence | Eliot | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | 1133 21st Street, NW | Suite 405 | Washington | DC | 20036 |
21706 | 21706 | 2012-06-30 | 2010-12-21 | Giacometto | Leo A. | GAGE International, LLC 6011 | 2010-12-21 | GAGE International, LLC | 122 C Street, NW | Suite 380 | Washington | DC | 20001 |
21707 | 21707 | 2012-06-30 | 2010-12-21 | Rehberg | AJ | GAGE International, LLC 6011 | 2010-12-21 | GAGE International, LLC | 122 C Street, NW | Suite 380 | Washington | DC | 20001 |
21708 | 21708 | 2012-06-30 | 2011-12-22 | Espinosa | Carlos | Blue Star Strategies, LLC 6083 | 2011-12-22 | Blue Star Strategies, LLC | 888 17th Street, NW | Suite 800 | Washington | DC | 20006 |
21709 | 21709 | 2012-06-30 | 2011-12-22 | Korkoian | David | Blue Star Strategies, LLC 6083 | 2011-12-22 | Blue Star Strategies, LLC | 888 17th Street, NW | Suite 800 | Washington | DC | 20006 |
21710 | 21710 | 2012-06-30 | 2011-12-22 | Tramontano | Karen A. | Blue Star Strategies, LLC 6083 | 2011-12-22 | Blue Star Strategies, LLC | 888 17th Street, NW | Suite 800 | Washington | DC | 20006 |
21711 | 21711 | 2012-06-30 | 2011-12-22 | Zinny | Gabriel Sanchez | Blue Star Strategies, LLC 6083 | 2011-12-22 | Blue Star Strategies, LLC | 888 17th Street, NW | Suite 800 | Washington | DC | 20006 |
21712 | 21712 | 2012-06-30 | 2005-12-27 | Hruby | Aubrey | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | 1133 21st Street, NW | Suite 405 | 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]) );