FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Short_Form_Last_Name = "Ross" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 18
- British Information Services 2
- U.S.-Cuban Sugar Council 1
- Bermuda Tourism Authority 1
- New York Bureau of the Telegraph Agency of Russia (TASS) 1
- Israel Government Tourist Office 1
- Curtis J. Hoxter, Inc. 1
- Jamaica Tourist Board, New York 1
- Ruder Finn, Inc. 1
- Shearman & Sterling 1
- Oliver-Beckman, Inc. 1
- Baron/Canning & Company, Inc. 1
- Tromson Monroe Advertising, Inc. 1
- Botein, Hays, Sklar & Herzberg 1
- Young & Rubicam, L.P. 1
- Young & Rubicam, New York 1
- Malkin & Ross 1
- Independent Diplomat, Inc. 1
- Finn Partners, Inc. 1
Registrant_Name 18
- British Information Services 2
- Baron/Canning & Company, Inc. 1
- Bermuda Tourism Authority 1
- Botein, Hays, Sklar & Herzberg 1
- Curtis J. Hoxter, Inc. 1
- Finn Partners, Inc. 1
- Independent Diplomat, Inc. 1
- Israel Government Tourist Office 1
- Jamaica Tourist Board, New York 1
- Malkin & Ross 1
- New York Bureau of the Telegraph Agency of Russia (TASS) 1
- Oliver-Beckman, Inc. 1
- Ruder Finn, Inc. 1
- Shearman & Sterling 1
- Tromson Monroe Advertising, Inc. 1
- U.S.-Cuban Sugar Council 1
- Young & Rubicam, L.P. 1
- Young & Rubicam, New York 1
State 1
- NY · 19 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3110 | 3110 | 1963-01-03 | 1951-03-02 | Ross | Mary Alison | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
4951 | 4951 | 1975-01-31 | 1974-09-30 | Ross | John P. , Jr. | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | 450 Park Avenue, South | New York | NY | 10016 | |
5638 | 5638 | 1956-02-01 | 1949-09-27 | Ross | James Stirling | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
6451 | 6451 | 1978-02-09 | 1976-08-19 | Ross | Daniel A. | Botein, Hays, Sklar & Herzberg 2716 | 1976-08-19 | Botein, Hays, Sklar & Herzberg | 20 Park Avenue | New York | NY | 10017 | |
9020 | 9020 | 1981-03-03 | 1969-10-01 | Ross | Stanley | Oliver-Beckman, Inc. 2009 | 1967-03-01 | Oliver-Beckman, Inc. | Post Office Box 676 | New York | NY | 10021 | |
10116 | 10116 | 1964-03-17 | 1963-08-30 | Ross | Martin Conrad | Curtis J. Hoxter, Inc. 1111 | 1958-01-28 | Curtis J. Hoxter, Inc. | 745 Fifth Avenue | New York | NY | 10022 | |
12366 | 12366 | 1955-04-01 | 1947-06-09 | Ross | Harry | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | 1947-06-03 | New York Bureau of the Telegraph Agency of Russia (TASS) | 50 Rockefeller Plaza | New York | NY | 10020 | |
13157 | 13157 | 1977-04-11 | 1966-08-11 | Ross | Alfred J. , Jr. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
20651 | 20651 | 1956-06-30 | 1955-09-08 | Ross | Jacob Jack | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
22078 | 22078 | 1968-07-01 | 1967-01-23 | Ross | Charlene Adair | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
25743 | 25743 | 2017-08-01 | 2008-04-03 | Ross | Carne W. | Independent Diplomat, Inc. 5860 | 2008-04-03 | Independent Diplomat, Inc. | 246 Fifth Avenue | New York | NY | 10001 | |
30208 | 30208 | 1992-09-21 | 1992-03-19 | Ross | Donald K. | Malkin & Ross 4636 | 1992-03-19 | Malkin & Ross | 40 Central Avenue | Albany | NY | 12206-3002 | |
31536 | 31536 | 2013-09-30 | 2012-01-06 | Ross | Jessica | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
35528 | 35528 | 1990-11-09 | 1981-08-27 | Ross | Frederick R. W. , Jr. | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
35709 | 35709 | 1987-11-13 | 1977-08-29 | Ross | David W. | Baron/Canning & Company, Inc. 2270 | 1971-07-23 | Baron/Canning & Company, Inc. | 555 Madison Avenue | 12th Floor | New York | NY | 10022 |
38825 | 38825 | 1993-12-20 | 1991-08-06 | Ross | Marguerite | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | 285 Madison Avenue | New York | NY | 100176486 | |
39706 | 39706 | 1961-12-31 | 1946-03-07 | Ross | Thomas Joseph | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
39953 | 39953 | 1973-12-31 | 1947-10-30 | Ross | Thomas Joseph | Bermuda Tourism Authority 430 | 1947-01-30 | Bermuda Tourism Authority | 675 Third Avenue | 12th Floor | New York | NY | 10017 |
42026 | 42026 | 2016-12-31 | 2014-03-10 | Ross | Jessica | Finn Partners, Inc. 6212 | 2014-03-10 | Finn Partners, Inc. | 301 E. 57th Street | New York | NY | 10022 |
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]) );