FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
273 rows where Registrant_Name = "DLA Piper US LLP" sorted by Short_Form_First_Name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21359 | 21359 | 2000-06-30 | 1999-06-15 | Dodd | Abaigeal G. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
17941 | 17941 | 2001-05-31 | 2001-02-22 | Jarmula | Agnieszka | 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 | |
29241 | 29241 | 2000-09-05 | 1995-12-12 | Yellin | Alex | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25961 | 25961 | 2006-08-04 | 2006-07-14 | Marzelli | Alexandra Scott | 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 | |
37438 | 37438 | 1992-12-01 | 1989-05-25 | Bondurant | Amy | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
37458 | 37458 | 1997-12-01 | 1994-09-19 | Bondurant | Amy L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
17199 | 17199 | 2006-05-26 | 2006-03-06 | Wolf | Andrea B. | 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 | |
25994 | 25994 | 2000-08-05 | 1995-06-02 | Eskin | Andrew D. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
15942 | 15942 | 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 | |
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 | |
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 | |
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 | |
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 | |
25886 | 25886 | 2004-08-03 | 2001-02-22 | Picard | B. Donovan | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29238 | 29238 | 2000-09-05 | 1995-11-16 | Rhoads | Barry | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
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 | |
3410 | 3410 | 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 | |
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 | |
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 | |
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 | |
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 | |
16337 | 16337 | 2002-05-14 | 2002-03-11 | Jones | Brian C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2804 | 2804 | 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 | |
24887 | 24887 | 1997-07-31 | 1987-02-12 | White | Buel | 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 | |
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 | |
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 | |
27437 | 27437 | 2006-08-25 | 2005-03-15 | Arrowood | Catherine | 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 | |
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 | |
41219 | 41219 | 2001-12-31 | 2001-02-22 | Kloes | Christina | 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 | |
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 | |
22301 | 22301 | 2003-07-01 | 2003-03-14 | Weston | Christopher D. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
36065 | 36065 | 2002-11-19 | 2002-03-11 | Weston | Christopher D. | 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 | |
29235 | 29235 | 2000-09-05 | 1995-10-13 | Vince | Clinton A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29239 | 29239 | 2000-09-05 | 1995-12-05 | Dowling | Colin | 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 | |
41186 | 41186 | 2000-12-31 | 1999-04-28 | Krasow | Cristina Louise | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
14838 | 14838 | 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 | |
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 | |
22479 | 22479 | 2004-07-02 | 2001-02-22 | Marshall | Dana M. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
33434 | 33434 | 2002-10-22 | 2002-02-04 | Colarulli | Dana R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25995 | 25995 | 2000-08-05 | 2000-09-05 | Coats | Daniel R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
41218 | 41218 | 2001-12-31 | 2001-02-22 | Floyd | Daniel S. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
29234 | 29234 | 2000-09-05 | 1995-10-13 | Swanstrom | Deborah A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
11876 | 11876 | 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 | |
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 | |
29832 | 29832 | 1987-09-15 | 1985-08-05 | Isaacks | Donna L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25650 | 25650 | 2006-08-01 | 2005-07-07 | Green | Douglas Haber | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
2817 | 2817 | 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 | |
27766 | 27766 | 1991-08-30 | 1988-09-19 | Steenland | Douglas M. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7642 | 7642 | 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 | |
18667 | 18667 | 1995-06-02 | 1994-09-19 | Krumholtz | E. John | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
37439 | 37439 | 1992-12-01 | 1991-11-25 | Krumholtz | E. John | 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 | |
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 | |
25887 | 25887 | 2004-08-03 | 2001-02-22 | Rowe | Edward B. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
6182 | 6182 | 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 | |
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 | |
40858 | 40858 | 1995-12-31 | 1995-06-02 | Diaz | Elizabeth | 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 | |
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 | |
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 | |
2806 | 2806 | 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 | |
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 | |
36066 | 36066 | 2002-11-19 | 2001-04-26 | Migdail | Evan | 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 | |
16706 | 16706 | 2000-05-19 | 1999-10-12 | Montano-Valdes | Fernanda | 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 | |
18767 | 18767 | 1994-06-03 | 1989-05-25 | Drogula | Fred W. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
7174 | 7174 | 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 | |
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 | |
29236 | 29236 | 2000-09-05 | 1997-10-30 | Klein | Gary J. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
37970 | 37970 | 1992-12-09 | 1989-05-25 | Schleppenbach | Gene | 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 | |
10528 | 10528 | 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 | |
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 | |
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 | |
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 | |
10455 | 10455 | 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 | |
10453 | 10453 | 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 | |
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 | |
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 | |
8848 | 8848 | 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 | |
33438 | 33438 | 2002-10-22 | 1998-08-27 | McDonald | Jack Harvey | 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 | |
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 | |
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 | |
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 |
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]) );