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

31 rows where Registration_Number = 4529

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Termination_Date (date)

State 1

Registration_Number 1

  • Capitoline/MS&L · 31 ✖

Registrant_Name 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
5127 5127 1994-01-31 1993-06-18 DeLiou Amar Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
5128 5128 1994-01-31 1993-06-18 Sheffer Paula Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
20446 20446 1996-06-28 1994-06-07 Kehnemui Sharon Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
24020 24020 1994-07-25 1993-02-18 Youssefiani Mehrdad Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
24517 24517 1992-07-30 1991-06-20 Brady Lawrence J. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
24889 24889 1997-07-31 1996-02-29 Smith Michael B. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
24896 24896 1997-07-31 1996-07-29 Ones Leyla Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
25791 25791 1993-08-02 1991-06-20 Locigno Paul R. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
25951 25951 1994-08-04 1993-02-18 Brady Lawrence J. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
31156 31156 1997-09-30 1996-02-29 MacKay Gordon D. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
37838 37838 1996-12-06 1996-02-29 Creel Berna M. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41009 41009 1997-12-31 1993-02-18 Hirshberg Jennefer Austin Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41010 41010 1997-12-31 1993-02-18 Moore Powell A. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41011 41011 1997-12-31 1993-02-18 Tarne Eugene C. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41013 41013 1997-12-31 1996-02-29 Behuncik John G. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41014 41014 1997-12-31 1996-02-29 Bolger Terry Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41015 41015 1997-12-31 1996-02-29 Garrison Amy Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41025 41025 1997-12-31 1996-05-03 Jordan Karen Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41035 41035 1997-12-31 1994-06-07 Borland Lydia A. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41036 41036 1997-12-31 1994-06-07 Coupe Jay Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41037 41037 1997-12-31 1994-06-07 Diamond Judith L. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41038 41038 1997-12-31 1991-06-20 Graves Edwin C. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41039 41039 1997-12-31 1991-06-20 Meeter Stephen H. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41040 41040 1997-12-31 1991-06-20 Pucie Charles R. , Jr. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41041 41041 1997-12-31 1991-06-20 Worden Joan M. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41043 41043 1997-12-31 1994-07-06 Roberts Arch W. , Jr. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41044 41044 1997-12-31 1992-07-10 Lange Homer Selim Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41059 41059 1997-12-31 1996-09-30 Vance B. Wayne Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41060 41060 1997-12-31 1993-10-14 Sills Hilary Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41061 41061 1997-12-31 1993-10-14 Sungar Sema H. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036
41064 41064 1997-12-31 1993-12-09 Brady John J. , Jr. Capitoline/MS&L 4529 1991-06-20 Capitoline/MS&L 1615 L Street, N.W. Suite 1150 Washington DC 20036

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