FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
89 rows where Address_2 = "Suite 650"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 13
- TKC International, Inc. 26
- Global U.S.A., Inc. 20
- Clark & Weinstock 15
- Rokk Solutions, LLC 9
- Strategic Policy, Inc. 5
- kglobal LLC 4
- Venn Strategies, LLC 3
- Energy Resources International, Inc. 2
- Advance International Corporation 1
- Smith, E. Del 1
- Roth, L. James 1
- Gray Global Strategies, Inc. 1
- Playmaker Strategies, LLC 1
Registrant_Name 13
- TKC International, Inc. 26
- Global U.S.A., Inc. 20
- Clark & Weinstock 15
- Rokk Solutions, LLC 9
- Strategic Policy, Inc. 5
- kglobal LLC 4
- Venn Strategies, LLC 3
- Energy Resources International, Inc. 2
- Advance International Corporation 1
- Gray Global Strategies, Inc. 1
- Playmaker Strategies, LLC 1
- Roth, L. James 1
- Smith, E. Del 1
City 2
- Washington 88
- Miami 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4307 | 4307 | 1986-01-23 | 1983-10-18 | Paredes | Luis Fernando | Advance International Corporation 3530 | 1983-10-18 | Advance International Corporation | 7270 Northwest 12th Street | Suite 650 | Miami | FL | 33126 |
5015 | 5015 | 1987-01-31 | 1985-03-25 | Timmons | William E. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
5093 | 5093 | 1991-01-31 | 1990-10-05 | Saperstein | Natalie | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
5489 | 5489 | 2014-01-31 | 2012-07-23 | Gray III | William H. | Gray Global Strategies, Inc. 6116 | 2012-07-23 | Gray Global Strategies, Inc. | 300 New Jersey Avenue, NW | Suite 650 | Washington | DC | 20001 |
5763 | 5763 | 1989-02-01 | 1987-01-20 | Thompson | Marilyn Berry | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
6838 | 6838 | 1996-02-14 | 1993-01-19 | Denysyk | Bohdan | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
6839 | 6839 | 1996-02-14 | 1984-02-10 | Nugent | John M. , Jr. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
6841 | 6841 | 1996-02-14 | 1987-05-04 | Golwen | Anne H. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
6844 | 6844 | 1996-02-14 | 1988-06-14 | Kopp | George S. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
6849 | 6849 | 1996-02-14 | 1993-07-09 | Berkove | Naomi | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
6850 | 6850 | 1996-02-14 | 1993-07-09 | Brown | Rosamond S. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
6853 | 6853 | 1996-02-14 | 1992-07-31 | Bannerman | Edward R.M. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
7105 | 7105 | 1993-02-16 | 1992-04-06 | III | William M. Diefenderfer | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | 1615 L Street, N.W. | Suite 650 | Washington | DC | 20036 |
7106 | 7106 | 1993-02-16 | 1992-04-06 | Ryan | Thomas M. | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | 1615 L Street, N.W. | Suite 650 | Washington | DC | 20036 |
7349 | 7349 | 1992-02-21 | 1990-10-05 | Riendeau | Judith Goodwin | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
7474 | 7474 | 1995-02-23 | 1991-01-10 | Clash | Bruce R. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
7475 | 7475 | 1995-02-23 | 1994-03-09 | Selby | Steven K. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
7782 | 7782 | 1987-02-27 | 1987-01-20 | Gaudet | Anne R. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
8916 | 8916 | 2019-03-01 | 2018-09-10 | Meade | Thomas | Energy Resources International, Inc. 6590 | 2018-09-10 | Energy Resources International, Inc. | 1015 18th Street NW | Suite 650 | Washington | DC | 20012 |
8917 | 8917 | 2019-03-01 | 2018-09-10 | Supko | Eileen | Energy Resources International, Inc. 6590 | 2018-09-10 | Energy Resources International, Inc. | 1015 18th Street NW | Suite 650 | Washington | DC | 20012 |
10323 | 10323 | 1993-03-19 | 1990-10-05 | Signer | William A. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
12162 | 12162 | 2014-03-31 | 2013-10-31 | Silverman | Stephanie | Venn Strategies, LLC 6110 | 2012-06-14 | Venn Strategies, LLC | 805 15th Street, NW | Suite 650 | Washington | DC | 20005 |
16618 | 16618 | 1995-05-17 | 1993-11-08 | Smith | E. Del | Smith, E. Del 4867 | 1993-11-08 | Smith, E. Del | 1130 Connecticut Avenue, N.W. | Suite 650 | Washington | DC | 20036 |
17938 | 17938 | 2000-05-31 | 1998-11-16 | Roth | L. James | Roth, L. James 5288 | 1998-11-16 | Roth, L. James | 2121 K Street N.W. | Suite 650 | Washington | DC | 20037 |
18063 | 18063 | 2010-05-31 | 2012-01-06 | D'Arcy | Christopher | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
18064 | 18064 | 2010-05-31 | 2009-02-17 | Kutler | Ed | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
18065 | 18065 | 2010-05-31 | 2009-02-17 | Stuart | Sandra K. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
18066 | 18066 | 2010-05-31 | 2009-03-06 | Weber | John Vincent | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
18079 | 18079 | 2010-05-31 | 2009-11-12 | Godes | Niles L. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
18080 | 18080 | 2010-05-31 | 2009-11-12 | Hotmire | Erik J. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
18081 | 18081 | 2010-05-31 | 2009-11-12 | Schwantes | Jonathan R. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
19293 | 19293 | 1986-06-12 | 1982-02-02 | James | Clarence L. , Jr. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
19572 | 19572 | 1993-06-15 | 1986-07-14 | Fierce | Donald L. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
21616 | 21616 | 2009-06-30 | 2009-02-17 | D'Arcy | Christopher | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21617 | 21617 | 2009-06-30 | 2009-02-17 | O'Hanlon | G. John | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21618 | 21618 | 2009-06-30 | 2009-02-17 | Edwards | Melissa M. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21619 | 21619 | 2009-06-30 | 2009-02-17 | Farmer | Kimberley | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21620 | 21620 | 2009-06-30 | 2009-02-17 | Lobo | Paul | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21621 | 21621 | 2009-06-30 | 2009-02-17 | Noone | James A. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21622 | 21622 | 2009-06-30 | 2009-02-17 | Speed | Tonya M. | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
21623 | 21623 | 2009-06-30 | 2009-02-17 | West | Fowler | Clark & Weinstock 5914 | 2009-03-06 | Clark & Weinstock | 701 8th Street, NW | Suite 650 | Washington | DC | 20001 |
23066 | 23066 | 1997-07-13 | 1989-01-13 | Merkin | William S. | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | 1615 L Street, N.W. | Suite 650 | Washington | DC | 20036 |
23068 | 23068 | 1997-07-13 | 1993-02-16 | Levine | Kenneth S. | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | 1615 L Street, N.W. | Suite 650 | Washington | DC | 20036 |
23069 | 23069 | 1997-07-13 | 1994-03-21 | Moffett | Anthony John , Jr. | Strategic Policy, Inc. 4206 | 1989-01-13 | Strategic Policy, Inc. | 1615 L Street, N.W. | Suite 650 | Washington | DC | 20036 |
23106 | 23106 | 1986-07-14 | 1986-07-24 | Wilson | Deborah Fry | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
23571 | 23571 | 2019-07-18 | 2019-06-21 | Farha | Michel | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
23572 | 23572 | 2019-07-18 | 2019-06-21 | Hughes | Ryan | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
23573 | 23573 | 2019-07-18 | 2019-06-21 | Paustenbach | Mark | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
23574 | 23574 | 2019-07-18 | 2019-06-21 | Singleton | Lindsay | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
23575 | 23575 | 2019-07-18 | 2015-09-29 | Bonjean | Ron | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
23576 | 23576 | 2019-07-18 | 2015-09-29 | Mollineau | Rodell | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
23577 | 23577 | 2019-07-18 | 2019-10-04 | Brooks | Cristina | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
23578 | 23578 | 2019-07-18 | 2019-10-04 | Yeager | Samantha | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
24309 | 24309 | 1993-07-28 | 1987-06-10 | Dresen | Anna-Maria | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
25874 | 25874 | 1993-08-03 | 1992-04-27 | Gross | Margaret | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
25876 | 25876 | 1993-08-03 | 1984-08-02 | Roberts | William A. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
25978 | 25978 | 1986-08-05 | 1986-06-17 | McIntosh | Joanna K. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
27708 | 27708 | 1991-08-29 | 1990-10-03 | Anderson | Stanton D. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
28096 | 28096 | 1986-08-31 | 1985-03-13 | Conkling | Robert J. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
29867 | 29867 | 1992-09-15 | 1986-01-31 | Denysyk | Bohdan | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
30124 | 30124 | 1990-09-20 | 1986-01-23 | Morris | William H. , Jr. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
30963 | 30963 | 1984-09-30 | 1981-04-07 | Bacha | Robert A. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
32949 | 32949 | 2012-10-15 | 2012-08-03 | O'Connor | Christine | Venn Strategies, LLC 6110 | 2012-06-14 | Venn Strategies, LLC | 805 15th Street, NW | Suite 650 | Washington | DC | 20005 |
33008 | 33008 | 1984-10-16 | 1982-02-02 | Rees | Joseph M. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
34423 | 34423 | 1999-10-31 | 1991-08-06 | Keefe | Kevin S. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
34722 | 34722 | 2018-10-31 | 2015-09-29 | Walsh | Brian J. | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
35843 | 35843 | 1984-11-15 | 1984-02-11 | Pfautch | Roy | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
36375 | 36375 | 1992-11-25 | 1992-11-09 | Brown | Michael Arrington | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
36657 | 36657 | 1983-11-30 | 1983-06-24 | Waldmann | Raymond J. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
37075 | 37075 | 2016-11-30 | 2016-09-14 | DeCleene | Randy | kglobal LLC 6374 | 2016-09-14 | kglobal LLC | 2001 L Street, NW | Suite 650 | Washington | DC | 20036 |
37076 | 37076 | 2016-11-30 | 2016-09-14 | Dolan | Charles | kglobal LLC 6374 | 2016-09-14 | kglobal LLC | 2001 L Street, NW | Suite 650 | Washington | DC | 20036 |
37077 | 37077 | 2016-11-30 | 2016-09-14 | Nuber | Jenny | kglobal LLC 6374 | 2016-09-14 | kglobal LLC | 2001 L Street, NW | Suite 650 | Washington | DC | 20036 |
37078 | 37078 | 2016-11-30 | 2016-09-14 | Pikulsky III | Theodore T. | kglobal LLC 6374 | 2016-09-14 | kglobal LLC | 2001 L Street, NW | Suite 650 | Washington | DC | 20036 |
37118 | 37118 | 2018-11-30 | 2017-11-09 | Feraci | Manning | Playmaker Strategies, LLC 6487 | 2017-11-09 | Playmaker Strategies, LLC | 750 Ninth Street, NW | Suite 650 | Washington | DC | 20001 |
37351 | 37351 | 1981-12-01 | 1979-12-13 | Hickman | Bert Ingalls , Jr. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
37387 | 37387 | 1986-12-01 | 1985-07-01 | Collins | W. Patrick | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
37408 | 37408 | 1990-12-01 | 1987-03-27 | Slade | Jonathan Blair | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38052 | 38052 | 1999-12-10 | 1998-11-06 | Hayes | Tammi Lee | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38246 | 38246 | 1999-12-13 | 1995-01-25 | Koelemay | J. Douglas | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38247 | 38247 | 1999-12-13 | 1994-03-09 | Southworth | Rachel | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38248 | 38248 | 1999-12-13 | 1988-07-13 | Guerra-Mondragon | Gabriel | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38249 | 38249 | 1999-12-13 | 1992-10-09 | Humphrey | Deidre D. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38250 | 38250 | 1999-12-13 | 1979-12-13 | Keefe | Robert J. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38308 | 38308 | 1995-12-14 | 1994-09-07 | Shackelford | Lottie H. | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38387 | 38387 | 1982-12-15 | 1981-07-27 | Razavi | Tema J. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38829 | 38829 | 1994-12-20 | 1982-02-02 | II | Terrence M. O'Connell | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
38991 | 38991 | 1984-12-23 | 1983-06-24 | Farrell | J. Michael | Global U.S.A., Inc. 3489 | 1983-06-24 | Global U.S.A., Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
40504 | 40504 | 1988-12-31 | 1985-07-01 | Shelby | Richard D. | TKC International, Inc. 3075 | 1979-12-13 | TKC International, Inc. | 2121 K Street, N.W. | Suite 650 | Washington | DC | 20037 |
41822 | 41822 | 2012-12-31 | 2012-06-14 | Silverman | Stephanie | Venn Strategies, LLC 6110 | 2012-06-14 | Venn Strategies, LLC | 805 15th Street, NW | Suite 650 | Washington | DC | 20005 |
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]) );