FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
413 rows where Registration_Number = 2759 sorted by Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
11977 | 11977 | 2006-03-31 | 2006-05-31 | Eriksson | Andreas | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11978 | 11978 | 2006-03-31 | 2006-05-31 | Escuder | Jeffrey | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
5990 | 5990 | 2006-02-02 | 2005-12-07 | Gay | Faith | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
10532 | 10532 | 2006-03-22 | 2005-12-07 | Zeidan | Isabelle | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12007 | 12007 | 2006-03-31 | 2005-12-07 | Johnsson | Bengt Ake | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
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 | |
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 | |
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 | |
12004 | 12004 | 2006-03-31 | 2005-11-15 | Marx | Joseph | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
9583 | 9583 | 2006-03-10 | 2005-04-14 | Yap | Justin | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11970 | 11970 | 2006-03-31 | 2005-04-14 | Katcherian | Amy L. | 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 | |
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 | |
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 | |
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 | |
9066 | 9066 | 2006-03-03 | 2004-10-13 | Dickson | Natalie | 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 | |
36933 | 36933 | 2005-11-30 | 2004-10-13 | Borg | Guillaume | 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 | |
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 | |
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 | |
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 | |
12006 | 12006 | 2006-03-31 | 2003-12-02 | Le Corre | Jean-Francois | 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 | |
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 | |
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 | |
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 | |
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 | |
11979 | 11979 | 2006-03-31 | 2003-06-03 | Von Oppen | Matthias | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]) );