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_Termination_Date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40441 | 40441 | 1987-12-31 | 1985-10-09 | Carr | Cynthia | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
2663 | 2663 | 1988-01-01 | 1977-03-09 | Fales | Haliburton , II | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3405 | 3405 | 1988-01-08 | 1980-04-16 | Buck | Bruce M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4025 | 4025 | 1988-01-18 | 1984-09-18 | Rose | Joanne W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4749 | 4749 | 1988-01-29 | 1985-03-01 | Brizzi | Barbara C. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9829 | 9829 | 1988-03-14 | 1982-04-09 | Dodson | Mary Jane | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
35212 | 35212 | 1988-11-04 | 1985-03-01 | Saavedra-Castro | Juan H. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
36712 | 36712 | 1988-11-30 | 1986-10-09 | Doyle | Margaret M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
38866 | 38866 | 1988-12-21 | 1984-09-18 | Cox | Judith S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
39393 | 39393 | 1988-12-30 | 1983-10-07 | Tschanz | Pierre-Yves | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5040 | 5040 | 1989-01-31 | 1985-10-09 | Hackney | James V. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9028 | 9028 | 1989-03-03 | 1987-12-08 | Fiszer | George A. | 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 | |
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 | |
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 | |
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 | |
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 | |
34300 | 34300 | 1989-10-31 | 1987-12-08 | Gogek | Daniel | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4466 | 4466 | 1990-01-25 | 1987-12-08 | Ambrose | Kathleen A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
6946 | 6946 | 1990-02-15 | 1988-10-07 | Boisseuain | Benjamin M. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
9520 | 9520 | 1990-03-09 | 1988-10-07 | Seaver | Christopher B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11141 | 11141 | 1990-03-30 | 1984-04-09 | Richardson | George O. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11150 | 11150 | 1990-03-30 | 1984-09-18 | Dunetz | Jeffrey L. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
35756 | 35756 | 1990-11-14 | 1986-04-09 | Dailey | Carolyn D. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
38872 | 38872 | 1990-12-21 | 1987-12-07 | Larsen | Clifford R. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5094 | 5094 | 1991-01-31 | 1983-10-07 | Zeifer | F. Ellen | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
36116 | 36116 | 1991-11-20 | 1986-04-09 | Bumsted | David W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
39009 | 39009 | 1991-12-23 | 1989-10-10 | Couch | C. Deryl | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40679 | 40679 | 1991-12-31 | 1990-04-09 | Obeidat | Thamer A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40719 | 40719 | 1991-12-31 | 1988-10-07 | Chauvet | Isabelle | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
2714 | 2714 | 1992-01-01 | 1980-03-28 | Hopkins | Thomas A. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4755 | 4755 | 1992-01-29 | 1990-04-09 | Wang | Danchi | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
5116 | 5116 | 1992-01-31 | 1987-10-13 | Kreindler | Richard H. | 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 | |
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 | |
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 | |
33495 | 33495 | 1992-10-23 | 1986-04-09 | Wisner | Douglas L. | 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 | |
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 | |
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 | |
35304 | 35304 | 1993-11-05 | 1991-04-09 | Rasenberger | Mary E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35668 | 35668 | 1993-11-12 | 1984-09-18 | Fain | T. Scott | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40768 | 40768 | 1993-12-31 | 1987-12-08 | Bonsal | Julia L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3365 | 3365 | 1994-01-07 | 1983-10-07 | Jump | Alice | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3970 | 3970 | 1994-01-17 | 1986-04-09 | Hober | Kaj | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
4222 | 4222 | 1994-01-21 | 1992-04-09 | Foster | Eric L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11059 | 11059 | 1994-03-29 | 1992-04-09 | Bahlke | Conrad G. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
40770 | 40770 | 1994-12-31 | 1980-01-21 | McNally | John J. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40780 | 40780 | 1994-12-31 | 1980-03-28 | Barnum | John W. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
40781 | 40781 | 1994-12-31 | 1980-03-28 | Moskin | Morton | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
3666 | 3666 | 1995-01-13 | 1990-10-10 | Redfern | William A. , III | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
7388 | 7388 | 1995-02-22 | 1989-04-07 | Varanese | James B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
7542 | 7542 | 1995-02-24 | 1990-04-09 | Haft | William S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8018 | 8018 | 1995-02-28 | 1984-04-09 | Sypher | Richard B. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
8019 | 8019 | 1995-02-28 | 1980-04-16 | Davis | Ronald 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]) );