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

33 rows where "Short_Form_Date" is on date 2017-01-30

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Address_1, Address_2, Short_Form_Date (date)

State 1

City 1

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
240 240   2017-01-30 Tucker James Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
8303 8303 2017-02-28 2017-01-30 Thomas Matthew Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
26654 26654 2019-08-14 2017-01-30 Cosar Yagmur BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
29779 29779 2018-09-14 2017-01-30 Chang Ben BCW LLC 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
35916 35916 2017-11-15 2017-01-30 Neal Terry Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
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

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