FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
156 rows where Registration_Number = 3076 sorted by Document_Type
This data as json, CSV (advanced)
Suggested facets: Date_Stamped (date)
Foreign_Principal_Name 15
- - 140
- TRANSCANADA PIPELINES, LTD. 3
- ACCOUNTANTS' LIABILITY ASSURANCE COMPANY, LTD. 1
- ATTORNEYS' LIABILITY ASSURANCE SOCIETY, LTD. 1
- BANK FOR FOREIGN ECONOMIC AFFAIRS OF RUSSIA 1
- BRAMBLES USA, LTD. 1
- DEUTSCHE BUNDESPOST TELEKOM 1
- DEUTSCHE LUFTHANSA, A.G. 1
- EMBASSY OF CANADA 1
- HARRIS TRUST SAVINGS BANK 1
- LEHNDORFF & BABSON REAL ESTATE COUNSEL 1
- LONDON METAL EXCHANGE, LTD. 1
- MITSUBISHI GAS CHEMICAL AMERICA, INC. 1
- SERVICIOS FINANCIEROS QUADRUM, S.A. 1
- STC, PLC 1
Foreign_Principal_Country 9
Document_Type 5
Registrant_Name 1
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type ▼ | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
1423 | 1423 | 1989-01-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19890101-D0K88K02.pdf | |||
11309 | 11309 | 1984-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19840201-D0K95J02.pdf | |||
11796 | 11796 | 1988-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19880201-D0K85R02.pdf | |||
12414 | 12414 | 1991-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19910201-D0K7BD02.pdf | |||
13238 | 13238 | 1994-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19940201-D0K9WJ02.pdf | |||
16207 | 16207 | 1994-02-14 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19940214-DQSIXM93.pdf | |||
21148 | 21148 | 1980-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19800301-D0K94502.pdf | |||
22141 | 22141 | 1988-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19880301-D0K82802.pdf | |||
23343 | 23343 | 1992-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19920301-D0K9D202.pdf | |||
26658 | 26658 | 1995-03-10 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19950310-DQSF7R03.pdf | |||
26659 | 26659 | 1995-03-10 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19950310-DQSF9I03.pdf | |||
29709 | 29709 | 1996-03-21 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19960321-DPYPII03.pdf | |||
34783 | 34783 | 1987-04-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19870401-D0K8QX02.pdf | |||
35278 | 35278 | 1990-04-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19900401-D0K7J802.pdf | |||
59745 | 59745 | 1989-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19890601-D0K7TK02.pdf | |||
82272 | 82272 | 1982-08-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19820801-D0K8XR02.pdf | |||
82775 | 82775 | 1987-08-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19870801-D0K8OV02.pdf | |||
92766 | 92766 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19860901-D0K8C502.pdf | |||
93332 | 93332 | 1989-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19890901-D0K7OL02.pdf | |||
93333 | 93333 | 1989-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19890901-D0K7XI02.pdf | |||
103453 | 103453 | 1980-10-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19801001-D0K92W02.pdf | |||
116529 | 116529 | 1993-11-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19931101-D0K9PM02.pdf | |||
118001 | 118001 | 1994-11-07 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19941107-DQSHXB03.pdf | |||
121203 | 121203 | 1995-11-22 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19951122-DJMVBP04.pdf | |||
125292 | 125292 | 1983-12-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19831201-D0K96W02.pdf | |||
127635 | 127635 | 1992-12-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19921201-D0K9H302.pdf | |||
1424 | 1424 | 1989-01-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | TRANSCANADA PIPELINES, LTD. | CANADA | https://efile.fara.gov/docs/3076-Exhibit-AB-19890101-D0K89002.pdf | |
11310 | 11310 | 1984-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | EMBASSY OF CANADA | CANADA | https://efile.fara.gov/docs/3076-Exhibit-AB-19840201-D0K94I02.pdf | |
11797 | 11797 | 1988-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | ACCOUNTANTS' LIABILITY ASSURANCE COMPANY, LTD. | BERMUDA | https://efile.fara.gov/docs/3076-Exhibit-AB-19880201-D0K87902.pdf | |
12415 | 12415 | 1991-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | STC, PLC | GREAT BRITAIN | https://efile.fara.gov/docs/3076-Exhibit-AB-19910201-D0K7C902.pdf | |
16208 | 16208 | 1994-02-14 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | DEUTSCHE LUFTHANSA, A.G. | GERMANY | https://efile.fara.gov/docs/3076-Exhibit-AB-19940214-DQSJD003.pdf | |
22142 | 22142 | 1988-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | LEHNDORFF & BABSON REAL ESTATE COUNSEL | GERMANY | https://efile.fara.gov/docs/3076-Exhibit-AB-19880301-D0K83I02.pdf | |
35279 | 35279 | 1990-04-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | BANK FOR FOREIGN ECONOMIC AFFAIRS OF RUSSIA | RUSSIA | https://efile.fara.gov/docs/3076-Exhibit-AB-19900401-D0K7JW02.pdf | |
59746 | 59746 | 1989-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | LONDON METAL EXCHANGE, LTD. | GREAT BRITAIN | https://efile.fara.gov/docs/3076-Exhibit-AB-19890601-D0K7U802.pdf | |
92767 | 92767 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | ATTORNEYS' LIABILITY ASSURANCE SOCIETY, LTD. | BERMUDA | https://efile.fara.gov/docs/3076-Exhibit-AB-19860901-D0K8E302.pdf | |
96305 | 96305 | 1989-09-08 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | BRAMBLES USA, LTD. | AUSTRALIA | https://efile.fara.gov/docs/3076-Exhibit-AB-19890908-D0K7PO02.pdf | |
114497 | 114497 | 1981-11-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | TRANSCANADA PIPELINES, LTD. | CANADA | https://efile.fara.gov/docs/3076-Exhibit-AB-19811101-D0K92502.pdf | |
116530 | 116530 | 1993-11-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | SERVICIOS FINANCIEROS QUADRUM, S.A. | MEXICO | https://efile.fara.gov/docs/3076-Exhibit-AB-19931101-D0K9TE02.pdf | |
118002 | 118002 | 1994-11-07 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | DEUTSCHE BUNDESPOST TELEKOM | GERMANY | https://efile.fara.gov/docs/3076-Exhibit-AB-19941107-DQSI1R03.pdf | |
121204 | 121204 | 1995-11-22 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | HARRIS TRUST SAVINGS BANK | CANADA | https://efile.fara.gov/docs/3076-Exhibit-AB-19951122-DJMVE704.pdf | |
124799 | 124799 | 1979-12-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | TRANSCANADA PIPELINES, LTD. | CANADA | https://efile.fara.gov/docs/3076-Exhibit-AB-19791201-D0K97902.pdf | |
127636 | 127636 | 1992-12-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Exhibit AB | MITSUBISHI GAS CHEMICAL AMERICA, INC. | JAPAN | https://efile.fara.gov/docs/3076-Exhibit-AB-19921201-D0K9HC02.pdf | |
124800 | 124800 | 1979-12-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Registration Statement | Available-FARA-Public-Office | |||
1805 | 1805 | 1991-01-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | MARK H. GITENSTEIN | Available-FARA-Public-Office | ||
9613 | 9613 | 1996-01-31 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | KIMBERLY A. LYNCH | Available-FARA-Public-Office | ||
9662 | 9662 | 1997-01-31 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | CAROLYN P. OSOLINIK | Available-FARA-Public-Office | ||
9663 | 9663 | 1997-01-31 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | DAVID C. CRANE | Available-FARA-Public-Office | ||
9664 | 9664 | 1997-01-31 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | GREGORY S. WALDEN | Available-FARA-Public-Office | ||
9665 | 9665 | 1997-01-31 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | RICHARD S. WILLIAMSON | Available-FARA-Public-Office | ||
11311 | 11311 | 1984-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | CHARLES CHU | Available-FARA-Public-Office | ||
12416 | 12416 | 1991-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | ARTHUR I. GOULD | Available-FARA-Public-Office | ||
13239 | 13239 | 1994-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | TAMINEH ROSHANIAN | Available-FARA-Public-Office | ||
15246 | 15246 | 1996-02-09 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JEAN S. CHAN | Available-FARA-Public-Office | ||
15247 | 15247 | 1996-02-09 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | NELSON K. AHN | Available-FARA-Public-Office | ||
16209 | 16209 | 1994-02-14 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JOHN P. SCHMITZ | Available-FARA-Public-Office | ||
17845 | 17845 | 1988-02-22 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | DONALD S. BREAKSTONE | Available-FARA-Public-Office | ||
17846 | 17846 | 1988-02-22 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JERRY L. OPPENHEIMER | Available-FARA-Public-Office | ||
17847 | 17847 | 1988-02-22 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | KAREN L. WHITNEY | Available-FARA-Public-Office | ||
17848 | 17848 | 1988-02-22 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | WILLIAM M. DALEY | Available-FARA-Public-Office | ||
19159 | 19159 | 1995-02-27 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | GREGORY S. WALDEN | Available-FARA-Public-Office | ||
21149 | 21149 | 1980-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | RICHARD M. SMITH | Available-FARA-Public-Office | ||
25056 | 25056 | 1988-03-04 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | HAROLD E. MCKEE | Available-FARA-Public-Office | ||
25057 | 25057 | 1988-03-04 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | MARK H. BERENS | Available-FARA-Public-Office | ||
31702 | 31702 | 1988-03-29 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JERRY L. OPPENHEIMER | Available-FARA-Public-Office | ||
31703 | 31703 | 1988-03-29 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | KAREN L. WHITNEY | Available-FARA-Public-Office | ||
31704 | 31704 | 1988-03-29 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | ROBERT H. SWART | Available-FARA-Public-Office | ||
34206 | 34206 | 1981-04-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | CHARLES S. LEVY | Available-FARA-Public-Office | ||
39853 | 39853 | 1990-04-13 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | ADLAI E. STEVENSON | Available-FARA-Public-Office | ||
39854 | 39854 | 1990-04-13 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | EDWARD S. MADARA, III | Available-FARA-Public-Office | ||
39855 | 39855 | 1990-04-13 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | MICHAEL G. CAPATIDES | Available-FARA-Public-Office | ||
75450 | 75450 | 1989-07-12 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | MARSHALL E. HANBURY | Available-FARA-Public-Office | ||
75451 | 75451 | 1989-07-12 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | RICHARD S. WILLIAMSON | Available-FARA-Public-Office | ||
75452 | 75452 | 1989-07-12 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | TYRONE C. FAHNER | Available-FARA-Public-Office | ||
87176 | 87176 | 1996-08-12 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | DAVID CHRISTOPHER GREENE | Available-FARA-Public-Office | ||
92768 | 92768 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | DAVID J. MANGEFRIDA, JR. | Available-FARA-Public-Office | ||
92769 | 92769 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | DONALD S. BREAKSTONE | Available-FARA-Public-Office | ||
92770 | 92770 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | HAROLD E. MCKEE | Available-FARA-Public-Office | ||
92771 | 92771 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JERRY L. OPPENHEIMER | Available-FARA-Public-Office | ||
92772 | 92772 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | KAREN L. WHITNEY | Available-FARA-Public-Office | ||
92773 | 92773 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | MARK H. BERENS | Available-FARA-Public-Office | ||
96306 | 96306 | 1989-09-08 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | RICHARD M. SMITH | Available-FARA-Public-Office | ||
96307 | 96307 | 1989-09-08 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | WILLIAM L. MASSEY | Available-FARA-Public-Office | ||
98608 | 98608 | 1989-09-18 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | AMY L. NATHAN | Available-FARA-Public-Office | ||
98609 | 98609 | 1989-09-18 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | ERIKA Z. JONES | Available-FARA-Public-Office | ||
98610 | 98610 | 1989-09-18 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | GREGORY L. BARTON | Available-FARA-Public-Office | ||
98611 | 98611 | 1989-09-18 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | HILLEL WEINBERG | Available-FARA-Public-Office | ||
98612 | 98612 | 1989-09-18 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JOEL V. WILLIAMSON | Available-FARA-Public-Office | ||
98613 | 98613 | 1989-09-18 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JOSEPH R. GOEKE | Available-FARA-Public-Office | ||
98614 | 98614 | 1989-09-18 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | MARK H. GITENSTEIN | Available-FARA-Public-Office | ||
98615 | 98615 | 1989-09-18 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | RICHARD S. WILLIAMSON | Available-FARA-Public-Office | ||
98816 | 98816 | 1989-09-19 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | CHARLES S. LEVY | Available-FARA-Public-Office | ||
98817 | 98817 | 1989-09-19 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | ERIC R. BIEL | Available-FARA-Public-Office | ||
98818 | 98818 | 1989-09-19 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | SIMEON M. KRIESBERG | Available-FARA-Public-Office | ||
104427 | 104427 | 1989-10-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | WILLIAM M. DALEY | Available-FARA-Public-Office | ||
116531 | 116531 | 1993-11-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | BRIAN SMITH | Available-FARA-Public-Office | ||
116532 | 116532 | 1993-11-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JAMES KNOX | Available-FARA-Public-Office | ||
116533 | 116533 | 1993-11-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | JERRY L. OPPENHEIMER | Available-FARA-Public-Office | ||
116534 | 116534 | 1993-11-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | MICHAEL GILMAN | Available-FARA-Public-Office | ||
116535 | 116535 | 1993-11-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | WAYNE S. KAPLAN | Available-FARA-Public-Office | ||
119825 | 119825 | 1994-11-16 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | ANDREW J. PINCUS | 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]) );