FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Short_Form_Termination_Date" is on date 2007-08-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Zip
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 | |
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 | |
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 |
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 | |
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
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]) );