FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where City = "Washington" and Short_Form_First_Name = "Ann"
This data as json, CSV (advanced)
Suggested facets: Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2379 | 2379 | 2022-12-09 | Temple | Ann | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 | |
11984 | 11984 | 2006-03-31 | 2005-06-30 | Paabus | Ann | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | 6331 Western Avenue, NW | Washington | DC | 20015 | |
14248 | 14248 | 1989-04-28 | 1987-07-08 | Allen | Ann | O'Melveny & Myers 3346 | 1982-03-12 | O'Melveny & Myers | 555 - 13th Street, N.W. | Suite 500 West | Washington | DC | 20004 |
15198 | 15198 | 2020-04-30 | 2020-04-30 | Adler | Ann | Prime Policy Group 6377 | 2016-09-19 | Prime Policy Group | 1801 K Street, NW | Suite 9000 | Washington | DC | 20006 |
15942 | 15942 | 2001-05-08 | 2001-03-28 | Richards | Ann | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18249 | 18249 | 2022-05-31 | 2018-01-30 | Jablon | Ann | Capitol Counsel, LLC 6328 | 2015-11-19 | Capitol Counsel, LLC | 700 13th Street, NW | Suite 200 | Washington | DC | 20005 |
19978 | 19978 | 1995-06-21 | 1993-05-14 | McCormick | Ann | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
20306 | 20306 | 1992-06-26 | 1989-01-27 | Morse | Ann | Pillsbury, Madison & Sutro 4212 | 1989-01-27 | Pillsbury, Madison & Sutro | 1667 K Street, N.W. | Suite 1100 | Washington | DC | 20006 |
33034 | 33034 | 2009-10-16 | 2009-09-24 | Norman | Ann | Whitaker Group, Inc. 5539 | 2003-02-13 | Whitaker Group, Inc. | 1133 21st Street, NW | Suite 405 | Washington | DC | 20036 |
34580 | 34580 | 2008-10-31 | 2008-12-23 | Mangold | Ann | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th 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]) );