FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where City = "New York" and Short_Form_First_Name = "Morris"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5473 | 5473 | 2013-01-31 | 1980-07-15 | Silver | Morris | M. Silver Associates, Inc. 3131 | 1980-07-15 | M. Silver Associates, Inc. | 747 Third Avenue, 23rd Floor | New York | NY | 10017-2803 | |
15415 | 15415 | 1989-05-01 | 1966-11-17 | Semmel | Morris | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
17279 | 17279 | 1976-05-28 | 1970-06-10 | Silver | Morris | M. Silver Associates, Inc. 2200 | 1970-06-10 | M. Silver Associates, Inc. | 360 Lexington Avenue | New York | NY | 10017 | |
19147 | 19147 | 1976-06-10 | 1975-09-04 | Hirsch | Morris | Republic National Bank of New York 2604 | 1975-09-04 | Republic National Bank of New York | 452 Fifth Avenue | New York | NY | 10018 | |
20335 | 20335 | 1952-06-27 | 1952-03-17 | Relin | Morris | Bernard Relin Associates 359 | 1946-05-27 | Bernard Relin Associates | 654 Madison Avenue | New York | NY | ||
31546 | 31546 | 2013-09-30 | 2013-04-25 | Silver | Morris | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
40079 | 40079 | 1978-12-31 | 1964-10-01 | Zucker | Morris | Eastern News Distributors, Inc. 1796 | 1964-10-01 | Eastern News Distributors, Inc. | 111 Eighth Avenue | New York | NY | 10011 |
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]) );