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

20 rows where Registration_Number = 5931

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Venable, LLP · 20 ✖

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
153 153   2018-01-19 Aho Loren Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
290 290   2018-02-02 Mullon Jr. David A. Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
318 318   2018-02-05 Finestone Josh Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
613 613   2019-03-21 Raymond Joshua Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
1137 1137   2021-05-28 Kimble Yardly Pollas Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
1162 1162   2012-05-31 Stupak Bart Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
1185 1185   2009-06-02 Hegg Richard Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
2134 2134   2022-11-10 Drzewicki John Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
2319 2319   2009-12-01 Quinn Thomas Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
15003 15003 2009-04-30 2009-06-05 Sherman Michael Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
22790 22790 2011-07-08 2010-05-28 Moore Powell Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
34693 34693 2017-10-31 2010-05-28 Smith II Robert L. Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
35050 35050 2020-11-01 2019-07-15 Kierig Anne Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
35126 35126 2018-11-02 2018-02-05 Smith II Robert L. Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
36521 36521 2017-11-28 2016-04-05 Manchester Doreen Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
36572 36572 2016-11-29 2009-06-02 Bayh Jr. Birch E. Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
36573 36573 2016-11-29 2009-06-02 Shepherd III Raymond V. Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
38522 38522 2011-12-16 2010-12-15 Moore Powell Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
38959 38959 2010-12-22 2010-06-21 Hinckley Elias Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
42140 42140 2017-12-31 2009-06-02 Nordwind William R. Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001

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