FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
413 rows where Registrant_Name = "White & Case, LLP"
This data as json, CSV (advanced)
State 1
- NY 234
Registration_Number 1
Registrant_Name 1
- White & Case, LLP · 234 ✖
City 1
- New York 234
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20991 | 20991 | 1983-06-30 | 1980-01-21 | Appert | Richard H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21052 | 21052 | 1986-06-30 | 1986-04-09 | Sacklen | Mats A. | 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 | |
21065 | 21065 | 1986-06-30 | 1983-10-07 | Hazlitt | Elizabeth M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21181 | 21181 | 1993-06-30 | 1980-03-28 | Ryan | Burton T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21183 | 21183 | 1993-06-30 | 1991-04-09 | Baker | Audrey H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21189 | 21189 | 1993-06-30 | 1989-10-10 | Wilson | Kathleen Isabella | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21190 | 21190 | 1993-06-30 | 1990-10-10 | Hanchet | Markham G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21191 | 21191 | 1993-06-30 | 1990-10-10 | Schwartz | Larry W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21201 | 21201 | 1994-06-30 | 1983-05-31 | Provine | John C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21209 | 21209 | 1994-06-30 | 1985-10-09 | Mazzaferro | Donna M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21214 | 21214 | 1995-06-30 | 1988-04-08 | Harder | Stephen | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21293 | 21293 | 1998-06-30 | 1980-03-28 | Mitchell | Clyde | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21348 | 21348 | 2000-06-30 | 1980-01-21 | Wales | Gwynne H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21352 | 21352 | 2000-06-30 | 1980-03-28 | Lorotte | Rosine | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
21675 | 21675 | 2010-06-30 | 2005-11-15 | Sutton | Alastair | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
22289 | 22289 | 2000-07-01 | 1997-10-24 | Garcia-Bello | Ana | 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 | |
22598 | 22598 | 1989-07-05 | 1985-10-09 | Wells | Linda A | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
22697 | 22697 | 1989-07-07 | 1986-04-09 | Gallegos | Gabrielle G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
22784 | 22784 | 1996-07-08 | 1986-04-09 | Smith | Ellen W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
22835 | 22835 | 1982-07-09 | 1980-01-21 | Lindsay | George P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
22971 | 22971 | 1997-07-11 | 1991-04-09 | Caradet | Bererand | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
22976 | 22976 | 2008-07-11 | 1992-04-09 | Wesol | Brian J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
23007 | 23007 | 1985-07-12 | 1979-01-24 | Higginson | Thomas L. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
23046 | 23046 | 1990-07-13 | 1980-03-28 | Murphy | Margaret | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
23258 | 23258 | 1991-07-15 | 1988-04-08 | White | Kathleen M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
23297 | 23297 | 2003-07-15 | 2003-06-03 | Robertson | Grant | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
23961 | 23961 | 1987-07-24 | 1984-04-09 | Fenster | Lawrence E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
24078 | 24078 | 1985-07-26 | 1980-03-28 | Dempsey | Guy C. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
24299 | 24299 | 1989-07-28 | 1985-10-09 | Hinely | Susan D. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
24374 | 24374 | 1994-07-29 | 1980-03-28 | Friedman | Paul L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
24730 | 24730 | 1983-07-31 | 1982-11-26 | Abecassis | Cyril | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
24731 | 24731 | 1983-07-31 | 1982-11-26 | Cyril | Abecassis | 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 | |
24821 | 24821 | 1991-07-31 | 1990-04-09 | Gesualdi | James F. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
25534 | 25534 | 1985-08-01 | 1983-04-08 | Herbert | John Kingston , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
25545 | 25545 | 1986-08-01 | 1982-10-08 | Graham | Jennifer F | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
25889 | 25889 | 2004-08-03 | 2003-06-03 | Moayery | Sheedeh | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26107 | 26107 | 1993-08-06 | 1989-04-07 | Tanner | Greg A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26161 | 26161 | 1985-08-07 | 1982-10-08 | Doudguih | Augustin | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26266 | 26266 | 1989-08-08 | 1985-04-09 | Rickard | Stephen A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26446 | 26446 | 1989-08-11 | 1982-04-09 | Tupman | W. Michael | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26461 | 26461 | 2006-08-11 | 2005-04-14 | Hagenson | Michael E. | 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 | |
26591 | 26591 | 1981-08-14 | 1980-01-21 | McAnaney | Brian T. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26717 | 26717 | 1985-08-15 | 1983-10-07 | Bigbie | Astrid | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26748 | 26748 | 1996-08-15 | 1986-10-09 | Kahn | Caroline | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
26831 | 26831 | 1991-08-16 | 1988-10-07 | Cohen | Lawrence | 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 | |
27046 | 27046 | 1982-08-20 | 1980-03-28 | Erich | Janice E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27081 | 27081 | 2004-08-20 | 2003-06-03 | Studenny | Eva | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27108 | 27108 | 1978-08-21 | 1977-03-09 | Lundy | A. Lee , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27360 | 27360 | 2007-08-24 | 2007-05-09 | Patel | Ameeta K. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27530 | 27530 | 2008-08-27 | 2004-04-16 | Soares | Antonia | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27582 | 27582 | 1987-08-28 | 1986-04-09 | Landman | David | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27695 | 27695 | 1980-08-29 | 1980-03-28 | Peters | Elizabeth | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27760 | 27760 | 1984-08-30 | 1982-10-08 | Lescure | Paige | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
27810 | 27810 | 2006-08-30 | 2006-05-31 | Orr | Stephen | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28059 | 28059 | 1983-08-31 | 1980-01-21 | Ismael | Bruce K. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28069 | 28069 | 1984-08-31 | 1980-03-28 | Prior | Michael J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28131 | 28131 | 1988-08-31 | 1987-12-08 | Shea | Barbara S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28137 | 28137 | 1989-08-31 | 1978-04-10 | Vickers | Raymond W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28212 | 28212 | 1992-08-31 | 1982-10-08 | Bedke | Kathryn L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28258 | 28258 | 1995-08-31 | 1979-01-24 | McAvoy | John J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28488 | 28488 | 2006-08-31 | 2005-11-15 | Prados | Javier | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28538 | 28538 | 2009-08-31 | 2003-06-03 | Rooney | Kim | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
28932 | 28932 | 2004-09-01 | 1991-04-09 | Eisenberg | David M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
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 |
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]) );