FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Termination_Date" is on date 2005-02-28 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Zip, Registration_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8176 | 8176 | 2005-02-28 | 2005-01-05 | Cullum | Tiffany | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
8177 | 8177 | 2005-02-28 | 2005-01-31 | Morgan | Kimberly James | FGS Global (US) LLC (FKA FGH Holdings LLC) 5666 | 2005-01-31 | FGS Global (US) LLC (FKA FGH Holdings LLC) | 1025 F Street, NW | 9th Floor | Washington | DC | 20004 |
8178 | 8178 | 2005-02-28 | 2005-02-01 | Mirijanian | Peter G. | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
8180 | 8180 | 2005-02-28 | 2004-04-19 | Pena | H.R. Bert | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
8183 | 8183 | 2005-02-28 | 2004-07-06 | Dodson | Courtney Alexander | Korea - United States Exchange Council 5453 | 2001-08-22 | Korea - United States Exchange Council | 3000 K Street, N.W. | Suite 125 | Washington | DC | 20007 |
8184 | 8184 | 2005-02-28 | 2004-07-06 | Stewart | Edward B. | Korea - United States Exchange Council 5453 | 2001-08-22 | Korea - United States Exchange Council | 3000 K Street, N.W. | Suite 125 | Washington | DC | 20007 |
8185 | 8185 | 2005-02-28 | 2003-07-14 | Leverett | Flynt | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
8186 | 8186 | 2005-02-28 | 2003-07-23 | Navarro | Ana | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
8187 | 8187 | 2005-02-28 | 2004-08-27 | Egge | Rob | 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 |
8188 | 8188 | 2005-02-28 | 2004-08-27 | Humphrey | Calvin | 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 |
8190 | 8190 | 2005-02-28 | 1997-10-22 | Bernstein | Caryl S. | Bernstein Law Firm, PLLC 4764 | 1993-02-08 | Bernstein Law Firm, PLLC | 5335 Wisconsin Avenue, NW | Suite 440 | Washington | DC | 20015 |
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]) );