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

52 rows where City = "Washington" and Registration_Number = 4208

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Shearman & Sterling · 52 ✖

Registrant_Name 1

City 1

  • Washington · 52 ✖
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
4320 4320 2000-01-23 1998-05-18 Davis Frederick T. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7246 7246 1998-02-19 1996-01-29 Moore Christopher Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7248 7248 1998-02-19 1989-05-12 Epstein Anita Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7443 7443 1990-02-23 1989-01-23 Abbott Raymond T. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7444 7444 1990-02-23 1989-01-23 Abrams Idelle R. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7445 7445 1990-02-23 1989-01-23 Bard Jennifer S. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7446 7446 1990-02-23 1989-01-23 Biggio Charles E. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7447 7447 1990-02-23 1989-01-23 Blessing Peter H. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7448 7448 1990-02-23 1989-01-23 Dauman Philippe P. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7449 7449 1990-02-23 1989-01-23 Deming Rachel E. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7450 7450 1990-02-23 1989-01-23 Dieterich Thomas A. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7451 7451 1990-02-23 1989-01-23 Epstein Jeremy G. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7452 7452 1990-02-23 1989-01-23 Freeling Kenneth A. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7453 7453 1990-02-23 1989-01-23 Goudiss Alan S. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7454 7454 1990-02-23 1989-01-23 Han Edward Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7455 7455 1990-02-23 1989-01-23 Hart Karen Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7456 7456 1990-02-23 1989-01-23 Kramer Kenneth M. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7457 7457 1990-02-23 1989-01-23 Rolfes James A. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7458 7458 1990-02-23 1989-01-23 Schmidt John T. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7460 7460 1990-02-23 1989-02-15 Butler Paul M. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7461 7461 1990-02-23 1989-02-21 Kondratiev-Keigh Michael Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7462 7462 1990-02-23 1989-02-21 McNulty Margaret A. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7463 7463 1990-02-23 1989-02-21 Meshulam Deborah R. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7464 7464 1990-02-23 1989-02-21 Saltarelli Joseph J. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7473 7473 1993-02-23 1991-09-24 Tokos Thomas C. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7478 7478 1995-02-23 1992-10-07 Levinas Randi B. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7541 7541 1995-02-24 1990-04-05 Becker Stephan E. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
7997 7997 1992-02-28 1991-11-19 Meagher Joseph Patrick Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
9571 9571 1995-03-10 1993-04-15 Eddleman Linda Hinikar Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
13453 13453 1993-04-15 1990-04-05 Berck Jonathan S. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
13454 13454 1993-04-15 1990-04-06 Tarullo Daniel T. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
13455 13455 1993-04-15 1989-05-15 Wollen W. Foster Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
13456 13456 1993-04-15 1992-06-19 Martin Thomas S. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
13458 13458 1993-04-15 1989-08-31 Shine Cathleen Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
13459 13459 1993-04-15 1991-09-24 Bergquist Robert A. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
14745 14745 1998-04-30 1990-04-06 Finlayson Grant Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
19247 19247 1997-06-11 1996-01-29 Rudbeck James P. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
19980 19980 1996-06-21 1996-01-29 Lane Annika Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
25953 25953 1995-08-04 1995-05-25 Gaines Richard Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
27266 27266 1994-08-23 1993-02-24 Censky Stephen L. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
27267 27267 1994-08-23 1990-04-05 Springer Gary L. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
27268 27268 1994-08-23 1991-11-19 Clark Christopher Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
27269 27269 1994-08-23 1991-11-19 Newberg Joshua A. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
37446 37446 1996-12-01 1996-02-27 King Michael Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
38243 38243 1996-12-13 1996-03-01 Clemons Elgin R. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
41066 41066 1998-12-31 1996-01-03 Bechky Perry S. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
41067 41067 1998-12-31 1996-01-03 Martin Thomas S. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
41070 41070 1998-12-31 1992-01-22 Ackerman Wendy E. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
41074 41074 1998-12-31 1996-01-29 Chapman Michael J. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
41082 41082 1998-12-31 1990-04-09 Winton Jeffrey M. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
41090 41090 1998-12-31 1989-05-12 Herzstein Robert E. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604
41091 41091 1998-12-31 1995-05-25 Wilner Thomas B. Shearman & Sterling 4208 1989-01-23 Shearman & Sterling 801 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20004-2604

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