FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where City = "New York" and Short_Form_First_Name = "Stanley"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Date (date)
Registration_Number 14
- National News-Features Syndicate, Inc. 1
- Dominican Republic Information Center, Inc. 1
- Israel Philatelic Agency in America, Inc. 1
- Polonia International, Inc. 1
- Swiss Philatelic Agency in America, Inc. 1
- Donald N. Martin & Company, Inc. 1
- Ruder Finn, Inc. 1
- Sudler & Hennessey, Inc. 1
- Barber & Baar Associates, Inc. 1
- Oliver-Beckman, Inc. 1
- Tromson Monroe Advertising, Inc. 1
- FCB New York 1
- Roberts & Holland 1
- Roberts & Holland 1
Registrant_Name 13
- Roberts & Holland 2
- Barber & Baar Associates, Inc. 1
- Dominican Republic Information Center, Inc. 1
- Donald N. Martin & Company, Inc. 1
- FCB New York 1
- Israel Philatelic Agency in America, Inc. 1
- National News-Features Syndicate, Inc. 1
- Oliver-Beckman, Inc. 1
- Polonia International, Inc. 1
- Ruder Finn, Inc. 1
- Sudler & Hennessey, Inc. 1
- Swiss Philatelic Agency in America, Inc. 1
- Tromson Monroe Advertising, Inc. 1
State 1
- NY 14
City 1
- New York · 14 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
9080 | 9080 | 1959-03-04 | 1955-08-23 | Walker | Stanley | Dominican Republic Information Center, Inc. 506 | 1947-12-05 | Dominican Republic Information Center, Inc. | 507 Fifth Avenue | New York | NY | ||
12887 | 12887 | 1992-04-07 | 1977-12-07 | Fields | Stanley | FCB New York 2415 | 1973-03-28 | FCB New York | 100 West 33rd Street | New York | NY | 10001 | |
13667 | 13667 | 1967-04-18 | 1966-01-20 | Kohlenberg | Stanley | Sudler & Hennessey, Inc. 1701 | 1964-03-17 | Sudler & Hennessey, Inc. | 130 East 59th Street | New York | NY | 10022 | |
14323 | 14323 | 1947-04-29 | 1947-03-06 | Walker | Stanley | National News-Features Syndicate, Inc. 388 | 1946-10-29 | National News-Features Syndicate, Inc. | 341 Madison Avenue | New York | NY | ||
14440 | 14440 | 1964-04-30 | 1960-02-15 | Beer | Stanley | Swiss Philatelic Agency in America, Inc. 1165 | 1958-08-26 | Swiss Philatelic Agency in America, Inc. | 116 West 32nd Street | New York | NY | ||
15592 | 15592 | 1988-05-02 | 1981-04-13 | Weiss | Stanley | Roberts & Holland 3233 | 1981-04-13 | Roberts & Holland | 30 Rockefeller Plaza | 20th Floor | New York | NY | 10112 |
17004 | 17004 | 1967-05-24 | 1964-04-20 | Baar | Stanley | Barber & Baar Associates, Inc. 1715 | 1964-04-20 | Barber & Baar Associates, Inc. | 370 Lexington Avenue | New York | NY | 10017 | |
17614 | 17614 | 1971-05-31 | 1964-02-10 | Thea | Stanley | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
20513 | 20513 | 1981-06-29 | 1980-06-30 | Weiss | Stanley | Roberts & Holland 3116 | 1980-06-30 | Roberts & Holland | 30 Rockefeller Plaza | New York | NY | 10020 | |
22036 | 22036 | 1959-07-01 | 1958-04-28 | Polipow | Stanley | Polonia International, Inc. 1054 | 1957-07-30 | Polonia International, Inc. | 55 West 42nd Street | New York | NY | ||
24347 | 24347 | 1965-07-29 | 1960-07-29 | Raiff | Stanley | Donald N. Martin & Company, Inc. 1381 | 1960-07-29 | Donald N. Martin & Company, Inc. | One Rockefeller Plaza | Suite 214 | New York | NY | 10020 |
30996 | 30996 | 1986-09-30 | 1977-10-03 | Fields | Stanley | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | 450 Park Avenue, South | New York | NY | 10016 | |
37591 | 37591 | 1966-12-02 | 1957-08-05 | Beer | Stanley | Israel Philatelic Agency in America, Inc. 830 | 1954-05-18 | Israel Philatelic Agency in America, Inc. | 116 West 32nd 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]) );