FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Date_Stamped" is on date 1989-02-21
This data as json, CSV (advanced)
These facets timed out: Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country
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 |
---|---|---|---|---|---|---|---|---|---|
17643 | 17643 | 1989-02-21 | BOZELL SAWYER MILLER GROUP | IPG DXTRA, Inc 3911 | Short-Form | LANCE IAN MORGAN | Available-FARA-Public-Office | ||
17644 | 17644 | 1989-02-21 | BOZELL SAWYER MILLER GROUP | IPG DXTRA, Inc 3911 | Short-Form | MARY MORRISON | Available-FARA-Public-Office | ||
17645 | 17645 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | ALAN S. GOUDISS | Available-FARA-Public-Office | ||
17646 | 17646 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | DEBORAH R. MESHULAM | Available-FARA-Public-Office | ||
17647 | 17647 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | JEREMY G. EPSTEIN | Available-FARA-Public-Office | ||
17648 | 17648 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | JOSEPH J. SALTARELLI | Available-FARA-Public-Office | ||
17649 | 17649 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | KENNETH M. KRAMER | Available-FARA-Public-Office | ||
17650 | 17650 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | MARGARET A. MCNULTY | Available-FARA-Public-Office | ||
17651 | 17651 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | MICHAEL KONDRATIEV-KEIGH | Available-FARA-Public-Office | ||
17652 | 17652 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | PHILIPPE P. DAUMAN | Available-FARA-Public-Office | ||
17653 | 17653 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | RACHEL E. DEMING | Available-FARA-Public-Office | ||
17654 | 17654 | 1989-02-21 | SHEARMAN & STERLING | Shearman & Sterling 4208 | Short-Form | THOMAS A. DIETERICH | 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]) );