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"
This data as json, CSV (advanced)
State 1
- NY · 313 ✖
Registration_Number 1
- White & Case, LLP · 313 ✖
Registrant_Name 1
City 1
- New York 313
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12008 | 12008 | 2006-03-31 | 2005-12-07 | McGivern | Brendan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12009 | 12009 | 2006-03-31 | 2005-12-07 | Proudian | Kaya | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12010 | 12010 | 2006-03-31 | 1987-12-08 | Alvarez | Pedro A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12476 | 12476 | 1988-04-01 | 1985-03-01 | Rollins | Pamela Lucy | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12481 | 12481 | 1988-04-01 | 1987-12-07 | Lawrence | Gary M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12516 | 12516 | 2003-04-01 | 1980-01-21 | Huber | David L. | 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 | |
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 | |
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 | |
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 | |
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 | |
12847 | 12847 | 2003-04-06 | 2003-08-07 | Grannon | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12848 | 12848 | 2003-04-06 | 2003-09-08 | Grannon | Eric | 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 | |
13387 | 13387 | 1980-04-15 | 1980-04-16 | Lieberman | Michael L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
13393 | 13393 | 1982-04-15 | 1980-03-28 | De Jose | John S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
13443 | 13443 | 1991-04-15 | 1990-04-09 | Banks | Martin K. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
13461 | 13461 | 1994-04-15 | 1992-04-09 | George | Frances H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
13468 | 13468 | 1996-04-15 | 1987-12-08 | de Daruvar | Jean-Charles | 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 | |
13911 | 13911 | 1992-04-22 | 1991-04-09 | Drutman | Evan Michael | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14044 | 14044 | 1991-04-24 | 1985-07-08 | Crane | David W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14340 | 14340 | 1988-04-29 | 1982-10-08 | Speers | John Gorham | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14529 | 14529 | 1982-04-30 | 1980-01-24 | Toms | Bate Carpenter , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14556 | 14556 | 1985-04-30 | 1980-03-28 | Wolfe | Edward | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14557 | 14557 | 1985-04-30 | 1979-04-20 | Branson | David J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14575 | 14575 | 1987-04-30 | 1985-07-08 | Bedos | Jean-Luc | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14712 | 14712 | 1996-04-30 | 1990-10-10 | Cohen | Gad J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
14945 | 14945 | 2006-04-30 | 2005-11-15 | Bridgland | Nicholas | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
15381 | 15381 | 1986-05-01 | 1985-10-09 | de Achaval | Alejandro Martin | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
15384 | 15384 | 1987-05-01 | 1985-03-01 | Sussman | Edna R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
15425 | 15425 | 1990-05-01 | 1989-10-10 | Goueff | Stephan Le | 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 | |
15853 | 15853 | 2004-05-07 | 2003-06-03 | Clark | Jonathan | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
15937 | 15937 | 1998-05-08 | 1982-10-08 | Rosenberg | Marianne | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16251 | 16251 | 1983-05-13 | 1980-03-28 | Dimond | Diane | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16381 | 16381 | 1980-05-15 | 1980-03-28 | Nicely | Patricia A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16391 | 16391 | 1985-05-15 | 1983-04-08 | Wallace | Richard E. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16393 | 16393 | 1985-05-15 | 1981-10-13 | Cadet | Marie | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16426 | 16426 | 1994-05-15 | 1980-04-16 | Reed | John G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16693 | 16693 | 1989-05-19 | 1981-04-09 | Wilson | R. Bradley | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16700 | 16700 | 1995-05-19 | 1991-04-09 | Hunt | Joseph H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16825 | 16825 | 1991-05-21 | 1991-04-09 | Grassi | Paolo S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16869 | 16869 | 1984-05-22 | 1982-11-26 | Johnson | Andrea L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16885 | 16885 | 1991-05-22 | 1989-10-10 | Procida | Mary A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16907 | 16907 | 2001-05-22 | 1987-12-08 | Giustini | Anthony | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
16944 | 16944 | 1980-05-23 | 1980-04-16 | Lehner | George A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17021 | 17021 | 1991-05-24 | 1980-04-16 | Laughlin | James P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17183 | 17183 | 1988-05-26 | 1988-04-08 | Burchett | Michelle P. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17346 | 17346 | 1987-05-29 | 1986-04-09 | Tapolsky | Bruno A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17698 | 17698 | 1986-05-31 | 1980-03-28 | Ramseur | Thomas M. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17709 | 17709 | 1988-05-31 | 1984-04-09 | Smith | Rebecca C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17733 | 17733 | 1990-05-31 | 1987-12-08 | Follie | Robert | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17755 | 17755 | 1991-05-31 | 1987-12-08 | Dietze | David G. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17770 | 17770 | 1994-05-31 | 1992-06-17 | Stephens | Cori | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
18901 | 18901 | 1981-06-05 | 1980-04-16 | Henry | James R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19307 | 19307 | 2003-06-12 | 2003-06-03 | Vetrano | Donna | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19529 | 19529 | 1982-06-15 | 1980-04-16 | James | Raymond C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19534 | 19534 | 1984-06-15 | 1980-01-21 | Kearns | John J. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19562 | 19562 | 1990-06-15 | 1985-10-09 | Yost | John A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19706 | 19706 | 2004-06-16 | 1992-06-17 | Pande | Raj | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19746 | 19746 | 1983-06-17 | 1980-01-21 | Kennedy | Paul L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
19765 | 19765 | 1994-06-17 | 1991-10-09 | Ragazzi | Maurizio | 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 | |
20425 | 20425 | 1985-06-28 | 1984-04-09 | Hammer | William P. , Jr. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
20927 | 20927 | 1978-06-30 | 1977-03-09 | Rassweiler | James C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
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 |
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]) );