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 Registrant_Name = "Washington & Christian"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

Registrant_Name 1

  • Washington & Christian · 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
5155 5155 1996-01-31 1995-02-17 Martin William R. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
5168 5168 1996-01-31 1994-12-01 Mercer John F. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
5186 5186 1998-01-31 1995-01-10 Ramsey Henry , Jr. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
5187 5187 1998-01-31 1995-01-20 Hill Daaga C. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
5197 5197 1998-01-31 1991-09-20 Christian James M. , Sr. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
5198 5198 1998-01-31 1991-09-20 Washington Robert B. , Jr. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
5201 5201 1998-01-31 1994-12-01 Carr Joseph N. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
6247 6247 1997-02-06 1995-02-27 Robinson Leonard H. , Jr. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
6326 6326 1995-02-07 1993-10-22 Taylor Darlene R. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
6864 6864 1997-02-14 1996-08-28 Atchimon Bruno Dogbo Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
6866 6866 1997-02-14 1991-09-20 Oyewole Funke O. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
6867 6867 1997-02-14 1991-09-20 Pruitt Steven Lawrence Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
7722 7722 1996-02-26 1993-01-28 Dellums Leola M. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
7725 7725 1996-02-26 1994-08-05 Smith Kymberly A. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
14205 14205 1993-04-27 1991-09-20 Borges Joaquina Lopes Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
14206 14206 1993-04-27 1991-09-20 Wiener Craig L. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
18509 18509 1995-06-01 1994-10-12 Sallah Sohna S. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
19444 19444 1996-06-14 1991-09-20 Hoffler Tricia Purks Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
26747 26747 1996-08-15 1996-07-05 Mahaffey Theodore Richard , III Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
34350 34350 1994-10-31 1993-10-22 Johnson Allison Marie Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
35108 35108 1992-11-02 1991-09-20 Louis Conan Noel Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
35433 35433 1991-11-08 1991-09-20 Peppe Melissa L. Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005
38050 38050 1995-12-10 1995-01-30 Dunn-Mouton Adwoa Washington & Christian 4569 1991-09-20 Washington & Christian 1155 15th Street, N.W. Suite 1004 Washington DC 20005

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