FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where "Date_Stamped" is on date 2002-03-13 and Document_Type = "Short-Form"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name
Foreign_Principal_Country 1
- - 17
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
27502 | 27502 | 2002-03-13 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Colford,Chritopher | Available-FARA-Public-Office | ||
27503 | 27503 | 2002-03-13 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Cox,James O. III | Available-FARA-Public-Office | ||
27504 | 27504 | 2002-03-13 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Mastal,Megan L. | Available-FARA-Public-Office | ||
27505 | 27505 | 2002-03-13 | Hill & Knowlton, Inc. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | Rhodes,Anne Karin | Available-FARA-Public-Office | ||
27509 | 27509 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Bernhard ,Berl | Available-FARA-Public-Office | ||
27510 | 27510 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Coe ,Jo-Anne | Available-FARA-Public-Office | ||
27511 | 27511 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Davis,Kelly J. | Available-FARA-Public-Office | ||
27512 | 27512 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Garment,Leonard | Available-FARA-Public-Office | ||
27513 | 27513 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Garon,Richard J. Jr., | Available-FARA-Public-Office | ||
27514 | 27514 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Garon,Richard J. Jr., | Available-FARA-Public-Office | ||
27515 | 27515 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Hanley,June | Available-FARA-Public-Office | ||
27516 | 27516 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Hanley,June | Available-FARA-Public-Office | ||
27517 | 27517 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Harris,Marshall F. | Available-FARA-Public-Office | ||
27518 | 27518 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Meister,Brenda G. | Available-FARA-Public-Office | ||
27519 | 27519 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Mietus,John R. Jr. | Available-FARA-Public-Office | ||
27520 | 27520 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Regan,Karen | Available-FARA-Public-Office | ||
27521 | 27521 | 2002-03-13 | Verner, Liipfert, Bernhard, McPherson & Hand, Chartered | DLA Piper US LLP 3712 | Short-Form | Zentay,John Holliday | 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]) );