FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
273 rows where Registration_Number = 3712
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
578 | 578 | 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 | ||
661 | 661 | 2012-03-29 | Bell | Nathaniel | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | ||
2796 | 2796 | 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 | |
2797 | 2797 | 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 | |
2798 | 2798 | 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 | |
2799 | 2799 | 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 | |
2800 | 2800 | 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 | |
2802 | 2802 | 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 | |
2809 | 2809 | 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 | |
2827 | 2827 | 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 | |
2828 | 2828 | 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 | |
2986 | 2986 | 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 | |
3156 | 3156 | 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 | |
3196 | 3196 | 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 | |
3398 | 3398 | 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 | |
4170 | 4170 | 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 | |
4268 | 4268 | 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 | |
4271 | 4271 | 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 | |
4273 | 4273 | 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 | |
4274 | 4274 | 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 | |
4276 | 4276 | 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 | |
4277 | 4277 | 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 | |
4278 | 4278 | 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 | |
5797 | 5797 | 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 | |
5798 | 5798 | 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 | |
5804 | 5804 | 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 | |
5805 | 5805 | 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 | |
5807 | 5807 | 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 | |
6169 | 6169 | 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 | |
6170 | 6170 | 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 | |
6183 | 6183 | 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 | |
6184 | 6184 | 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 | |
6684 | 6684 | 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 | |
6731 | 6731 | 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 | |
6951 | 6951 | 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 | |
7160 | 7160 | 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 | |
7161 | 7161 | 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 | |
7239 | 7239 | 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 | |
7629 | 7629 | 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 | |
7630 | 7630 | 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 | |
7716 | 7716 | 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 | |
7717 | 7717 | 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 | |
7718 | 7718 | 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 | |
7719 | 7719 | 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 | |
7720 | 7720 | 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 | |
8117 | 8117 | 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 | |
8118 | 8118 | 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 | |
8252 | 8252 | 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 | |
8399 | 8399 | 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 | |
8401 | 8401 | 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 | |
8406 | 8406 | 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 | |
8423 | 8423 | 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 | |
8424 | 8424 | 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 | |
8425 | 8425 | 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 | |
8426 | 8426 | 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 | |
8579 | 8579 | 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 | |
8834 | 8834 | 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 | |
8835 | 8835 | 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 | |
8836 | 8836 | 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 | |
8837 | 8837 | 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 | |
8838 | 8838 | 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 | |
8842 | 8842 | 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 | |
8846 | 8846 | 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 | |
8847 | 8847 | 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 | |
8866 | 8866 | 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 | |
8869 | 8869 | 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 | |
8877 | 8877 | 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 | |
9399 | 9399 | 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 | |
9400 | 9400 | 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 | |
10157 | 10157 | 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 | |
10217 | 10217 | 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 | |
10440 | 10440 | 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 | |
10442 | 10442 | 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 | |
10515 | 10515 | 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 | |
10977 | 10977 | 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 | |
11194 | 11194 | 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 | |
11198 | 11198 | 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 | |
11843 | 11843 | 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 | |
11856 | 11856 | 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 | |
11863 | 11863 | 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 | |
12002 | 12002 | 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 | |
12504 | 12504 | 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 | |
12505 | 12505 | 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 | |
12506 | 12506 | 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 | |
12508 | 12508 | 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 | |
12510 | 12510 | 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 | |
12592 | 12592 | 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 | |
13036 | 13036 | 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 | |
14136 | 14136 | 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 | |
14137 | 14137 | 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 | |
14291 | 14291 | 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 | |
14362 | 14362 | 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 | |
14698 | 14698 | 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 | |
14823 | 14823 | 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 | |
15070 | 15070 | 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 | |
15071 | 15071 | 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 | |
15086 | 15086 | 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 | |
15109 | 15109 | 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 | |
15834 | 15834 | 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 | |
15925 | 15925 | 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]) );