FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
237 rows where Document_Type = "Short-Form" and Registrant_Name = "Fleishman-Hillard, Inc." sorted by Short_Form_Name
This data as json, CSV (advanced)
Registrant_Name 1
- Fleishman-Hillard, Inc. · 137 ✖
Foreign_Principal_Name 1
- - 137
Foreign_Principal_Country 1
- - 137
Document_Type 1
- Short-Form · 137 ✖
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name ▼ | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
96155 | 96155 | 2001-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Hubbard,Danley Thomas, Jr. | Available-FARA-Public-Office | ||
96156 | 96156 | 2001-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Hubbard,Danley Thomas, Jr. | Available-FARA-Public-Office | ||
40689 | 40689 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Hutchins, Coleman Roest | Available-FARA-Public-Office | ||
27885 | 27885 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Isaf, John K. | https://efile.fara.gov/docs/5801-Short-Form-20180314-216.pdf | ||
94990 | 94990 | 2000-09-01 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Isenhower,Anne | Available-FARA-Public-Office | ||
15774 | 15774 | 2022-02-11 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Jada, Amanda | https://efile.fara.gov/docs/5801-Short-Form-20220211-320.pdf | ||
65306 | 65306 | 2022-06-15 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Jada, Amanda | https://efile.fara.gov/docs/5801-Short-Form-20220615-326.pdf | ||
65307 | 65307 | 2022-06-15 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Jada, Amanda | https://efile.fara.gov/docs/5801-Short-Form-20220615-332.pdf | ||
96935 | 96935 | 2021-09-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Jada, Amanda | https://efile.fara.gov/docs/5801-Short-Form-20210910-312.pdf | ||
110329 | 110329 | 2022-10-21 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Jada, Amanda | https://efile.fara.gov/docs/5801-Short-Form-20221021-344.pdf | ||
10381 | 10381 | 2022-01-31 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Johnson, Byron E | https://efile.fara.gov/docs/5801-Short-Form-20220131-314.pdf | ||
97237 | 97237 | 2002-09-12 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Johnson,C. Donald | Available-FARA-Public-Office | ||
26711 | 26711 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Katell ,Andrew | Available-FARA-Public-Office | ||
27795 | 27795 | 2001-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Katell ,Andrew | Available-FARA-Public-Office | ||
97238 | 97238 | 2002-09-12 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Katell ,Andrew | Available-FARA-Public-Office | ||
26712 | 26712 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Keith,Ilina | Available-FARA-Public-Office | ||
67428 | 67428 | 2010-06-25 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Kershow, Madeleine | https://efile.fara.gov/docs/5801-Short-Form-20100625-122.pdf | ||
107531 | 107531 | 2010-10-08 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Kershow, Madeleine | https://efile.fara.gov/docs/5801-Short-Form-20101008-130.pdf | ||
95692 | 95692 | 1991-09-05 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Kim ,Howard G. | Available-FARA-Public-Office | ||
40690 | 40690 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Kincannon III, Benjamin Francis | Available-FARA-Public-Office | ||
96134 | 96134 | 1999-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Klein,Mara S. | Available-FARA-Public-Office | ||
67979 | 67979 | 2014-06-27 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Kramer, Hannah | https://efile.fara.gov/docs/5801-Short-Form-20140627-176.pdf | ||
55235 | 55235 | 2016-05-27 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Kunst, Molly | https://efile.fara.gov/docs/5801-Short-Form-20160527-182.pdf | ||
96135 | 96135 | 1999-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Lansdale ,Edward R. | Available-FARA-Public-Office | ||
99546 | 99546 | 2003-09-22 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Lansdale ,Edward R. | Available-FARA-Public-Office | ||
26713 | 26713 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Lashbrook,Brenda | Available-FARA-Public-Office | ||
98988 | 98988 | 2017-09-19 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Leong, Lonna | https://efile.fara.gov/docs/5801-Short-Form-20170919-200.pdf | ||
95693 | 95693 | 1991-09-05 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Levy ,Jill Anne | Available-FARA-Public-Office | ||
28432 | 28432 | 2009-03-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Licha, Rissig | https://efile.fara.gov/docs/5801-Short-Form-20090316-88.pdf | ||
65017 | 65017 | 2013-06-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Lowry, Kathleen | https://efile.fara.gov/docs/5801-Short-Form-20130614-160.pdf | ||
65018 | 65018 | 2013-06-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Lyall, Alexander | https://efile.fara.gov/docs/5801-Short-Form-20130614-162.pdf | ||
4549 | 4549 | 2014-01-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Maietta, Rosanna | https://efile.fara.gov/docs/5801-Short-Form-20140110-170.pdf | ||
27334 | 27334 | 2013-03-12 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Maietta, Rosanna | https://efile.fara.gov/docs/5801-Short-Form-20130312-154.pdf | ||
66435 | 66435 | 2011-06-21 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Maietta, Rosanna | https://efile.fara.gov/docs/5801-Short-Form-20110621-142.pdf | ||
26714 | 26714 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Martin,Kim S. | Available-FARA-Public-Office | ||
43622 | 43622 | 2009-04-28 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Matthews, Christopher L. | https://efile.fara.gov/docs/5801-Short-Form-20090428-94.pdf | ||
95665 | 95665 | 1989-09-05 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | McCabe, Ian Richard | Available-FARA-Public-Office | ||
99547 | 99547 | 2003-09-22 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | McGuinness,Katie | Available-FARA-Public-Office | ||
96174 | 96174 | 2007-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | McSherry, Michael T. | Available-FARA-Public-Office | ||
98989 | 98989 | 2017-09-19 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Mok, Martina | https://efile.fara.gov/docs/5801-Short-Form-20170919-202.pdf | ||
100053 | 100053 | 2007-09-24 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Moran, Kelly Coreen | Available-FARA-Public-Office | ||
107532 | 107532 | 2010-10-08 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Moritz, Janelle M. | https://efile.fara.gov/docs/5801-Short-Form-20101008-134.pdf | ||
52441 | 52441 | 2017-05-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Moroney, Michael | https://efile.fara.gov/docs/5801-Short-Form-20170516-190.pdf | ||
64610 | 64610 | 2017-06-12 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Moroney, Michael | https://efile.fara.gov/docs/5801-Short-Form-20170612-196.pdf | ||
26853 | 26853 | 2021-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Mulcahy, Sarah | https://efile.fara.gov/docs/5801-Short-Form-20210310-298.pdf | ||
66114 | 66114 | 2009-06-19 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Naru, Stephen R. | https://efile.fara.gov/docs/5801-Short-Form-20090619-98.pdf | ||
95694 | 95694 | 1991-09-05 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Neisloss ,Susan | Available-FARA-Public-Office | ||
32348 | 32348 | 2020-03-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Netto, Joseph | https://efile.fara.gov/docs/5801-Short-Form-20200330-242.pdf | ||
87653 | 87653 | 2020-08-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Netto, Joseph | https://efile.fara.gov/docs/5801-Short-Form-20200814-252.pdf | ||
63621 | 63621 | 2017-06-08 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Nolan, Bethany | https://efile.fara.gov/docs/5801-Short-Form-20170608-194.pdf | ||
26715 | 26715 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Novin,Helene | Available-FARA-Public-Office | ||
65019 | 65019 | 2013-06-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Ortiz, Eunic | https://efile.fara.gov/docs/5801-Short-Form-20130614-164.pdf | ||
27796 | 27796 | 2001-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Oyman,Idil | Available-FARA-Public-Office | ||
96157 | 96157 | 2001-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Oyman,Idil | Available-FARA-Public-Office | ||
99548 | 99548 | 2003-09-22 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Parentin,Cathy | Available-FARA-Public-Office | ||
26716 | 26716 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Parker,Amy M. | Available-FARA-Public-Office | ||
96136 | 96136 | 1999-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Parker,Amy M. | Available-FARA-Public-Office | ||
117498 | 117498 | 2017-11-04 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Perrien, Ainsley | https://efile.fara.gov/docs/5801-Short-Form-20171104-208.pdf | ||
3521 | 3521 | 2023-01-05 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Pierce, Margaret Hannaway | https://efile.fara.gov/docs/5801-Short-Form-20230105-352.pdf | ||
10382 | 10382 | 2022-01-31 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Pierce, Margaret Hannaway | https://efile.fara.gov/docs/5801-Short-Form-20220131-316.pdf | ||
110330 | 110330 | 2022-10-21 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Pierce, Margaret Hannaway | https://efile.fara.gov/docs/5801-Short-Form-20221021-340.pdf | ||
40691 | 40691 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Posner, Ralph | Available-FARA-Public-Office | ||
100054 | 100054 | 2007-09-24 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Posner, Ralph | Available-FARA-Public-Office | ||
96158 | 96158 | 2001-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Powell,Cynthia | Available-FARA-Public-Office | ||
65308 | 65308 | 2022-06-15 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Powers, Shelby L | https://efile.fara.gov/docs/5801-Short-Form-20220615-328.pdf | ||
96936 | 96936 | 2021-09-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Powers, Shelby L | https://efile.fara.gov/docs/5801-Short-Form-20210910-302.pdf | ||
26854 | 26854 | 2021-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Powers, Shelby Lynn | https://efile.fara.gov/docs/5801-Short-Form-20210310-300.pdf | ||
28152 | 28152 | 2018-03-15 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Prior, Melanie | https://efile.fara.gov/docs/5801-Short-Form-20180315-230.pdf | ||
67792 | 67792 | 2020-06-26 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rahman, Kamilla | https://efile.fara.gov/docs/5801-Short-Form-20200626-246.pdf | ||
6629 | 6629 | 2021-01-21 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rand, Amy | https://efile.fara.gov/docs/5801-Short-Form-20210121-272.pdf | ||
26855 | 26855 | 2021-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rand, Amy | https://efile.fara.gov/docs/5801-Short-Form-20210310-290.pdf | ||
96937 | 96937 | 2021-09-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rand, Amy | https://efile.fara.gov/docs/5801-Short-Form-20210910-310.pdf | ||
31474 | 31474 | 2002-03-28 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Rivera,Lori L. | Available-FARA-Public-Office | ||
120883 | 120883 | 2013-11-20 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rockenbach, Denise M. | https://efile.fara.gov/docs/5801-Short-Form-20131120-168.pdf | ||
40692 | 40692 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rohrer, Donna Weatherly | Available-FARA-Public-Office | ||
96159 | 96159 | 2001-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Rohrer,Donna | Available-FARA-Public-Office | ||
3778 | 3778 | 2023-01-06 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rose, Sheila | https://efile.fara.gov/docs/5801-Short-Form-20230106-356.pdf | ||
100668 | 100668 | 2017-09-26 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rose, Sheila | https://efile.fara.gov/docs/5801-Short-Form-20170926-206.pdf | ||
108600 | 108600 | 2020-10-13 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Sadlier, Lizanne | https://efile.fara.gov/docs/5801-Short-Form-20201013-268.pdf | ||
40693 | 40693 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Saharko, Juliet C. Johnson | Available-FARA-Public-Office | ||
9349 | 9349 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Sanchez, Nicole | https://efile.fara.gov/docs/5801-Short-Form-20210130-286.pdf | ||
96175 | 96175 | 2007-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Sandlin, Max A. | Available-FARA-Public-Office | ||
120067 | 120067 | 2022-11-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Scanlon, Sean | https://efile.fara.gov/docs/5801-Short-Form-20221116-348.pdf | ||
99549 | 99549 | 2003-09-22 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Schertzer,Patty | Available-FARA-Public-Office | ||
15775 | 15775 | 2022-02-11 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Schmidt, Michael T | https://efile.fara.gov/docs/5801-Short-Form-20220211-324.pdf | ||
26856 | 26856 | 2021-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Schmidt, Michael T | https://efile.fara.gov/docs/5801-Short-Form-20210310-296.pdf | ||
96938 | 96938 | 2021-09-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Schmidt, Michael T | https://efile.fara.gov/docs/5801-Short-Form-20210910-304.pdf | ||
32349 | 32349 | 2020-03-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Schmidt, Michael Thomas | https://efile.fara.gov/docs/5801-Short-Form-20200330-240.pdf | ||
87654 | 87654 | 2020-08-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Schmidt, Michael Thomas | https://efile.fara.gov/docs/5801-Short-Form-20200814-254.pdf | ||
67793 | 67793 | 2020-06-26 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Shaw, Steven | https://efile.fara.gov/docs/5801-Short-Form-20200626-250.pdf | ||
99550 | 99550 | 2003-09-22 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Shimoda,Kelly | Available-FARA-Public-Office | ||
32350 | 32350 | 2020-03-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Shull, Anna Marie | https://efile.fara.gov/docs/5801-Short-Form-20200330-244.pdf | ||
66115 | 66115 | 2009-06-19 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Sommerlath-Pizzi, Ann E. | https://efile.fara.gov/docs/5801-Short-Form-20090619-96.pdf | ||
40694 | 40694 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Spindler, Natasha | Available-FARA-Public-Office | ||
100055 | 100055 | 2007-09-24 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Story, Mark | Available-FARA-Public-Office | ||
32351 | 32351 | 2020-03-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Streich, William Joseph Brendan | https://efile.fara.gov/docs/5801-Short-Form-20200330-238.pdf | ||
122520 | 122520 | 2012-11-29 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Struthers, Jonathan | https://efile.fara.gov/docs/5801-Short-Form-20121129-148.pdf | ||
31475 | 31475 | 2002-03-28 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Sucar,Liana | Available-FARA-Public-Office | ||
110091 | 110091 | 2020-10-20 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Svehlak, Benjamin Taylor | https://efile.fara.gov/docs/5801-Short-Form-20201021-270.pdf | ||
96176 | 96176 | 2007-09-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Sweet, Paul | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );