FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
273 rows where Registration_Number = 3712 sorted by Short_Form_Termination_Date descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Registration_Date (date)
State 1
- DC 273
Registration_Number 1
- DLA Piper US LLP · 273 ✖
Registrant_Name 1
- DLA Piper US LLP 273
City 1
- Washington 273
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8436 | 8436 | 2023-02-28 | 2023-02-22 | Audia | Benedetta | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8437 | 8437 | 2023-02-28 | 2023-02-22 | Frimpong | Naana | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8438 | 8438 | 2023-02-28 | 2014-05-20 | Newcomb | Robert Richard | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8439 | 8439 | 2023-02-28 | 2021-08-10 | Peyman | David | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32299 | 32299 | 2022-10-04 | 2018-10-26 | Jebeyli | Stephanie | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
42413 | 42413 | 2021-12-31 | 1995-11-16 | Levinson | Lawrence E. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
37185 | 37185 | 2021-11-30 | 2006-05-04 | Salem | George Richard | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
35600 | 35600 | 2021-11-10 | 2021-09-30 | Gately | Mary | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28706 | 28706 | 2021-08-31 | 2021-09-30 | Samra | Harout | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8412 | 8412 | 2021-02-28 | 2020-03-11 | Penhoet | Braden | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8414 | 8414 | 2021-02-28 | 1995-06-02 | Merrigan | John A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8419 | 8419 | 2021-02-28 | 2006-12-08 | Bernstein | Matthew | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
33037 | 33037 | 2020-10-16 | 2015-03-12 | Stern | Rochelle Eva | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28684 | 28684 | 2020-08-31 | 2015-03-12 | Schaefermeier | Martin | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
12606 | 12606 | 2020-04-01 | 2016-11-22 | Woolley | Jessica S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8592 | 8592 | 2020-02-29 | 2016-09-07 | Simon | Anthony | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32422 | 32422 | 2019-10-07 | 2001-02-22 | Sanchez | Ignacio | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32423 | 32423 | 2019-10-07 | 2018-09-28 | Korologos | Tom C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28989 | 28989 | 2019-09-01 | 2012-11-07 | Garcia | Melanie | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18214 | 18214 | 2019-05-31 | 2013-03-28 | Castle | Michael | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
3208 | 3208 | 2019-01-04 | 2018-09-30 | Kierig | Anne | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
22371 | 22371 | 2018-07-01 | 2016-09-30 | Reardon | James | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18590 | 18590 | 2018-06-01 | 2011-09-29 | Donovan | Sarah | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18204 | 18204 | 2018-05-31 | 2017-08-21 | Dove | Caroline | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18205 | 18205 | 2018-05-31 | 2017-08-21 | Footlik | Jay K. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
15101 | 15101 | 2018-04-30 | 2018-03-06 | Smotkin | Richard | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
15124 | 15124 | 2018-04-30 | 2015-03-31 | Boyd | Thomas | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28986 | 28986 | 2017-09-01 | 2016-11-04 | Simmons | Joseph | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
19126 | 19126 | 2017-06-09 | 2017-05-18 | Halpert | James | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
14305 | 14305 | 2017-04-28 | 2017-01-27 | Leahy | Wynne | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2994 | 2994 | 2017-01-01 | 2016-08-26 | Migdail | Evan | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32073 | 32073 | 2016-10-01 | 2010-03-29 | Woolley | Jessica S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28981 | 28981 | 2016-09-01 | 2015-09-03 | Forgie | Anna | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
15085 | 15085 | 2016-04-30 | 2015-12-07 | Infante | Emil | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
15086 | 15086 | 2016-04-30 | 2015-12-07 | Samra | Harout Jack | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
22658 | 22658 | 2015-07-06 | 2014-10-08 | Prevas | Thomas | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28597 | 28597 | 2014-08-31 | 2014-05-20 | Daya | Christine | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
31552 | 31552 | 2013-09-30 | 2013-09-30 | Adams | Earl | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25188 | 25188 | 2013-07-31 | 2013-05-23 | Granwell | Alan Winston | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25189 | 25189 | 2013-07-31 | 2013-05-23 | Jurewicz | Witold | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
23684 | 23684 | 2013-07-20 | 2012-09-27 | Pickup | James | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
10990 | 10990 | 2013-03-28 | 2011-09-29 | Schwanke | Beth | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8890 | 8890 | 2013-03-01 | 2000-09-05 | Loud | Edward P. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8265 | 8265 | 2013-02-28 | 2010-10-14 | Baker III | Charles A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
16911 | 16911 | 2012-05-22 | 2012-01-30 | Rodriguez | Ilia | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4182 | 4182 | 2012-01-20 | 2006-11-20 | O'Scannlain | Kevin | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
41774 | 41774 | 2011-12-31 | 1998-07-13 | Meister | Brenda G. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29904 | 29904 | 2010-09-15 | 2002-02-04 | Weiss | David A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29905 | 29905 | 2010-09-15 | 2009-04-14 | Blanchard | James J. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29906 | 29906 | 2010-09-15 | 2009-04-14 | Minor | William | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29907 | 29907 | 2010-09-15 | 2009-04-14 | Shimberg | Steven | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8879 | 8879 | 2010-03-01 | 1998-01-06 | McPherson | Harry C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8882 | 8882 | 2010-03-01 | 2010-03-29 | Jones | Lisa L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
41661 | 41661 | 2009-12-31 | 2007-05-29 | LaBrache | Lisa | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
35007 | 35007 | 2009-11-01 | 2006-12-08 | Keller | Jill Rebecca | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32027 | 32027 | 2009-10-01 | 2003-03-10 | Migdail | Evan M. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32033 | 32033 | 2009-10-01 | 2008-11-12 | Carelli | Nicole | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28961 | 28961 | 2009-09-01 | 2006-05-04 | Klein | Gary J. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28964 | 28964 | 2009-09-01 | 2007-11-02 | Baker III | Charles | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28532 | 28532 | 2009-08-31 | 2009-04-03 | Christy | David S | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28533 | 28533 | 2009-08-31 | 2009-04-03 | Parlin | C. Christopher | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
27605 | 27605 | 2009-08-28 | 2007-06-11 | Campbell | Jean L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
27609 | 27609 | 2009-08-28 | 2006-11-20 | Antelo | Cristina | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
26636 | 26636 | 2009-08-14 | 2004-01-28 | Armey | Richard K. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
14377 | 14377 | 2009-04-29 | 2007-11-02 | Koloski | Metodija A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4283 | 4283 | 2009-01-22 | 2008-07-15 | Jones | Lisa L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4285 | 4285 | 2009-01-22 | 2006-07-19 | Gephardt | Richard | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4286 | 4286 | 2009-01-22 | 2007-08-09 | Borland | Lydia | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4288 | 4288 | 2009-01-22 | 2000-09-05 | Pickup | James A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4289 | 4289 | 2009-01-22 | 2008-10-10 | Maksad | Firas | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4290 | 4290 | 2009-01-22 | 2007-11-02 | Abrams | Kristen Leanderson | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
38693 | 38693 | 2008-12-18 | 2007-06-11 | Gans | Kiera S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
38695 | 38695 | 2008-12-18 | 2007-10-12 | Hepworth | Michael R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
38696 | 38696 | 2008-12-18 | 2006-11-20 | Coles | Anthony | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
38697 | 38697 | 2008-12-18 | 2006-11-20 | Finnerty III | Joseph G. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
38698 | 38698 | 2008-12-18 | 2006-11-20 | Land | Christopher C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
38699 | 38699 | 2008-12-18 | 2006-11-20 | Sharp | Peter D. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
38700 | 38700 | 2008-12-18 | 2006-11-20 | Wenger | David S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
36005 | 36005 | 2008-11-17 | 2003-03-14 | Genser | Jared | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
35729 | 35729 | 2008-11-13 | 2007-07-18 | Krantz | Sheldon | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
35730 | 35730 | 2008-11-13 | 1985-08-05 | Bernhard | Berl | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
35629 | 35629 | 2008-11-11 | 2007-06-11 | Zentay | John H. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
35631 | 35631 | 2008-11-11 | 2008-10-14 | Bolia | Donald M. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
34577 | 34577 | 2008-10-31 | 2008-10-10 | Lieber | David A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29649 | 29649 | 2008-09-12 | 2007-11-02 | Woolley | Jessica S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
28956 | 28956 | 2008-09-01 | 2003-09-25 | Phillips | Steven R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
23974 | 23974 | 2008-07-24 | 2006-11-20 | Rohrscheib | Joshua G. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
23747 | 23747 | 2008-07-21 | 2007-07-18 | Messmer | Michael F. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
23389 | 23389 | 2008-07-16 | 2007-11-02 | Lieber | David A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
22732 | 22732 | 2008-07-07 | 2007-08-09 | Bauer | Dana | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
22733 | 22733 | 2008-07-07 | 2007-10-12 | Bayrak | Emel | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
19942 | 19942 | 2008-06-20 | 2007-06-11 | LaBoissonniere | Lucie | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
19000 | 19000 | 2008-06-06 | 2007-06-11 | Dilloff | Shani C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18528 | 18528 | 2008-06-01 | 2007-11-02 | Eskin | Andrew D. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
16450 | 16450 | 2008-05-15 | 2003-09-25 | Tucker | Patrick A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
16028 | 16028 | 2008-05-10 | 2006-02-14 | Ginsberg | Ellen S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8855 | 8855 | 2008-03-01 | 2007-06-11 | Magill | Alix | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8859 | 8859 | 2008-03-01 | 2006-11-20 | Cardozo | Camilo | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8860 | 8860 | 2008-03-01 | 2006-11-20 | Salomon | Claudia | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
38181 | 38181 | 2007-12-12 | 2007-10-12 | Ozden | Eda | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 |
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]) );