FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where State = "NY" and Zip = 10018
This data as json, CSV (advanced)
Suggested facets: Termination_Date, Name, Business_Name, Address_2, Termination_Date (date)
Registration_Date (date) 18 ✖
- 1949-11-07 1
- 1950-02-28 1
- 1961-03-28 1
- 1964-09-21 1
- 1975-09-04 1
- 1978-04-10 1
- 1983-02-11 1
- 1986-02-20 1
- 1986-04-14 1
- 1988-11-23 1
- 1993-07-02 1
- 2007-11-15 1
- 2008-06-17 1
- 2015-04-21 1
- 2017-05-24 1
- 2020-02-13 1
- 2020-05-08 1
- 2020-05-19 1
Address_1 17
- 1350 Broadway 2
- 104 West 40th Street 1
- 111 West 40th Street 1
- 111 West 40th Street 1
- 1359 Broadway 1
- 1400 Broadway 1
- 1430 Broadway 1
- 1441 Broadway 1
- 15 West 36th Street 1
- 390 Fifth Avenue 1
- 438 West 37th Street 1
- 452 5th Avenue 1
- 452 Fifth Avenue 1
- 48 W 38th Street, 12th Floor 1
- 48 West 38th Street 12th Floor 1
- Desley Group 1
- New York Times Building 1
State 1
- NY · 18 ✖
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
596 | 1949-11-07 | 1993-03-30 | Amtorg Trading Corporation | 15 West 36th Street | 6th Floor | New York | NY | 10018 | |
616 | 1950-02-28 | German National Tourist Office | 1350 Broadway | Suite 440 | New York | NY | 10018 | ||
1436 | 1961-03-28 | 1998-05-01 | Wolf Shevack, Inc. | Partners & Shevack | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
1793 | 1964-09-21 | Moroccan National Tourist Office | 104 West 40th Street | Suite 1820 | New York | NY | 10018 | ||
2604 | 1975-09-04 | 1976-06-10 | Republic National Bank of New York | 452 Fifth Avenue | New York | NY | 10018 | ||
2951 | 1978-04-10 | 1988-05-11 | Ranko International | 390 Fifth Avenue | New York | NY | 10018 | ||
3442 | 1983-02-11 | 1983-09-09 | Bressen Communications, Inc. | 438 West 37th Street | New York | NY | 10018 | ||
3780 | 1986-02-20 | 2001-03-31 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 | |
3811 | 1986-04-14 | 1986-06-13 | Desley, Robert F. | Desley Group | 32 West 40th Street #3-C | New York | NY | 10018 | |
4191 | 1988-11-23 | 2003-11-23 | West Glen Communications | 1430 Broadway | New York | NY | 10018 | ||
4826 | 1993-07-02 | 1994-10-25 | Charney, Leon H. | 1441 Broadway | New York | NY | 10018 | ||
5840 | 2007-11-15 | Tourist Office for Flanders, Belgium - New York Office | New York Times Building | 620 Eighth Avenue, 38th Floor | New York | NY | 10018 | ||
5875 | 2008-06-17 | BLJ Worldwide LTD | 1359 Broadway | Suite 1102 | New York | NY | 10018 | ||
6290 | 2015-04-21 | 2015-12-31 | Quinn & Co. of NY LTD. | Quinn PR | 48 West 38th Street 12th Floor | New York | NY | 10018 | |
6433 | 2017-05-24 | Quinn & Co. of NY LTD. | 48 W 38th Street, 12th Floor | New York | NY | 10018 | |||
6793 | 2020-02-13 | 2020-11-01 | BurgherGray LLP | 1350 Broadway | Suite 406 | New York | NY | 10018 | |
6821 | 2020-05-08 | Baker & McKenzie | 452 5th Avenue | New York | NY | 10018 | |||
6827 | 2020-05-19 | Fragomen, Del Rey, Bernsen & Loewy, LLP | 1400 Broadway | New York | NY | 10018 |
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]) );