FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
372 rows where City = "St. Louis"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number
Registrant_Name
- Fleishman-Hillard, Inc. 295
- Gardner Advertising Company, Inc. 41
- Ashcroft Law Firm, LLC 11
- Armstrong, Teasdale, Kramer & Vaughan 7
- Thompson & Mitchell 5
- Avatar Enterprises, Inc. 3
- Baron Public Affairs, LLC 3
- Kit Bond Strategies, LLP 3
- Bryan Cave LLP 1
- Oliver A. Dulle Jr. & Company, Inc. 1
- Oliver A. Dulle, Jr. & Company, Inc. 1
- Transcontinental Financial & Trading Corporation 1
State
- MO 372
City
- St. Louis · 372 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
130 | 130 | 2021-01-21 | Rand | Amy | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
216 | 216 | 2021-01-30 | Adolph | Michael Charles | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
217 | 217 | 2021-01-30 | Belding | Arman | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
218 | 218 | 2021-01-30 | Bernard | Mikael | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
219 | 219 | 2021-01-30 | Bueno | Alexander de la Torre | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
220 | 220 | 2021-01-30 | Franklin | James Nikolai | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
221 | 221 | 2021-01-30 | Graziano | Devon | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
222 | 222 | 2021-01-30 | Heibeck | Olivia | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
225 | 225 | 2021-01-30 | Sanchez | Nicole | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
966 | 966 | 2017-06-09 | Ashcroft | John D. | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
967 | 967 | 2017-06-09 | Ayres | David T. | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
968 | 968 | 2017-06-09 | Day | Lori Sharpe | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
969 | 969 | 2017-06-09 | Peele | Christopher L. | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
970 | 970 | 2017-06-09 | Reyes | Luis Alejandro | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
971 | 971 | 2017-06-09 | Sullivan | Michael J. | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
1062 | 1062 | 2020-06-26 | Rahman | Kamilla | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1063 | 1063 | 2020-06-26 | Shaw | Steven | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1064 | 1064 | 2020-06-26 | Teahan | Caitlin | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1138 | 1138 | 2020-07-10 | Brennan | Nathan | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
1563 | 1563 | 2019-10-02 | West | Kimberly | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
1613 | 1613 | 2020-10-09 | Girouard | Spencer | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1614 | 1614 | 2020-10-09 | Tchoukaleff | Tayler | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1615 | 1615 | 2020-10-09 | Tchoukaleff | Tayler | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1616 | 1616 | 2020-10-09 | Zagora | Anthony | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1625 | 1625 | 2020-10-12 | Witt | Bailey | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1629 | 1629 | 2020-10-13 | Evenson | Erin | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1635 | 1635 | 2020-10-13 | Sadlier | Lizanne | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | ||
1853 | 1853 | 2019-11-13 | Bennett | Barry | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 | |
2266 | 2266 | 1969-01-01 | 1960-08-12 | Claggett | Charles Evans | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
2719 | 2719 | 2018-01-01 | 2017-09-19 | Leong | Lonna | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
2821 | 2821 | 1973-01-03 | 1960-08-12 | Pellegrino | Thomas John | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
3035 | 3035 | 1999-01-07 | 1992-03-05 | Campbell | W. Douglas | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
3170 | 3170 | 2020-01-09 | 2017-06-09 | Reilly | Michelle T. | 6438 6438 | 2017-06-09 | Ashcroft Law Firm, LLC | 1100 Main Street | Suite 2700 | St. Louis | MO | 64105 |
3369 | 3369 | 2000-01-14 | 1999-03-05 | Harrower | David A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
3407 | 3407 | 1972-01-15 | 1968-10-11 | Lucci | Giuseppe | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
3550 | 3550 | 1998-01-16 | 1986-02-05 | Sullivan | Richard J. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
3551 | 3551 | 1998-01-16 | 1992-03-05 | Anderson | William K. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
3553 | 3553 | 1998-01-16 | 1988-09-01 | Epstein | Jerry A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
3554 | 3554 | 1998-01-16 | 1989-09-05 | Van Meter | Jan R. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
3555 | 3555 | 1998-01-16 | 1993-09-07 | Modzelewski | Jack (John F.) | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
3602 | 3602 | 1989-01-17 | 1988-03-03 | de Leon | Richard Rueda | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
3628 | 3628 | 2017-01-17 | 2009-03-16 | Cutin | Dario O. | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
3740 | 3740 | 1998-01-19 | 1995-09-06 | Gonzalez | Luis A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
4120 | 4120 | 1995-01-25 | 1990-05-14 | Morrison | Jean Anne | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
4457 | 4457 | 2004-01-30 | 2002-03-28 | Collender | Stanley E. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
4552 | 4552 | 1972-01-31 | 1968-10-11 | Digby | Noel | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
4641 | 4641 | 1988-01-31 | 1986-09-05 | White | Rene L. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
4782 | 4782 | 1996-01-31 | 1993-10-20 | Bingol | Selim | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
4792 | 4792 | 1997-01-31 | 1994-03-04 | Sharples | Susan | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
4812 | 4812 | 1998-01-31 | 1994-09-08 | Tuncata | Arzu F. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
5049 | 5049 | 2010-01-31 | 2007-07-27 | Fears | Gary | 5821 5821 | 2007-07-27 | Avatar Enterprises, Inc. | 10349 Watson Road | Suite 100 | St. Louis | MO | 63127 |
5281 | 5281 | 1973-02-01 | 1972-11-13 | Filice | Michael | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
6154 | 6154 | 2009-02-10 | 2007-04-16 | Edwards | Samantha A. | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
6435 | 6435 | 1963-02-15 | 1962-09-07 | Eastright | Robert Earl | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
6454 | 6454 | 1973-02-15 | 1971-03-29 | Vecchio | Pasquale G. Del | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
6456 | 6456 | 1973-02-15 | 1966-12-08 | Sabatino | Daniel Casper | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
6531 | 6531 | 2018-02-15 | 2017-06-08 | Hancock | Katy | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
6748 | 6748 | 2000-02-18 | 1996-09-04 | Jennings | Malin | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
6826 | 6826 | 1998-02-20 | 1986-02-20 | Pearlman | Vicki E. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
7306 | 7306 | 1998-02-27 | 1988-01-19 | Sonnenfeldt | Marjorie Hecht | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
7317 | 7317 | 2009-02-27 | 2007-04-16 | Viorst | Marla Rigel | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
7525 | 7525 | 1995-02-28 | 1993-03-05 | Sommerfield | Frank E. , Jr. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
7839 | 7839 | 2018-02-28 | 2017-05-16 | Moroney | Michael | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
7856 | 7856 | 2018-02-28 | 2017-11-04 | Perrien | Ainsley | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
8355 | 8355 | 2010-03-01 | 2009-10-29 | Dulle Jr. | Oliver A. | 5959 5959 | 2009-10-29 | Oliver A. Dulle Jr. & Company, Inc. | 8000 Maryland Avenue | Suite 1320 | St. Louis | MO | 63105 |
8432 | 8432 | 2018-03-02 | 2017-09-19 | Mok | Martina | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
8565 | 8565 | 1994-03-04 | 1992-03-05 | Clarkson | Pamela A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8566 | 8566 | 1994-03-04 | 1993-03-05 | Tucker | Brett | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8567 | 8567 | 1994-03-04 | 1992-03-18 | Ampolsk | Alan G. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8577 | 8577 | 2017-03-04 | 2013-06-14 | Yang | Jennifer | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
8609 | 8609 | 1993-03-05 | 1991-03-07 | Levy | Jill Anne | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8611 | 8611 | 1993-03-05 | 1989-09-05 | Bloch | Jayne | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8612 | 8612 | 1993-03-05 | 1989-09-05 | McCabe | Ian Richard | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8613 | 8613 | 1993-03-05 | 1989-09-05 | Smith | Alan Wayne | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8614 | 8614 | 1993-03-05 | 1989-09-05 | Turner | Caren Zeldie | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8615 | 8615 | 1993-03-05 | 1991-09-05 | de Tejada | Marivi Lerdo | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8616 | 8616 | 1993-03-05 | 1988-10-12 | Christy | Valerie E. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8670 | 8670 | 1992-03-06 | 1991-03-07 | Hamblin | Koleen Carole | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8675 | 8675 | 1995-03-06 | 1991-03-07 | Hancock | Mary | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8678 | 8678 | 1995-03-06 | 1990-05-18 | Solymossy | Diana Sun | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8848 | 8848 | 1997-03-07 | 1993-09-07 | Carpenter | Cynthia L. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9136 | 9136 | 1998-03-12 | 1990-12-10 | Woods | Andrew A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9211 | 9211 | 1973-03-14 | 1963-03-05 | Brugnatelli | Bruno Ercole | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9212 | 9212 | 1973-03-14 | 1963-03-05 | Buffington | Louis Dell , III | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9213 | 9213 | 1973-03-14 | 1961-03-08 | Pierce | Alvin Frederick | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9214 | 9214 | 1973-03-14 | 1962-03-09 | Cornwell | William Earl | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9215 | 9215 | 1973-03-14 | 1962-03-09 | Ewell | Charles Lee | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9216 | 9216 | 1973-03-14 | 1962-03-09 | Rice | Francis Xavier | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9219 | 9219 | 1973-03-14 | 1965-11-05 | Davidson | John M. | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9220 | 9220 | 1973-03-14 | 1968-11-25 | Dalton | Peter J. | 1385 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9243 | 9243 | 2001-03-14 | 2000-03-10 | Martin | Kim S. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9246 | 9246 | 2003-03-14 | 2003-03-07 | Franco | Nathalia | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9260 | 9260 | 2018-03-14 | 2018-03-14 | Adolph | Michael Charles | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
9261 | 9261 | 2018-03-14 | 2018-03-14 | Choi | Michelle | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
9262 | 9262 | 2018-03-14 | 2018-03-14 | Demashkieh | Diala | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
9263 | 9263 | 2018-03-14 | 2018-03-14 | Flaster | Samuel Grant | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
9264 | 9264 | 2018-03-14 | 2018-03-14 | Francomano | Sarah | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
9265 | 9265 | 2018-03-14 | 2018-03-14 | Isaf | John K. | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
9266 | 9266 | 2018-03-14 | 2018-03-15 | Hollyer | Luke | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 | |
9267 | 9267 | 2018-03-14 | 2018-03-15 | Prior | Melanie | 5801 5801 | 2007-04-16 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102 |
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) );