FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
413 rows where Registration_Number = 2759 and State = "NY" sorted by Short_Form_Termination_Date descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- NY · 413 ✖
Registration_Number 1
- White & Case, LLP · 413 ✖
Registrant_Name 1
City 1
- New York 413
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12562 | 12562 | 2014-04-01 | 2011-10-31 | Curran | Christopher | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12563 | 12563 | 2014-04-01 | 2011-10-31 | Erb | Nicole | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12564 | 12564 | 2014-04-01 | 2011-10-31 | Leddicotte | Matthew S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12565 | 12565 | 2014-04-01 | 2011-12-21 | Pell | Owen C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41891 | 41891 | 2013-12-31 | 2011-10-31 | Carlisle | Linda E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35021 | 35021 | 2012-11-01 | 2011-12-21 | Asner | Karen M. | 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 | |
12970 | 12970 | 2011-04-08 | 2008-10-02 | Ritcey-Donohue | Joanna | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12548 | 12548 | 2011-04-01 | 2008-10-02 | Lee | Adams C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10268 | 10268 | 2011-03-18 | 2008-10-31 | Delelle | Claire | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
38322 | 38322 | 2010-12-14 | 2003-06-03 | Erb | Nicole | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
38323 | 38323 | 2010-12-14 | 2007-11-05 | Curran | Christopher | 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 | |
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 | |
3985 | 3985 | 2010-01-17 | 2006-05-31 | Al-Louzi | Sami | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35000 | 35000 | 2009-11-01 | 1985-03-01 | Smith | Anne D. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35001 | 35001 | 2009-11-01 | 1981-04-09 | Lamm | Carolyn Beth | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35002 | 35002 | 2009-11-01 | 2008-05-06 | Lanning | Geoffrey B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35003 | 35003 | 2009-11-01 | 2008-05-06 | McCullough | Katherine | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
34583 | 34583 | 2009-10-31 | 2008-05-06 | Nunneley | Devon | 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 | |
13655 | 13655 | 2009-04-17 | 2006-05-31 | McMahon | Nicole | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12537 | 12537 | 2009-04-01 | 1991-04-09 | Cohen (Smutny) | Abby P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12538 | 12538 | 2009-04-01 | 2008-05-06 | Gilbert | Daniel R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12539 | 12539 | 2009-04-01 | 2008-05-06 | Moloo | Rahim | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12540 | 12540 | 2009-04-01 | 2008-05-06 | Steven | Lee A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41617 | 41617 | 2008-12-31 | 1977-03-09 | Amon | Carl H. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
36006 | 36006 | 2008-11-17 | 2008-10-02 | Lederman | Gordon N. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
36007 | 36007 | 2008-11-17 | 2007-11-05 | Francois | Autumn | 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 | |
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 | |
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 | |
12530 | 12530 | 2008-04-01 | 1979-04-20 | Fitzherbert-Brockholes | Francis J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12532 | 12532 | 2008-04-01 | 2006-05-31 | Serran | Erika | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12533 | 12533 | 2008-04-01 | 2003-06-03 | Leddicotte | Matthew | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12534 | 12534 | 2008-04-01 | 2005-07-20 | Clinton | William J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12535 | 12535 | 2008-04-01 | 1987-12-08 | Ellis | Kenneth C. | 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 | |
12526 | 12526 | 2007-04-01 | 2006-05-31 | Mir | Imraan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12527 | 12527 | 2007-04-01 | 1982-10-03 | Wolffe | Leslie R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12528 | 12528 | 2007-04-01 | 1991-10-09 | Miller | Brian M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12529 | 12529 | 2007-04-01 | 1991-10-09 | Smyth | Maureen A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6593 | 6593 | 2007-02-10 | 2005-07-20 | Crosby | Daniel C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5378 | 5378 | 2007-01-31 | 2003-06-03 | Weinacht | Felix | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4111 | 4111 | 2007-01-19 | 2005-12-07 | Al-Sudairi | Salman | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4112 | 4112 | 2007-01-19 | 2005-12-07 | Levine | Judith | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3246 | 3246 | 2007-01-05 | 2004-04-16 | Martinez | Lucy | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
41504 | 41504 | 2006-12-31 | 2006-05-31 | Rune | Gustaf | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
39291 | 39291 | 2006-12-29 | 2003-06-03 | Bekker | Pieter | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
15763 | 15763 | 2006-05-05 | 2006-05-31 | Bisset | Mark | 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]) );