FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
191 rows where Registration_Number = 3774
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3054 | 3054 | 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 | |
3388 | 3388 | 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 | |
3569 | 3569 | 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 | |
3570 | 3570 | 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 | |
3572 | 3572 | 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 | |
3573 | 3573 | 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 | |
3574 | 3574 | 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 | |
3621 | 3621 | 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 | |
3759 | 3759 | 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 | |
4139 | 4139 | 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 | |
4476 | 4476 | 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 | |
4660 | 4660 | 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 | |
4801 | 4801 | 1996-01-31 | 1993-10-20 | Bingol | Selim | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
4811 | 4811 | 1997-01-31 | 1994-03-04 | Sharples | Susan | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
4831 | 4831 | 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 | |
6762 | 6762 | 2000-02-18 | 1996-09-04 | Jennings | Malin | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
6840 | 6840 | 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 | |
7320 | 7320 | 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 | |
7539 | 7539 | 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 | |
8578 | 8578 | 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 | |
8579 | 8579 | 1994-03-04 | 1993-03-05 | Tucker | Brett | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8580 | 8580 | 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 | |
8622 | 8622 | 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 | |
8624 | 8624 | 1993-03-05 | 1989-09-05 | Bloch | Jayne | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8625 | 8625 | 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 | |
8626 | 8626 | 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 | |
8627 | 8627 | 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 | |
8628 | 8628 | 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 | |
8629 | 8629 | 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 | |
8683 | 8683 | 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 | |
8688 | 8688 | 1995-03-06 | 1991-03-07 | Hancock | Mary | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
8691 | 8691 | 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 | |
8861 | 8861 | 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 | |
9149 | 9149 | 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 | |
9256 | 9256 | 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 | |
9259 | 9259 | 2003-03-14 | 2003-03-07 | Franco | Nathalia | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9474 | 9474 | 2000-03-16 | 1989-09-05 | Colon | William A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9572 | 9572 | 2000-03-17 | 1997-09-04 | Doble | Michael F. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9573 | 9573 | 2000-03-17 | 1999-09-07 | Klein | Mara S. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9667 | 9667 | 1998-03-18 | 1993-09-07 | Beightol | Michael H. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
9932 | 9932 | 2002-03-22 | 2000-09-01 | Blomquist | Eric | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
10430 | 10430 | 1991-03-29 | 1989-03-03 | Tagliarino | Scott A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
10431 | 10431 | 1991-03-29 | 1991-03-07 | Pardo | Francesca | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
10437 | 10437 | 1991-03-29 | 1989-09-05 | Moriber | Jeffrey | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11188 | 11188 | 1999-03-31 | 1993-03-05 | Burket | David | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11223 | 11223 | 2000-03-31 | 1996-07-15 | Glidden | Julia A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11227 | 11227 | 2000-03-31 | 1999-09-07 | Parker | Amy M. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11928 | 11928 | 1997-04-02 | 1996-03-06 | Garber | Jennifer | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11930 | 11930 | 1999-04-02 | 1996-03-06 | Blackburn | Daniel | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
11931 | 11931 | 1999-04-02 | 1991-03-07 | Nakakura | Shari | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
12177 | 12177 | 1995-04-07 | 1987-03-06 | Ouellette | Jeanne | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
12374 | 12374 | 2000-04-10 | 1999-03-05 | Guarnieri | Rica M. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
12376 | 12376 | 2001-04-10 | 1989-03-03 | Gregory | John R. (Jack) | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
12489 | 12489 | 1991-04-12 | 1991-03-07 | Krauss | Beatrice | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
12738 | 12738 | 2003-04-15 | 2002-03-28 | Sucar | Liana | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
12953 | 12953 | 1995-04-18 | 1991-05-17 | Birney | Jonelle | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
13144 | 13144 | 1992-04-22 | 1991-09-05 | Neisloss | Susan | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
13271 | 13271 | 1992-04-24 | 1991-03-07 | Chuck | Charles D. Gelman | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
14585 | 14585 | 1992-05-01 | 1990-05-10 | Gray | William Brett | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
14710 | 14710 | 1997-05-02 | 1993-09-07 | Monson | Sharon M. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
14821 | 14821 | 1999-05-04 | 1993-03-12 | Massey | Donald F. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
14867 | 14867 | 1995-05-05 | 1991-03-07 | Fletcher | Nancy | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
15073 | 15073 | 1997-05-09 | 1996-04-09 | Eisner | David | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
15405 | 15405 | 1999-05-14 | 1989-03-03 | McLean | Carolyn Alexis | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
15507 | 15507 | 2002-05-15 | 2000-03-10 | Batalla | Yvette | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
15513 | 15513 | 2003-05-15 | 1988-10-12 | Leddy | Gregory | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
15682 | 15682 | 1996-05-17 | 1993-09-07 | Rudnick | Gary | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
15824 | 15824 | 1998-05-20 | 1995-01-24 | Harmon | Elisabeth | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
15892 | 15892 | 1999-05-21 | 1995-09-06 | Barry | Ellen | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
16014 | 16014 | 1996-05-23 | 1988-01-19 | Buckmaster | Thomas L. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
16097 | 16097 | 1996-05-24 | 1995-09-06 | Riley | Stephen F. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
16098 | 16098 | 1996-05-24 | 1994-09-08 | Cabelly | Robert John | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
16244 | 16244 | 1999-05-26 | 1996-04-09 | Gustafson | Robert C. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
16346 | 16346 | 1999-05-28 | 1993-10-20 | Gossens | Peter J. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
18293 | 18293 | 1997-06-13 | 1995-09-06 | Johnson | Judy A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
18376 | 18376 | 1996-06-14 | 1996-04-09 | Raymond | Derrick | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
18476 | 18476 | 1987-06-15 | 1986-02-20 | Size | Susan A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
18518 | 18518 | 2004-06-15 | 2002-09-12 | Johnson | C. Donald | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
18629 | 18629 | 2004-06-16 | 2003-09-22 | McGuinness | Katie | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
18685 | 18685 | 1996-06-17 | 1995-09-06 | Jackson | Nancy Izzo | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
18728 | 18728 | 1999-06-18 | 1997-03-22 | Anthony | Adam | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
18885 | 18885 | 1991-06-21 | 1991-04-08 | Solomon | Mary C. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
20002 | 20002 | 1988-06-30 | 1986-09-05 | DesRosiers | Kathleen A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
21009 | 21009 | 1988-07-01 | 1986-09-05 | Margaritis | John P. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
21265 | 21265 | 1998-07-02 | 1996-04-09 | Graziani | Andrew | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
21507 | 21507 | 2000-07-07 | 1999-09-07 | Feria | Isabel | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
22311 | 22311 | 1991-07-18 | 1991-03-07 | Fischer | Kathleen | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
22389 | 22389 | 2004-07-19 | 2000-09-01 | Isenhower | Anne | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
22436 | 22436 | 2004-07-20 | 1989-09-05 | Lansdale | Edward R. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
22506 | 22506 | 2000-07-21 | 2000-03-10 | Yacker | Jeffrey | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
22858 | 22858 | 1996-07-26 | 1995-03-06 | Coulter | Cynthia A. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
23038 | 23038 | 1995-07-28 | 1994-03-04 | Horner | Chris | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
23039 | 23039 | 1999-07-28 | 1991-05-30 | Soh | Peter Y. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
23471 | 23471 | 1987-07-31 | 1987-03-06 | Elwell | Stephen | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
23603 | 23603 | 1996-07-31 | 1990-10-30 | Zingman | Benjamin L. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
24668 | 24668 | 2004-08-05 | 1988-01-19 | Miller | Martha | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
24669 | 24669 | 2004-08-05 | 1986-02-05 | Graham | John D. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
24670 | 24670 | 2004-08-05 | 1993-03-05 | Boxerman | Benita W. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
24671 | 24671 | 2004-08-05 | 1993-03-05 | Garino | David P. | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
24672 | 24672 | 2004-08-05 | 1999-03-05 | Licha | Rissig | 3774 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 |
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) );