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_Number = 3712 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- DC 273
Registration_Number 1
- DLA Piper US LLP · 273 ✖
Registration_Date (date) 1 ✖
- 1985-08-05 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
41238 | 41238 | 2001-12-31 | 1999-09-03 | Shakow | Susannah Wellford | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
41230 | 41230 | 2001-12-31 | 2001-05-29 | Neilson | Mikol | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
41220 | 41220 | 2001-12-31 | 2001-02-22 | Quiroga | Lorraine | 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 | |
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 | |
41216 | 41216 | 2001-12-31 | 2002-01-23 | Garlock | Vincent E. | 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 | |
40918 | 40918 | 1995-12-31 | 1995-10-18 | Hanfling | Robert I. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
37973 | 37973 | 1992-12-09 | 1991-11-25 | Freeman | Rosemary | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
37972 | 37972 | 1992-12-09 | 1991-11-25 | Blanchard | James J. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
37971 | 37971 | 1992-12-09 | 1988-09-19 | Gould | Rebecca M.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 | |
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 | |
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 | |
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 | |
37392 | 37392 | 1987-12-01 | 1985-12-09 | Lowry | Joseph R. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
34984 | 34984 | 2004-11-01 | 2004-06-24 | Lauria | Thomas J. | 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 | |
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 | |
33437 | 33437 | 2002-10-22 | 2001-05-29 | Coe | Jo-Anne L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
33436 | 33436 | 2002-10-22 | 2001-02-22 | Hart | Vicki | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
33435 | 33435 | 2002-10-22 | 2002-02-14 | McCarthy | Martin S. | 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 | |
33142 | 33142 | 1991-10-18 | 1988-09-19 | Cartwright | Suzanne | 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 | |
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 | |
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 | |
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 | |
32271 | 32271 | 1999-10-04 | 1995-11-16 | Waihee | John D. , III | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32270 | 32270 | 1999-10-04 | 1995-10-13 | Sterne | John H. , Jr. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32269 | 32269 | 1999-10-04 | 1998-04-03 | Sterne | John H. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
32268 | 32268 | 1999-10-04 | 1998-01-05 | Dole | Robert J. | 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 | |
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 | |
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 | |
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 | |
31218 | 31218 | 1999-09-30 | 1999-04-28 | Pande | Jyoti | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
31152 | 31152 | 1996-09-30 | 1995-10-23 | Courter | James A. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
31012 | 31012 | 1987-09-30 | 1985-12-09 | Nelson | Robert L. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
30235 | 30235 | 2001-09-21 | 2000-09-05 | Koch | Robbie N. | 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 | |
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 | |
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 | |
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 | |
29860 | 29860 | 1989-09-15 | 1985-08-05 | Cys | Richard L. | 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 | |
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 | |
29446 | 29446 | 2003-09-08 | 2002-02-04 | Grossman | Marla P. | 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 | |
29240 | 29240 | 2000-09-05 | 1985-12-09 | Hand | Lloyd N. | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]) );