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 = "David J."
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 11
- White & Case, LLP 2
- Clinton E. Frank, Inc., New York 1
- McCann-Erickson, Inc. 1
- Milbank, Tweed, Hadley & McCloy 1
- Shearman & Sterling 1
- International Public Relations Company, Ltd. 1
- Friedlich, Fearon & Strohmeier, Inc. 1
- DJJ Communications, Inc. 1
- Airbus Industrie of North America, Inc. 1
- Office of the Government of Alberta 1
- International Public Relations Company, Ltd. 1
Registrant_Name 10
- International Public Relations Company, Ltd. 2
- White & Case, LLP 2
- Airbus Industrie of North America, Inc. 1
- Clinton E. Frank, Inc., New York 1
- DJJ Communications, Inc. 1
- Friedlich, Fearon & Strohmeier, Inc. 1
- McCann-Erickson, Inc. 1
- Milbank, Tweed, Hadley & McCloy 1
- Office of the Government of Alberta 1
- Shearman & Sterling 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3952 | 3952 | 1973-01-17 | 1965-04-29 | Supino | David J. | Shearman & Sterling 1877 | 1965-04-05 | Shearman & Sterling | 53 Wall Street | New York | NY | 10005 | |
6557 | 6557 | 1992-02-10 | 1987-07-02 | Harris | David J. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
6840 | 6840 | 1996-02-14 | 1990-04-09 | Kaplan | David J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8737 | 8737 | 1981-03-01 | 1979-08-27 | Maund | David J. | Airbus Industrie of North America, Inc. 2817 | 1977-08-02 | Airbus Industrie of North America, Inc. | 630 Fifth Avenue | New York | NY | 10111 | |
14557 | 14557 | 1985-04-30 | 1979-04-20 | Branson | David J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
15614 | 15614 | 1974-05-03 | 1973-01-16 | Frank | David J. | Friedlich, Fearon & Strohmeier, Inc. 2228 | 1970-12-03 | Friedlich, Fearon & Strohmeier, Inc. | 600 Third Avenue | New York | NY | 10016 | |
15909 | 15909 | 1974-05-08 | 1972-10-12 | Jacobson | David J. | DJJ Communications, Inc. 2371 | 1972-08-24 | DJJ Communications, Inc. | 575 Madison Avenue | New York | NY | 10022 | |
18503 | 18503 | 1994-06-01 | 1990-03-16 | Manning | David 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 |
23718 | 23718 | 1987-07-21 | 1986-06-04 | Speer | David J. | International Public Relations Company, Ltd. 3839 | 1986-06-04 | International Public Relations Company, Ltd. | 950 Third Avenue | New York | NY | 10022 | |
27929 | 27929 | 1977-08-31 | 1970-01-06 | Hayes | David J. | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
38776 | 38776 | 1964-12-20 | 1964-03-30 | Jacobson | David J. | Clinton E. Frank, Inc., New York 1601 | 1963-02-25 | Clinton E. Frank, Inc., New York | 666 Third Avenue | New York | NY | 10017 | |
40683 | 40683 | 1991-12-31 | 1991-04-23 | Rokit | David J. | International Public Relations Company, Ltd. 1967 | 1966-03-14 | International Public Relations Company, Ltd. | 352 Park Avenue, South | Suite 705 | New York | NY | 10010 |
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]) );