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 J."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 10
- Kramer, Marx, Greenlee & Backus 2
- White & Case, LLP 2
- Australian Information Service 1
- U.S. Office of the British Broadcasting Corporation 1
- EG&A International, Inc. 1
- Milbank, Tweed, Hadley & McCloy 1
- Government of Ontario, Canada 1
- Promotional Concept Group, Inc. 1
- Friends of Fianna Fail, Inc. 1
- International Trade Promotion, Ltd. 1
Registrant_Name 10
- Kramer, Marx, Greenlee & Backus 2
- White & Case, LLP 2
- Australian Information Service 1
- EG&A International, Inc. 1
- Friends of Fianna Fail, Inc. 1
- Government of Ontario, Canada 1
- International Trade Promotion, Ltd. 1
- Milbank, Tweed, Hadley & McCloy 1
- Promotional Concept Group, Inc. 1
- U.S. Office of the British Broadcasting Corporation 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3744 | 3744 | 1971-01-15 | 1968-01-02 | Sheffield | John J. | EG&A International, Inc. 1584 | 1962-11-28 | EG&A International, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
5075 | 5075 | 1991-01-31 | 1982-06-16 | Gruntkowski | John J. | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
9830 | 9830 | 1989-03-14 | 1965-01-11 | McCloy | John J. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
13446 | 13446 | 1992-04-15 | 1988-04-15 | McCabe | John J. | International Trade Promotion, Ltd. 4119 | 1988-04-15 | International Trade Promotion, Ltd. | Post Office Box 1000 | New York | NY | 10024 | |
23088 | 23088 | 1947-07-14 | 1946-12-31 | Marciante | John J. | Australian Information Service 418 | 1946-12-31 | Australian Information Service | 636 Fifth Avenue | New York | NY | 10020 | |
27003 | 27003 | 1986-08-19 | 1984-06-08 | Stack | John J. | Friends of Fianna Fail, Inc. 3596 | 1984-06-08 | Friends of Fianna Fail, Inc. | C/O Richardson Mahon Casey & Rooney, LLP | 1270 Avenue of the Americas #2911 | New York | NY | 10020 |
28258 | 28258 | 1995-08-31 | 1979-01-24 | McAvoy | John J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
33795 | 33795 | 1993-10-28 | 1990-11-16 | Dorr | John J. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
35970 | 35970 | 1967-11-17 | 1960-05-19 | Hayes | John J. | Kramer, Marx, Greenlee & Backus 1293 | 1959-11-09 | Kramer, Marx, Greenlee & Backus | 29 Broadway | New York | NY | 10006 | |
35973 | 35973 | 1967-11-17 | 1961-05-29 | Tommaney | John J. | Kramer, Marx, Greenlee & Backus 1293 | 1959-11-09 | Kramer, Marx, Greenlee & Backus | 29 Broadway | New York | NY | 10006 | |
39398 | 39398 | 1988-12-30 | 1978-11-07 | Stringer | John J. | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 | |
40770 | 40770 | 1994-12-31 | 1980-01-21 | McNally | John J. | 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]) );