FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where City = "New York" and Short_Form_First_Name = "Harry"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 17
- New York Bureau of the Telegraph Agency of Russia (TASS) 2
- Israel Information Services 2
- Package Express & Travel Agency, Inc. 2
- Free Holland on the Seas, Inc. 1
- Polish Research & Information Service 1
- European Travel Commission 1
- Eagleton, Clyde 1
- Federal Advertising Agency, Inc. 1
- Ruder Finn, Inc. 1
- Foreign Research & Development Corporation 1
- Lampert Agency, Inc. 1
- Needham, Harper & Steers Advertising, Inc. 1
- Solov, Liuba 1
- Greek National Tourist Organization, New York 1
- Doremus & Company 1
- Robert Marston & Associates, Inc. 1
- Strategy XXI Group, Ltd. 1
Registrant_Name 17
- Israel Information Services 2
- New York Bureau of the Telegraph Agency of Russia (TASS) 2
- Package Express & Travel Agency, Inc. 2
- Doremus & Company 1
- Eagleton, Clyde 1
- European Travel Commission 1
- Federal Advertising Agency, Inc. 1
- Foreign Research & Development Corporation 1
- Free Holland on the Seas, Inc. 1
- Greek National Tourist Organization, New York 1
- Lampert Agency, Inc. 1
- Needham, Harper & Steers Advertising, Inc. 1
- Polish Research & Information Service 1
- Robert Marston & Associates, Inc. 1
- Ruder Finn, Inc. 1
- Solov, Liuba 1
- Strategy XXI Group, Ltd. 1
State 1
- NY 20
City 1
- New York · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3146 | 3146 | 1964-01-04 | 1963-01-11 | Sackren | Harry | Foreign Research & Development Corporation 1589 | 1963-01-11 | Foreign Research & Development Corporation | 575 Madison Avenue | New York | NY | ||
3702 | 3702 | 1978-01-14 | 1947-06-09 | Freeman | 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 | |
8617 | 8617 | 1954-03-01 | 1951-03-28 | Zinder | Harry | Israel Information Services 543 | 1948-10-12 | Israel Information Services | 11 East 70th Street | New York | NY | 10021 | |
9617 | 9617 | 1971-03-11 | 1964-05-21 | Lampert | Harry | Lampert Agency, Inc. 1739 | 1964-05-21 | Lampert Agency, Inc. | 770 Lexington Avenue | New York | NY | 10021 | |
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 | |
12992 | 12992 | 1985-04-09 | 1959-04-17 | Kujtkowski | Harry | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
13021 | 13021 | 1985-04-09 | 1973-08-06 | Kujtkowski | Harry | Package Express & Travel Agency, Inc. 1117 | 1958-02-24 | Package Express & Travel Agency, Inc. | 1776 Broadway | New York | NY | 10019 | |
16305 | 16305 | 1952-05-14 | 1950-11-14 | Tax | Harry | Federal Advertising Agency, Inc. 649 | 1950-11-14 | Federal Advertising Agency, Inc. | 270 Park Avenue | New York | NY | ||
18959 | 18959 | 1973-06-06 | 1973-04-05 | Webber | Harry | Needham, Harper & Steers Advertising, Inc. 1748 | 1964-06-03 | Needham, Harper & Steers Advertising, Inc. | 909 Third Avenue | New York | NY | 10022 | |
19138 | 19138 | 1974-06-10 | 1967-12-21 | Levine | Harry | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
23036 | 23036 | 1979-07-13 | 1977-10-12 | Savage | Harry | Robert Marston & Associates, Inc. 2834 | 1977-10-12 | Robert Marston & Associates, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
26334 | 26334 | 1951-08-10 | 1950-03-02 | Winegar | Harry | Polish Research & Information Service 473 | 1947-06-25 | Polish Research & Information Service | 250 West 57th Street | New York | NY | ||
26662 | 26662 | 1953-08-15 | 1950-03-10 | Kursh | Harry | Eagleton, Clyde 588 | 1949-08-15 | Eagleton, Clyde | New York University | New York | NY | ||
26910 | 26910 | 1978-08-18 | 1976-04-06 | Haralambopoulos | Harry | Greek National Tourist Organization, New York 1895 | 1965-05-27 | Greek National Tourist Organization, New York | Olympic Tower | 645 Fifth Avenue | New York | NY | 10022 |
28385 | 28385 | 2001-08-31 | 2000-03-14 | Wall | Harry | Strategy XXI Group, Ltd. 5273 | 1998-09-01 | Strategy XXI Group, Ltd. | 515 Madison Avenue | 34th Floor | New York | NY | 10022 |
30495 | 30495 | 1985-09-26 | 1978-01-30 | Cromer | Harry | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
31866 | 31866 | 1982-10-01 | 1979-08-31 | Haralambopoulos | Harry | European Travel Commission 574 | 1949-06-30 | European Travel Commission | c/o Spring O'Brien | 30 West 26th Street, 4th Floor | New York | NY | 10010 |
35252 | 35252 | 1949-11-05 | 1948-10-12 | Zinder | Harry | Israel Information Services 543 | 1948-10-12 | Israel Information Services | 11 East 70th Street | New York | NY | 10021 | |
39529 | 39529 | 1954-12-31 | 1952-07-03 | Vrymoet | Harry | Free Holland on the Seas, Inc. 459 | 1947-04-28 | Free Holland on the Seas, Inc. | 61 Broadway | Room 812 | New York | NY | |
39951 | 39951 | 1973-12-31 | 1969-09-23 | Lowenkron | Harry | Solov, Liuba 1766 | 1964-06-29 | Solov, Liuba | 24 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]) );