FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Document_Type = "Short-Form" and Registrant_Name = "Shandwick Public Affairs, Inc."
This data as json, CSV (advanced)
Registrant_Name 1
- Shandwick Public Affairs, Inc. · 13 ✖
Foreign_Principal_Name 1
- - 13
Foreign_Principal_Country 1
- - 13
Document_Type 1
- Short-Form · 13 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
6194 | 6194 | 2000-01-19 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Wilson,Peter Vance | Available-FARA-Public-Office | ||
43297 | 43297 | 2000-04-27 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Francis,Barbara Lynn | Available-FARA-Public-Office | ||
43298 | 43298 | 2000-04-27 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Kolstad,Katherine C. | Available-FARA-Public-Office | ||
50758 | 50758 | 2000-05-10 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Adams,Ashley Ann | Available-FARA-Public-Office | ||
76058 | 76058 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Abernethy,Stacey Holm | Available-FARA-Public-Office | ||
76059 | 76059 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Gest,Kathryn | Available-FARA-Public-Office | ||
76060 | 76060 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Gest,Kathryn | Available-FARA-Public-Office | ||
76061 | 76061 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Kolstad,Katherine C. | Available-FARA-Public-Office | ||
76062 | 76062 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Leibach,Dale W. | Available-FARA-Public-Office | ||
76063 | 76063 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Leibach,Dale W. | Available-FARA-Public-Office | ||
76064 | 76064 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Miller,Andrew Clark | Available-FARA-Public-Office | ||
76065 | 76065 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Powell,Joseph L. | Available-FARA-Public-Office | ||
76066 | 76066 | 2000-07-14 | Shandwick Public Affairs, Inc. | Shandwick Public Affairs, Inc. 5220 | Short-Form | Tate,Sheila | 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]) );