FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Document_Type = "Short-Form" and Registrant_Name = "CLIFFORD & WARNKE"
This data as json, CSV (advanced)
Registrant_Name 1
- CLIFFORD & WARNKE · 15 ✖
Foreign_Principal_Name 1
- - 15
Foreign_Principal_Country 1
- - 15
Document_Type 1
- Short-Form · 15 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
22405 | 22405 | 1990-03-01 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | JAMES C. DUFF | Available-FARA-Public-Office | ||
22406 | 22406 | 1990-03-01 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | JOHN F. KOVIN | Available-FARA-Public-Office | ||
30852 | 30852 | 1975-03-26 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | CLARK M. CLIFFORD | Available-FARA-Public-Office | ||
30853 | 30853 | 1975-03-26 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | JAMES T. STOVALL, III | Available-FARA-Public-Office | ||
30854 | 30854 | 1975-03-26 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | PAUL C. WARNKE | Available-FARA-Public-Office | ||
30855 | 30855 | 1975-03-26 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | TERENCE T. FORTUNE | Available-FARA-Public-Office | ||
45723 | 45723 | 1977-05-01 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | HAROLD D. MURRY, JR. | Available-FARA-Public-Office | ||
45826 | 45826 | 1979-05-01 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | PAUL C. WARNKE | Available-FARA-Public-Office | ||
57985 | 57985 | 1975-06-01 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | CARSON M. GLASS | Available-FARA-Public-Office | ||
62560 | 62560 | 1991-06-04 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | HAROLD D. MURRY, JR. | Available-FARA-Public-Office | ||
66017 | 66017 | 1991-06-19 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | KATHERINE D. MCMANUS | Available-FARA-Public-Office | ||
66018 | 66018 | 1991-06-19 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | KATHRYN A. KUSSKE | Available-FARA-Public-Office | ||
66019 | 66019 | 1991-06-19 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | NANCY E. OWEN | Available-FARA-Public-Office | ||
103352 | 103352 | 1979-10-01 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | BRYAN JAY YOLLES | Available-FARA-Public-Office | ||
114144 | 114144 | 1975-11-01 | CLIFFORD & WARNKE | Clifford & Warnke 2564 | Short-Form | BARRY J. ISRAEL | 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]) );