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

24 rows where "Short_Form_Termination_Date" is on date 2007-08-31

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 4

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
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
28491 28491 2007-08-31 2007-02-05 Alomari Mohammed Zenith Consulting, Inc. 5792 2007-02-05 Zenith Consulting, Inc. 5322 Fifteen Mile Road Suite C Sterling Heights MI 48310
28492 28492 2007-08-31 1992-02-26 Judd Terry W. APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. 700 12th Street, NW Suite 800 Washington DC 20005
28493 28493 2007-08-31 2004-03-01 Rice Theresa Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544
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
28499 28499 2007-08-31 2006-05-17 Patch Sarabeth V. Richard L. Collins & Company, Inc. 5537 2003-01-22 Richard L. Collins & Company, Inc. 2111 Wilson Boulevard Suite 700 Arlington VA 22201
28500 28500 2007-08-31 2006-08-02 Nakanishi Leigh Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28501 28501 2007-08-31 2007-08-03 Krieger Kathy L. James & Hoffman, PC 5822 2007-08-03 James & Hoffman, PC 1101 17th Street, NW Suite 510 Washington DC 20036
28502 28502 2007-08-31 2007-08-09 Heikkila Tiffany Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28503 28503 2007-08-31 2007-08-09 Hossain Sarah Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28504 28504 2007-08-31 2007-08-09 Murphy Sean K. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28505 28505 2007-08-31 2007-08-09 Post Emma Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
28506 28506 2007-08-31 2006-08-23 Bailey Nawel Gilberts Washington, Inc. 5763 2006-09-28 Gilberts Washington, Inc. 601 Pennsylvania Avenue, NW Suite 922 Washington DC 20004-2601
28507 28507 2007-08-31 2006-08-23 Johnstone Jeff Gilberts Washington, Inc. 5763 2006-09-28 Gilberts Washington, Inc. 601 Pennsylvania Avenue, NW Suite 922 Washington DC 20004-2601
28508 28508 2007-08-31 1991-09-03 Schumacher Barry J. APCO Worldwide, Inc. 4561 1991-09-03 APCO Worldwide, Inc. 700 12th Street, NW Suite 800 Washington DC 20005
28509 28509 2007-08-31 2004-10-27 Chew Kok Chuan Singapore Tourism Board 2414 1973-03-27 Singapore Tourism Board 589 5th Avenue Suite 1702 New York NY 10017
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
28512 28512 2007-08-31 2004-12-22 Heng Teck Thai Singapore Economic Development Board 2003 1967-02-02 Singapore Economic Development Board 55 East 59th Street Suite 21 B, 21st Floor New York NY 10022
28513 28513 2007-08-31 2006-12-26 Saenz Natalie Burson-Marsteller 2469 1973-10-23 Burson-Marsteller 1110 Vermont Avenue, NW, 12th Floor   Washington DC 20005-3544

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