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

23 rows where Registration_Number = 4079

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Swidler Berlin Shereff Friedman, LLP · 23 ✖

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
3581 3581 1994-01-11 1988-10-07 Lipman Andrew D. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
6315 6315 1989-02-07 1988-01-07 Schaner Kenneth I. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
6318 6318 1989-02-07 1988-03-17 Gray Karen J. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
7480 7480 1996-02-23 1994-12-15 Goldberg Adam W. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
8084 8084 1997-02-28 1993-10-13 Hoff John S. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
10225 10225 1988-03-18 1988-01-07 Lehman Bruce A. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
10226 10226 1988-03-18 1988-01-07 Mitnick Lisa Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
10227 10227 1988-03-18 1988-01-07 Palmer Stephen C. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
10228 10228 1988-03-18 1988-01-07 Prater Dan J. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
10229 10229 1988-03-18 1988-01-07 Starr Piper Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
19982 19982 1996-06-21 1994-12-15 Mazurek Henry E. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22178 22178 1988-07-01 1988-01-07 Walker Vern R. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22716 22716 2000-07-07 1988-01-07 Goldfield H.P. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22717 22717 2000-07-07 1988-01-07 Hyman Lester Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22718 22718 2000-07-07 1988-01-07 Miller Leonard A. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22719 22719 2000-07-07 1988-01-07 Popkin Richard A. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22720 22720 2000-07-07 1996-01-31 Disenhaus Helen E. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22721 22721 2000-07-07 1995-02-27 Novak Alan R. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22722 22722 2000-07-07 1989-07-07 Lehman Bruce A. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22725 22725 2000-07-07 1993-11-05 Palma Jose Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22726 22726 2000-07-07 1993-11-18 Whitehead Priscilla Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
22727 22727 2000-07-07 1994-12-15 Direnfeld Barry B. Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841
28152 28152 1990-08-31 1988-03-17 Gifford-Martinez Dawn Swidler Berlin Shereff Friedman, LLP 4079 1988-01-07 Swidler Berlin Shereff Friedman, LLP 3000 K Street, N.W. Suite 300 Washington DC 20007-3841

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