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_Date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6196 | 6196 | 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 | |
6197 | 6197 | 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 | |
7252 | 7252 | 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 | |
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 | |
7643 | 7643 | 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 | |
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 | |
11856 | 11856 | 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 | |
12015 | 12015 | 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 | |
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 | |
15851 | 15851 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
11207 | 11207 | 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 | |
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 | |
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 | |
2805 | 2805 | 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 | |
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 | |
2807 | 2807 | 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 | |
2808 | 2808 | 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 | |
7733 | 7733 | 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 | |
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 | |
5817 | 5817 | 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 | |
9413 | 9413 | 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 | |
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 | |
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 | |
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 | |
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 | |
13050 | 13050 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
7729 | 7729 | 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 | |
7730 | 7730 | 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 | |
7731 | 7731 | 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 | |
12518 | 12518 | 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 | |
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 | |
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 | |
7732 | 7732 | 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 | |
9412 | 9412 | 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 | |
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 | |
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 | |
5818 | 5818 | 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 | |
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 | |
12522 | 12522 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12519 | 12519 | 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 | |
6697 | 6697 | 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 | |
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 | |
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 | |
6964 | 6964 | 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 | |
11211 | 11211 | 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 | |
14151 | 14151 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
8847 | 8847 | 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 | |
10170 | 10170 | 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 | |
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 | |
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 | |
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 | |
4285 | 4285 | 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 | |
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 | |
8849 | 8849 | 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 | |
4182 | 4182 | 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 | |
8850 | 8850 | 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 | |
8851 | 8851 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
8419 | 8419 | 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 | |
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 |
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]) );