FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and Short_Form_First_Name = "Gabriel"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9130 | 9130 | 2005-03-04 | 2003-04-17 | Tseng | Gabriel | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
14035 | 14035 | 1987-04-24 | 1959-07-10 | Reiner | Gabriel | Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. 1246 | 1959-07-10 | Cosmos Parcels Express Corp./Rumanian Export Parcels Corp. | 40 East 49th Street | New York | NY | 10017 | |
14828 | 14828 | 2000-04-30 | 1999-10-26 | Guerra-Mondragon | Gabriel | Shepardson Stern & Kaminsky 5335 | 1999-10-26 | Shepardson Stern & Kaminsky | 568 Broadway | Suite 1103 | New York | NY | 10012 |
16689 | 16689 | 1951-05-19 | 1951-05-08 | Danihel | Gabriel | Slovak National Council Abroad, U.S. Branch 667 | 1951-04-10 | Slovak National Council Abroad, U.S. Branch | 34 Park Row | New York | NY | ||
16732 | 16732 | 1970-05-20 | 1957-05-17 | Desdoits | Gabriel | French Film Office 977 | 1956-09-29 | French Film Office | 745 Fifth Avenue | New York | NY | 10022 | |
18508 | 18508 | 1995-06-01 | 1992-06-30 | Tseng | Gabriel | Singapore Tourism Board 2414 | 1973-03-27 | Singapore Tourism Board | 589 5th Avenue | Suite 1702 | New York | NY | 10017 |
20111 | 20111 | 1995-06-23 | 1990-07-31 | Biron | Gabriel | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
22427 | 22427 | 1969-07-02 | 1967-09-21 | Reiner | Gabriel | Podarogifts, Inc. 1919 | 1965-08-23 | Podarogifts, Inc. | 240 Fifth Avenue | New York | NY | 10001 | |
22532 | 22532 | 1991-07-03 | 1988-01-26 | Goulet | Gabriel | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
23208 | 23208 | 1980-07-15 | 1971-03-01 | Lewander | Gabriel | Eastern News Distributors, Inc. 1796 | 1964-10-01 | Eastern News Distributors, Inc. | 111 Eighth Avenue | New York | NY | 10011 | |
26301 | 26301 | 1960-08-09 | 1955-11-07 | Reiner | Gabriel | Cosmos Travel Bureau, Inc. 918 | 1955-11-07 | Cosmos Travel Bureau, Inc. | 45 West 45th Street | New York | NY |
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]) );