FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
337 rows where Registrant_Name = "DLA Piper US LLP"
This data as json, CSV (advanced)
Foreign_Principal_Name 22
- - 221
- Palestine Monetary Authority 3
- Embassy of the Hellenic Republic 2
- Embassy of the United Arab Emirates 2
- Executive Office of Dubai 2
- Azerbaijan Railways CJSC 1
- Borse Dubai Limited 1
- Embassy of the Islamic Republic of Afghanistan 1
- Embassy of the United Kingdom 1
- German State of Rheinland-Pfalz 1
- Government of Afghanistan, Embassy 1
- Government of Bermuda 1
- Government of Turkey 1
- Government of Turkey, Embassy 1
- Government of the Democratic Republic of Timor-Leste 1
- Kingdom of Bahrain 1
- Kingdom of Saudi Arabia Ministry of Foreign Affairs 1
- Liberian International Ship and Corporate Registry (LISCR, LLC) 1
- PRONACOM (Programa Nacional de la Competitividad) 1
- Republic of Ecuador, Embassy 1
- Sheik Mohammed Bin Rashid Al Maktoum, Prime Minister and Vice President of the United Arab Emirates, et al 1
- The Royal Hashemite Court 1
Foreign_Principal_Country 17
- - 221
- UNITED ARAB EMIRATES 6
- PALESTINE 3
- AFGHANISTAN 2
- GREECE 2
- TURKEY 2
- AZERBAIJAN 1
- BAHRAIN 1
- BERMUDA 1
- ECUADOR 1
- GERMANY 1
- GUATEMALA 1
- JORDAN 1
- LIBERIA 1
- SAUDI ARABIA 1
- TIMOR-LESTE EAST TIMOR 1
- UNITED KINGDOM 1
Document_Type 5
- Short-Form 180
- Amendment 25
- Exhibit AB 21
- Supplemental Statement 16
- Informational Materials 5
Registrant_Name 1
- DLA Piper US LLP · 247 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
50518 | 50518 | 2007-05-09 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Gephardt, Richard | Available-FARA-Public-Office | ||
50814 | 50814 | 2007-05-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Government of Turkey | TURKEY | https://efile.fara.gov/docs/3712-Exhibit-AB-20070510-4.pdf | |
50815 | 50815 | 2007-05-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bernstein, Matthew | Available-FARA-Public-Office | ||
50816 | 50816 | 2007-05-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Gephardt, Richard | Available-FARA-Public-Office | ||
50817 | 50817 | 2007-05-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Jones, Lisa Langston | Available-FARA-Public-Office | ||
50818 | 50818 | 2007-05-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Merrigan, John A. | Available-FARA-Public-Office | ||
50819 | 50819 | 2007-05-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Pickup, James A. | Available-FARA-Public-Office | ||
50820 | 50820 | 2007-05-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Sanchez, Ignacio | Available-FARA-Public-Office | ||
52997 | 52997 | 2017-05-18 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20170518-25.pdf | |||
52998 | 52998 | 2017-05-18 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Embassy of the United Kingdom | UNITED KINGDOM | https://efile.fara.gov/docs/3712-Exhibit-AB-20170518-29.pdf | |
52999 | 52999 | 2017-05-18 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Halpert, James | https://efile.fara.gov/docs/3712-Short-Form-20170518-472.pdf | ||
53444 | 53444 | 2014-05-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20140520-17.pdf | |||
53445 | 53445 | 2014-05-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Kingdom of Bahrain | BAHRAIN | https://efile.fara.gov/docs/3712-Exhibit-AB-20140520-17.pdf | |
53446 | 53446 | 2014-05-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Daya, Christine | https://efile.fara.gov/docs/3712-Short-Form-20140520-376.pdf | ||
53447 | 53447 | 2014-05-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Levinson, Lawrence E. | https://efile.fara.gov/docs/3712-Short-Form-20140520-380.pdf | ||
53448 | 53448 | 2014-05-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Newcomb, Robert Richard | https://efile.fara.gov/docs/3712-Short-Form-20140520-378.pdf | ||
54183 | 54183 | 2013-05-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20130523-15.pdf | |||
54184 | 54184 | 2013-05-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Government of Bermuda | BERMUDA | https://efile.fara.gov/docs/3712-Exhibit-AB-20130523-16.pdf | |
54185 | 54185 | 2013-05-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Granwell, Alan Winston | https://efile.fara.gov/docs/3712-Short-Form-20130523-366.pdf | ||
54186 | 54186 | 2013-05-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Jurewicz, Witold | https://efile.fara.gov/docs/3712-Short-Form-20130523-368.pdf | ||
55763 | 55763 | 2007-05-29 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | LaBrache, Lisa | Available-FARA-Public-Office | ||
55764 | 55764 | 2007-05-29 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | McPherson, Harry C. | Available-FARA-Public-Office | ||
55765 | 55765 | 2007-05-29 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Meister, Brenda G. | Available-FARA-Public-Office | ||
56939 | 56939 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20160531-22.pdf | |||
56940 | 56940 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Kingdom of Saudi Arabia Ministry of Foreign Affairs | SAUDI ARABIA | https://efile.fara.gov/docs/3712-Exhibit-AB-20160531-22.pdf | |
56941 | 56941 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bell, Nathaniel | https://efile.fara.gov/docs/3712-Short-Form-20160531-430.pdf | ||
56942 | 56942 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bernstein, Matthew | https://efile.fara.gov/docs/3712-Short-Form-20160531-432.pdf | ||
56943 | 56943 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Boyd, Thomas | https://efile.fara.gov/docs/3712-Short-Form-20160531-434.pdf | ||
56944 | 56944 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Castle, Michael | https://efile.fara.gov/docs/3712-Short-Form-20160531-436.pdf | ||
56945 | 56945 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Merrigan, John A. | https://efile.fara.gov/docs/3712-Short-Form-20160531-438.pdf | ||
56946 | 56946 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Salem, George Richard | https://efile.fara.gov/docs/3712-Short-Form-20160531-440.pdf | ||
56947 | 56947 | 2016-05-31 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Woolley, Jessica S. | https://efile.fara.gov/docs/3712-Short-Form-20160531-442.pdf | ||
63900 | 63900 | 2017-06-09 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20170609-26.pdf | |||
64332 | 64332 | 2007-06-11 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bernhard, Berl | Available-FARA-Public-Office | ||
64333 | 64333 | 2007-06-11 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Campbell, Jean J. | Available-FARA-Public-Office | ||
64334 | 64334 | 2007-06-11 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Dilloff, Shani C. | Available-FARA-Public-Office | ||
64335 | 64335 | 2007-06-11 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Gans, Kiera S. | Available-FARA-Public-Office | ||
64336 | 64336 | 2007-06-11 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | LaBoissonniere, Lucie | Available-FARA-Public-Office | ||
64337 | 64337 | 2007-06-11 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Magill, Alix | Available-FARA-Public-Office | ||
64338 | 64338 | 2007-06-11 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Rohrscheib, Joshua G. | Available-FARA-Public-Office | ||
64339 | 64339 | 2007-06-11 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Zentay, John H. | Available-FARA-Public-Office | ||
67639 | 67639 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Executive Office of Dubai | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/3712-Exhibit-AB-20080626-9.pdf | |
67640 | 67640 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Antelo, Cristina | https://efile.fara.gov/docs/3712-Short-Form-20080626-256.pdf | ||
67641 | 67641 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bernstein, Matthew | https://efile.fara.gov/docs/3712-Short-Form-20080626-258.pdf | ||
67642 | 67642 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Keller, Jill Rebecca | https://efile.fara.gov/docs/3712-Short-Form-20080626-260.pdf | ||
67643 | 67643 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Koloski, Metodija A. | https://efile.fara.gov/docs/3712-Short-Form-20080626-262.pdf | ||
67644 | 67644 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Levinson, Lawrence E. | https://efile.fara.gov/docs/3712-Short-Form-20080626-264.pdf | ||
67645 | 67645 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Merrigan, John A. | https://efile.fara.gov/docs/3712-Short-Form-20080626-266.pdf | ||
67646 | 67646 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Phillips, Steven R. | https://efile.fara.gov/docs/3712-Short-Form-20080626-268.pdf | ||
67647 | 67647 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Salem, George Richard | https://efile.fara.gov/docs/3712-Short-Form-20080626-270.pdf | ||
67648 | 67648 | 2008-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Woolley, Jessica S. | https://efile.fara.gov/docs/3712-Short-Form-20080626-272.pdf | ||
67682 | 67682 | 2016-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20160626-23.pdf | |||
67683 | 67683 | 2016-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Government of the Democratic Republic of Timor-Leste | TIMOR-LESTE EAST TIMOR | https://efile.fara.gov/docs/3712-Exhibit-AB-20160626-27.pdf | |
67684 | 67684 | 2016-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bell, Nathaniel | https://efile.fara.gov/docs/3712-Short-Form-20160626-444.pdf | ||
67685 | 67685 | 2016-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bernstein, Matthew | https://efile.fara.gov/docs/3712-Short-Form-20160626-446.pdf | ||
67686 | 67686 | 2016-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Boyd, Thomas | https://efile.fara.gov/docs/3712-Short-Form-20160626-448.pdf | ||
67687 | 67687 | 2016-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Castle, Michael | https://efile.fara.gov/docs/3712-Short-Form-20160626-450.pdf | ||
67688 | 67688 | 2016-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Merrigan, John A. | https://efile.fara.gov/docs/3712-Short-Form-20160626-452.pdf | ||
67689 | 67689 | 2016-06-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Woolley, Jessica S. | https://efile.fara.gov/docs/3712-Short-Form-20160626-454.pdf | ||
68219 | 68219 | 2012-06-28 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20120628-14.pdf | |||
76312 | 76312 | 2008-07-15 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Jones, Lisa L. | https://efile.fara.gov/docs/3712-Short-Form-20080715-274.pdf | ||
76678 | 76678 | 2008-07-17 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-19410222-6.pdf | |||
76679 | 76679 | 2008-07-17 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20080717-7.pdf | |||
76680 | 76680 | 2008-07-17 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Government of Turkey, Embassy | TURKEY | https://efile.fara.gov/docs/3712-Exhibit-AB-20080717-10.pdf | |
76887 | 76887 | 2007-07-18 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Carelli, Nicole D. | Available-FARA-Public-Office | ||
76888 | 76888 | 2007-07-18 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Krantz, Sheldon | Available-FARA-Public-Office | ||
76889 | 76889 | 2007-07-18 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Messmer, Michael F. | Available-FARA-Public-Office | ||
78181 | 78181 | 2015-07-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20150723-20.pdf | |||
78182 | 78182 | 2015-07-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Palestine Monetary Authority | PALESTINE | https://efile.fara.gov/docs/3712-Exhibit-AB-20150723-20.pdf | |
78183 | 78183 | 2015-07-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Levinson, Lawrence E. | https://efile.fara.gov/docs/3712-Short-Form-20150723-400.pdf | ||
78184 | 78184 | 2015-07-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Newcomb, Robert Richard | https://efile.fara.gov/docs/3712-Short-Form-20150723-402.pdf | ||
78185 | 78185 | 2015-07-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Salem, George Richard | https://efile.fara.gov/docs/3712-Short-Form-20150723-404.pdf | ||
78207 | 78207 | 2019-07-23 | DLA Piper US LLP | DLA Piper US LLP 3712 | Informational Materials | Embassy of the Hellenic Republic | GREECE | https://efile.fara.gov/docs/3712-Informational-Materials-20190723-6.pdf | |
86567 | 86567 | 2007-08-09 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bauer, Dana | Available-FARA-Public-Office | ||
86568 | 86568 | 2007-08-09 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Borland, Lydia | Available-FARA-Public-Office | ||
86892 | 86892 | 2021-08-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20210810-38.pdf | |||
86893 | 86893 | 2021-08-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Liberian International Ship and Corporate Registry (LISCR, LLC) | LIBERIA | https://efile.fara.gov/docs/3712-Exhibit-AB-20210810-37.pdf | |
86894 | 86894 | 2021-08-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Newcomb, Robert Richard | https://efile.fara.gov/docs/3712-Short-Form-20210810-524.pdf | ||
86895 | 86895 | 2021-08-10 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Peyman, David | https://efile.fara.gov/docs/3712-Short-Form-20210810-522.pdf | ||
88843 | 88843 | 2007-08-21 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20070821-4.pdf | |||
88844 | 88844 | 2007-08-21 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Government of Afghanistan, Embassy | AFGHANISTAN | https://efile.fara.gov/docs/3712-Exhibit-AB-20070821-5.pdf | |
88908 | 88908 | 2017-08-21 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20170821-27.pdf | |||
88909 | 88909 | 2017-08-21 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Dove, Caroline | https://efile.fara.gov/docs/3712-Short-Form-20170821-474.pdf | ||
88910 | 88910 | 2017-08-21 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Footlik, Jay K. | https://efile.fara.gov/docs/3712-Short-Form-20170821-476.pdf | ||
89780 | 89780 | 2016-08-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20160826-24.pdf | |||
89781 | 89781 | 2016-08-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Republic of Ecuador, Embassy | ECUADOR | https://efile.fara.gov/docs/3712-Exhibit-AB-20160826-28.pdf | |
89782 | 89782 | 2016-08-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Migdail, Evan | https://efile.fara.gov/docs/3712-Short-Form-20160826-456.pdf | ||
89783 | 89783 | 2016-08-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Woolley, Jessica S. | https://efile.fara.gov/docs/3712-Short-Form-20160826-458.pdf | ||
95378 | 95378 | 2015-09-03 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Forgie, Anna | https://efile.fara.gov/docs/3712-Short-Form-20150903-406.pdf | ||
96201 | 96201 | 2016-09-07 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Simon, Anthony | https://efile.fara.gov/docs/3712-Short-Form-20160907-460.pdf | ||
96548 | 96548 | 2008-09-09 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Executive Office of Dubai | UNITED ARAB EMIRATES | https://efile.fara.gov/docs/3712-Exhibit-AB-20080909-11.pdf | |
99204 | 99204 | 2018-09-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20180920-30.pdf | |||
99205 | 99205 | 2018-09-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Exhibit AB | Embassy of the Islamic Republic of Afghanistan | AFGHANISTAN | https://efile.fara.gov/docs/3712-Exhibit-AB-20180920-30.pdf | |
99206 | 99206 | 2018-09-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bernstein, Matthew | https://efile.fara.gov/docs/3712-Short-Form-20180920-480.pdf | ||
99207 | 99207 | 2018-09-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Bernstein, Matthew | https://efile.fara.gov/docs/3712-Short-Form-20180920-486.pdf | ||
99208 | 99208 | 2018-09-20 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Woolley, Jessica S. | https://efile.fara.gov/docs/3712-Short-Form-20180920-482.pdf | ||
100593 | 100593 | 2008-09-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20080926-8.pdf | |||
100594 | 100594 | 2008-09-26 | DLA Piper US LLP | DLA Piper US LLP 3712 | Amendment | https://efile.fara.gov/docs/3712-Amendment-20080926-9.pdf | |||
100882 | 100882 | 2012-09-27 | DLA Piper US LLP | DLA Piper US LLP 3712 | Short-Form | Pickup, James | https://efile.fara.gov/docs/3712-Short-Form-20120927-360.pdf | ||
100883 | 100883 | 2012-09-27 | DLA Piper US LLP | DLA Piper US LLP 3712 | Supplemental Statement | https://efile.fara.gov/docs/3712-Supplemental-Statement-20120927-17.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]) );