FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
156 rows where Registrant_Name = "MAYER, BROWN & PLATT"
This data as json, CSV (advanced)
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
- MAYER, BROWN & PLATT · 156 ✖
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 | |||
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 | |
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 | ||
11309 | 11309 | 1984-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19840201-D0K95J02.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 | |
11311 | 11311 | 1984-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | CHARLES CHU | Available-FARA-Public-Office | ||
11796 | 11796 | 1988-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19880201-D0K85R02.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 | |
12414 | 12414 | 1991-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19910201-D0K7BD02.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 | |
12416 | 12416 | 1991-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | ARTHUR I. GOULD | Available-FARA-Public-Office | ||
13238 | 13238 | 1994-02-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19940201-D0K9WJ02.pdf | |||
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 | ||
16207 | 16207 | 1994-02-14 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19940214-DQSIXM93.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 | |
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 | ||
21148 | 21148 | 1980-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19800301-D0K94502.pdf | |||
21149 | 21149 | 1980-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | RICHARD M. SMITH | Available-FARA-Public-Office | ||
22141 | 22141 | 1988-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19880301-D0K82802.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 | |
23343 | 23343 | 1992-03-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19920301-D0K9D202.pdf | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |
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 | ||
58438 | 58438 | 1980-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19800601-D0K93102.pdf | |||
58538 | 58538 | 1981-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19810601-D0K91402.pdf | |||
58647 | 58647 | 1982-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19820601-D0K8XV02.pdf | |||
58764 | 58764 | 1983-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19830601-D0K8VC02.pdf | |||
58900 | 58900 | 1984-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19840601-D0K89802.pdf | |||
59053 | 59053 | 1985-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19850601-D0K8K402.pdf | |||
59211 | 59211 | 1986-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19860601-D0K8H102.pdf | |||
59407 | 59407 | 1987-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19870601-D0K8PB02.pdf | |||
59561 | 59561 | 1988-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19880601-D0K80202.pdf | |||
59745 | 59745 | 1989-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19890601-D0K7TK02.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 | |
59747 | 59747 | 1989-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19890601-D0K7RB02.pdf | |||
59965 | 59965 | 1990-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19900601-D0K7G102.pdf | |||
60310 | 60310 | 1991-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19910601-D0K17S02.pdf | |||
60893 | 60893 | 1992-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19920601-D0K9EJ02.pdf | |||
61495 | 61495 | 1993-06-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19930601-D0K9NA02.pdf | |||
69121 | 69121 | 1994-06-30 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19940630-DQSIRT93.pdf | |||
69221 | 69221 | 1995-06-30 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19950630-DQSF1I93.pdf | |||
69310 | 69310 | 1996-06-30 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19960630-DW6K0B93.pdf | |||
69393 | 69393 | 1997-06-30 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Supplemental Statement | https://efile.fara.gov/docs/3076-Supplemental-Statement-19970630-EGZ2LM04.pdf | |||
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 | ||
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 | |||
87176 | 87176 | 1996-08-12 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | DAVID CHRISTOPHER GREENE | Available-FARA-Public-Office | ||
92766 | 92766 | 1986-09-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19860901-D0K8C502.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 | |
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 | ||
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 | |||
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 | |
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 | ||
103453 | 103453 | 1980-10-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Amendment | https://efile.fara.gov/docs/3076-Amendment-19801001-D0K92W02.pdf | |||
104427 | 104427 | 1989-10-01 | MAYER, BROWN & PLATT | Mayer, Brown & Platt 3076 | Short-Form | WILLIAM M. DALEY | 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]) );