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

11 rows where Registration_Number = 3275

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date)

State 1

Registration_Number 1

  • Graham & James, L.L.P. · 11 ✖

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
2770 2770 1997-01-01 1981-09-23 Bank Richard K. Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
6587 6587 1998-02-10 1996-04-11 Palmeter N. David Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
7305 7305 1998-02-20 1987-08-24 Walders Lawrence R. Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
8815 8815 1997-03-01 1989-11-15 Cavanaugh J. Michael Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
21294 21294 1998-06-30 1992-04-14 Dubuc Carroll E. Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
29225 29225 1997-09-05 1996-03-27 Daniels Michael P. Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
30317 30317 1998-09-23 1996-03-27 Clark Alice Slayton Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
30318 30318 1998-09-23 1996-03-27 DiGiulian Maria Tawes Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
33214 33214 1995-10-19 1993-10-21 Karpinski Richard J. Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
33310 33310 1994-10-21 1993-10-21 Fahy Richard J. , Jr. Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113
39421 39421 1995-12-30 1992-04-14 Jones Aidan D. Graham & James, L.L.P. 3275 1981-09-23 Graham & James, L.L.P. 2000 M Street, N.W. Suite 700 Washington DC 20036-3113

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