FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Date_Stamped" is on date 1991-06-01 and Document_Type = "Registration Statement"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name, Foreign_Principal_Country, Date_Stamped
Registrant_Name 11
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
60173 | 60173 | 1991-06-01 | CAPITOLINE/MS&L | Capitoline/MS&L 4529 | Registration Statement | Available-FARA-Public-Office | |||
60207 | 60207 | 1991-06-01 | DESTA, TASSEW B. | Desta, Tassew B. 4532 | Registration Statement | Available-FARA-Public-Office | |||
60223 | 60223 | 1991-06-01 | FINLEY, MCDERMOTT & COMPANY | Finley, McDermott & Company 4523 | Registration Statement | Available-FARA-Public-Office | |||
60237 | 60237 | 1991-06-01 | GIBSON, BARRY J. | Gibson, Barry J. 4527 | Registration Statement | Available-FARA-Public-Office | |||
60301 | 60301 | 1991-06-01 | LEVINE, LEONARD B. | Levine, Leonard B. 4520 | Registration Statement | Available-FARA-Public-Office | |||
60313 | 60313 | 1991-06-01 | MCKENNA & CUNEO | McKenna & Cuneo 4530 | Registration Statement | Available-FARA-Public-Office | |||
60318 | 60318 | 1991-06-01 | MERKLEY NEWMAN HARTY | Merkley Newman Harty 4525 | Registration Statement | Available-FARA-Public-Office | |||
60369 | 60369 | 1991-06-01 | SABA, PAUL F. | Saba, Paul F. 4522 | Registration Statement | Available-FARA-Public-Office | |||
60376 | 60376 | 1991-06-01 | SHANDWICK NORTH AMERICA, INC. | Shandwick North America, Inc. 4521 | Registration Statement | Available-FARA-Public-Office | |||
60387 | 60387 | 1991-06-01 | SUTERWALLA, RAZIA | Suterwalla, Razia 4526 | Registration Statement | Available-FARA-Public-Office | |||
60413 | 60413 | 1991-06-01 | VON RAAB, WILLIAM | von Raab, William 4538 | Registration Statement | 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]) );