FARA_All_ShortForms
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 2006-05-31 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Short_Form_Termination_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17992 | 17992 | 2006-05-31 | 2005-01-05 | Hartwig | Myron A. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17993 | 17993 | 2006-05-31 | 2005-01-05 | Reineke | Eugene | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17994 | 17994 | 2006-05-31 | 2005-01-05 | Tragakis | Charles | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17995 | 17995 | 2006-05-31 | 2005-01-05 | Williams | Michele | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17996 | 17996 | 2006-05-31 | 2006-01-27 | Amestoy | Erica | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17997 | 17997 | 2006-05-31 | 2006-01-27 | Goodman | Bonnie | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
17998 | 17998 | 2006-05-31 | 2006-01-27 | Haas | Michael | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18000 | 18000 | 2006-05-31 | 2006-03-03 | Outhier | William | Carmen Group Incorporated 5727 | 2006-01-17 | Carmen Group Incorporated | 1919 Pennsylvania Avenue, N.W. | Fifth Floor | Washington | DC | 20006 |
18001 | 18001 | 2006-05-31 | 2003-03-18 | Grannell | Nora | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18006 | 18006 | 2006-05-31 | 2005-06-10 | Aldinger | Michael | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18007 | 18007 | 2006-05-31 | 2005-06-10 | Mangum | Jeff | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
18009 | 18009 | 2006-05-31 | 1997-08-11 | Moran | Mark A. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18010 | 18010 | 2006-05-31 | 2007-09-27 | Columbus | R. Timothy | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18011 | 18011 | 2006-05-31 | 2007-09-27 | Cunningham | Richard O. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18012 | 18012 | 2006-05-31 | 2007-09-27 | Fremlin | Grace Parke | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18013 | 18013 | 2006-05-31 | 2007-09-27 | Kantor | Douglas S. | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18014 | 18014 | 2006-05-31 | 2007-09-27 | Maloney | Robert | Steptoe & Johnson, L.L.P. 3975 | 1987-05-08 | Steptoe & Johnson, L.L.P. | 1330 Connecticut Avenue, N.W. | Washington | DC | 20036-1795 | |
18015 | 18015 | 2006-05-31 | 2005-10-14 | Park | Andrew J. | Watts Partners (J.C. Watts Companies) 5641 | 2004-08-27 | Watts Partners (J.C. Watts Companies) | 601 Pennsylvania Avenue, NW | Suite 900 | Washington | DC | 20004 |
18016 | 18016 | 2006-05-31 | 2005-11-02 | Heck | Patrick T. | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18017 | 18017 | 2006-05-31 | 2005-11-02 | Jackson III | Alfred | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18018 | 18018 | 2006-05-31 | 2005-11-02 | McCrery | Johnette Hawkins | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18019 | 18019 | 2006-05-31 | 2005-11-02 | Tindall | Zachary | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18020 | 18020 | 2006-05-31 | 2005-11-02 | Wyeth | Natalie | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
18021 | 18021 | 2006-05-31 | 2005-11-02 | Zavlodaver | Tal | Ketchum Washington 5719 | 2005-11-02 | Ketchum Washington | 2000 L Street, NW | 3rd Floor | Washington | DC | 20036 |
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]) );