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 1994-11-30
This data as json, CSV (advanced)
Suggested facets: Address_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36773 | 36773 | 1994-11-30 | 1994-05-17 | Catlett | S. Graham | Catlett & Yancey, PLC 4914 | 1994-05-17 | Catlett & Yancey, PLC | 1800 Tower Building | 323 Center Street | Little Rock | AR | 72201 |
36774 | 36774 | 1994-11-30 | 1994-05-17 | Yancey | H. Lawrence | Catlett & Yancey, PLC 4914 | 1994-05-17 | Catlett & Yancey, PLC | 1800 Tower Building | 323 Center Street | Little Rock | AR | 72201 |
36775 | 36775 | 1994-11-30 | 1993-06-08 | Ip-Magdael | Judianna | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
36776 | 36776 | 1994-11-30 | 1991-06-18 | Smith | Eunice | Grenada Board of Tourism 2378 | 1972-09-10 | Grenada Board of Tourism | 317 Madison Avenue | Suite 1522 | New York | NY | 10017 |
36777 | 36777 | 1994-11-30 | 1994-11-08 | Ferrero | Henry J. , Jr. | Deloitte & Touche, L.L.P. 4970 | 1994-11-08 | Deloitte & Touche, L.L.P. | 1001 Pennsylvania Avenue, N.W. | Suite 350 North | Washington | DC | 20004-2505 |
36778 | 36778 | 1994-11-30 | 1991-11-29 | Cowan | Joyce A. | Levine & Company 3971 | 1987-04-29 | Levine & Company | 7100 Millwood Road | Bethesda | MD | 20817 |
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]) );