FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Short_Form_Termination_Date" is on date 1990-10-29
This data as json, CSV (advanced)
Link | rowid ▼ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33959 | 33959 | 1990-10-29 | 1990-02-06 | Cannon | William Stephen | Levine & Company 3971 | 1987-04-29 | Levine & Company | 7100 Millwood Road | Bethesda | MD | 20817 | |
33960 | 33960 | 1990-10-29 | 1990-02-06 | Gibson | Joseph H. | Levine & Company 3971 | 1987-04-29 | Levine & Company | 7100 Millwood Road | Bethesda | MD | 20817 | |
33961 | 33961 | 1990-10-29 | 1990-02-06 | Ryan | Thomas M. | Levine & Company 3971 | 1987-04-29 | Levine & Company | 7100 Millwood Road | Bethesda | MD | 20817 | |
33962 | 33962 | 1990-10-29 | 1963-06-12 | Heyward | Evelyn Joan (E. H. Hildes) | Heyward Associates, Inc. 1639 | 1963-06-12 | Heyward Associates, Inc. | 205 West 57th Street | New York | NY | 10019 | |
33963 | 33963 | 1990-10-29 | 1988-08-11 | Wunder | Bernard J. , Jr. | Levine & Company 3971 | 1987-04-29 | Levine & Company | 7100 Millwood Road | Bethesda | MD | 20817 | |
33964 | 33964 | 1990-10-29 | 1990-10-29 | Shelby | Rick | Commerce Consultants International, Ltd. 4248 | 1989-05-05 | Commerce Consultants International, Ltd. | 1025 Thomas Jeff. Street, N.W. | Suite 105 | Washington | DC | 20007 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );