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

17 rows where City = "Washington" and "Short_Form_Termination_Date" is on date 1992-03-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)

State 1

City 1

  • Washington · 17 ✖
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
11656 11656 1992-03-31 1983-01-10 Lieberman Edward H. Cole Corette & Abrutyn, P.C. 2968 1978-10-18 Cole Corette & Abrutyn, P.C. 805 - 15th Street, N.W, Suite 900 Washington DC 20005
11660 11660 1992-03-31 1991-02-25 Valero Rob Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544
11665 11665 1992-03-31 1991-05-08 Campbell James S. Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11666 11666 1992-03-31 1991-05-08 Hammond Robert A. , III Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11667 11667 1992-03-31 1991-05-08 Lovett James Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11668 11668 1992-03-31 1991-05-08 Mathernova Katarina Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11669 11669 1992-03-31 1990-06-04 Thompson Anthony J. Perkins Coie 3753 1985-11-01 Perkins Coie 607 - 14th Street, N.W. Suite 800 Washington DC 20005
11672 11672 1992-03-31 1991-07-29 Lowen Theodore W. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
11673 11673 1992-03-31 1991-08-08 Wallison Peter J. Gibson, Dunn & Crutcher 4552 1991-08-08 Gibson, Dunn & Crutcher 1050 Connecticut Avenue, N.W.   Washington DC 20036
11674 11674 1992-03-31 1991-08-09 McCormick Mary Lou Gold & Liebengood, Inc. 3700 1985-07-09 Gold & Liebengood, Inc. 1455 Pennsylvania Avenue, N.W. Suite 950 Washington DC 20004
11675 11675 1992-03-31 1991-08-13 Lebow Cynthia C. Gibson, Dunn & Crutcher 4552 1991-08-08 Gibson, Dunn & Crutcher 1050 Connecticut Avenue, N.W.   Washington DC 20036
11678 11678 1992-03-31 1990-09-05 Windolph John M. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
11683 11683 1992-03-31 1991-11-08 Chin Stephen C. Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11684 11684 1992-03-31 1991-11-08 Greenwald John D. Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11685 11685 1992-03-31 1991-11-12 Cutler Lloyd N. Wilmer, Cutler & Pickering 3355 1982-04-08 Wilmer, Cutler & Pickering 2445 M Street, N.W.   Washington DC 20037-1420
11686 11686 1992-03-31 1981-11-19 Crawford Charles , III Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
11688 11688 1992-03-31 1987-12-23 Riley Stephen F. Riley & Fox, Inc. 3813 1986-04-11 Riley & Fox, Inc. 1101 - 17th Street, N.W. Suite 606 Washington DC 20036

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