FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where City = "New York", Registrant_Name = "White & Case, LLP", Registration_Number = 2759, "Short_Form_Termination_Date" is on date 2006-10-01 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- NY · 40 ✖
Registration_Number 1
- White & Case, LLP · 40 ✖
Registrant_Name 1
- White & Case, LLP · 40 ✖
City 1
- New York · 40 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31981 | 31981 | 2006-10-01 | 1980-03-28 | Goodwillie | Eugene W. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31982 | 31982 | 2006-10-01 | 1980-03-28 | Higgins | Thomas P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31983 | 31983 | 2006-10-01 | 1980-03-28 | Peigney | Gilles | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31984 | 31984 | 2006-10-01 | 1990-04-09 | Washenko | Jeffrey A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31985 | 31985 | 2006-10-01 | 1990-04-09 | Willems | John S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31986 | 31986 | 2006-10-01 | 2005-04-14 | Garner | Robert L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31987 | 31987 | 2006-10-01 | 2004-04-16 | Relden | Anders | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31988 | 31988 | 2006-10-01 | 2006-05-31 | Blakemore | J. Haywood | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31989 | 31989 | 2006-10-01 | 2006-05-31 | Ebaugh | Stefan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31990 | 31990 | 2006-10-01 | 2006-05-31 | Grenley | Neal | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31991 | 31991 | 2006-10-01 | 2006-05-31 | Huston | Jane Louise | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31992 | 31992 | 2006-10-01 | 2006-05-31 | Keller | Edward | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31993 | 31993 | 2006-10-01 | 2006-05-31 | Kritzalis | Alexander | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31994 | 31994 | 2006-10-01 | 2006-05-31 | Leibowitz | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31995 | 31995 | 2006-10-01 | 2006-05-31 | Lincicome | Scott | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31996 | 31996 | 2006-10-01 | 2006-05-31 | Rakower | Sali | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31997 | 31997 | 2006-10-01 | 2006-05-31 | Terblanche | Villiers | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31998 | 31998 | 2006-10-01 | 2006-05-31 | Tonova | Sylvia | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31999 | 31999 | 2006-10-01 | 2006-05-31 | Wang | Xiaogang | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32000 | 32000 | 2006-10-01 | 2003-06-03 | Metais | Philip | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32001 | 32001 | 2006-10-01 | 2003-06-03 | Panopoulos | Frank | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32002 | 32002 | 2006-10-01 | 1985-07-08 | Basgoz | Asli F. | 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 | |
32005 | 32005 | 2006-10-01 | 1991-10-09 | Dammann | Reinhard | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32006 | 32006 | 2006-10-01 | 1989-10-10 | Rust | Neil | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32007 | 32007 | 2006-10-01 | 1990-10-10 | Seppala | Christopher R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32008 | 32008 | 2006-10-01 | 1981-10-13 | Stopford | Henry Philip Terence | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32009 | 32009 | 2006-10-01 | 2004-10-13 | Avery | Alan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32010 | 32010 | 2006-10-01 | 2004-10-13 | Barnard | Kevin F. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32011 | 32011 | 2006-10-01 | 2004-10-13 | Friedland | Paul | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32012 | 32012 | 2006-10-01 | 1978-11-09 | Crozer | George K. , IV | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32013 | 32013 | 2006-10-01 | 2005-11-15 | Collins | Christopher | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32014 | 32014 | 2006-10-01 | 2003-12-02 | Hamilton | Jonathan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32015 | 32015 | 2006-10-01 | 2003-12-02 | Lau | Lucius | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32016 | 32016 | 2006-10-01 | 2005-12-07 | FitzPatrick Jr. | Vincent R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32017 | 32017 | 2006-10-01 | 2005-12-07 | Goldstein | David | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32018 | 32018 | 2006-10-01 | 2005-12-07 | Grannon | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32019 | 32019 | 2006-10-01 | 2005-12-07 | Hammond | Andrew | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32020 | 32020 | 2006-10-01 | 2005-12-07 | Kass | Jonathan | 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]) );