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" and "Registration_Date" is on date 1985-08-05
This data as json, CSV (advanced)
State 1
- DC 173
Registration_Number 1
- DLA Piper US LLP 173
Registrant_Name 1
- DLA Piper US LLP · 173 ✖
City 1
- Washington 173
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15943 | 15943 | 2001-05-08 | 1995-06-02 | Hickie | Jane | 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 | |
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 | |
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 | |
16621 | 16621 | 2002-05-17 | 2002-03-13 | Garon | Richard J. Jr., | 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 | |
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 | |
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 | |
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 | |
17942 | 17942 | 2001-05-31 | 2000-03-17 | Sullivan | Lauraine D. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
17950 | 17950 | 2001-05-31 | 1998-07-20 | Youngblood | Theresa Marie | 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 | |
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 | |
18516 | 18516 | 2000-06-01 | 1998-09-23 | Sharma | Kapil | 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 | |
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 | |
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 | |
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 | |
18768 | 18768 | 1994-06-03 | 1985-08-05 | Merrigan | John A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18770 | 18770 | 1994-06-03 | 1991-11-25 | Mendelsohn | Martin | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18771 | 18771 | 1994-06-03 | 1991-11-25 | Zeitler | William | 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 | |
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 | |
19819 | 19819 | 2002-06-18 | 2002-09-04 | Kehn | Jeri L. | 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 | |
21358 | 21358 | 2000-06-30 | 1995-06-02 | Jorge | Maria Fabiana | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
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 | |
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 | |
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 | |
22445 | 22445 | 1987-07-02 | 1985-08-05 | Jerome | Richard | 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 | |
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 | |
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 | |
22856 | 22856 | 1999-07-09 | 1998-07-20 | Minor | William Henning | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
22857 | 22857 | 1999-07-09 | 1998-09-23 | Tritak | John S. | 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 | |
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 | |
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 | |
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 | |
24107 | 24107 | 2003-07-26 | 2001-02-22 | Getachew | Yared | 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 | |
24940 | 24940 | 1999-07-31 | 1999-04-28 | Fatka | Stacie Lynn | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
24941 | 24941 | 1999-07-31 | 1999-04-28 | Kearney | Stephen John | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
24981 | 24981 | 2000-07-31 | 1998-08-27 | Payne | Mary Penelope | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
24983 | 24983 | 2000-07-31 | 1995-10-20 | Payne | Nell | 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 | |
25648 | 25648 | 2006-08-01 | 1999-04-28 | Boggs | Virginia R. | 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 | |
25651 | 25651 | 2006-08-01 | 2005-07-07 | Van Buren | Lynn Marie | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25798 | 25798 | 2002-08-02 | 2002-02-21 | Brown | Jamie E. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25882 | 25882 | 2004-08-03 | 2003-01-10 | Williamson | Jill M. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25883 | 25883 | 2004-08-03 | 2003-01-21 | Dailey | Virginia C. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25884 | 25884 | 2004-08-03 | 2003-02-19 | Snider | Thomas R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25885 | 25885 | 2004-08-03 | 2001-02-22 | Cawley | Justin | 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 | |
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 | |
25888 | 25888 | 2004-08-03 | 2001-02-22 | Van Buren | Lynn M. | 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 | |
25992 | 25992 | 2000-08-05 | 1999-04-28 | Weinberg | Linda Michelle | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25993 | 25993 | 2000-08-05 | 1999-05-04 | Hart | Vicki | 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 | |
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 | |
25997 | 25997 | 2003-08-05 | 2002-02-01 | Schaefermeier | Martin | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25998 | 25998 | 2003-08-05 | 2002-02-04 | Kramer | William D. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
25999 | 25999 | 2003-08-05 | 2002-04-12 | Manson | Joseph L. III | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
26001 | 26001 | 2003-08-05 | 2002-09-24 | Phillips | Steven R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
26114 | 26114 | 2007-08-06 | 2007-07-18 | Carelli | Nicole D. | 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 | |
26726 | 26726 | 1988-08-15 | 1986-04-08 | Johnson | Lindsey | 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 | |
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 | |
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 | |
28136 | 28136 | 1989-08-31 | 1988-04-01 | Santos | Leonard E. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
29226 | 29226 | 2000-09-05 | 1998-01-05 | Coe | Jo-Anne | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29227 | 29227 | 2000-09-05 | 1996-02-21 | Wong | Norma N. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29228 | 29228 | 2000-09-05 | 1998-04-03 | Iturregui | Juan Carlos | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29229 | 29229 | 2000-09-05 | 1995-06-02 | Johnson | Steven R. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29230 | 29230 | 2000-09-05 | 1995-06-02 | Zeitler | William A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29231 | 29231 | 2000-09-05 | 1994-09-19 | Mendelsohn | Martin | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
29233 | 29233 | 2000-09-05 | 1995-10-13 | Cartwright | Suzanne D. | 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 | |
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 | |
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 | |
29237 | 29237 | 2000-09-05 | 1995-11-16 | McKnight | Steve | 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 |
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]) );