FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
4 rows where Address_2 = "Suite 601"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Zip, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17536 | 17536 | 2020-05-30 | 2019-05-09 | Abrams | David | Zionist Advocacy Center (TZAC Inc.) 6676 | 2019-05-09 | Zionist Advocacy Center (TZAC Inc.) | 305 Broadway | Suite 601 | New York | NY | 10007 |
40879 | 40879 | 1995-12-31 | 1995-06-30 | Battaglia | Lisa | Fuji Bank, Ltd., Washington D.C. Representative Office 5034 | 1995-06-30 | Fuji Bank, Ltd., Washington D.C. Representative Office | 1155 Connecticut Avenue, N.W. | Suite 601 | Washington | DC | 20036 |
40880 | 40880 | 1995-12-31 | 1995-06-30 | Coons | Julie J. | Fuji Bank, Ltd., Washington D.C. Representative Office 5034 | 1995-06-30 | Fuji Bank, Ltd., Washington D.C. Representative Office | 1155 Connecticut Avenue, N.W. | Suite 601 | Washington | DC | 20036 |
40881 | 40881 | 1995-12-31 | 1995-06-30 | Ikegami | Kazuyuki | Fuji Bank, Ltd., Washington D.C. Representative Office 5034 | 1995-06-30 | Fuji Bank, Ltd., Washington D.C. Representative Office | 1155 Connecticut Avenue, N.W. | Suite 601 | Washington | DC | 20036 |
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]) );