FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1992-01-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_2, Zip, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5096 | 5096 | 1992-01-31 | 1992-01-21 | Genge | W. Dean | Merkley Newman Harty 4525 | 1991-06-04 | Merkley Newman Harty | 200 Varick Street | New York | NY | 10014 | |
5097 | 5097 | 1992-01-31 | 1992-01-24 | Willis | Raymond | Kirghizstan International, Inc. 4607 | 1992-01-14 | Kirghizstan International, Inc. | 192 East 75th Street | New York | NY | 10021 | |
5103 | 5103 | 1992-01-31 | 1991-06-10 | McBride | Kelly | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | 14 East 60th Street | New York | NY | 10022 | |
5107 | 5107 | 1992-01-31 | 1990-08-03 | Eisenstat | Susan | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
5108 | 5108 | 1992-01-31 | 1991-08-06 | Chamberlin | Susan | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | 285 Madison Avenue | New York | NY | 100176486 | |
5109 | 5109 | 1992-01-31 | 1991-08-06 | Giannone | Dorothy D. | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | 285 Madison Avenue | New York | NY | 100176486 | |
5110 | 5110 | 1992-01-31 | 1991-08-06 | Lowe | James Scott | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | 285 Madison Avenue | New York | NY | 100176486 | |
5111 | 5111 | 1992-01-31 | 1991-08-06 | Nicholson | Lori L. | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | 285 Madison Avenue | New York | NY | 100176486 | |
5112 | 5112 | 1992-01-31 | 1991-08-06 | Tumprosky | Ira B. | Young & Rubicam, New York 4554 | 1991-08-06 | Young & Rubicam, New York | 285 Madison Avenue | New York | NY | 100176486 | |
5116 | 5116 | 1992-01-31 | 1987-10-13 | Kreindler | Richard H. | 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]) );