FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
206 rows where Foreign_Principal_Country = "" and Registrant_Name = "HOGAN & HARTSON, L.L.P." sorted by Date_Stamped
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|
10630 | 10630 | 1971-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Registration Statement | Available-FARA-Public-Office | |||
26336 | 26336 | 1971-03-09 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | EDWARD A. MCDERMOTT | Available-FARA-Public-Office | ||
26599 | 26599 | 1971-03-10 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | BOB G. ODLE | Available-FARA-Public-Office | ||
28329 | 28329 | 1971-03-16 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | JEROME N. SONOSKY | Available-FARA-Public-Office | ||
45545 | 45545 | 1971-05-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19710501-CZC68903.pdf | |||
45546 | 45546 | 1971-05-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19710501-CZC68E03.pdf | |||
45547 | 45547 | 1971-05-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19710501-CZC68J03.pdf | |||
49901 | 49901 | 1971-05-07 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | ANTHONY S. HARRINGTON | Available-FARA-Public-Office | ||
49902 | 49902 | 1971-05-07 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | EDWARD A. MCDERMOTT | Available-FARA-Public-Office | ||
81724 | 81724 | 1971-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19710801-CZC67C03.pdf | |||
91775 | 91775 | 1971-09-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19710901-CZC67803.pdf | |||
10652 | 10652 | 1972-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19720201-CZC66A03.pdf | |||
33766 | 33766 | 1972-04-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19720401-CZC66203.pdf | |||
81751 | 81751 | 1972-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19720801-CZC65403.pdf | |||
10692 | 10692 | 1973-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19730201-CZC64403.pdf | |||
81801 | 81801 | 1973-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19730801-CZC63703.pdf | |||
10730 | 10730 | 1974-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19740201-CZC61Y03.pdf | |||
81843 | 81843 | 1974-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19740801-CZC60P03.pdf | |||
10763 | 10763 | 1975-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19750201-CZC5ZM03.pdf | |||
81895 | 81895 | 1975-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19750801-CZC5Y603.pdf | |||
340 | 340 | 1976-01-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | J. WILLIAM FULBRIGHT | Available-FARA-Public-Office | ||
10794 | 10794 | 1976-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19760201-CZC5DI03.pdf | |||
26094 | 26094 | 1976-03-08 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | A. LINWOOD HOLTON, JR. | Available-FARA-Public-Office | ||
26095 | 26095 | 1976-03-08 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | ROBERT E. MONTGOMERY, JR. | Available-FARA-Public-Office | ||
81935 | 81935 | 1976-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | J. WILLIAM FULBRIGHT | Available-FARA-Public-Office | ||
81936 | 81936 | 1976-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19760801-CZC5C903.pdf | |||
103173 | 103173 | 1976-10-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19761001-CZC5BT03.pdf | |||
103174 | 103174 | 1976-10-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19761001-CZC5BY03.pdf | |||
103175 | 103175 | 1976-10-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19761001-CZC6AM03.pdf | |||
103176 | 103176 | 1976-10-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19761001-CZC6AU03.pdf | |||
103177 | 103177 | 1976-10-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19761001-CZDCQC02.pdf | |||
10834 | 10834 | 1977-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19770201-CZC69D03.pdf | |||
81978 | 81978 | 1977-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19770801-CZDCP502.pdf | |||
98113 | 98113 | 1977-09-16 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | A. LINWOOD HOLTON, JR. | Available-FARA-Public-Office | ||
98114 | 98114 | 1977-09-16 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | ARTHUR J. ROTHKOPF | Available-FARA-Public-Office | ||
98115 | 98115 | 1977-09-16 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | BOB GLEN ODLE | Available-FARA-Public-Office | ||
10881 | 10881 | 1978-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19780201-CZC4XA03.pdf | |||
82024 | 82024 | 1978-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19780801-CZC4YK03.pdf | |||
10931 | 10931 | 1979-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19790201-CZC4YF03.pdf | |||
10932 | 10932 | 1979-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19790201-CZC4W003.pdf | |||
55685 | 55685 | 1979-05-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | BOB GLEN ODLE | Available-FARA-Public-Office | ||
55686 | 55686 | 1979-05-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | JAMES A. STUBER | Available-FARA-Public-Office | ||
82072 | 82072 | 1979-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19790801-CZC59203.pdf | |||
10988 | 10988 | 1980-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19800201-CZC57W03.pdf | |||
82120 | 82120 | 1980-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19800801-CZC56R03.pdf | |||
103438 | 103438 | 1980-10-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19801001-CZC55Q03.pdf | |||
114414 | 114414 | 1980-11-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19801101-CZC54T03.pdf | |||
11037 | 11037 | 1981-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19810201-CZDDJR02.pdf | |||
82177 | 82177 | 1981-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19810801-CZC53L03.pdf | |||
11113 | 11113 | 1982-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19820201-CZC52D03.pdf | |||
82252 | 82252 | 1982-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19820801-CZC51403.pdf | |||
11192 | 11192 | 1983-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19830201-CZC4ZP03.pdf | |||
82322 | 82322 | 1983-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19830801-CZC4US03.pdf | |||
11293 | 11293 | 1984-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19840201-CZC4TF03.pdf | |||
82396 | 82396 | 1984-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19840801-CZC4Q703.pdf | |||
926 | 926 | 1985-01-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19850101-CZC4OI03.pdf | |||
11378 | 11378 | 1985-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19850201-CZC4OR03.pdf | |||
82481 | 82481 | 1985-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19850801-CZDDHR02.pdf | |||
118329 | 118329 | 1985-11-09 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | ARTHUR J. ROTHKOPF | Available-FARA-Public-Office | ||
118330 | 118330 | 1985-11-09 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | EDWARD A. MCDERMOTT | Available-FARA-Public-Office | ||
11495 | 11495 | 1986-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19860201-CZC4N203.pdf | |||
82594 | 82594 | 1986-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19860801-CZC4LM03.pdf | |||
11610 | 11610 | 1987-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19870201-CZC4K703.pdf | |||
59375 | 59375 | 1987-06-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | CLIFFORD S. GIBBONS | Available-FARA-Public-Office | ||
75015 | 75015 | 1987-07-10 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | CLIFFORD S. GIBBONS | Available-FARA-Public-Office | ||
75016 | 75016 | 1987-07-10 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | MARK S. MCCONNELL | Available-FARA-Public-Office | ||
82738 | 82738 | 1987-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19870801-CZC5Z603.pdf | |||
82740 | 82740 | 1987-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | MARK S. MCCONNELL | Available-FARA-Public-Office | ||
82741 | 82741 | 1987-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19870801-CZC46U03.pdf | |||
86704 | 86704 | 1987-08-10 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | CHESTER D. TAYLOR, JR. | Available-FARA-Public-Office | ||
119154 | 119154 | 1987-11-13 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | ARTHUR J. ROTHKOPF | Available-FARA-Public-Office | ||
119155 | 119155 | 1987-11-13 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | CLIFFORD S. GIBBONS | Available-FARA-Public-Office | ||
119156 | 119156 | 1987-11-13 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | JOHN S. STANTON | Available-FARA-Public-Office | ||
11762 | 11762 | 1988-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19880201-CZC3N703.pdf | |||
22110 | 22110 | 1988-03-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19880301-CZC3R903.pdf | |||
22111 | 22111 | 1988-03-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19880301-CZC4EJ03.pdf | |||
27977 | 27977 | 1988-03-15 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | ARNOLD C. JOHNSON | Available-FARA-Public-Office | ||
31692 | 31692 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | ALPHONSO AUGUSTINE CHRISTIAN, II | Available-FARA-Public-Office | ||
31693 | 31693 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | C. STEPHEN LAWRENCE | Available-FARA-Public-Office | ||
31694 | 31694 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | CHESTER D. TAYLOR, JR. | Available-FARA-Public-Office | ||
31695 | 31695 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | CLIFFORD S. GIBBONS | Available-FARA-Public-Office | ||
31696 | 31696 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | GEORGE U. CARNEAL | Available-FARA-Public-Office | ||
31697 | 31697 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | GERALD E. GILBERT | Available-FARA-Public-Office | ||
31698 | 31698 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | JOHN S. STANTON | Available-FARA-Public-Office | ||
31699 | 31699 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | MARK S. MCCONNELL | Available-FARA-Public-Office | ||
31700 | 31700 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | PAUL G. ROGERS | Available-FARA-Public-Office | ||
31701 | 31701 | 1988-03-29 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | ROBERT J. ELLIOTT | Available-FARA-Public-Office | ||
82882 | 82882 | 1988-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19880801-CZC3TY03.pdf | |||
93080 | 93080 | 1988-09-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19880901-CZC3VX03.pdf | |||
93081 | 93081 | 1988-09-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | MARK S. MCCONNELL | Available-FARA-Public-Office | ||
115102 | 115102 | 1988-11-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19881101-CZC3TM03.pdf | |||
11901 | 11901 | 1989-02-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19890201-CZC3RL03.pdf | |||
22277 | 22277 | 1989-03-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19890301-CZC45R03.pdf | |||
35069 | 35069 | 1989-04-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19890401-CZC45F03.pdf | |||
46818 | 46818 | 1989-05-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19890501-CZC45303.pdf | |||
46820 | 46820 | 1989-05-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Short-Form | PATRICK M. RAHER | Available-FARA-Public-Office | ||
71843 | 71843 | 1989-07-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19890701-CZC44J03.pdf | |||
83016 | 83016 | 1989-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19890801-CZC46F03.pdf | |||
83017 | 83017 | 1989-08-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Supplemental Statement | https://efile.fara.gov/docs/2244-Supplemental-Statement-19890801-CZC42E03.pdf | |||
93278 | 93278 | 1989-09-01 | HOGAN & HARTSON, L.L.P. | Hogan Lovells US LLP 2244 | Amendment | https://efile.fara.gov/docs/2244-Amendment-19890901-CZD7OE02.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]) );