FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
413 rows where City = "New York" and Registration_Number = 2759
This data as json, CSV (advanced)
State 1
- NY 166
Registration_Number 1
- White & Case, LLP · 166 ✖
Registrant_Name 1
City 1
- New York · 166 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29040 | 29040 | 2005-09-02 | 1980-01-21 | Dreizen | Alison M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29041 | 29041 | 2005-09-02 | 1977-03-09 | Wall | Duane D. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29042 | 29042 | 2005-09-02 | 1980-03-28 | Blakemore | John Haywood , IV | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29043 | 29043 | 2005-09-02 | 1980-03-28 | Chin | Sylvia Fung | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29044 | 29044 | 2005-09-02 | 1980-03-28 | MacNaughton | Donald T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29045 | 29045 | 2005-09-02 | 1980-03-28 | McGanney | Thomas | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29046 | 29046 | 2005-09-02 | 1980-03-28 | Wynne | William F. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29047 | 29047 | 2005-09-02 | 1981-04-09 | Finlay | Peter D. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29048 | 29048 | 2005-09-02 | 1985-04-09 | Koschik | David N. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29049 | 29049 | 2005-09-02 | 1985-04-09 | Scavone | Arthur A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29050 | 29050 | 2005-09-02 | 1986-04-09 | Bender | David | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29051 | 29051 | 2005-09-02 | 1986-04-09 | Hartline | Sharon E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29052 | 29052 | 2005-09-02 | 1990-04-09 | Dang | Khai-Minh | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29053 | 29053 | 2005-09-02 | 1991-04-09 | Gannon | Lawrence J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29054 | 29054 | 2005-09-02 | 1992-04-09 | Warren | Sandra J. (Schecter) | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29055 | 29055 | 2005-09-02 | 2005-04-14 | Byrne | Lawrence | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29056 | 29056 | 2005-09-02 | 2004-04-16 | Miller | Amanda Johnson | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29057 | 29057 | 2005-09-02 | 1978-05-02 | Riggs | John H. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29058 | 29058 | 2005-09-02 | 2003-06-03 | Smith | Michael | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29059 | 29059 | 2005-09-02 | 2003-06-03 | Teck | Lim Sin | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29060 | 29060 | 2005-09-02 | 1992-06-17 | Takayama | Ichizo | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29061 | 29061 | 2005-09-02 | 1982-10-01 | Kelly | Robert M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29062 | 29062 | 2005-09-02 | 1983-10-07 | Joyce | David E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29063 | 29063 | 2005-09-02 | 1991-10-09 | Brundage | Maureen A. (Smyth) | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29064 | 29064 | 2005-09-02 | 2003-12-02 | Nyatanyi | Gilbert | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29102 | 29102 | 1982-09-03 | 1979-04-20 | Hodgdon | Timothy F. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29120 | 29120 | 2004-09-03 | 1992-04-09 | Goodman | Ronald E.M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29525 | 29525 | 1988-09-10 | 1986-04-09 | Wenzlaff | Elisabet | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29533 | 29533 | 2002-09-10 | 1980-03-28 | Baron | Martin L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29534 | 29534 | 2002-09-10 | 1979-04-20 | Cousins | Janice E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29535 | 29535 | 2002-09-10 | 1985-07-08 | Ley | Kathleen A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
29536 | 29536 | 2002-09-10 | 1983-10-28 | Fenster | Lawrence Elliott | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
30279 | 30279 | 2006-09-22 | 2005-12-07 | Sigrist | Mark | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
30671 | 30671 | 1979-09-28 | 1979-01-24 | Bergdall | Thomas W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
30686 | 30686 | 1990-09-28 | 1980-03-28 | Demos | Emanuel G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
30745 | 30745 | 1994-09-29 | 1990-04-09 | Morowitz | Deborah | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
30758 | 30758 | 2000-09-29 | 1986-04-09 | Gropper | Allan L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
30763 | 30763 | 2006-09-29 | 1990-04-09 | Narducci | John | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
30973 | 30973 | 1985-09-30 | 1980-03-28 | Halliday | Joseph W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31002 | 31002 | 1987-09-30 | 1986-04-09 | Noronha | Sirikit M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31016 | 31016 | 1988-09-30 | 1980-03-28 | Sachs | David | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31113 | 31113 | 1994-09-30 | 1990-10-10 | Haroules | Beth | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
31975 | 31975 | 2005-10-01 | 2005-04-14 | Fitzgerald | Joy A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
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 | |
32025 | 32025 | 2008-10-01 | 1983-10-07 | Maddrey | Wendell C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32039 | 32039 | 2010-10-01 | 2007-10-26 | Carlisle | Linda E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32051 | 32051 | 2012-10-01 | 2012-04-30 | Lanning | Geoffrey | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32055 | 32055 | 2012-10-01 | 2011-10-31 | Gover | Alan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32056 | 32056 | 2012-10-01 | 2011-10-31 | Kampfner | Roberto J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32057 | 32057 | 2012-10-01 | 2011-10-31 | Mackintosh | Andrew C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32058 | 32058 | 2012-10-01 | 2011-10-31 | Sequeria | Reuben | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32059 | 32059 | 2012-10-01 | 2011-10-31 | Silverbrand | Ian | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32155 | 32155 | 1987-10-02 | 1984-04-09 | Greene | David G. | 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 | |
32466 | 32466 | 1993-10-08 | 1987-10-13 | Mack | Kathryn S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32512 | 32512 | 1992-10-09 | 1980-01-21 | Epley | Marion J. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32513 | 32513 | 1992-10-09 | 1980-03-28 | Swanson | David W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32514 | 32514 | 1992-10-09 | 1989-04-07 | Bocciarelli | Rosann | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32515 | 32515 | 1992-10-09 | 1980-04-16 | Hedges | Philip H. | 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 | |
32520 | 32520 | 1992-10-09 | 1980-10-14 | Wilkinson | Donald M. , 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]) );