FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
57 rows where Document_Type = "Short-Form" and Registration_Number = 3600
This data as json, CSV (advanced)
Registrant_Name 1
Foreign_Principal_Name 1
- - 19
Foreign_Principal_Country 1
- - 19
Document_Type 1
- Short-Form · 19 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
71815 | 71815 | 1989-07-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | VIRGINIA E. SAGREDO | Available-FARA-Public-Office | ||
71957 | 71957 | 1990-07-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | WYATT HUDSON MCGEE | Available-FARA-Public-Office | ||
72892 | 72892 | 1993-07-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | EVAN TRACEY | Available-FARA-Public-Office | ||
76015 | 76015 | 1992-07-14 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | ELBERT MICHAEL USSERY | Available-FARA-Public-Office | ||
76016 | 76016 | 1992-07-14 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | MARY ELIZABETH ARNOLD | Available-FARA-Public-Office | ||
76017 | 76017 | 1992-07-14 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | ROBERT GREGORY STEVENS | Available-FARA-Public-Office | ||
77276 | 77276 | 1992-07-20 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | DAVID H. FENIG | Available-FARA-Public-Office | ||
77536 | 77536 | 1986-07-21 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | DIVINA K. WESTERFIELD | Available-FARA-Public-Office | ||
77537 | 77537 | 1986-07-21 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | JOHN AYCOTH | Available-FARA-Public-Office | ||
79764 | 79764 | 1986-07-29 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | JOHN DONALDSON | Available-FARA-Public-Office | ||
92497 | 92497 | 1984-09-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | LINDA A. PINEGAR | Available-FARA-Public-Office | ||
92593 | 92593 | 1985-09-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | CHRISTOPHER M. LEHMAN | Available-FARA-Public-Office | ||
93419 | 93419 | 1990-09-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | MARY ELLEN COUGHLIN | Available-FARA-Public-Office | ||
94494 | 94494 | 1993-09-01 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | DEAN N. GLOY | Available-FARA-Public-Office | ||
108700 | 108700 | 1998-10-14 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | DAVID H. FENIG | Available-FARA-Public-Office | ||
108701 | 108701 | 1998-10-14 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | MARK ROBERT DISLER | Available-FARA-Public-Office | ||
109115 | 109115 | 1995-10-16 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | ANNE DAVIS BURNS | Available-FARA-Public-Office | ||
109116 | 109116 | 1995-10-16 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | DEBBIE WILLHITE | Available-FARA-Public-Office | ||
130838 | 130838 | 1995-12-14 | BLACK, KELLY, SCRUGGS & HEALEY | Black, Kelly, Scruggs & Healey 3600 | Short-Form | RICK GATES | 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]) );