FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Short_Form_Termination_Date" is on date 2007-03-31
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Short_Form_Termination_Date (date)
Registration_Number 9
Registrant_Name 9
City 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12013 | 12013 | 2007-03-31 | 2007-01-31 | Gidez | Christopher R. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
12014 | 12014 | 2007-03-31 | 2005-02-14 | Iler | Meredith S. (Maxfield) | Iler Interests, LP 5669 | 2005-02-14 | Iler Interests, LP | 11410 Carson Field Lane | Cypress | TX | 77433 | |
12015 | 12015 | 2007-03-31 | 2001-02-22 | Hanley | June | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
12016 | 12016 | 2007-03-31 | 2004-03-12 | Kies | Kenneth J. | Clark Consulting 5611 | 2004-03-12 | Clark Consulting | 102 South Wynstone Park Drive | North Barrington | IL | 60010 | |
12017 | 12017 | 2007-03-31 | 2006-05-22 | Raffaniello | Patrick J. | Clark Consulting 5611 | 2004-03-12 | Clark Consulting | 102 South Wynstone Park Drive | North Barrington | IL | 60010 | |
12018 | 12018 | 2007-03-31 | 2006-05-30 | McBurney | Janet | Invest Northern Ireland 4364 | 1990-04-13 | Invest Northern Ireland | 2201 Waukegan Road | Suite 150 South | Bannockburn | IL | 60015 |
12019 | 12019 | 2007-03-31 | 2005-06-10 | Getzug | Steve | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
12020 | 12020 | 2007-03-31 | 2006-07-21 | Nishimoto | Keiko | Samuels International Associates, Inc. 4848 | 1993-08-26 | Samuels International Associates, Inc. | 1140 Connecticut Avenue, N.W. | Suite 950 | Washington | DC | 20036 |
12021 | 12021 | 2007-03-31 | 2006-08-02 | Mackin | Rory | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
12022 | 12022 | 2007-03-31 | 2004-08-16 | Murooka | Yoshikatsu | Osaka University, San Francisco Office 5631 | 2004-07-12 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 |
12023 | 12023 | 2007-03-31 | 2004-10-21 | Rinaldo | Diane | Cassidy & Associates, Inc. 5643 | 2004-09-10 | Cassidy & Associates, Inc. | 700 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
12024 | 12024 | 2007-03-31 | 2007-12-06 | Mirijanian | Peter G. | Bob, Daniel 5794 | 2007-02-23 | Bob, Daniel | 1001 G Street, NW | Suite 460 | Washington | DC | 20001 |
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]) );