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

16 rows where Registration_Number = 4953

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Chlopak, Leonard, Schechter & Associates, Inc. · 16 ✖

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
6331 6331 1997-02-07 1996-07-02 Wolf John Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
9784 9784 1998-03-13 1997-07-09 Brown Julia Jane Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
14107 14107 1997-04-25 1996-05-17 Maselli Mary Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
19578 19578 1997-06-15 1996-09-17 Silverman Peter Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
22533 22533 1998-07-03 1997-05-09 Marshall Don Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
24102 24102 1996-07-26 1996-05-17 Fulwider Michael Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
30448 30448 1998-09-25 1997-07-28 Howell Andrew P. Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
30449 30449 1998-09-25 1997-09-11 Larson Jennifer Paige Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
41132 41132 1999-12-31 1998-04-14 Aman Sally J. Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
41137 41137 1999-12-31 1996-05-17 Montrey Scot Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
41138 41138 1999-12-31 1996-05-17 Sullivan Kelly Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
41148 41148 1999-12-31 1997-07-09 Leonard Dan Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
41161 41161 1999-12-31 1994-09-28 Chlopak Robert A. Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
41162 41162 1999-12-31 1994-09-28 Leonard Charles G. Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
41163 41163 1999-12-31 1994-09-28 Schechter Peter Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 Washington DC 20036
41169 41169 1999-12-31 1998-10-30 Waffle William Chlopak, Leonard, Schechter & Associates, Inc. 4953 1994-09-28 Chlopak, Leonard, Schechter & Associates, Inc. 1850 M Street, N.W. Suite 550 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])
);