FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where City = "New York" and Short_Form_First_Name = "John W."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 11
- White & Case, LLP 2
- Netherlands Board of Tourism and Conventions (NBTC) 1
- Bennett Tours, Inc. 1
- Sydney Morrell & Company, Inc. 1
- Quebec Government Office 1
- Milbank, Tweed, Hadley & McCloy 1
- Shearman & Sterling 1
- Doremus & Company 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Daniel J. Edelman, Inc. 1
- IPG DXTRA, Inc 1
Registrant_Name 11
- White & Case, LLP 2
- Bennett Tours, Inc. 1
- Daniel J. Edelman, Inc. 1
- Doremus & Company 1
- IPG DXTRA, Inc 1
- Milbank, Tweed, Hadley & McCloy 1
- Netherlands Board of Tourism and Conventions (NBTC) 1
- Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 1
- Quebec Government Office 1
- Shearman & Sterling 1
- Sydney Morrell & Company, Inc. 1
State 1
- NY 12
City 1
- New York · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6551 | 6551 | 1992-02-10 | 1978-03-06 | Dean | John W. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
8953 | 8953 | 1960-03-02 | 1959-08-28 | Knudsen | John W. | Bennett Tours, Inc. 1260 | 1959-08-28 | Bennett Tours, Inc. | 290 Madison Avenue | New York | NY | ||
9972 | 9972 | 1993-03-15 | 1992-09-14 | Walker | John W. | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. 2530 | 1974-08-12 | Ogilvy & Mather U.S., a Division of The Ogilvy Group, Inc. | 309 West 49th Street | Worldwide Plaza | New York | NY | 10019-7399 |
13151 | 13151 | 1977-04-11 | 1965-04-22 | Weiser | John W. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
24331 | 24331 | 2017-07-28 | 2017-01-28 | Leslie Jr | John W. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
30529 | 30529 | 1985-09-26 | 1976-09-15 | O'Connell | John W. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
30603 | 30603 | 1991-09-27 | 1972-02-28 | Serbrock | John W. | Netherlands Board of Tourism and Conventions (NBTC) 619 | 1950-03-20 | Netherlands Board of Tourism and Conventions (NBTC) | 215 Park Avenue South | Suite 1302 | New York | NY | 10003 |
35841 | 35841 | 1982-11-15 | 1982-11-15 | Sullivan | John W. | Sydney Morrell & Company, Inc. 1661 | 1963-10-11 | Sydney Morrell & Company, Inc. | 152 East 78th Street | New York | NY | 10021 | |
38120 | 38120 | 1990-12-11 | 1990-01-09 | Walker | John W. | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
39933 | 39933 | 1973-12-31 | 1974-01-21 | Sharp | John W. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
40780 | 40780 | 1994-12-31 | 1980-03-28 | Barnum | John W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41196 | 41196 | 2000-12-31 | 1982-10-08 | Erickson | John W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );