FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and Short_Form_First_Name = "John M."
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 11
- American Members of the Institut de France, Inc. 1
- Allied Syndicates, Inc. 1
- Tea Council of the U.S.A., Inc. 1
- Trinidad-Tobago Industrial Development Corporation 1
- Government of Ontario, Canada 1
- French Film Office/Unifrance USA 1
- Peter Martin Associates, Inc. 1
- Stroock & Stroock & Lavan 1
- Murphy, John M. 1
- Azerbaijan Study Foundation 1
- Hughes Hubbard & Reed, LLP 1
Registrant_Name 11
- Allied Syndicates, Inc. 1
- American Members of the Institut de France, Inc. 1
- Azerbaijan Study Foundation 1
- French Film Office/Unifrance USA 1
- Government of Ontario, Canada 1
- Hughes Hubbard & Reed, LLP 1
- Murphy, John M. 1
- Peter Martin Associates, Inc. 1
- Stroock & Stroock & Lavan 1
- Tea Council of the U.S.A., Inc. 1
- Trinidad-Tobago Industrial Development Corporation 1
State 1
- NY 11
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3260 | 3260 | 1951-01-06 | 1950-01-06 | Gray | John M. | Allied Syndicates, Inc. 604 | 1950-01-06 | Allied Syndicates, Inc. | 745 Fifth Avenue | New York | NY | ||
3771 | 3771 | 1978-01-15 | 1977-11-15 | Harrison | John M. | Peter Martin Associates, Inc. 2846 | 1977-11-15 | Peter Martin Associates, Inc. | 770 Lexington Avenue | New York | NY | 10021 | |
5880 | 5880 | 2013-02-01 | 2006-08-15 | Kochman | John M. | French Film Office/Unifrance USA 2358 | 1972-07-20 | French Film Office/Unifrance USA | 972 Fifth Avenue | New York | NY | 10075 | |
14030 | 14030 | 1984-04-24 | 1982-04-22 | Gibbons | John M. | Stroock & Stroock & Lavan 3005 | 1979-03-22 | Stroock & Stroock & Lavan | Seven Hanover Square | New York | NY | 10004 | |
14721 | 14721 | 1996-04-30 | 1994-12-22 | Murphy | John M. | Azerbaijan Study Foundation 4964 | 1994-10-14 | Azerbaijan Study Foundation | 110 East 59th Street | Suite 3202 | New York | NY | 10022 |
17405 | 17405 | 1971-05-30 | 1971-08-11 | Hackshaw | John M. | Trinidad-Tobago Industrial Development Corporation 1889 | 1965-04-30 | Trinidad-Tobago Industrial Development Corporation | 400 Madison Avenue | New York | NY | 10017 | |
30271 | 30271 | 1992-09-22 | 1992-09-22 | Murphy | John M. | Murphy, John M. 4679 | 1992-06-02 | Murphy, John M. | 110 East 59th Street | Suite 3202 | New York | NY | 10022 |
32793 | 32793 | 1944-10-15 | 1944-04-15 | Franz | John M. | American Members of the Institut de France, Inc. 245 | 1944-04-15 | American Members of the Institut de France, Inc. | Hotel Savoy Plaza | 5th Avenue & 59th Street | New York | NY | |
36432 | 36432 | 1978-11-26 | 1965-02-10 | Anderson | John M. | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | 420 Lexington Avenue | Suite 825 | New York | NY | 10170 |
40339 | 40339 | 1985-12-31 | 1984-11-15 | Eastwood | John M. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
41097 | 41097 | 1998-12-31 | 1998-06-11 | Townsend | John M. | Hughes Hubbard & Reed, LLP 5261 | 1998-06-11 | Hughes Hubbard & Reed, LLP | One Battery Park Plaza | New York | NY | 10004-1482 |
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]) );