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

22 rows where "Short_Form_Termination_Date" is on date 2003-12-31 and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Zip, Short_Form_Date (date)

State 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
41293 41293 2003-12-31 2003-01-09 Bergner Jeffrey T. Bockorny, Petrizzo, Inc. 5555 2003-01-09 Bockorny, Petrizzo, Inc. 1101 16th Street, N.W. Suite 500 Washington DC 20036
41294 41294 2003-12-31 2001-02-13 Downey Thomas J. Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. 1225 I Street, N.W. Suite 600 Washington DC 20005
41295 41295 2003-12-31 2001-02-13 Painter Sally Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. 1225 I Street, N.W. Suite 600 Washington DC 20005
41299 41299 2003-12-31 2003-02-27 Neeley Jeffrey S. Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 700 12th Street, N.W. Suite 1100 Washington DC 20005
41300 41300 2003-12-31 2001-03-06 Stein Donald Steven Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 700 12th Street, N.W. Suite 1100 Washington DC 20005
41301 41301 2003-12-31 2001-03-20 McGrath Raymond J. Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. 1225 I Street, N.W. Suite 600 Washington DC 20005
41302 41302 2003-12-31 2002-03-26 Morse Casey Beth Downey McGrath Group, Inc. 5411 2001-02-13 Downey McGrath Group, Inc. 1225 I Street, N.W. Suite 600 Washington DC 20005
41304 41304 2003-12-31 1989-04-19 Bradfield Michael Jones Day 3427 1982-12-10 Jones Day 51 Louisiana Avenue, N.W.   Washington DC 20001-2113
41305 41305 2003-12-31 1999-04-27 Louison Deborah APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. 700 12th Street, NW Suite 800 Washington DC 20005
41308 41308 2003-12-31 1998-05-29 Altschuler Irwin P. Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 700 12th Street, N.W. Suite 1100 Washington DC 20005
41309 41309 2003-12-31 2003-05-29 Hannaford Peter D. Pepperwood International Corporation 5574 2003-05-29 Pepperwood International Corporation 1615 L Street, N.W. Suite 900 Washington DC 20036-5610
41311 41311 2003-12-31 2002-05-31 Franz Mark Allan Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
41313 41313 2003-12-31 2003-06-13 Birnbaum Rise Jill QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
41320 41320 2003-12-31 2003-07-03 Roberts David Van Scoyoc Associates, Inc. 5401 2000-12-14 Van Scoyoc Associates, Inc. 800 Maine Avenue, SW Suite 800 Washington DC 20024
41325 41325 2003-12-31 2007-07-31 Rossman-McKinney Kelly QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
41331 41331 2003-12-31 2003-08-15 Mulder Steven J . Manatt, Phelps & Phillips 5171 1997-04-11 Manatt, Phelps & Phillips 700 12th Street, N.W. Suite 1100 Washington DC 20005
41332 41332 2003-12-31 2003-08-20 Kandel Kara D. Appia Group LLC 5576 2003-08-20 Appia Group LLC 1101 Pennsylvania Avenue, N.W. Suite 700 Washington DC 20004-2520
41335 41335 2003-12-31 2006-10-16 Walton Kenneth W. QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
41336 41336 2003-12-31 2002-10-18 Miller Melissa Sandler, Travis & Rosenberg, P.A. 5303 1998-12-07 Sandler, Travis & Rosenberg, P.A. 1300 Pennsylvania Avenue, N.W. Suite 400 Washington DC 20004-3002
41337 41337 2003-12-31 2003-10-22 Bierman Everett Loeffler Group, LLP 5432 2001-05-18 Loeffler Group, LLP 1801 K Street, NW Suite 340 Washington DC 20006
41341 41341 2003-12-31 2002-12-19 Ross Steven G. American Continental Group 5536 2002-12-19 American Continental Group 2099 Pennsylvania Avenue, N.W. Suite 850 Washington DC 20006
41342 41342 2003-12-31 2002-12-19 Smeallie Shawn H. American Continental Group 5536 2002-12-19 American Continental Group 2099 Pennsylvania Avenue, N.W. Suite 850 Washington DC 20006

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