FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Document_Type = "Short-Form" and Registrant_Name = "SHEA & GARDNER"
This data as json, CSV (advanced)
Registrant_Name 1
- SHEA & GARDNER · 12 ✖
Foreign_Principal_Name 1
- - 12
Foreign_Principal_Country 1
- - 12
Document_Type 1
- Short-Form · 12 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
21997 | 21997 | 1987-03-01 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | R. JAMES WOOLSEY | Available-FARA-Public-Office | ||
104036 | 104036 | 1986-10-01 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | FRANKLIN D. KRAMER | Available-FARA-Public-Office | ||
104037 | 104037 | 1986-10-01 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | JOHN D. ALDOCK | Available-FARA-Public-Office | ||
104038 | 104038 | 1986-10-01 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | MICHAEL P. HEALY | Available-FARA-Public-Office | ||
110553 | 110553 | 1986-10-23 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | JOHN D. ALDOCK | Available-FARA-Public-Office | ||
110554 | 110554 | 1986-10-23 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | MICHAEL P. HEALY | Available-FARA-Public-Office | ||
110815 | 110815 | 1986-10-24 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | FRANKLIN D. KRAMER | Available-FARA-Public-Office | ||
122690 | 122690 | 1987-11-30 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | PATRICK M. HANLON | Available-FARA-Public-Office | ||
122691 | 122691 | 1987-11-30 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | PATRICK M. HANLON | Available-FARA-Public-Office | ||
122692 | 122692 | 1987-11-30 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | ROBERT J. MEYER | Available-FARA-Public-Office | ||
122693 | 122693 | 1987-11-30 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | ROBERT J. MEYER | Available-FARA-Public-Office | ||
128086 | 128086 | 1993-12-01 | SHEA & GARDNER | Goodwin Procter, LLP 3901 | Short-Form | ELIZABETH M. BROWN | 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]) );