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

39 rows where Registration_Number = 3765

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Willkie, Farr & Gallagher · 39 ✖

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
3131 3131 1990-01-03 1989-10-16 Donald David Charles Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
4098 4098 1990-01-19 1985-12-26 Lafave Arthur J. , III Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
5976 5976 1995-02-02 1993-07-29 Zeichner Lee M. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
5977 5977 1995-02-02 1985-12-26 Clinton William J. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
5978 5978 1995-02-02 1985-12-26 Spak Walter J. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6574 6574 1994-02-10 1992-02-07 Fraser-Reid Andrea C. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6576 6576 1994-02-10 1987-06-23 Schneider Matthew Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6668 6668 1993-02-12 1991-02-20 Schoff James Lowden Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6669 6669 1993-02-12 1986-07-24 Ellis Dwight W. , III Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6670 6670 1993-02-12 1986-07-25 Crass Theodore Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6671 6671 1993-02-12 1986-07-25 Lund Kristin Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6672 6672 1993-02-12 1986-08-01 Robbins Liz Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6674 6674 1993-02-12 1989-10-16 Neto Jose' Almeida Maciel Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
6675 6675 1993-02-12 1985-12-26 III Royal Daniel Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
9777 9777 1992-03-13 1987-01-28 Jabionski Zygmunt Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
9780 9780 1992-03-13 1989-10-16 Lindsey William Brinkley Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
10952 10952 1989-03-28 1987-06-23 Keating John S. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
12464 12464 1986-04-01 1985-12-26 Curtiss Catherine Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
13752 13752 1991-04-19 1989-10-16 Middleton Sarah Collins Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
14586 14586 1988-04-30 1986-08-01 Peterson Robert A. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
15814 15814 1988-05-06 1985-12-26 Carr Jeffrey W. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
20143 20143 1986-06-24 1985-12-26 Williams Susan G. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
23113 23113 1989-07-14 1989-02-10 Remark Leslie A. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
25594 25594 1991-08-01 1990-01-26 Overcash Tracy Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
25595 25595 1991-08-01 1989-02-10 Gantnier Cindy L. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
26731 26731 1990-08-15 1989-10-16 Suber John McLellan Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27064 27064 1998-08-20 1988-01-29 Miller Edgar B. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27065 27065 1998-08-20 1995-02-02 McCullough Matthew P. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27066 27066 1998-08-20 1992-02-07 Bond David E. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27067 27067 1998-08-20 1989-02-10 Stokes Christopher Scott Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27068 27068 1998-08-20 1993-06-14 Smith Russell L. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27069 27069 1998-08-20 1986-07-25 Pierce Kenneth Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27070 27070 1998-08-20 1992-07-27 Egge William Robert Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27071 27071 1998-08-20 1993-07-29 LaFrankie Robert L. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27072 27072 1998-08-20 1985-12-26 Barringer William H. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27073 27073 1998-08-20 1985-12-26 Dunn Christopher Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27074 27074 1998-08-20 1985-12-26 Durling James P. Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
27075 27075 1998-08-20 1985-12-26 Hemmendinger Noel Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302
28149 28149 1990-08-31 1990-01-26 Carty Elizabeth Willkie, Farr & Gallagher 3765 1985-12-26 Willkie, Farr & Gallagher Three Lafayette Center 1155 - 21st Street, N.W. #600 Washington DC 20036-3302

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