FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "Hicks"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 8
Registrant_Name 8
City 6
- New York 2
- Washington 2
- Arlington 1
- Buffalo 1
- Falls Church 1
- Syracuse 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16086 | 16086 | 1971-05-12 | 1970-12-22 | Hicks | Bernice Espy | Arab Information Center 876 | 1955-03-03 | Arab Information Center | League of Arab States | 1100 17th Street, N.W., Suite 201 | Washington | DC | 20036 |
17206 | 17206 | 2022-05-26 | 2021-10-29 | Hicks | Brandon | Terakeet LLC 6806 | 2020-03-24 | Terakeet LLC | 333 West Washington Street, Suite 500 | Syracuse | NY | 13202 | |
20858 | 20858 | 1972-06-30 | 1964-11-20 | Hicks | Rita | Tribune Films, Inc. 1810 | 1964-10-29 | Tribune Films, Inc. | 55 West 14th Street | Suite 8D | New York | NY | 10011 |
23456 | 23456 | 1958-07-18 | 1957-09-03 | Hicks | Albert Cross | Ernst, Morris Leopold 1047 | 1957-07-19 | Ernst, Morris Leopold | 285 Madison Avenue | New York | NY | ||
23457 | 23457 | 1958-07-18 | 1957-09-03 | Hicks | Albert Cross | Munson, William Howes 1048 | 1957-07-23 | Munson, William Howes | 1018 Walbridge Building | Buffalo | NY | ||
26694 | 26694 | 1980-08-15 | 1979-06-29 | Hicks | Margaret Lynn | Dickstein Shapiro, LLP 3028 | 1979-06-07 | Dickstein Shapiro, LLP | 1825 Eye Street, N.W. | Washington | DC | 20006-5403 | |
30226 | 30226 | 1998-09-21 | 1987-04-27 | Hicks | A.J. | National Union for the Total Independence of Angola (UNITA) 3797 | 1986-03-21 | National Union for the Total Independence of Angola (UNITA) | 6021 Munson Hill Road | Falls Church | VA | 22041 | |
36689 | 36689 | 1987-11-30 | 1987-08-20 | Hicks | Angela J. | Friedmann, Hicks & Company 4028 | 1987-08-20 | Friedmann, Hicks & Company | 1400 South Joyce Street | Suite B-711 | Arlington | VA | 22202-1834 |
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]) );