FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
271 rows where Registrant_Name = "DLA Piper US LLP"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
State 1
- DC 271
Registration_Number 1
- DLA Piper US LLP 271
Registrant_Name 1
- DLA Piper US LLP · 271 ✖
City 1
- Washington 271
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
549 | 549 | 2009-03-17 | Phillips | Steven R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | ||
630 | 630 | 2013-03-28 | Castle | Michael | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | ||
640 | 640 | 2012-03-29 | Bell | Nathaniel | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | ||
1034 | 1034 | 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 | ||
1465 | 1465 | 2021-08-10 | Peyman | David | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | ||
1877 | 1877 | 2018-10-26 | Jebeyli | Stephanie | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | ||
2674 | 2674 | 2002-01-01 | 2001-04-16 | Berry | Brian T. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2675 | 2675 | 2002-01-01 | 2001-04-16 | Chlopak | Robert A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2676 | 2676 | 2002-01-01 | 2001-04-16 | Christy | Erin E. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2677 | 2677 | 2002-01-01 | 2001-04-16 | Schechter | Peter D. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2678 | 2678 | 2002-01-01 | 2001-04-16 | Singer | Sheri L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2680 | 2680 | 2003-01-01 | 2001-02-22 | McDonald | Michael K. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2687 | 2687 | 2003-01-01 | 1998-12-16 | MacKinnon | Douglas M. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2705 | 2705 | 2005-01-01 | 2000-09-05 | Bernstein | Matthew C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2706 | 2706 | 2005-01-01 | 1998-09-22 | Zentay | John Holliday | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2864 | 2864 | 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 | |
3025 | 3025 | 1991-01-04 | 1985-10-03 | Billings | Leon G. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
3065 | 3065 | 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 | |
3234 | 3234 | 1993-01-08 | 1988-04-01 | Flowe | Benjamin H. , Jr. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
3997 | 3997 | 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 | |
4093 | 4093 | 2002-01-22 | 1999-09-03 | Bishop | Wayne S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
4096 | 4096 | 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 | |
4098 | 4098 | 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 | |
4099 | 4099 | 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 | |
4101 | 4101 | 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 | |
4102 | 4102 | 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 | |
4103 | 4103 | 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 | |
5602 | 5602 | 2002-02-01 | 2001-02-22 | Brown | Jamie | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
5603 | 5603 | 2002-02-01 | 1999-04-28 | Saint-Louis | Layn | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
5609 | 5609 | 2003-02-01 | 2001-05-29 | Dole | Robert J. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
5610 | 5610 | 2003-02-01 | 2002-07-02 | Marshall | Michael | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
5612 | 5612 | 2003-02-01 | 1999-09-03 | Harris | Marshall F. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
5966 | 5966 | 2001-02-05 | 1999-05-04 | Merrigan | Edward L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
5967 | 5967 | 2001-02-05 | 1999-09-03 | Hawley | Noelle M. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
5980 | 5980 | 2003-02-05 | 2001-02-22 | Regan | Karen | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
5981 | 5981 | 2003-02-05 | 2001-02-22 | Robinson | Sara A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
6475 | 6475 | 2004-02-12 | 2003-04-03 | Minor | William H. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
6522 | 6522 | 1998-02-13 | 1995-06-02 | Williams | Whitney J. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
6728 | 6728 | 2005-02-15 | 2003-10-28 | Manson | Joseph L. III | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
6937 | 6937 | 1994-02-17 | 1989-11-06 | Kramerich | Leslie | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
6938 | 6938 | 1994-02-17 | 1991-11-25 | Klein | Gary | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7014 | 7014 | 2002-02-19 | 2001-02-22 | Snider | Jonathan Seth | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7395 | 7395 | 2002-02-25 | 2001-02-22 | Cors | Dylan D. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7396 | 7396 | 2002-02-25 | 2001-02-22 | Luther | Paul T. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7483 | 7483 | 2003-02-26 | 2002-02-27 | Cortinas-Garcia | Juan | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7484 | 7484 | 2003-02-26 | 2002-02-27 | Giesbert | Vera P. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7485 | 7485 | 2003-02-26 | 2002-02-27 | Haefeli | Jennifer A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7486 | 7486 | 2003-02-26 | 2002-03-13 | Garment | Leonard | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7487 | 7487 | 2003-02-26 | 2001-04-16 | Bruce | Thomas W. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7885 | 7885 | 2001-02-28 | 2000-05-15 | Hibey | James F. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7886 | 7886 | 2001-02-28 | 2000-05-15 | Saltsman | Richard H. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8020 | 8020 | 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 | |
8168 | 8168 | 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 | |
8170 | 8170 | 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 | |
8175 | 8175 | 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 | |
8337 | 8337 | 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 | |
8592 | 8592 | 2007-03-01 | 2006-05-04 | Pantaleo | Peter S. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8593 | 8593 | 2007-03-01 | 2006-09-08 | Colleli | J. Anthony | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8594 | 8594 | 2007-03-01 | 2006-10-13 | Barron | Meghan | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8595 | 8595 | 2007-03-01 | 2006-11-20 | Boggs | Virginia | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8596 | 8596 | 2007-03-01 | 2006-11-20 | Jones | Lisa Langston | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
8600 | 8600 | 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 | |
8604 | 8604 | 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 | |
8605 | 8605 | 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 | |
8624 | 8624 | 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 | |
8627 | 8627 | 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 | |
8635 | 8635 | 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 | |
9143 | 9143 | 2003-03-07 | 2002-03-13 | Farrell | Kelly J. Davis | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
9144 | 9144 | 2003-03-07 | 2001-05-29 | Patel | Rita | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
9872 | 9872 | 2007-03-17 | 2006-05-04 | Murray | Mark W. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
9931 | 9931 | 1988-03-18 | 1986-04-08 | Stikas | Tina M. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
10154 | 10154 | 1991-03-21 | 1989-05-25 | Darneille | Hopewell H. , III | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
10156 | 10156 | 1991-03-21 | 1985-12-09 | McPherson | Harry C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
10229 | 10229 | 2002-03-22 | 2001-02-22 | Thoms | Greg | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
10687 | 10687 | 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 | |
10901 | 10901 | 2007-03-30 | 2001-03-28 | Hand | Lloyd | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
10905 | 10905 | 2007-03-30 | 2003-12-24 | Escudero | Maria Luisa | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
11549 | 11549 | 2001-03-31 | 2001-02-22 | Rogers | Joyce A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
11562 | 11562 | 2001-03-31 | 1999-09-03 | White | Lisa McHenry | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
11569 | 11569 | 2001-03-31 | 1995-10-13 | Dwyer | Denis J. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
11708 | 11708 | 2007-03-31 | 2001-02-22 | Hanley | June | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
12171 | 12171 | 2004-04-01 | 2002-03-06 | Evans | William C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
12172 | 12172 | 2004-04-01 | 2003-03-24 | Hyland | James E. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
12173 | 12173 | 2004-04-01 | 2000-05-15 | Mietus | John R. Jr. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
12175 | 12175 | 2004-04-01 | 2002-09-24 | Lauria | Thomas J. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
12177 | 12177 | 2005-04-01 | 1995-10-13 | Freeman | Rosemary B. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
12259 | 12259 | 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 | |
12691 | 12691 | 2002-04-09 | 2002-02-04 | Burdick | Jessica A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
13774 | 13774 | 2002-04-26 | 2000-09-05 | Duncan | Lawrence III | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
13775 | 13775 | 2004-04-26 | 2004-01-14 | Choharis | Peter | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
13925 | 13925 | 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 | |
13996 | 13996 | 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 | |
14328 | 14328 | 1996-04-30 | 1995-10-13 | Howerton | Lorraine C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
14453 | 14453 | 2001-04-30 | 2001-02-22 | Taylor | Damon | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
14700 | 14700 | 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 | |
14701 | 14701 | 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 | |
14716 | 14716 | 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 | |
14739 | 14739 | 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 | |
15424 | 15424 | 2004-05-07 | 2001-02-22 | Scott | Lela R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
15514 | 15514 | 2001-05-08 | 2001-03-28 | Richards | Ann | 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]) );