FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
123 rows where Registration_Number = 3777 sorted by Document_Type
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type ▼ | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
1327 | 1327 | 1988-01-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880101-D15GB301.pdf | |||
1328 | 1328 | 1988-01-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880101-D15GBZ01.pdf | |||
2587 | 2587 | 1993-01-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19930101-D159FV01.pdf | |||
22170 | 22170 | 1988-03-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880301-D15G8N01.pdf | |||
22171 | 22171 | 1988-03-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880301-D15G9C01.pdf | |||
22172 | 22172 | 1988-03-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880301-D15GAU01.pdf | |||
22337 | 22337 | 1989-03-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19890301-D15G2L01.pdf | |||
34964 | 34964 | 1988-04-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880401-D15G8601.pdf | |||
34965 | 34965 | 1988-04-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880401-D15G8F01.pdf | |||
35746 | 35746 | 1991-04-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19910401-D155UT01.pdf | |||
35747 | 35747 | 1991-04-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19910401-D15EFM01.pdf | |||
35748 | 35748 | 1991-04-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19910401-D15EG601.pdf | |||
46722 | 46722 | 1988-05-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880501-D15GID01.pdf | |||
46723 | 46723 | 1988-05-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880501-D15GJS01.pdf | |||
46724 | 46724 | 1988-05-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880501-D15GK101.pdf | |||
60371 | 60371 | 1991-06-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19910601-D1625K01.pdf | |||
71778 | 71778 | 1988-07-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19880701-D15FR801.pdf | |||
82804 | 82804 | 1987-08-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19870801-D15GFO01.pdf | |||
82805 | 82805 | 1987-08-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19870801-D15GFX01.pdf | |||
83090 | 83090 | 1989-08-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19890801-D15FYQ01.pdf | |||
83091 | 83091 | 1989-08-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19890801-D15FZF01.pdf | |||
93368 | 93368 | 1989-09-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19890901-D15ER301.pdf | |||
105034 | 105034 | 1991-10-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19911001-D14YVM01.pdf | |||
105035 | 105035 | 1991-10-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19911001-D14YWH01.pdf | |||
105036 | 105036 | 1991-10-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19911001-D14Z0K01.pdf | |||
115152 | 115152 | 1988-11-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19881101-D15G3E01.pdf | |||
126274 | 126274 | 1989-12-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19891201-D15EQM01.pdf | |||
126275 | 126275 | 1989-12-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Amendment | https://efile.fara.gov/docs/3777-Amendment-19891201-D15EQU01.pdf | |||
12768 | 12768 | 1992-02-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19920201-D152C401.pdf | |||
12769 | 12769 | 1992-02-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19920201-D152CD01.pdf | |||
72352 | 72352 | 1991-07-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19910701-D14ZH901.pdf | |||
72353 | 72353 | 1991-07-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19910701-D14ZHF01.pdf | |||
94349 | 94349 | 1992-09-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19920901-D1574O01.pdf | |||
94350 | 94350 | 1992-09-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19920901-D1574X01.pdf | |||
94873 | 94873 | 1993-09-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19930901-D156RJ01.pdf | |||
94874 | 94874 | 1993-09-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19930901-D156SE01.pdf | |||
105037 | 105037 | 1991-10-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19911001-D14ZLH01.pdf | |||
105038 | 105038 | 1991-10-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Dissemination Report | https://efile.fara.gov/docs/3777-Dissemination-Report-19911001-D14ZLQ01.pdf | |||
1209 | 1209 | 1987-01-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | CAMPAIGN OF CORAZON AQUINO | PHILIPPINES | https://efile.fara.gov/docs/3777-Exhibit-AB-19870101-D15GHT01.pdf | |
7626 | 7626 | 1988-01-26 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | CENTRAL BANK, GOVERNMENT OF THE PHILIPPINES | PHILIPPINES | https://efile.fara.gov/docs/3777-Exhibit-AB-19880126-D15GC701.pdf | |
7627 | 7627 | 1988-01-26 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | GOVERNMENT OF COLOMBIA THROUGH ALVARO SANCHEZ MALLARINO | COLOMBIA | https://efile.fara.gov/docs/3777-Exhibit-AB-19880126-D15GBE01.pdf | |
11546 | 11546 | 1986-02-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | CAMPAIGN OF CORAZON AQUINO | PHILIPPINES | https://efile.fara.gov/docs/3777-Exhibit-AB-19860201-D161VH01.pdf | |
22173 | 22173 | 1988-03-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | GOVERNMENT OF THE REPUBLIC OF PANAMA (IN EXILE), | PANAMA | https://efile.fara.gov/docs/3777-Exhibit-AB-19880301-D15G8W01.pdf | |
22338 | 22338 | 1989-03-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | PHILIPPINE SUGAR ADMINISTRATION | PHILIPPINES | https://efile.fara.gov/docs/3777-Exhibit-AB-19890301-D15G2T01.pdf | |
24768 | 24768 | 1989-03-03 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | FUNDACION PRO-IMAGEN DE COLOMBIA EN EL EXTERIOR | COLOMBIA | https://efile.fara.gov/docs/3777-Exhibit-AB-19890303-D15G9K01.pdf | |
30367 | 30367 | 1989-03-24 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | PHILIPPINE SUGAR ADMINISTRATION | PHILIPPINES | https://efile.fara.gov/docs/3777-Exhibit-AB-19890324-D15G2501.pdf | |
37150 | 37150 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | FUNDACION PRO-IMAGEN DE COLOMBIA EN EL EXTERIOR | COLOMBIA | https://efile.fara.gov/docs/3777-Exhibit-AB-19910402-D161XP01.pdf | |
37151 | 37151 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | NEC CORPORATION | JAPAN | https://efile.fara.gov/docs/3777-Exhibit-AB-19910402-D161WT01.pdf | |
49204 | 49204 | 1988-05-04 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | GOVERNMENT OF THE REPUBLIC OF PANAMA (IN EXILE), ERIC ARTURO | PANAMA | https://efile.fara.gov/docs/3777-Exhibit-AB-19880504-D15GKP01.pdf | |
55130 | 55130 | 1988-05-27 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | GOVERNMENT OF THE REPUBLIC OF COLOMBIA | COLOMBIA | https://efile.fara.gov/docs/3777-Exhibit-AB-19880527-D15GK901.pdf | |
56422 | 56422 | 1988-05-31 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | GOVERNMENT OF THE REPUBLIC OF THE PHILIPPINES | PHILIPPINES | https://efile.fara.gov/docs/3777-Exhibit-AB-19880531-D15GIL01.pdf | |
59251 | 59251 | 1986-06-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | GOVERNMENT OF CANADA, THROUGH MARKET OPINION RESEARCH | CANADA | https://efile.fara.gov/docs/3777-Exhibit-AB-19860601-D1623K01.pdf | |
60372 | 60372 | 1991-06-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | SOCIEDAD ESTATAL PARA LA EJECUCION DE PROGRAMAS Y | SPAIN | https://efile.fara.gov/docs/3777-Exhibit-AB-19910601-D15C1Q01.pdf | |
87699 | 87699 | 1989-08-15 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | PRESIDENTIAL CAMPAIGN OF MR. GONZALO SANCHEZ DE LOZADA | BOLIVIA | https://efile.fara.gov/docs/3777-Exhibit-AB-19890815-D15FZN01.pdf | |
88804 | 88804 | 1989-08-21 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | GOVERNMENT OF ECUADOR | ECUADOR | https://efile.fara.gov/docs/3777-Exhibit-AB-19890821-D15FYY01.pdf | |
92815 | 92815 | 1986-09-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | MINISTRY OF INFORMATION, NEW REPUBLIC OF THE PHILIPPINES | PHILIPPINES | https://efile.fara.gov/docs/3777-Exhibit-AB-19860901-D1622J01.pdf | |
97168 | 97168 | 1989-09-12 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | PRESIDENTIAL CAMPAIGN OF MR. GONZALO SANCHEZ DE LOZADA | BOLIVIA | https://efile.fara.gov/docs/3777-Exhibit-AB-19890912-D15FY701.pdf | |
101015 | 101015 | 1989-09-28 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | GOVERNMENT OF PORTUGAL | PORTUGAL | https://efile.fara.gov/docs/3777-Exhibit-AB-19890928-D15ERC01.pdf | |
104024 | 104024 | 1986-10-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | FREEDOM & JUSTICE FOR CYPRUS TRUST | CYPRUS | https://efile.fara.gov/docs/3777-Exhibit-AB-19861001-D15G6G01.pdf | |
106540 | 106540 | 1991-10-04 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | VENEZUELA CEMENT PRODUCERS' ASSOCIATION | VENEZUELA | https://efile.fara.gov/docs/3777-Exhibit-AB-19911004-D14YUY01.pdf | |
110399 | 110399 | 1991-10-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | HOLDEN ROBERTO, PRESIDENT OF THE NATIONAL FRONT FOR THE LIBE | ANGOLA | https://efile.fara.gov/docs/3777-Exhibit-AB-19911022-D14Z1A01.pdf | |
118883 | 118883 | 1987-11-12 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit AB | PHILIPPINE COCONUT AUTHORITY (PCA) | PHILIPPINES | https://efile.fara.gov/docs/3777-Exhibit-AB-19871112-D15GDK01.pdf | |
59252 | 59252 | 1986-06-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Exhibit C | https://efile.fara.gov/docs/3777-Exhibit-C-19860601-D161RG01.pdf | |||
11547 | 11547 | 1986-02-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Registration Statement | Available-FARA-Public-Office | |||
1329 | 1329 | 1988-01-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | G. MARK MALLOCH BROWN | Available-FARA-Public-Office | ||
6703 | 6703 | 1993-01-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | C.C. CASE | Available-FARA-Public-Office | ||
6704 | 6704 | 1993-01-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | ELLEN S. SULLIVAN | Available-FARA-Public-Office | ||
6705 | 6705 | 1993-01-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | ULRIKE SZALAY | Available-FARA-Public-Office | ||
14531 | 14531 | 1986-02-06 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID E. MOREY | Available-FARA-Public-Office | ||
15398 | 15398 | 1986-02-10 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOEL MCCLEARY | Available-FARA-Public-Office | ||
15807 | 15807 | 1986-02-12 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID HASKELL SAWYER | Available-FARA-Public-Office | ||
19539 | 19539 | 1992-02-28 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | HEATHER HAMILTON LANE | Available-FARA-Public-Office | ||
19540 | 19540 | 1992-02-28 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOHN BASKIND | Available-FARA-Public-Office | ||
24781 | 24781 | 1992-03-03 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | LENNY STERN | Available-FARA-Public-Office | ||
24782 | 24782 | 1992-03-03 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | MICHAEL R. EGGER | Available-FARA-Public-Office | ||
25058 | 25058 | 1992-03-04 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | BASIL S. TSAPALAS | Available-FARA-Public-Office | ||
25059 | 25059 | 1992-03-04 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | RICK JOHN BEAULIEU | Available-FARA-Public-Office | ||
25060 | 25060 | 1992-03-04 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | WILLIAM B. TAYLOR | Available-FARA-Public-Office | ||
34817 | 34817 | 1987-04-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | PETER SCHECTER | Available-FARA-Public-Office | ||
37152 | 37152 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | GINA CHRISTENSEN | Available-FARA-Public-Office | ||
37153 | 37153 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | HARRIS DIAMOND | Available-FARA-Public-Office | ||
37154 | 37154 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | LYNN GUGGENHEIMER | Available-FARA-Public-Office | ||
37155 | 37155 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | MARK R. JOHNSON | Available-FARA-Public-Office | ||
37156 | 37156 | 1991-04-02 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | MARY F. MASELLI | Available-FARA-Public-Office | ||
46725 | 46725 | 1988-05-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOEL MCCLEARY | Available-FARA-Public-Office | ||
60373 | 60373 | 1991-06-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOHN P. SCANLON | Available-FARA-Public-Office | ||
63017 | 63017 | 1991-06-06 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | ROBERT SHEPARDSON | Available-FARA-Public-Office | ||
64034 | 64034 | 1991-06-10 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | KELLY A. MCBRIDE | Available-FARA-Public-Office | ||
64301 | 64301 | 1991-06-11 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | MARK P. LONGABAUGH | Available-FARA-Public-Office | ||
66364 | 66364 | 1986-06-21 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID HASKELL SAWYER | Available-FARA-Public-Office | ||
67090 | 67090 | 1986-06-24 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JOEL MCCLEARY | Available-FARA-Public-Office | ||
67091 | 67091 | 1986-06-24 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | WILLIAM SCOTT MILLER | Available-FARA-Public-Office | ||
72354 | 72354 | 1991-07-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JILL WILKINS | Available-FARA-Public-Office | ||
92979 | 92979 | 1987-09-01 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | G. MARK MALLOCH BROWN | Available-FARA-Public-Office | ||
97878 | 97878 | 1986-09-15 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | DAVID E. MOREY | Available-FARA-Public-Office | ||
97879 | 97879 | 1986-09-15 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | G. MARK MALLOCH BROWN | Available-FARA-Public-Office | ||
99502 | 99502 | 1992-09-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | CAROLINE MCCALL | Available-FARA-Public-Office | ||
99503 | 99503 | 1992-09-22 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | THOMAS BRUCE | Available-FARA-Public-Office | ||
100506 | 100506 | 1990-09-26 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | BARRY HALL FRENCH | Available-FARA-Public-Office | ||
100507 | 100507 | 1990-09-26 | SAWYER MILLER GROUP | Sawyer Miller Group 3777 | Short-Form | JAMES A. MESZAROS | 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]) );