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

36 rows where Registrant_Name = "Jellinek, Schwartz & Connolly, Inc." and State = "VA"

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_Termination_Date (date)

State 1

Registration_Number 1

Registrant_Name 1

  • Jellinek, Schwartz & Connolly, Inc. · 36 ✖

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
4105 4105 2001-01-19 1990-02-23 Schwartz Jeffrey H. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
4582 4582 2001-01-26 2000-09-27 Hollidge Lori S. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
4630 4630 1992-01-27 1990-09-19 Sigal Jill Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8123 8123 2001-02-28 1993-03-25 Noyes Pamela Diane Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8125 8125 2001-02-28 1999-03-26 Brown Shanna M. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8126 8126 2001-02-28 1999-03-26 Murray Thomas P. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8127 8127 2001-02-28 2000-03-29 Brill, II Richard Budd Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8128 8128 2001-02-28 2001-04-19 Staiti Gregory Richard Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8129 8129 2001-02-28 2001-04-19 Wan-Ling Lie Sharyn Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8136 8136 2001-02-28 1997-09-19 Director Syril Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8137 8137 2001-02-28 1992-09-25 Allemang Diane Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8138 8138 2001-02-28 1995-09-25 Tyler Seth Daniel Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8139 8139 2001-02-28 1996-09-26 Walsh Scott Andrew Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8140 8140 2001-02-28 2000-09-27 Boshes Alison Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8141 8141 2001-02-28 1993-09-28 Dennis Sherri Buttrey Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8142 8142 2001-02-28 1993-09-28 Schloesser Christopher John Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8143 8143 2001-02-28 1993-09-28 Stephens Stephanie Holmes Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
8816 8816 1998-03-01 1993-09-28 Lippman Steven Robert Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
10753 10753 1993-03-25 1990-02-23 Tohn Ellen R. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
10754 10754 1993-03-25 1990-09-19 Purkey Andrew Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
10961 10961 1991-03-28 1990-09-19 Stendebach Sue Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
13293 13293 1995-04-13 1994-03-22 Arthur David Keith Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
17048 17048 2000-05-24 1999-09-27 Pettit Syril D. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
19870 19870 1996-06-19 1995-03-23 Jensen Sara Morgan Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
20317 20317 1998-06-26 1996-09-26 Buffington John Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
20433 20433 1991-06-28 1990-02-23 Bennison Barbara A. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
23660 23660 1990-07-20 1990-02-23 Millstone Jeremy S. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
24789 24789 1990-07-31 1990-02-23 Kast Lawrence P. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
25627 25627 2000-08-01 1999-03-26 Lau Yewah F. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
26110 26110 1999-08-06 1999-09-27 Caplan Christina Childs Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
26457 26457 2000-08-11 1990-02-23 Pfifferling Sueanne Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
26507 26507 1997-08-12 1996-03-28 Kohn Christina Childs Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
30688 30688 1993-09-28 1992-03-27 O'Brien Carolyn G. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
30689 30689 1993-09-28 1992-03-27 Stoner Brenda Sue Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
34316 34316 1991-10-31 1990-02-23 Freshman John D. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209
34319 34319 1991-10-31 1991-03-28 Kast Lawrence P. Jellinek, Schwartz & Connolly, Inc. 4345 1990-02-23 Jellinek, Schwartz & Connolly, Inc. 1525 Wilson Boulevard Suite 600 Arlington VA 22209

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