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 Foreign_Principal_Country
This data as json, CSV (advanced)
Suggested facets: Date_Stamped (date)
These facets timed out: Document_Type, Registrant_Name
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country ▼ | URL |
---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
4548 | 4548 | 2014-01-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Black, William | https://efile.fara.gov/docs/5801-Short-Form-20140110-172.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 | ||
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 | ||
9342 | 9342 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Adolph, Michael Charles | https://efile.fara.gov/docs/5801-Short-Form-20210130-282.pdf | ||
9343 | 9343 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Belding, Arman | https://efile.fara.gov/docs/5801-Short-Form-20210130-274.pdf | ||
9344 | 9344 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Bernard, Mikael | https://efile.fara.gov/docs/5801-Short-Form-20210130-284.pdf | ||
9345 | 9345 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Bueno, Alexander de la Torre | https://efile.fara.gov/docs/5801-Short-Form-20210130-276.pdf | ||
9346 | 9346 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Franklin, James Nikolai | https://efile.fara.gov/docs/5801-Short-Form-20210130-280.pdf | ||
9347 | 9347 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Graziano, Devon | https://efile.fara.gov/docs/5801-Short-Form-20210130-278.pdf | ||
9348 | 9348 | 2021-01-30 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Heibeck, Olivia | https://efile.fara.gov/docs/5801-Short-Form-20210130-288.pdf | ||
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 | ||
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 | ||
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 | ||
10383 | 10383 | 2022-01-31 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Williams, Timothy Robert | https://efile.fara.gov/docs/5801-Short-Form-20220131-318.pdf | ||
15773 | 15773 | 2022-02-11 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Hart, Colin M | https://efile.fara.gov/docs/5801-Short-Form-20220211-322.pdf | ||
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 | ||
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 | ||
25888 | 25888 | 2003-03-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Franco,Nathalia | Available-FARA-Public-Office | ||
25889 | 25889 | 2003-03-07 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Vink,Graham | Available-FARA-Public-Office | ||
26705 | 26705 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Batalla,Yvette | Available-FARA-Public-Office | ||
26706 | 26706 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Davenport,Rory | Available-FARA-Public-Office | ||
26707 | 26707 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Gamboa,Juan Carlos | Available-FARA-Public-Office | ||
26708 | 26708 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Glidden ,Julia A. | Available-FARA-Public-Office | ||
26709 | 26709 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Glidden ,Julia A. | Available-FARA-Public-Office | ||
26710 | 26710 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Gonzalez-Robiou,Georgina | Available-FARA-Public-Office | ||
26711 | 26711 | 2000-03-10 | 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 | ||
26713 | 26713 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Lashbrook,Brenda | Available-FARA-Public-Office | ||
26714 | 26714 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Martin,Kim S. | Available-FARA-Public-Office | ||
26715 | 26715 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Novin,Helene | 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 | ||
26717 | 26717 | 2000-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Yacker,Jeffrey | Available-FARA-Public-Office | ||
26852 | 26852 | 2021-03-10 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Dillman, Jesse | https://efile.fara.gov/docs/5801-Short-Form-20210310-294.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 | ||
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 | ||
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 | ||
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 | ||
27333 | 27333 | 2013-03-12 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Auchman, Caren | https://efile.fara.gov/docs/5801-Short-Form-20130312-150.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 | ||
27335 | 27335 | 2013-03-12 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Weintraub, Jeffrey R. | https://efile.fara.gov/docs/5801-Short-Form-20130312-152.pdf | ||
27794 | 27794 | 2001-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Goodman,Alan | Available-FARA-Public-Office | ||
27795 | 27795 | 2001-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Katell ,Andrew | Available-FARA-Public-Office | ||
27796 | 27796 | 2001-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Oyman,Idil | Available-FARA-Public-Office | ||
27797 | 27797 | 2001-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Werner,Anne | Available-FARA-Public-Office | ||
27798 | 27798 | 2001-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | de Villegas,Jorge Diaz | Available-FARA-Public-Office | ||
27879 | 27879 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Adolph, Michael Charles | https://efile.fara.gov/docs/5801-Short-Form-20180314-226.pdf | ||
27880 | 27880 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Albright, Erin | https://efile.fara.gov/docs/5801-Short-Form-20180314-224.pdf | ||
27881 | 27881 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Choi, Michelle | https://efile.fara.gov/docs/5801-Short-Form-20180314-210.pdf | ||
27882 | 27882 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Demashkieh, Diala | https://efile.fara.gov/docs/5801-Short-Form-20180314-222.pdf | ||
27883 | 27883 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Flaster, Samuel Grant | https://efile.fara.gov/docs/5801-Short-Form-20180314-220.pdf | ||
27884 | 27884 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Francomano, Sarah | https://efile.fara.gov/docs/5801-Short-Form-20180314-218.pdf | ||
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 | ||
27886 | 27886 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Tanguay, Randi | https://efile.fara.gov/docs/5801-Short-Form-20180314-214.pdf | ||
27887 | 27887 | 2018-03-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Tornifoglio, Jillian | https://efile.fara.gov/docs/5801-Short-Form-20180314-212.pdf | ||
28151 | 28151 | 2018-03-15 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Hollyer, Luke | https://efile.fara.gov/docs/5801-Short-Form-20180315-232.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 | ||
28153 | 28153 | 2018-03-15 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Thom, Amy | https://efile.fara.gov/docs/5801-Short-Form-20180315-228.pdf | ||
28430 | 28430 | 2009-03-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Cutin, Dario O. | https://efile.fara.gov/docs/5801-Short-Form-20090316-90.pdf | ||
28431 | 28431 | 2009-03-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Doering, Matthew J. | https://efile.fara.gov/docs/5801-Short-Form-20090316-86.pdf | ||
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 | ||
30452 | 30452 | 2009-03-24 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Capel, Rodney S. | https://efile.fara.gov/docs/5801-Short-Form-20090324-92.pdf | ||
30709 | 30709 | 2011-03-25 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Auchman, Caren | https://efile.fara.gov/docs/5801-Short-Form-20110325-140.pdf | ||
30710 | 30710 | 2011-03-25 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Whiting, Jr, David Smythe | https://efile.fara.gov/docs/5801-Short-Form-20110325-138.pdf | ||
31473 | 31473 | 2002-03-28 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Collender,Stanley E. | Available-FARA-Public-Office | ||
31474 | 31474 | 2002-03-28 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Rivera,Lori L. | Available-FARA-Public-Office | ||
31475 | 31475 | 2002-03-28 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 3774 | Short-Form | Sucar,Liana | 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 | ||
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 | ||
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 | ||
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 | ||
40684 | 40684 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Boudreau, Martha Miller | Available-FARA-Public-Office | ||
40685 | 40685 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Checeanu, Camelia Cristina | Available-FARA-Public-Office | ||
40686 | 40686 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Church, Cynthia Renee | Available-FARA-Public-Office | ||
40687 | 40687 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Dionne, Marc | Available-FARA-Public-Office | ||
40688 | 40688 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Edwards, Samantha A. | 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 | ||
40690 | 40690 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Kincannon III, Benjamin Francis | Available-FARA-Public-Office | ||
40691 | 40691 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Posner, Ralph | Available-FARA-Public-Office | ||
40692 | 40692 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Rohrer, Donna Weatherly | Available-FARA-Public-Office | ||
40693 | 40693 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Saharko, Juliet C. Johnson | Available-FARA-Public-Office | ||
40694 | 40694 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Spindler, Natasha | Available-FARA-Public-Office | ||
40695 | 40695 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Viorst, Marla Rigel | Available-FARA-Public-Office | ||
40696 | 40696 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Weintraub, Jeffrey R. | Available-FARA-Public-Office | ||
40697 | 40697 | 2007-04-16 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Westermann, Carolyn Cawley | 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 | ||
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 | ||
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 | ||
63620 | 63620 | 2017-06-08 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Hancock, Katy | https://efile.fara.gov/docs/5801-Short-Form-20170608-192.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 | ||
63875 | 63875 | 2015-06-09 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Cosar, Yagmur | https://efile.fara.gov/docs/5801-Short-Form-20150609-180.pdf | ||
64367 | 64367 | 2012-06-11 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Whiting Jr, David S | https://efile.fara.gov/docs/5801-Short-Form-20120611-144.pdf | ||
64368 | 64368 | 2012-06-11 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Whiting Jr, David Smythe | https://efile.fara.gov/docs/5801-Short-Form-20120611-146.pdf | ||
64609 | 64609 | 2017-06-12 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Gupta, Mrinalini | https://efile.fara.gov/docs/5801-Short-Form-20170612-198.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 | ||
65015 | 65015 | 2013-06-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Balderston, Kris | https://efile.fara.gov/docs/5801-Short-Form-20130614-156.pdf | ||
65016 | 65016 | 2013-06-14 | Fleishman-Hillard, Inc. | Fleishman-Hillard, Inc. 5801 | Short-Form | Houk, Ashley | https://efile.fara.gov/docs/5801-Short-Form-20130614-158.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 |
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]) );