FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where State = "NY" and Zip = 10006
This data as json, CSV (advanced)
Suggested facets: Termination_Date, Name, Address_2, Registration_Date (date), Termination_Date (date)
Address_1 10
State 1
- NY · 12 ✖
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
81 | 1942-08-03 | 1972-08-17 | Gdynia American Line, Inc. | 115 Broadway | New York | NY | 10006 | ||
240 | 1944-03-06 | 1945-09-06 | Ahmed, Shaikh Muzaffar | Trinity Station | Post Office Box 24 | New York | NY | 10006 | |
495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 | ||
1113 | 1958-02-06 | 1976-09-16 | Japan Trade Promotion Office (JTPO) | 39 Broadway | New York | NY | 10006 | ||
1293 | 1959-11-09 | 1967-11-17 | Kramer, Marx, Greenlee & Backus | 29 Broadway | New York | NY | 10006 | ||
1897 | 1965-06-01 | Tourism Authority of Thailand, New York | 61 Broadway | Suite 2810 | New York | NY | 10006 | ||
2880 | 1978-04-04 | 1979-07-27 | Ogilvie, Taylor & Associates, Inc. | 111 Broadway | New York | NY | 10006 | ||
4860 | 1993-10-12 | Office of the Deputy Commissioner of Maritime Affairs | 39 Broadway | Suite 2020 | New York | NY | 10006 | ||
6421 | 2017-04-21 | 2017-10-31 | Geoffrey Weill Associates | 29 Broadway Suite 2205 | New York | NY | 10006 | ||
6607 | 2018-11-06 | 2019-11-30 | Cleary Gottlieb Steen & Hamilton LLP | One Liberty Plaza | New York | NY | 10006 | ||
6964 | 2021-05-25 | Cleary Gottlieb Steen & Hamilton LLP | One Liberty Plaza | New York | NY | 10006 | |||
7173 | 2022-09-27 | Geoffrey Weill | Geoffrey Weill Associates | 29 Broadway, Suite 2205 | New York | NY | 10006 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [FARA_All_Registrants] ( [Registration_Number] INTEGER PRIMARY KEY, [Registration_Date] TEXT, [Termination_Date] TEXT, [Name] TEXT, [Business_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );