FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
188 rows where Registrant_Name = "APCO Worldwide, Inc."
This data as json, CSV (advanced)
Registration_Number 3
State 1
- DC 89
Registrant_Name 1
- APCO Worldwide, Inc. · 89 ✖
City 1
- Washington 89
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22862 | 22862 | 2010-07-09 | 2010-04-28 | Leonard | Scott | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
23314 | 23314 | 2011-07-15 | 2010-04-28 | Alejandro | John | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
24601 | 24601 | 2015-07-30 | 2015-06-22 | Ackerman | Graham | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
24932 | 24932 | 1998-07-31 | 1991-09-03 | Bronk | Robin L. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
25269 | 25269 | 2015-07-31 | 2015-06-22 | Eymond-Laritaz | Thomas | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
25270 | 25270 | 2015-07-31 | 2015-06-22 | King | Richard | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
25281 | 25281 | 2015-07-31 | 2015-11-05 | Patch | Alison | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
25622 | 25622 | 1997-08-01 | 1996-10-24 | Ostfeld | Stacy E. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
25652 | 25652 | 2006-08-01 | 2002-09-13 | Hannaford | Peter D. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
25950 | 25950 | 1993-08-04 | 1992-09-09 | Hardy | Sarah M. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
26563 | 26563 | 2010-08-13 | 2010-05-21 | Mencarini | Theresa | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
27498 | 27498 | 2010-08-26 | 1994-03-07 | Bissen | Robert J. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
27532 | 27532 | 2010-08-27 | 2009-08-14 | Fitzpatrick | Maggie | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
27720 | 27720 | 2011-08-29 | 2010-04-28 | Douglass | John | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
28213 | 28213 | 1993-08-31 | 1992-01-10 | Ablack | Cecile | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
28492 | 28492 | 2007-08-31 | 1992-02-26 | Judd | Terry W. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
28508 | 28508 | 2007-08-31 | 1991-09-03 | Schumacher | Barry J. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
30162 | 30162 | 2007-09-20 | 2004-07-28 | Downen | Robert L. (Bob) | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
30560 | 30560 | 2017-09-26 | 2016-12-06 | Shaljian | Michelle | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
31136 | 31136 | 1996-09-30 | 1994-03-07 | Banta | Jennifer R. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
31181 | 31181 | 1997-09-30 | 1994-10-21 | Habeeb | William Mark | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
31508 | 31508 | 2010-09-30 | 2010-05-21 | Dudzinsky | John P. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
34989 | 34989 | 2005-11-01 | 2000-11-15 | Williams | Jaselle | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
35221 | 35221 | 1993-11-04 | 1992-01-10 | Liebowitz | Robin K. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
35222 | 35222 | 1993-11-04 | 1993-04-05 | Hussey | John F. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
36025 | 36025 | 1994-11-18 | 1994-02-03 | Judsen | Louise B. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
36569 | 36569 | 2010-11-29 | 1996-08-07 | Solarz | Stephen J. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37748 | 37748 | 2013-12-04 | 2013-09-05 | Crawford | Victoria | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37749 | 37749 | 2013-12-04 | 2013-09-05 | Dalbec | Bill | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37750 | 37750 | 2013-12-04 | 2013-09-05 | Fernandez | Nelson | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37751 | 37751 | 2013-12-04 | 2013-09-05 | Hartman | Kimberly | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37752 | 37752 | 2013-12-04 | 2013-09-05 | Jack-Preisman | Julie | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37753 | 37753 | 2013-12-04 | 2013-09-05 | Porter | Jeffrey | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37754 | 37754 | 2013-12-04 | 2013-09-05 | Verderosa | Annie | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37755 | 37755 | 2013-12-04 | 2013-09-19 | Cheyne | Alison Rachel | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37756 | 37756 | 2013-12-04 | 2013-09-19 | Robinson | James | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37757 | 37757 | 2013-12-04 | 2013-10-04 | Compton | Lauren | APCO Worldwide, Inc. 6184 | 2013-09-05 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
37801 | 37801 | 2003-12-05 | 1995-10-12 | Leff | Harry S. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
38055 | 38055 | 2003-12-10 | 1999-04-27 | Jenkins | Kempton B. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
39034 | 39034 | 2010-12-23 | 2009-08-14 | Conochan | Kelaine | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
40994 | 40994 | 1996-12-31 | 1995-10-12 | Painter | William L. , III | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41112 | 41112 | 1998-12-31 | 1996-10-24 | Powell | Cynthia A. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41305 | 41305 | 2003-12-31 | 1999-04-27 | Louison | Deborah | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41706 | 41706 | 2010-12-31 | 2010-05-13 | Geertruyen | Ivo Van | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41734 | 41734 | 2010-12-31 | 2009-11-19 | Hatzfeld | Richard | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41737 | 41737 | 2010-12-31 | 2010-12-14 | Jones | A. Elizabeth | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41744 | 41744 | 2011-12-31 | 2002-01-30 | Riegle | Donald W. Jr., (Don) | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41746 | 41746 | 2011-12-31 | 2011-02-15 | Dean | Robert | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41750 | 41750 | 2011-12-31 | 1993-03-30 | Bonker | Don L. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41753 | 41753 | 2011-12-31 | 2010-04-12 | Parich | Marc | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41754 | 41754 | 2011-12-31 | 2010-04-28 | Carmona | David Sanchez | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41755 | 41755 | 2011-12-31 | 2010-04-28 | Johndroe | Gordon D. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41756 | 41756 | 2011-12-31 | 2010-04-28 | Johnson | Marc | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41757 | 41757 | 2011-12-31 | 2010-04-28 | Levy | Sara Heather | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41758 | 41758 | 2011-12-31 | 2010-04-28 | Meyer | Jason | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41759 | 41759 | 2011-12-31 | 2010-04-28 | Savage | Jessica Claire | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41760 | 41760 | 2011-12-31 | 2010-04-28 | Shah | Falguni Dinesh | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41761 | 41761 | 2011-12-31 | 2010-04-28 | Strong | Steven W. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41762 | 41762 | 2011-12-31 | 2011-04-28 | Carey | Sarah | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41763 | 41763 | 2011-12-31 | 2011-04-28 | Johnston | J. Bennett | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41764 | 41764 | 2011-12-31 | 2011-04-28 | Johnston | N. Hunter | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41766 | 41766 | 2011-12-31 | 2010-05-13 | Zakariya | Shamyl E. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41769 | 41769 | 2011-12-31 | 2010-05-21 | Franklin | Pamela M. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41770 | 41770 | 2011-12-31 | 2010-05-21 | Lanza | Jack | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41771 | 41771 | 2011-12-31 | 2010-05-21 | Ruchirek | Darin | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41775 | 41775 | 2011-12-31 | 2010-07-22 | Dyck | Paul B. | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41779 | 41779 | 2011-12-31 | 2009-08-14 | Benson | Mark | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41780 | 41780 | 2011-12-31 | 2009-08-14 | Startseva | Anna | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41781 | 41781 | 2011-12-31 | 2009-08-14 | Winer | Jonathan | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41782 | 41782 | 2011-12-31 | 1991-09-03 | Kraus | Margery | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41786 | 41786 | 2011-12-31 | 2008-09-17 | Emond | Jessica | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41787 | 41787 | 2011-12-31 | 2008-09-17 | Matteucci | Rose | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41792 | 41792 | 2011-12-31 | 2001-10-17 | Namsrai | Ariuna | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
41794 | 41794 | 2011-12-31 | 2011-10-25 | Gregory | Jonathan | APCO Worldwide, Inc. 4561 | 1991-09-03 | APCO Worldwide, Inc. | 700 12th Street, NW | Suite 800 | Washington | DC | 20005 |
42042 | 42042 | 2016-12-31 | 2016-06-21 | Goldman | Kevin | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42053 | 42053 | 2016-12-31 | 2016-07-29 | Cohen | Neal M. | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42054 | 42054 | 2016-12-31 | 2016-07-29 | Scandling | Dan | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42055 | 42055 | 2016-12-31 | 2016-08-11 | Arlook | Eleanor | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42057 | 42057 | 2016-12-31 | 2016-08-26 | Faull | Benjamin | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42058 | 42058 | 2016-12-31 | 2016-08-26 | Rose | Mary Alice | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42059 | 42059 | 2016-12-31 | 2016-08-26 | Sanderman | Kenneth | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42060 | 42060 | 2016-12-31 | 2016-08-26 | Ungar | Breely | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42071 | 42071 | 2016-12-31 | 2016-10-19 | Leroy | Olivier | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42072 | 42072 | 2016-12-31 | 2016-10-19 | Patch | Alison | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42075 | 42075 | 2016-12-31 | 2016-11-10 | Guggenheim | Karen | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42076 | 42076 | 2016-12-31 | 2016-11-10 | Padgett | William Robert | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42077 | 42077 | 2016-12-31 | 2016-11-16 | Huyse | Kami | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42078 | 42078 | 2016-12-31 | 2016-11-16 | Pippert | Julie | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | Washington | DC | 20004 |
42080 | 42080 | 2016-12-31 | 2016-12-06 | Maitland | Samantha Dawn | APCO Worldwide, Inc. 6291 | 2015-04-28 | APCO Worldwide, Inc. | 1299 Pennsylvania Ave. NW | Suite 300 | 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]) );