FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

127 rows where Registration_Number = 2988

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date_Stamped (date)

Foreign_Principal_Country 5

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
498 498 1979-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   COUNCIL FOR THE PROMOTION OF INTERNATIONAL TRADE (CCPIT) CHINA https://efile.fara.gov/docs/2988-Exhibit-AB-19790101-D0EIPX03.pdf
499 499 1979-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Registration Statement       Available-FARA-Public-Office
500 500 1979-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form DAVID H. SEMMES     Available-FARA-Public-Office
501 501 1979-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form WARREN E. OLSEN     Available-FARA-Public-Office
559 559 1980-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19800101-D0EJ3503.pdf
618 618 1981-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19810101-D0EJ1U03.pdf
693 693 1982-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19820101-D0EI2F03.pdf
795 795 1983-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19830101-D0EHXA03.pdf
880 880 1984-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19840101-D0EIMZ03.pdf
986 986 1985-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19850101-DC32L801.pdf
1078 1078 1986-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19860101-D0EHCT03.pdf
1204 1204 1987-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19870101-D0EH9V03.pdf
1319 1319 1988-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19880101-D0EH6B03.pdf
1439 1439 1989-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19890101-D0EIOO03.pdf
1626 1626 1990-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19900101-D0EIWK03.pdf
1832 1832 1991-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19910101-D0EISC03.pdf
2173 2173 1992-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19920101-D0EEK003.pdf
2565 2565 1993-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930101-D0EEVF03.pdf
2566 2566 1993-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930101-D0EEVK03.pdf
2567 2567 1993-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930101-D0EEVP03.pdf
2568 2568 1993-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19930101-D0EF9I03.pdf
2803 2803 1994-01-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19940101-D0EGM903.pdf
5854 5854 1995-01-17 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19950117-DQSAAI03.pdf
5860 5860 1996-01-17 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19960117-DOU7AR91.pdf
11316 11316 1984-02-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19840201-D0EIMN03.pdf
11422 11422 1985-02-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   MINISTRY OF COMMERCE, GOVERNMENT OF MAURITIUS MAURITANIA https://efile.fara.gov/docs/2988-Exhibit-AB-19850201-D0EIKN03.pdf
12448 12448 1991-02-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19910201-D0EITK03.pdf
12449 12449 1991-02-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19910201-D0EITP03.pdf
12738 12738 1992-02-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19920201-D0EDTP03.pdf
13080 13080 1993-02-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930201-D0EDZA03.pdf
13081 13081 1993-02-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930201-D0EDZI03.pdf
23400 23400 1992-03-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19920301-D0EEPB03.pdf
23884 23884 1993-03-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930301-D0EFBA03.pdf
23885 23885 1993-03-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930301-D0EFCH03.pdf
23886 23886 1993-03-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930301-D0EFCX03.pdf
23887 23887 1993-03-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930301-D0EFDO03.pdf
23888 23888 1993-03-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930301-D0EFE403.pdf
23889 23889 1993-03-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930301-D0EFEJ03.pdf
34546 34546 1985-04-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19850401-D0EHF203.pdf
34804 34804 1987-04-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form JAMES C. BEH     Available-FARA-Public-Office
35116 35116 1989-04-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19890401-D0EIO403.pdf
35117 35117 1989-04-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form KEVIN W. MCLEAN     Available-FARA-Public-Office
36755 36755 1993-04-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930401-D0EFBX03.pdf
36756 36756 1993-04-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930401-D0EFFA03.pdf
42920 42920 1995-04-26 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form CLINTON E. CAMERON     Available-FARA-Public-Office
46020 46020 1982-05-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19820501-D0EHZW03.pdf
46021 46021 1982-05-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   MAURITIUS CHAMBER OF AGRICULTURE & MAURITIUS SUGAR MAURITIUS https://efile.fara.gov/docs/2988-Exhibit-AB-19820501-D0EI0103.pdf
46022 46022 1982-05-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form PAUL RYBERG     Available-FARA-Public-Office
46409 46409 1986-05-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19860501-D0EHCH03.pdf
47037 47037 1990-05-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19900501-D0EIV903.pdf
47038 47038 1990-05-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   MAURITIUS CHAMBER OF AGRICULTURE & MAURITIUS SUGAR MAURITIUS https://efile.fara.gov/docs/2988-Exhibit-AB-19900501-D0EIVH03.pdf
47039 47039 1990-05-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form JUNE B. BROWN     Available-FARA-Public-Office
51576 51576 1982-05-13 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form SCOTT P. KLURFELD     Available-FARA-Public-Office
51577 51577 1982-05-13 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form SHELDON E. HOCHBERG     Available-FARA-Public-Office
51822 51822 1982-05-14 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form THEODORE F.T. CROLIUS     Available-FARA-Public-Office
52606 52606 1995-05-17 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19950517-DZ0HHB01.pdf
53092 53092 1982-05-19 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form W. DEVIER PIERSON     Available-FARA-Public-Office
56543 56543 1995-05-31 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19950531-DQSCXL03.pdf
56544 56544 1995-05-31 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   MAURITIUS CHAMBER OF AGRICULTURE & MAURITIUS SUGAR SYNDICATE MAURITIUS https://efile.fara.gov/docs/2988-Exhibit-AB-19950531-DQSCZX03.pdf
59237 59237 1986-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19860601-D0EHC903.pdf
59432 59432 1987-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19870601-D0EH8Z03.pdf
59433 59433 1987-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   MAURITIUS CHAMBER OF AGRICULTURE & MAURITIUS SUGAR MAURITIUS https://efile.fara.gov/docs/2988-Exhibit-AB-19870601-D0EH9703.pdf
59768 59768 1989-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19890601-D0EJ0H03.pdf
59769 59769 1989-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   GRAND COUNCIL OF THE CREES (OF QUEBEC) CANADA https://efile.fara.gov/docs/2988-Exhibit-AB-19890601-D0EJ1D03.pdf
60352 60352 1991-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19910601-D0EEM103.pdf
60353 60353 1991-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19910601-D0EIS703.pdf
60950 60950 1992-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19920601-D0EEPF03.pdf
60951 60951 1992-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19920601-D0EEUT03.pdf
60952 60952 1992-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   MAURITIUS CHAMBER OF AGRICULTURE & MAURITIUS SUGAR MAURITIUS https://efile.fara.gov/docs/2988-Exhibit-AB-19920601-D0EEQD03.pdf
61568 61568 1993-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19930601-D0EFNM03.pdf
61569 61569 1993-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930601-D0EFGE03.pdf
61570 61570 1993-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19930601-D0EFMD03.pdf
61571 61571 1993-06-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   MAURITIUS CHAMBER OF AGRICULTURE & MAURITIUS SUGAR MAURITIUS https://efile.fara.gov/docs/2988-Exhibit-AB-19930601-D0EFO603.pdf
62110 62110 1995-06-02 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19950602-DZU6VF03.pdf
64529 64529 1995-06-12 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19950612-DYJYUK04.pdf
64530 64530 1995-06-12 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19950612-DYJYWU04.pdf
65365 65365 1989-06-16 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form DAVID F. B. SMITH     Available-FARA-Public-Office
65366 65366 1989-06-16 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Short-Form SHELDON E. HOCHBERG     Available-FARA-Public-Office
65382 65382 1995-06-16 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19950616-E89WW103.pdf
66234 66234 1995-06-20 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19950620-DZOOAF03.pdf
68448 68448 1995-06-29 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19950629-DZMX1Z04.pdf
69239 69239 1995-06-30 PIERSON SEMMES AND BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19950630-DZSOJ504.pdf
70935 70935 1979-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19790701-D0EJ4K03.pdf
70996 70996 1980-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19800701-D0EEF403.pdf
71065 71065 1981-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19810701-D0EHUZ03.pdf
71121 71121 1982-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19820701-D0EHYO03.pdf
71182 71182 1983-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19830701-D0EHWA03.pdf
71272 71272 1984-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19840701-D0EIL603.pdf
71375 71375 1985-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19850701-D0EHDX03.pdf
71474 71474 1986-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19860701-D0EHB403.pdf
71643 71643 1987-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19870701-D0EH7R03.pdf
71773 71773 1988-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19880701-D0EH4C03.pdf
71898 71898 1989-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Amendment       https://efile.fara.gov/docs/2988-Amendment-19890701-D0EIZQ03.pdf
71899 71899 1989-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Exhibit AB   MAURITIUS CHAMBER OF AGRICULTURE & MAURITIUS SUGAR MAURITIUS https://efile.fara.gov/docs/2988-Exhibit-AB-19890701-D0EIZZ03.pdf
71900 71900 1989-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19890701-D0EIYF03.pdf
72080 72080 1990-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19900701-D0EITU03.pdf
72336 72336 1991-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19910701-D0EEM603.pdf
72337 72337 1991-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19910701-D0EEMB03.pdf
72338 72338 1991-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Supplemental Statement       https://efile.fara.gov/docs/2988-Supplemental-Statement-19910701-D0ECE603.pdf
72725 72725 1992-07-01 PIERSON, SEMMES & BEMIS Pierson, Semmes & Bemis 2988 Dissemination Report       https://efile.fara.gov/docs/2988-Dissemination-Report-19920701-D0EEYG03.pdf

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);