FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
36 rows where "Date_Stamped" is on date 2007-08-09 and Document_Type = "Short-Form"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Date_Stamped
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
86567 | 86567 | 2007-08-09 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bauer, Dana | Available-FARA-Public-Office | ||
86568 | 86568 | 2007-08-09 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Borland, Lydia | Available-FARA-Public-Office | ||
86573 | 86573 | 2007-08-09 | Gavin Anderson & Company | Kreab Gavin Anderson (USA), Inc. 5824 | Short-Form | Mahony, Richard | Available-FARA-Public-Office | ||
86574 | 86574 | 2007-08-09 | Gavin Anderson & Company | Kreab Gavin Anderson (USA), Inc. 5824 | Short-Form | McBride, William G. | Available-FARA-Public-Office | ||
86575 | 86575 | 2007-08-09 | Gavin Anderson & Company | Kreab Gavin Anderson (USA), Inc. 5824 | Short-Form | Peniston-Bird, Tristan Bruce | Available-FARA-Public-Office | ||
86576 | 86576 | 2007-08-09 | Gavin Anderson & Company | Kreab Gavin Anderson (USA), Inc. 5824 | Short-Form | Silvers, Sharron | Available-FARA-Public-Office | ||
86577 | 86577 | 2007-08-09 | Gavin Anderson & Company | Kreab Gavin Anderson (USA), Inc. 5824 | Short-Form | Tingler, Brion Lee | Available-FARA-Public-Office | ||
86578 | 86578 | 2007-08-09 | Gavin Anderson & Company | Kreab Gavin Anderson (USA), Inc. 5824 | Short-Form | Vosk, Jessica | Available-FARA-Public-Office | ||
86580 | 86580 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Anderson, Jessica Juliet | Available-FARA-Public-Office | ||
86581 | 86581 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Baird, Patrick M. | Available-FARA-Public-Office | ||
86582 | 86582 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Buchanan, Sheila | Available-FARA-Public-Office | ||
86583 | 86583 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Cox, James | Available-FARA-Public-Office | ||
86584 | 86584 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Crane, Emily | Available-FARA-Public-Office | ||
86585 | 86585 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Gallagher, Katherine | Available-FARA-Public-Office | ||
86586 | 86586 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Gidez, Christopher R. | Available-FARA-Public-Office | ||
86587 | 86587 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Goldberg, Judy | Available-FARA-Public-Office | ||
86588 | 86588 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Heikkila, Tiffany | Available-FARA-Public-Office | ||
86589 | 86589 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Hossain, Sarah | Available-FARA-Public-Office | ||
86590 | 86590 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Hyde, Richard C. | Available-FARA-Public-Office | ||
86591 | 86591 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Layman, Heather | Available-FARA-Public-Office | ||
86592 | 86592 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Mangum, Jeff | Available-FARA-Public-Office | ||
86593 | 86593 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Mankiewicz, Frank | Available-FARA-Public-Office | ||
86594 | 86594 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Martin, Christopher | Available-FARA-Public-Office | ||
86595 | 86595 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | McHugh, Nicki | Available-FARA-Public-Office | ||
86596 | 86596 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | McKay, Melissa Laura | Available-FARA-Public-Office | ||
86597 | 86597 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Murphy, Sean K. | Available-FARA-Public-Office | ||
86598 | 86598 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Nakanishi, Leigh | Available-FARA-Public-Office | ||
86599 | 86599 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Nelson, Deborah | Available-FARA-Public-Office | ||
86600 | 86600 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Post, Emma | Available-FARA-Public-Office | ||
86601 | 86601 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Post, Emma | Available-FARA-Public-Office | ||
86602 | 86602 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Poulos, Peter | Available-FARA-Public-Office | ||
86603 | 86603 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Purchia, Elizabeth | Available-FARA-Public-Office | ||
86604 | 86604 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Sfikas, Athanasia | Available-FARA-Public-Office | ||
86605 | 86605 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Stegeman, Saskia | Available-FARA-Public-Office | ||
86606 | 86606 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Tsai, Michelle | Available-FARA-Public-Office | ||
86607 | 86607 | 2007-08-09 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Vernon, Robert M. | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );