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

25 rows where Registration_Number = 5621

✖
✖

✎ 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_Termination_Date (date), Registration_Date (date)

State 1

Registration_Number 1

  • Covington & Burling, LLP · 25 ✖

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
6592 6592 2006-02-10 2005-06-30 Martin Matthew G.T. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
13294 13294 2005-04-13 2004-05-07 Seksaria Priti Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
17307 17307 2004-05-28 2004-05-07 Kim Laura M. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
18679 18679 2006-06-02 2005-06-30 Kizer Karin L. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
18998 18998 2007-06-06 2005-12-27 Givens Andrew Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
23020 23020 2006-07-12 2005-01-04 Mehta Probir Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
28490 28490 2007-08-31 2005-01-04 Letchworth Elizabeth Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
28494 28494 2007-08-31 2004-05-07 Eizenstat Stuart E. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
28495 28495 2007-08-31 2004-05-07 Flanagan Peter L. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
28496 28496 2007-08-31 2004-05-07 Lane Allegra M. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
28497 28497 2007-08-31 2004-05-07 Smith Brian D. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
28498 28498 2007-08-31 2004-05-12 Gold Martin B. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
28510 28510 2007-08-31 2006-12-21 Cook Randall Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
28511 28511 2007-08-31 2006-12-21 Wichterman William Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36068 36068 2007-11-19 2006-12-21 Friedman Aharon Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36931 36931 2005-11-30 2004-05-07 Marchick David M. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36937 36937 2006-11-30 2005-01-04 Morgan Linda Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36940 36940 2006-11-30 2004-05-07 Carnegie Les P. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36944 36944 2006-11-30 2004-05-12 DeArment Roderick A. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36945 36945 2006-11-30 2004-05-12 Schenendorf Jack L. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36946 36946 2006-11-30 2004-05-18 Kutcher Joan L. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36948 36948 2006-11-30 2005-06-30 Blevins John Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36949 36949 2006-11-30 2005-06-30 Omand H. LiIIian Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36950 36950 2006-11-30 2005-06-30 Stetson David M. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, N.W.   Washington DC 20004
36951 36951 2006-11-30 2006-06-30 Grace David R. Covington & Burling, LLP 5621 2004-05-07 Covington & Burling, LLP 1201 Pennsylvania Avenue, 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])
);