FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where City = "New York", Short_Form_Date = "1984-09-18" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4025 | 4025 | 1988-01-18 | 1984-09-18 | Rose | Joanne W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5748 | 5748 | 1985-02-01 | 1984-09-18 | Shaffer | Stefan L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6940 | 6940 | 1985-02-15 | 1984-09-18 | Berger | Robert Glenn | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
7292 | 7292 | 1987-02-20 | 1984-09-18 | Clarke | Jennifer R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11150 | 11150 | 1990-03-30 | 1984-09-18 | Dunetz | Jeffrey L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11989 | 11989 | 2006-03-31 | 1984-09-18 | Hayden | James F. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
20044 | 20044 | 2001-06-22 | 1984-09-18 | Munson | Elizabeth P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21063 | 21063 | 1986-06-30 | 1984-09-18 | Grace | Manuel G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
22596 | 22596 | 1988-07-05 | 1984-09-18 | Das | Kalyan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
24771 | 24771 | 1988-07-31 | 1984-09-18 | Wetter | J. Gillis | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26495 | 26495 | 1986-08-12 | 1984-09-18 | Jenney | Frederick E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26879 | 26879 | 1990-08-17 | 1984-09-18 | Randolph | Lloyd H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32003 | 32003 | 2006-10-01 | 1984-09-18 | Pell | Owen C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32004 | 32004 | 2006-10-01 | 1984-09-18 | Verrier | Hugh | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32156 | 32156 | 1987-10-02 | 1984-09-18 | Lawrie | Robert F.C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32519 | 32519 | 1992-10-09 | 1984-09-18 | Knake | P.B. Konrad | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35364 | 35364 | 1986-11-07 | 1984-09-18 | Maguire | J. Robert | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35668 | 35668 | 1993-11-12 | 1984-09-18 | Fain | T. Scott | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
37921 | 37921 | 1995-12-08 | 1984-09-18 | Morrow | Robert J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
38866 | 38866 | 1988-12-21 | 1984-09-18 | Cox | Judith S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41106 | 41106 | 1998-12-31 | 1984-09-18 | Rooney | Paul C. , Jr. | 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]) );