FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
273 rows where Registration_Number = 3712 sorted by Short_Form_Last_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4290 | 4290 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
669 | 669 | 2012-03-29 | Bell | Nathaniel | 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 | |
2835 | 2835 | 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 | |
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 | |
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 | |
3168 | 3168 | 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 | |
4280 | 4280 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
4286 | 4286 | 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 | |
15124 | 15124 | 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 | |
5810 | 5810 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
14150 | 14150 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12524 | 12524 | 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 | |
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 | |
8437 | 8437 | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]) );