FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
643 rows where Registrant_Name = "BURSON-MARSTELLER" sorted by Foreign_Principal_Name
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name
Foreign_Principal_Name >30
- - 570
- GOVERNMENT OF MEXICO, MINISTRY OF COMMERCE & INDUSTRIAL 3
- GOVERNMENT OF ARGENTINA 2
- SAUDI BASIC INDUSTRIES CORPORATION (SABIC) 2
- THOMSON, S.A. 2
- U.S.S.R. CHAMBER OF COMMERCE & INDUSTRY 2
- ALLMANNA SVENSKA ELEKTRISKA AKTIEBDAYET (ASEA) 1
- BETTER HONG KONG FOUNDATION (BHKF) 1
- BOMBARDIER INC./SEA-DOO DIVISION 1
- BRITISH NUCLEAR FUELS, PLC (BNFL) 1
- CAMARA NACIONAL DEL CEMENTO 1
- CEMEX 1
- CENTER FOR INFORMATION AND BUSINESS DEVELOPMENT (CIDEM) GENE 1
- CITY OF BERLIN 1
- COMISION EJECUTIVA HIDROELECTRICA DEL RIO LEMPA CEL 1
- CONSEJO MEXICANO DE HOMBRES DE NEGOCIOS 1
- COUNCIL OF SAUDI CHAMBERS OF COMMERCE & INDUSTRY 1
- DEGUSSA, A.G. 1
- DEPARTMENT OF INDUSTRY, TECHNOLOGY & RESOURCES 1
- EMBASSY OF NORWAY 1
- EMBASSY OF THE CZECH & SLOVAK FEDERAL REPUBLIC 1
- EMBASSY OF THE REPUBLIC OF KOREA 1
- EMBRATUR/BRAZILIAN TOURISM AUTHORITY 1
- EMPRESA BRASILEIRA DE AERONAUTICA S.A. (EMBRAER) 1
- EPSON AMERICA, INC. 1
- EXPORTADORA DE SAL, S.A. DE C.V. 1
- FEDERAL REPUBLIC OF GERMANY, MINISTRY OF ECONOMICS 1
- FEDERATION OF BOSNIA-HERZEGOVINA 1
- FOUNDATION THE NETHERLANDS-THE U.S. OF AMERICA 200 1
- GOVERNMENT OF CAMEROON 1
- …
Foreign_Principal_Country >30
- - 570
- MEXICO 11
- SAUDI ARABIA 5
- CANADA 3
- GERMANY FEDERAL REPUBLIC OF 3
- KOREA SOUTH 3
- SPAIN 3
- USSR 3
- ARGENTINA 2
- BRAZIL 2
- FRANCE 2
- GERMANY 2
- GREAT BRITAIN 2
- JAPAN 2
- NORWAY 2
- TAIWAN 2
- AUSTRALIA 1
- BAHAMAS 1
- BOSNIA & HERZEGOVINA 1
- BRUNEI 1
- CAMEROON 1
- COSTA RICA 1
- CZECHOSLOVAKIA 1
- EL SALVADOR 1
- FINLAND 1
- GHANA 1
- HONG KONG 1
- HUNGARY 1
- INDONESIA 1
- INTERNATIONAL 1
- …
Date_Stamped (date) >30 ✖
- 1991-05-01 17
- 1992-01-01 12
- 1976-11-01 10
- 1993-01-01 10
- 1993-01-28 10
- 1991-02-25 9
- 1997-10-07 9
- 1977-10-13 8
- 1984-09-24 8
- 1992-08-01 8
- 1992-04-01 7
- 1976-07-01 6
- 1982-01-23 6
- 1982-06-07 6
- 1987-02-09 6
- 1996-06-04 6
- 1976-08-15 5
- 1986-02-28 5
- 1986-11-20 5
- 1987-10-02 5
- 1987-10-05 5
- 1990-03-16 5
- 1992-09-01 5
- 1973-10-01 4
- 1976-05-13 4
- 1978-07-01 4
- 1979-09-24 4
- 1982-07-14 4
- 1983-11-01 4
- 1983-12-01 4
- …
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name ▼ | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
905 | 905 | 1985-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | SUSAN EISENHOWER | Available-FARA-Public-Office | ||
1019 | 1019 | 1986-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Amendment | https://efile.fara.gov/docs/2469-Amendment-19860101-CZMMWN02.pdf | |||
1020 | 1020 | 1986-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Amendment | https://efile.fara.gov/docs/2469-Amendment-19860101-CZMMWV02.pdf | |||
1022 | 1022 | 1986-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LEONARD BIEGEL | Available-FARA-Public-Office | ||
1117 | 1117 | 1987-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | PHYLLIS M. WALTERS | Available-FARA-Public-Office | ||
1358 | 1358 | 1989-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Amendment | https://efile.fara.gov/docs/2469-Amendment-19890101-CZHW9402.pdf | |||
1705 | 1705 | 1991-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LISA Z. JAHODA | Available-FARA-Public-Office | ||
1948 | 1948 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQMN02.pdf | |||
1949 | 1949 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQMR02.pdf | |||
1950 | 1950 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQMW02.pdf | |||
1951 | 1951 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQN002.pdf | |||
1952 | 1952 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQN502.pdf | |||
1953 | 1953 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQNA02.pdf | |||
1954 | 1954 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQNE02.pdf | |||
1955 | 1955 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQNJ02.pdf | |||
1956 | 1956 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQNN02.pdf | |||
1957 | 1957 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQNS02.pdf | |||
1958 | 1958 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQNW02.pdf | |||
1959 | 1959 | 1992-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19920101-CZMQO102.pdf | |||
2285 | 2285 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Amendment | https://efile.fara.gov/docs/2469-Amendment-19930101-CZMSKL02.pdf | |||
2286 | 2286 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Amendment | https://efile.fara.gov/docs/2469-Amendment-19930101-CZMSL002.pdf | |||
2287 | 2287 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Amendment | https://efile.fara.gov/docs/2469-Amendment-19930101-CZMSME02.pdf | |||
2288 | 2288 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Amendment | https://efile.fara.gov/docs/2469-Amendment-19930101-CZMSO302.pdf | |||
2289 | 2289 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19930101-CZMSFK02.pdf | |||
2290 | 2290 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19930101-CZMSFS02.pdf | |||
2291 | 2291 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19930101-CZMSHR02.pdf | |||
2292 | 2292 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19930101-CZMUX702.pdf | |||
2294 | 2294 | 1993-01-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | PATRICK FORD | Available-FARA-Public-Office | ||
2969 | 2969 | 1989-01-03 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | CLARE GOEPFERT | Available-FARA-Public-Office | ||
2970 | 2970 | 1989-01-03 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | CYNTHIA BULL | Available-FARA-Public-Office | ||
2971 | 2971 | 1989-01-03 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | KATHLEEN LOBB | Available-FARA-Public-Office | ||
5333 | 5333 | 1982-01-14 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JAY W. LEVY | Available-FARA-Public-Office | ||
5373 | 5373 | 1999-01-14 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LAURIE JILL ADLER | Available-FARA-Public-Office | ||
5374 | 5374 | 1999-01-14 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | RICHARD IAN MINTZ | Available-FARA-Public-Office | ||
5690 | 5690 | 1990-01-16 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | EDITH R. WILSON | Available-FARA-Public-Office | ||
5691 | 5691 | 1990-01-16 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | RICHARD MOORE | Available-FARA-Public-Office | ||
5841 | 5841 | 1990-01-17 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | TIMOTHY G. BROSNAHAN | Available-FARA-Public-Office | ||
6340 | 6340 | 1993-01-20 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JANE BARR | Available-FARA-Public-Office | ||
6341 | 6341 | 1993-01-20 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LAURENCE S. HANAUER | Available-FARA-Public-Office | ||
6697 | 6697 | 1990-01-22 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | SALLY GLASS | Available-FARA-Public-Office | ||
6904 | 6904 | 1982-01-23 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | EILEEN JOYCE | Available-FARA-Public-Office | ||
6905 | 6905 | 1982-01-23 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | ELIAS BUCHWALD | Available-FARA-Public-Office | ||
6906 | 6906 | 1982-01-23 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JOHN STODDARD | Available-FARA-Public-Office | ||
6907 | 6907 | 1982-01-23 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JUDITH K. HENRY | Available-FARA-Public-Office | ||
6908 | 6908 | 1982-01-23 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | KENNETH D. HUSZAR | Available-FARA-Public-Office | ||
6909 | 6909 | 1982-01-23 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | PATRICK B. MULDOWNEY | Available-FARA-Public-Office | ||
6943 | 6943 | 1990-01-23 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | RISSIG LICHA | Available-FARA-Public-Office | ||
7156 | 7156 | 1993-01-24 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | CHARLES VENANCIO | Available-FARA-Public-Office | ||
7367 | 7367 | 1982-01-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | WILLIAM R. DONALDSON | Available-FARA-Public-Office | ||
7635 | 7635 | 1993-01-26 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | HOWARD F. PARK | Available-FARA-Public-Office | ||
7636 | 7636 | 1993-01-26 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | TIFFANY WESTOVER | Available-FARA-Public-Office | ||
8129 | 8129 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | ALLING WOODRUFF, JR. | Available-FARA-Public-Office | ||
8130 | 8130 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | ARLENE GORDON | Available-FARA-Public-Office | ||
8131 | 8131 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | DIANE MOSER | Available-FARA-Public-Office | ||
8132 | 8132 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JOSH REISS | Available-FARA-Public-Office | ||
8133 | 8133 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | KENNETH WONG | Available-FARA-Public-Office | ||
8134 | 8134 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LISA POULSON | Available-FARA-Public-Office | ||
8135 | 8135 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | MARGARET A. DURANTE | Available-FARA-Public-Office | ||
8136 | 8136 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | MATTHEW M. LITTLEJOHN | Available-FARA-Public-Office | ||
8137 | 8137 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | MICHAEL J. DEVLIN | Available-FARA-Public-Office | ||
8138 | 8138 | 1993-01-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | PHILIP LENTZ | Available-FARA-Public-Office | ||
10979 | 10979 | 1980-02-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | ROBERT M. BUSSJAEGER | Available-FARA-Public-Office | ||
11177 | 11177 | 1983-02-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Amendment | https://efile.fara.gov/docs/2469-Amendment-19830201-CZMMTS02.pdf | |||
11350 | 11350 | 1985-02-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | MICHAEL SMITH NEBEKER | Available-FARA-Public-Office | ||
12855 | 12855 | 1993-02-01 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Dissemination Report | https://efile.fara.gov/docs/2469-Dissemination-Report-19930201-CZMV5102.pdf | |||
13814 | 13814 | 1995-02-03 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | MELANIE JANIN | Available-FARA-Public-Office | ||
14310 | 14310 | 1980-02-05 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | HAROLD BURSON | Available-FARA-Public-Office | ||
14532 | 14532 | 1987-02-06 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JULIE ROBIN SLAVITT | Available-FARA-Public-Office | ||
14746 | 14746 | 1980-02-07 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | SUSAN C. SMALL | Available-FARA-Public-Office | ||
14747 | 14747 | 1980-02-07 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | THOMAS E. NUNAN | Available-FARA-Public-Office | ||
14748 | 14748 | 1980-02-07 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | TRUDI P. ROHLA | Available-FARA-Public-Office | ||
15213 | 15213 | 1987-02-09 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | CATHY ANNE RAMSEY | Available-FARA-Public-Office | ||
15214 | 15214 | 1987-02-09 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | CHARLES E. HAMLIN | Available-FARA-Public-Office | ||
15215 | 15215 | 1987-02-09 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | KENNETH DANIEL HUSZAR | Available-FARA-Public-Office | ||
15216 | 15216 | 1987-02-09 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | KYLE T. KUNZ | Available-FARA-Public-Office | ||
15217 | 15217 | 1987-02-09 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LARRY E. SMITH | Available-FARA-Public-Office | ||
15218 | 15218 | 1987-02-09 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | MAYER R. RESNICK | Available-FARA-Public-Office | ||
16467 | 16467 | 1995-02-15 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | PIERRE SALINGER | Available-FARA-Public-Office | ||
16863 | 16863 | 1987-02-17 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JEFF ROBERT HUNT | Available-FARA-Public-Office | ||
16864 | 16864 | 1987-02-17 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | SCOTT J. FARRELL | Available-FARA-Public-Office | ||
17069 | 17069 | 1986-02-18 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JONATHAN S. JESSAR | Available-FARA-Public-Office | ||
17690 | 17690 | 1997-02-21 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | KELLEY MULLANEY | Available-FARA-Public-Office | ||
17691 | 17691 | 1997-02-21 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LEE JOHNSON | Available-FARA-Public-Office | ||
17844 | 17844 | 1986-02-22 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LISA JAHODA | Available-FARA-Public-Office | ||
18371 | 18371 | 1986-02-24 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | ALISON LOUISE HILL | Available-FARA-Public-Office | ||
18372 | 18372 | 1986-02-24 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | MARY-ANN SHERMAN | Available-FARA-Public-Office | ||
18627 | 18627 | 1986-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | LEONARD BIEGEL | Available-FARA-Public-Office | ||
18628 | 18628 | 1986-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | TIMOTHY LEE | Available-FARA-Public-Office | ||
18648 | 18648 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | BILL SKLAR | Available-FARA-Public-Office | ||
18649 | 18649 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | ELLEN T. CALDWELL | Available-FARA-Public-Office | ||
18650 | 18650 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | GARTH NEUFFER | Available-FARA-Public-Office | ||
18651 | 18651 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JAMES CALLAN | Available-FARA-Public-Office | ||
18652 | 18652 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JAMES J. HYDE, JR. | Available-FARA-Public-Office | ||
18653 | 18653 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | KAREN E. DIAKUN | Available-FARA-Public-Office | ||
18654 | 18654 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | RAMIRO E. PRUDENCIO | Available-FARA-Public-Office | ||
18655 | 18655 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | ROB VALERO | Available-FARA-Public-Office | ||
18656 | 18656 | 1991-02-25 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | ZANKU ARMENIAN | Available-FARA-Public-Office | ||
18902 | 18902 | 1986-02-26 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | HAROLD BURSON | Available-FARA-Public-Office | ||
19498 | 19498 | 1986-02-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | BARBARA A. HAND | Available-FARA-Public-Office | ||
19499 | 19499 | 1986-02-28 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | JAMES P. GRUBE | 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]) );