FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

73 rows where City = "Washington", Short_Form_Termination_Date = "2017-12-31" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)

State 1

City 1

  • Washington · 73 ✖
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
42082 42082 2017-12-31 2017-01-27 Faulkner Cynthia S.G.R. LLC Government Relations and Lobbying 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 Eye Street, NW Suite 410 Washington DC 20006
42083 42083 2017-12-31 2017-01-30 Allison Steven BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42084 42084 2017-12-31 2017-01-30 Avinger Katie BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42085 42085 2017-12-31 2017-01-30 Buehler Susan BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42086 42086 2017-12-31 2017-01-30 Chandler Carson BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42087 42087 2017-12-31 2017-01-30 Cox Matthew BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42088 42088 2017-12-31 2017-01-30 Cunningham David BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42089 42089 2017-12-31 2017-01-30 Dunaway Scott BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42090 42090 2017-12-31 2017-01-30 Ert Lauren Van BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42091 42091 2017-12-31 2017-01-30 Feeley Kevin A. BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42092 42092 2017-12-31 2017-01-30 Graul Mark BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42093 42093 2017-12-31 2017-01-30 Hallaway Katie BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42094 42094 2017-12-31 2017-01-30 Kefauver Joseph BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42095 42095 2017-12-31 2017-01-30 Koenig Shanna BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42096 42096 2017-12-31 2017-01-30 Martinez Natalie BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42097 42097 2017-12-31 2017-01-30 Mason Karen BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42098 42098 2017-12-31 2017-01-30 McMillan Kim BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42099 42099 2017-12-31 2017-01-30 McShane Rory BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42100 42100 2017-12-31 2017-01-30 Melton Patrick BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42101 42101 2017-12-31 2017-01-30 Pinales Yesenia BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42102 42102 2017-12-31 2017-01-30 Price Walter BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42103 42103 2017-12-31 2017-01-30 Pruitt David BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42104 42104 2017-12-31 2017-01-30 Schacht Nathan BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42105 42105 2017-12-31 2017-01-30 Schwartz David BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42106 42106 2017-12-31 2017-01-30 Smith Nancy BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42107 42107 2017-12-31 2017-01-30 Thomas Travis BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42108 42108 2017-12-31 2017-01-30 Thompson Randi BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42109 42109 2017-12-31 2017-01-30 Torralvo Diana BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42110 42110 2017-12-31 2017-01-30 Walch Dana BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42111 42111 2017-12-31 2013-01-31 Dyer James Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42112 42112 2017-12-31 2013-01-31 Holly Josh Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42113 42113 2017-12-31 2010-02-03 Anderson John Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42114 42114 2017-12-31 1999-02-08 Skladany, Jr. Barney J. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
42115 42115 2017-12-31 2014-02-10 Kirsch Steven Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42117 42117 2017-12-31 2013-03-01 Moore Riley Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42118 42118 2017-12-31 2009-04-01 Podesta Anthony T. Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42119 42119 2017-12-31 2011-04-07 Friedman Francine Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
42121 42121 2017-12-31 2018-05-01 Smullen F. William QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
42122 42122 2017-12-31 2017-05-09 Brooks Jeri J. BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42123 42123 2017-12-31 2017-05-09 Callanan Erin M. BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42124 42124 2017-12-31 2017-05-09 Christman Rita Elizabeth BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42125 42125 2017-12-31 2017-05-09 Ortega Jorge BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42126 42126 2017-12-31 2017-05-09 Rodriguez Matthew BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42127 42127 2017-12-31 2016-05-11 Farber Ethan BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42128 42128 2017-12-31 2016-05-11 Gensemer Thomas BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42129 42129 2017-12-31 2016-05-11 Posner Ralph BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42130 42130 2017-12-31 2016-05-11 Sessums Michael BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42131 42131 2017-12-31 2016-05-11 Vega Dagoberto BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42136 42136 2017-12-31 2015-05-22 Cohen Nicole Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
42138 42138 2017-12-31 2016-05-31 Dade Corey A. BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42139 42139 2017-12-31 2016-05-31 Gaines Jeremy BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42140 42140 2017-12-31 2009-06-02 Nordwind William R. Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
42141 42141 2017-12-31 1991-06-12 Griffith Spencer S. Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
42144 42144 2017-12-31 2018-07-06 Bates Hunter Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
42145 42145 2017-12-31 2015-07-20 Dyson Caryn Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
42146 42146 2017-12-31 2014-07-30 Adams David Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42147 42147 2017-12-31 2014-07-30 Wohlford Katelyn Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42148 42148 2017-12-31 2016-07-31 Jarnagan Stephanie BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42149 42149 2017-12-31 2016-07-31 Miner Julie BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42150 42150 2017-12-31 2016-07-31 Naru Stephen BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42151 42151 2017-12-31 2016-07-31 Smith Rachel BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42152 42152 2017-12-31 2016-07-31 Spriggs-Hernandez Cherri BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42153 42153 2017-12-31 2016-07-31 Vega Mayra BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42154 42154 2017-12-31 2017-07-31 Komisarjevsky Nicholas BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
42160 42160 2017-12-31 2018-08-31 Crabbe Carol C. Wilson Global Communications, LLC 6584 2018-08-31 Wilson Global Communications, LLC 1701 Pennsylvania Avenue, NW Second Floor Washington DC 20006
42161 42161 2017-12-31 2017-09-05 Beck Katherine Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42162 42162 2017-12-31 2017-09-05 Bohlen Will Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42165 42165 2017-12-31 2017-11-16 Gilster Kyle Husch Blackwell, LLP 6362 2016-06-22 Husch Blackwell, LLP 750 17th Street, NW Suite 900 Washington DC 20006
42166 42166 2017-12-31 2014-11-18 Johnson Rachelle Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42167 42167 2017-12-31 2017-11-30 Ferguson Robert E. Hawksbill Group, LLC 6493 2017-11-30 Hawksbill Group, LLC 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
42168 42168 2017-12-31 2017-11-30 Lee Timothy Eby Hawksbill Group, LLC 6493 2017-11-30 Hawksbill Group, LLC 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
42171 42171 2017-12-31 2017-12-21 Hruska Andrew C King & Spalding LLP 6501 2017-12-21 King & Spalding LLP 1700 Pennsylvania Avenue, NW Suite 200 Washington DC 20006
42176 42176 2017-12-31 2017-12-31 Bates Hunter Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);