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 Registration_Number = 4929

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Blank Rome, LLP · 23 ✖

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
5464 5464 2013-01-31 2004-01-13 Blanton Alex Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5465 5465 2013-01-31 2004-01-13 Dyer Thomas M. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5466 5466 2013-01-31 2004-01-13 Esber Brett Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5467 5467 2013-01-31 2004-01-13 Waldron Jonathan K. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5479 5479 2013-01-31 2010-10-06 Blondman Mark Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5480 5480 2013-01-31 2010-10-06 DeBaecke Michael Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5481 5481 2013-01-31 2010-10-06 Mingione Anthony Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5824 5824 2005-02-01 2004-01-13 Drewry James Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5825 5825 2005-02-01 2004-01-13 Mitchell Sarah Heckel Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5854 5854 2009-02-01 2004-01-13 Cheplo Thomas Z. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
5855 5855 2009-02-01 2004-03-04 Daghir Roberta Kienast Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
8230 8230 2009-02-28 2004-01-13 Smith Duncan C. III Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
18058 18058 2009-05-31 2007-08-30 Drewry James Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
18680 18680 2008-06-02 2008-02-06 Davis Ashley Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
18681 18681 2008-06-02 2008-02-13 Remington Kristi Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
19121 19121 2006-06-09 2004-01-13 Naftzger J. Christopher Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
21601 21601 2008-06-30 2004-01-13 Barrett Jane F. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
23072 23072 2007-07-13 2004-01-13 Shehadeh Karim K. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
25058 25058 2005-07-31 2004-01-13 Freeman Alan M. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
25663 25663 2009-08-01 1994-07-22 Farrell Edward J. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
28971 28971 2012-09-01 2008-03-03 Leiter Tara L. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
29903 29903 2010-09-15 2004-01-13 Dyer Andrew W. Jr., Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
41727 41727 2010-12-31 2010-10-06 Azar Christine Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037

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