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

18 rows where Registration_Number = 6379

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State

Registration_Number

  • 6379 · 18 ✖

City

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
17 17     Shulklapper Max 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
1509 1509   2016-09-20 Courtovich James C. 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
1510 1510   2016-09-20 Miller James G. 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
1555 1555   2017-09-28 Fleming Patrick 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
1600 1600   2018-10-05 Argueta Eduardo Jose Frances 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
1601 1601   2018-10-05 Mandelbaum Aaron C. 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
3846 3846 2017-01-20 2016-09-20 Kelly John 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
13037 13037 2018-04-20 2017-01-27 Ghazal Jay 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
13038 13038 2018-04-20 2017-01-27 Sandground Sr Mark 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
13040 13040 2018-04-20 2017-09-12 Vitello Frank 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
20753 20753 2017-06-30 2016-09-20 Walling Chris 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
21414 21414 2018-07-06 2017-08-28 Abu-Rubieh Mahmood 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
23975 23975 2017-07-31 2016-09-20 Looney Scott 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
23976 23976 2017-07-31 2016-09-20 Smith Addison 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
24007 24007 2018-07-31 2016-09-20 Amundaray Carla 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
24039 24039 2019-07-31 2016-09-20 Lowman Greg 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
29258 29258 2017-09-29 2016-09-20 Wyatt Edward 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
40212 40212 2017-12-31 2017-01-27 Faulkner Cynthia 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 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)
);