home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

22 rows where Registration_Number = 5435

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 22

Registration_Number 1

  • Venable, LLP · 22 ✖

Registrant_Name 1

  • Venable, LLP 22

City 1

  • Washington 22
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
3914 3914 2007-01-16 2004-04-13 Pitts James T. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
3915 3915 2007-01-16 2001-05-29 O' Donnell Patrick E. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
3916 3916 2007-01-16 2003-08-01 Jatras James G. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5373 5373 2007-01-31 2004-01-23 Quinn Thomas H. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5375 5375 2007-01-31 2006-04-04 Smith Robert Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5383 5383 2007-01-31 2003-08-01 Bayh, Jr. Birch E. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5384 5384 2007-01-31 2003-08-01 Burnley IV James H. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5385 5385 2007-01-31 2003-08-01 Harmala Robert C. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5386 5386 2007-01-31 2005-08-02 Ferrell Michael J. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5388 5388 2007-01-31 2003-08-15 Huey Erik V. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5389 5389 2007-01-31 2003-08-15 Smith II Robert Leverett Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5391 5391 2007-01-31 2005-09-22 Craig Ashley Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5394 5394 2007-01-31 2005-10-24 Faley Kevin Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5395 5395 2007-01-31 2005-10-24 Hegg Rick Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5396 5396 2007-01-31 2005-10-24 Roberts Michael G. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
5397 5397 2007-01-31 2003-11-19 Stirrup Heidi H. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
11986 11986 2006-03-31 2003-08-15 Springer David Edward Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
13708 13708 2002-04-18 2001-05-29 Veruete Nina N. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
16528 16528 2006-05-16 2005-10-24 Paugh Wayne Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
17960 17960 2002-05-31 2001-05-29 Quinn Thomas H. Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
22291 22291 2001-07-01 2001-05-29 Fagre Danielle Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004
31352 31352 2006-09-30 2004-01-23 Garcia Robert Venable, LLP 5435 2001-05-29 Venable, LLP 575 7th Street, N.W.   Washington DC 20004

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])
);
Powered by Datasette · Queries took 1830.297ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows