FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where City = "New York" and Short_Form_First_Name = "Robert J."
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, Short_Form_Date (date), Registration_Date (date)
Registration_Number 16
- Merkley Newman Harty 2
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Skadden, Arps, Slate & Timbers 1
- Casey, Lane & Mittendorf 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- Aranow, Brodsky, Bohlinger, Einhorn & Dann 1
- IDA Ireland 1
- Doremus & Company 1
- Carl Byoir & Associates, Inc. 1
- White & Case, LLP 1
- Shea & Gould 1
- Office of the Government of Alberta 1
- GCI Group, Inc. 1
- Michael Solomon Associates 1
- Berman/Godek Communications, Inc. 1
- Dilenschneider Group, Inc. 1
Registrant_Name 16
- Merkley Newman Harty 2
- Aranow, Brodsky, Bohlinger, Einhorn & Dann 1
- Berman/Godek Communications, Inc. 1
- Carl Byoir & Associates, Inc. 1
- Casey, Lane & Mittendorf 1
- Dilenschneider Group, Inc. 1
- Doremus & Company 1
- GCI Group, Inc. 1
- IDA Ireland 1
- Michael Solomon Associates 1
- Netherlands Chamber of Commerce in the U.S., Inc. 1
- Office of the Government of Alberta 1
- Shea & Gould 1
- Skadden, Arps, Slate & Timbers 1
- Van Brunt & Company Advertising-Marketing, Inc. 1
- White & Case, LLP 1
State 1
- NY 17
City 1
- New York · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5224 | 5224 | 2000-01-31 | 1998-10-09 | Carraro | Robert J. | Michael Solomon Associates 3923 | 1987-01-06 | Michael Solomon Associates | 516 Fifth Avenue | Suite 801 | New York | NY | 10036 |
10580 | 10580 | 1976-03-23 | 1976-03-15 | Woody | Robert J. | Casey, Lane & Mittendorf 1553 | 1962-07-02 | Casey, Lane & Mittendorf | 26 Broadway | New York | NY | 10004 | |
12387 | 12387 | 1965-04-01 | 1958-12-03 | Kiek | Robert J. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | 1947-04-16 | Netherlands Chamber of Commerce in the U.S., Inc. | One Rockefeller Plaza | New York | NY | 10020 | |
21081 | 21081 | 1988-06-30 | 1986-02-04 | Scott | Robert J. | Office of the Government of Alberta 3459 | 1983-04-20 | Office of the Government of Alberta | 450 Park Avenue | Suite 1502 | New York | NY | 10020 |
23355 | 23355 | 1980-07-16 | 1975-03-28 | Wood | Robert J. | Carl Byoir & Associates, Inc. 2568 | 1975-03-28 | Carl Byoir & Associates, Inc. | 380 Madison Avenue | New York | NY | 10017 | |
25834 | 25834 | 1956-08-03 | 1955-09-08 | Ensher | Robert J. | Skadden, Arps, Slate & Timbers 737 | 1952-07-28 | Skadden, Arps, Slate & Timbers | 551 Fifth Avenue | New York | NY | ||
28199 | 28199 | 1991-08-31 | 1990-07-05 | Hong | Robert J. | Berman/Godek Communications, Inc. 4394 | 1990-07-05 | Berman/Godek Communications, Inc. | 30 Rockefeller Plaza | Suite 2818 | New York | NY | 10112 |
32848 | 32848 | 1979-10-15 | 1978-12-22 | Casey | Robert J. | Shea & Gould 2986 | 1978-12-22 | Shea & Gould | 330 Madison Avenue | New York | NY | 10017 | |
35560 | 35560 | 1994-11-09 | 1992-10-06 | Stone | Robert J. | Dilenschneider Group, Inc. 4717 | 1992-10-06 | Dilenschneider Group, Inc. | 200 Park Avenue | New York | NY | 10166 | |
37921 | 37921 | 1995-12-08 | 1984-09-18 | Morrow | Robert J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
38596 | 38596 | 1967-12-18 | 1964-05-13 | Ward | Robert J. | Aranow, Brodsky, Bohlinger, Einhorn & Dann 1731 | 1964-05-13 | Aranow, Brodsky, Bohlinger, Einhorn & Dann | 122 East 42nd Street | New York | NY | 10017 | |
39977 | 39977 | 1975-12-31 | 1974-05-22 | McDermott | Robert J. | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
40076 | 40076 | 1978-12-31 | 1976-07-12 | Fisher | Robert J. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
40222 | 40222 | 1982-12-31 | 1971-04-20 | Ricglane | Robert J. | Van Brunt & Company Advertising-Marketing, Inc. 1704 | 1964-04-02 | Van Brunt & Company Advertising-Marketing, Inc. | 7 Dey Street | New York | NY | 10017 | |
40668 | 40668 | 1991-12-31 | 1991-01-31 | Siegmann | Robert J. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
40954 | 40954 | 1996-12-31 | 1992-01-21 | Jaczko | Robert J. | Merkley Newman Harty 4525 | 1991-06-04 | Merkley Newman Harty | 200 Varick Street | New York | NY | 10014 | |
40979 | 40979 | 1996-12-31 | 1991-06-04 | Docherty | Robert J. | Merkley Newman Harty 4525 | 1991-06-04 | Merkley Newman Harty | 200 Varick Street | New York | NY | 10014 |
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]) );