FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
4 rows where "Short_Form_Termination_Date" is on date 1972-01-31
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4933 | 4933 | 1972-01-31 | 1964-02-11 | Utsch | Annemarie Schuelein | International Remittances, Inc. 1141 | 1958-05-09 | International Remittances, Inc. | 164 - 1st Street | Hoboken | NJ | 07030 | |
4934 | 4934 | 1972-01-31 | 1965-04-13 | Garza | Joel Quinones | Mexican Government Tourism Office, San Antonio 1882 | 1965-04-13 | Mexican Government Tourism Office, San Antonio | GPM South Tower | Suite 240 | San Antonio | TX | 78216 |
4935 | 4935 | 1972-01-31 | 1967-07-20 | Rule | Frank Edwin | New South Wales Government Office 1276 | 1959-09-25 | New South Wales Government Office | 2049 Century Park, East | Suite 2250 | Los Angeles | CA | 90067 |
4936 | 4936 | 1972-01-31 | 1968-10-11 | Digby | Noel | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 |
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]) );