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 1993-06-01 and Document_Type = "Registration Statement"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country, Date_Stamped
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
61187 | 61187 | 1993-06-01 | BROUILLARD COMMUNICATIONS | Brouillard Communications 4819 | Registration Statement | Available-FARA-Public-Office | |||
61251 | 61251 | 1993-06-01 | CRANDALL, ROBERT W. | Crandall, Robert W. 4823 | Registration Statement | Available-FARA-Public-Office | |||
61279 | 61279 | 1993-06-01 | DOVER & DIXON, P.A. | Dover & Dixon, P.A. 4824 | Registration Statement | Available-FARA-Public-Office | |||
61316 | 61316 | 1993-06-01 | FRANCIS S. RATH, P.C. | Francis S. Rath, P.C. 4822 | Registration Statement | Available-FARA-Public-Office | |||
61319 | 61319 | 1993-06-01 | FRIED, FRANK, HARRIS, SHRIVER & JACOBSON | Fried, Frank, Harris, Shriver & Jacobson 4821 | Registration Statement | Available-FARA-Public-Office | |||
61327 | 61327 | 1993-06-01 | GEC ALSTHOM, INC. (A SUBSIDIARY OF GEC ALSTHOM, NV) | GEC Alsthom, Inc. (a Subsidiary of GEC Alsthom, NV) 4814 | Registration Statement | Available-FARA-Public-Office | |||
61360 | 61360 | 1993-06-01 | GRAYDON ASSOCIATES, INC. | Graydon Associates, Inc. 4820 | Registration Statement | Available-FARA-Public-Office | |||
61363 | 61363 | 1993-06-01 | GREENBERG, TRAURIG, HOFFMAN, LIPOFF, ROSEN & QUENTEL, P.A. | Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A. 4817 | Registration Statement | Available-FARA-Public-Office | |||
61501 | 61501 | 1993-06-01 | MCDERMOTT, WILL & EMERY | McDermott, Will & Emery 4818 | Registration Statement | Available-FARA-Public-Office | |||
61586 | 61586 | 1993-06-01 | RAFTIS ASSOCIATES | Raftis Associates 4816 | Registration Statement | Available-FARA-Public-Office | |||
61647 | 61647 | 1993-06-01 | WALLACE, DONALD L., JR. | Wallace & Edwards 4813 | Registration Statement | Available-FARA-Public-Office | |||
61657 | 61657 | 1993-06-01 | WILLIAMS, MULLEN, CHRISTIAN & DOBBINS, P.C. | Williams, Mullen, Christian & Dobbins, P.C. 4815 | 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]) );