FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40,054 rows where Document_Type = "Short-Form" sorted by Foreign_Principal_Name
This data as json, CSV (advanced)
Registrant_Name >30
- HILL & KNOWLTON, INC. 1,522
- Daniel J. Edelman, Inc. 895
- ARNOLD & PORTER 446
- Hill & Knowlton, Inc. 418
- BURSON-MARSTELLER 389
- SQUIRE, SANDERS & DEMPSEY 341
- Ogilvy Public Relations Worldwide 332
- WHITE & CASE 318
- Amtorg Trading Corporation 314
- JETRO, New York 286
- RUDER & FINN, INC. 284
- DANIEL J. EDELMAN, INC. 281
- Mercury Public Affairs, LLC 271
- AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 269
- NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. 259
- MMGY Global, LLC 241
- Commonwealth of Dominica Maritime Registry, Inc. 237
- Fleishman-Hillard, Inc. 237
- DLA Piper US LLP 231
- QUEBEC GOVERNMENT HOUSE 227
- Akin, Gump, Strauss, Hauer & Feld, LLP 226
- Ketchum Inc. NY 217
- JETRO, NEW YORK 216
- FLEISHMAN-HILLARD, INC. 203
- Hill and Knowlton Strategies, LLC 203
- Qorvis Communications, LLC 199
- L.A. MOTLEY & COMPANY 190
- Podesta Group, Inc. 190
- Patton Boggs, LLP 185
- NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) 182
- …
Foreign_Principal_Name 1
- - 39,954
Foreign_Principal_Country 1
- - 39,954
Document_Type 1
- Short-Form · 39,954 ✖
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name ▼ | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
405 | 405 | 1978-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | THOMAS B. WILNER | Available-FARA-Public-Office | ||
406 | 406 | 1978-01-01 | AUSTRALIAN TOURIST COMMISSION | Tourism Australia 1032 | Short-Form | IAN L. KENNEDY | Available-FARA-Public-Office | ||
417 | 417 | 1978-01-01 | INTOURIST, RUSSIAN JOINT STOCK COMPANY FOR FOREIGN TRAVEL, | Intourist U.S.A., Inc. 1240 | Short-Form | VICOR N. TOURKINE | Available-FARA-Public-Office | ||
424 | 424 | 1978-01-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Short-Form | SUGURU MURAKAMI | Available-FARA-Public-Office | ||
425 | 425 | 1978-01-01 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Short-Form | KAZUMI SUZUKI | Available-FARA-Public-Office | ||
426 | 426 | 1978-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | Available-FARA-Public-Office | ||
429 | 429 | 1978-01-01 | KOREA INTERNATL TRADE ASSN, INC. | Korea International Trade Association, Inc. 2686 | Short-Form | SUNG DO HONG | Available-FARA-Public-Office | ||
433 | 433 | 1978-01-01 | MALAYSIAN INDUSTRIAL DEVELOPMENT AUTHORITY | Malaysian Industrial Development Authority 2331 | Short-Form | YAAKUB ARSHAD | Available-FARA-Public-Office | ||
436 | 436 | 1978-01-01 | NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | Short-Form | NIKOLAI NIKOLAEVICH KAREV | Available-FARA-Public-Office | ||
450 | 450 | 1979-01-01 | ARAB INFORMATION CENTER | Arab Information Center 876 | Short-Form | A. HADI TORON | Available-FARA-Public-Office | ||
451 | 451 | 1979-01-01 | BAHAMAS TOURIST OFFICE | Bahamas Tourist Office 2310 | Short-Form | VAN JAMES ISSACS | Available-FARA-Public-Office | ||
456 | 456 | 1979-01-01 | CLEARY, GOTTLIEB, STEEN & HAMILTON | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | Short-Form | THOMAS J. KIERNAN | Available-FARA-Public-Office | ||
461 | 461 | 1979-01-01 | HANNAFORD COMPANY, INC. | Hannaford Company, Inc. 2850 | Short-Form | JAMES W. ROBINSON | Available-FARA-Public-Office | ||
463 | 463 | 1979-01-01 | HENRY DAVIS CORPORATION | Henry Davis Corporation 2952 | Short-Form | FRED SKELTON | Available-FARA-Public-Office | ||
464 | 464 | 1979-01-01 | HONG KONG TOURIST ASSOCIATION | Hong Kong Tourism Board 2110 | Short-Form | VINCE DI MARCO | Available-FARA-Public-Office | ||
469 | 469 | 1979-01-01 | IDA IRELAND | IDA Ireland 1770 | Short-Form | BERNARD USSHER | Available-FARA-Public-Office | ||
474 | 474 | 1979-01-01 | JAMAICA TOURIST BOARD, NEW YORK | Jamaica Tourist Board, New York 1445 | Short-Form | DOLORES ELAINE STEPHENSON | Available-FARA-Public-Office | ||
479 | 479 | 1979-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | FUGIE ROSE KAJIMURA | Available-FARA-Public-Office | ||
482 | 482 | 1979-01-01 | KOREA TRADE PROMOTION CENTER, NEW YORK | KOTRA 1619 | Short-Form | JOONDU JOHONG | Available-FARA-Public-Office | ||
486 | 486 | 1979-01-01 | MEXICAN GOVERNMENT TOURIST OFFICE, NEW YORK | Mexican Tourism Board 1754 | Short-Form | JORGE V. GONZALEZ | Available-FARA-Public-Office | ||
489 | 489 | 1979-01-01 | NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | Short-Form | PAVEL A. FISUNOV | Available-FARA-Public-Office | ||
496 | 496 | 1979-01-01 | OFFICE OF TIBET | Office of Tibet 1699 | Short-Form | IRVING MANDELL | Available-FARA-Public-Office | ||
497 | 497 | 1979-01-01 | PEKAO TRADING CORPORATION | Pekao Trading Corporation 817 | Short-Form | JOSEF KIRSTEIN | 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 | ||
502 | 502 | 1979-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | PHILLIPPE CINQ-MARS | Available-FARA-Public-Office | ||
503 | 503 | 1979-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | ROBERT G. JONES | Available-FARA-Public-Office | ||
504 | 504 | 1979-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | THEODORE H. JOHN | Available-FARA-Public-Office | ||
505 | 505 | 1979-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | YVES LABONTE | Available-FARA-Public-Office | ||
509 | 509 | 1979-01-01 | TEA COUNCIL OF THE U.S.A., INC. | Tea Council of the U.S.A., Inc. 1853 | Short-Form | DONALD A. WIEDERECHT | Available-FARA-Public-Office | ||
511 | 511 | 1979-01-01 | TURKISH CONSULATE OFFICE OF CULTURE & INFORMATION ATTACHE | Turkish Consulate Office of Culture & Information Attache 498 | Short-Form | HASAN HUSEYIN CERCI | Available-FARA-Public-Office | ||
519 | 519 | 1980-01-01 | AUSTRALIAN MEAT & LIVESTOCK CORPORATION | Australian Meat & Livestock Corporation 2611 | Short-Form | LLOYD B. WYATT | Available-FARA-Public-Office | ||
520 | 520 | 1980-01-01 | BARBADOS INVESTMENT & DEVELOPMENT CORP. BARBADOS TOURISM | Barbados Investment & Development Corp. Barbados Tourism 1995 | Short-Form | BARBARA ANTOINETTE BROWNE | Available-FARA-Public-Office | ||
528 | 528 | 1980-01-01 | GARVEY, SCHUBERT & BARER | Foster Garvey PC 3047 | Short-Form | ALAN P. SHERBROOKE | Available-FARA-Public-Office | ||
529 | 529 | 1980-01-01 | GARVEY, SCHUBERT & BARER | Foster Garvey PC 3047 | Short-Form | BROCK ADAMS | Available-FARA-Public-Office | ||
530 | 530 | 1980-01-01 | GARVEY, SCHUBERT & BARER | Foster Garvey PC 3047 | Short-Form | E. CHARLES ROUTH | Available-FARA-Public-Office | ||
531 | 531 | 1980-01-01 | GARVEY, SCHUBERT & BARER | Foster Garvey PC 3047 | Short-Form | JOHN K. HOERSTER | Available-FARA-Public-Office | ||
537 | 537 | 1980-01-01 | HONG KONG TOURIST ASSOCIATION | Hong Kong Tourism Board 2110 | Short-Form | EDWIN W. TIEDEMANN | Available-FARA-Public-Office | ||
543 | 543 | 1980-01-01 | ITALIAN GOVERNMENT TRAVEL OFFICE, CHICAGO | Italian Government Travel Office, Chicago 1892 | Short-Form | GABRIELE PALA | Available-FARA-Public-Office | ||
557 | 557 | 1980-01-01 | NEW ZEALAND CENTRAL RESERVATIONS OFFICE | New Zealand Central Reservations Office 672 | Short-Form | MICHAEL JOHN DAMIANO | Available-FARA-Public-Office | ||
560 | 560 | 1980-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | JEAN-CLAUDE TREMBLAY | Available-FARA-Public-Office | ||
566 | 566 | 1980-01-01 | TKC INTERNATIONAL, INC. | TKC International, Inc. 3075 | Short-Form | BERT INGALLS HICKMAN, JR. | Available-FARA-Public-Office | ||
577 | 577 | 1981-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | DOUGLAS L. WALD | Available-FARA-Public-Office | ||
582 | 582 | 1981-01-01 | CHINA BOOKS & PERIODICALS, INC. | China Books & Periodicals, Inc. 1350 | Short-Form | LAWRENCE PEMBLE | Available-FARA-Public-Office | ||
591 | 591 | 1981-01-01 | HONG KONG TOURIST ASSOCIATION | Hong Kong Tourism Board 2110 | Short-Form | CAROLYN E. TAVARES | Available-FARA-Public-Office | ||
604 | 604 | 1981-01-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Short-Form | YASUTOMI OTA | Available-FARA-Public-Office | ||
614 | 614 | 1981-01-01 | NEW YORK BUREAU OF THE TELEGRAPH AGENCY OF RUSSIA (TASS) | New York Bureau of the Telegraph Agency of Russia (TASS) 464 | Short-Form | ALEXANDER GEORGIEVICH ALEXANDROV | Available-FARA-Public-Office | ||
617 | 617 | 1981-01-01 | NOVA SCOTIA INFORMATION CENTRE | Nova Scotia Information Centre 3078 | Short-Form | ISABELL SHARON HAYTER | Available-FARA-Public-Office | ||
621 | 621 | 1981-01-01 | ROBINSONS, INC. | Robinsons, Inc. 3110 | Short-Form | ADRIAN C. ROBINSON | Available-FARA-Public-Office | ||
625 | 625 | 1981-01-01 | RUDER & FINN, INC. | Ruder Finn, Inc. 1481 | Short-Form | JOSEPH H. BALL | Available-FARA-Public-Office | ||
635 | 635 | 1982-01-01 | ANDERSON & PENDLETON, C.A. | Anderson & Pendleton, C.A. 2696 | Short-Form | GEORGE PENDLETON | Available-FARA-Public-Office | ||
637 | 637 | 1982-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | K. PETER SCHMIDT | Available-FARA-Public-Office | ||
638 | 638 | 1982-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | LAWRENCE A. SCHNEIDER | Available-FARA-Public-Office | ||
639 | 639 | 1982-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | NORMAN MARK SINEL | Available-FARA-Public-Office | ||
640 | 640 | 1982-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | THOMAS DWYER | Available-FARA-Public-Office | ||
643 | 643 | 1982-01-01 | CHINA INTERNATIONAL TRAVEL SERVICE, INC. | China National Tourist Office 3318 | Short-Form | SHUYU SHEN | Available-FARA-Public-Office | ||
644 | 644 | 1982-01-01 | CHINA INTERNATIONAL TRAVEL SERVICE, INC. | China National Tourist Office 3318 | Short-Form | TIEYING LI | Available-FARA-Public-Office | ||
645 | 645 | 1982-01-01 | CHINA INTERNATIONAL TRAVEL SERVICE, INC. | China National Tourist Office 3318 | Short-Form | ZIHAN LIU | Available-FARA-Public-Office | ||
646 | 646 | 1982-01-01 | CLEARY, GOTTLIEB, STEEN & HAMILTON | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | Short-Form | WILLIAM B. MCGURN, III | Available-FARA-Public-Office | ||
650 | 650 | 1982-01-01 | FAR EAST TRADE SERVICE, INC., SAN FRANCISCO | Far East Trade Services, Inc. 2985 | Short-Form | BRET E. LEE | Available-FARA-Public-Office | ||
664 | 664 | 1982-01-01 | JETRO, HOUSTON | JETRO, Houston 2277 | Short-Form | MASAKI ADACHI | Available-FARA-Public-Office | ||
665 | 665 | 1982-01-01 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Short-Form | TAKUMA OKADA | Available-FARA-Public-Office | ||
671 | 671 | 1982-01-01 | LEBOEUF, LAMB, GREENE & MACRAE, L.L.P. | LeBoeuf, Lamb, Greene & MacRae, L.L.P. 2868 | Short-Form | DANIEL J. CONWAY | Available-FARA-Public-Office | ||
677 | 677 | 1982-01-01 | M. SILVER ASSOCIATES, INC. | M. Silver Associates, Inc. 3131 | Short-Form | MARGARET BALDERSON ADAM | Available-FARA-Public-Office | ||
694 | 694 | 1982-01-01 | POWELL, GOLDSTEIN, FRAZER & MURPHY LLP | Powell, Goldstein, Frazer & Murphy, L.L.P. 3274 | Short-Form | JUDITH C. APPELBAUM | Available-FARA-Public-Office | ||
707 | 707 | 1982-01-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | HARRY CARLTON CROMER | Available-FARA-Public-Office | ||
708 | 708 | 1982-01-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | JOHN CHRISTOPHER HENRY | Available-FARA-Public-Office | ||
709 | 709 | 1982-01-01 | WASHINGTON INTERNATIONAL GROUP, INC. | Washington International Group, Inc. 3320 | Short-Form | JOHN J. MULLENHOLZ | Available-FARA-Public-Office | ||
710 | 710 | 1982-01-01 | WILLIAMS & JENSEN, P.C. | Williams & Jensen, P.C. 3112 | Short-Form | PAUL ARNESON | Available-FARA-Public-Office | ||
716 | 716 | 1983-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | BELTON T. ZEIGLER | Available-FARA-Public-Office | ||
717 | 717 | 1983-01-01 | ARNOLD & PORTER | Arnold & Porter Kaye Scholer LLP 1750 | Short-Form | JAN-ERIK SVENSSON | Available-FARA-Public-Office | ||
718 | 718 | 1983-01-01 | AUSTRALIAN TOURIST COMMISSION | Tourism Australia 1032 | Short-Form | KENNETH LEE CORBETT | Available-FARA-Public-Office | ||
719 | 719 | 1983-01-01 | BAHAMAS TOURIST OFFICE | Bahamas Tourist Office 2310 | Short-Form | RUSSELL EDWARD RAETHER | Available-FARA-Public-Office | ||
733 | 733 | 1983-01-01 | GOVERNMENT OF ANTIGUA & BARBUDA DEPARTMENT OF TOURISM | Government of Antigua & Barbuda Department of Tourism 2342 | Short-Form | ELAINE JOSEPH | Available-FARA-Public-Office | ||
734 | 734 | 1983-01-01 | GOVERNMENT OF ANTIGUA & BARBUDA DEPARTMENT OF TOURISM | Government of Antigua & Barbuda Department of Tourism 2342 | Short-Form | LLOYDSTONE L. JACOBS | Available-FARA-Public-Office | ||
736 | 736 | 1983-01-01 | HANNAFORD COMPANY, INC. | Hannaford Company, Inc. 2850 | Short-Form | PETER DOR HANNAFORD | Available-FARA-Public-Office | ||
770 | 770 | 1983-01-01 | IDA IRELAND | IDA Ireland 1770 | Short-Form | NICHOLAS RYAN | Available-FARA-Public-Office | ||
774 | 774 | 1983-01-01 | ITALIAN GOVERNMENT TOURIST BOARD (ENIT), LOS ANGELES | Italian Government Tourist Board (ENIT), Los Angeles 1884 | Short-Form | SILVERIO NARDONE | Available-FARA-Public-Office | ||
782 | 782 | 1983-01-01 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Short-Form | HIROSHI NAKANO | Available-FARA-Public-Office | ||
796 | 796 | 1983-01-01 | PROMOTIONAL CONCEPT GROUP, INC. | Promotional Concept Group, Inc. 3383 | Short-Form | JAMES SOMOHANA | Available-FARA-Public-Office | ||
797 | 797 | 1983-01-01 | QUEBEC GOVERNMENT HOUSE | Quebec Government Office 1787 | Short-Form | MURIEL CHAMBERLAND | Available-FARA-Public-Office | ||
798 | 798 | 1983-01-01 | ROBINSONS, INC. | Robinsons, Inc. 3110 | Short-Form | MARGARET PRICE | Available-FARA-Public-Office | ||
799 | 799 | 1983-01-01 | ROBINSONS, INC. | Robinsons, Inc. 3110 | Short-Form | WILLIAM LIENEWEBER | Available-FARA-Public-Office | ||
808 | 808 | 1983-01-01 | WEIL, GOTSHAL, & MANGES, LLP | Weil, Gotshal & Manges, L.L.P. 3317 | Short-Form | BRUCE H. TURNBULL | Available-FARA-Public-Office | ||
809 | 809 | 1983-01-01 | WEIL, GOTSHAL, & MANGES, LLP | Weil, Gotshal & Manges, L.L.P. 3317 | Short-Form | IRA M. MILLSTEIN | Available-FARA-Public-Office | ||
810 | 810 | 1983-01-01 | WEIL, GOTSHAL, & MANGES, LLP | Weil, Gotshal & Manges, L.L.P. 3317 | Short-Form | PHILIP G. BARBER | Available-FARA-Public-Office | ||
811 | 811 | 1983-01-01 | WEIL, GOTSHAL, & MANGES, LLP | Weil, Gotshal & Manges, L.L.P. 3317 | Short-Form | RICHARD J. DAVIS | Available-FARA-Public-Office | ||
812 | 812 | 1983-01-01 | WEIL, GOTSHAL, & MANGES, LLP | Weil, Gotshal & Manges, L.L.P. 3317 | Short-Form | RONALD F. DAITZ | Available-FARA-Public-Office | ||
816 | 816 | 1984-01-01 | AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | Short-Form | JAMES L. BAYLESS, JR. | Available-FARA-Public-Office | ||
821 | 821 | 1984-01-01 | CAYMAN ISLANDS DEPARTMENT OF TOURISM | Cayman Islands Department of Tourism 2500 | Short-Form | CONSTANCE CECILIA LEONG | Available-FARA-Public-Office | ||
823 | 823 | 1984-01-01 | CLEARY, GOTTLIEB, STEEN & HAMILTON | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | Short-Form | WILLIAM GANSON ROBERTSON | Available-FARA-Public-Office | ||
824 | 824 | 1984-01-01 | COLE CORETTE & ABRUTYN, P.C. | Cole Corette & Abrutyn, P.C. 2968 | Short-Form | LISA MEZZETI | Available-FARA-Public-Office | ||
825 | 825 | 1984-01-01 | COLE CORETTE & ABRUTYN, P.C. | Cole Corette & Abrutyn, P.C. 2968 | Short-Form | STEPHEN A. NAUHEIM | Available-FARA-Public-Office | ||
843 | 843 | 1984-01-01 | HANNAFORD COMPANY, INC. | Hannaford Company, Inc. 2850 | Short-Form | TONY A. TRUJILLO, JR. | Available-FARA-Public-Office | ||
846 | 846 | 1984-01-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | FRANK MANKIEWICZ | Available-FARA-Public-Office | ||
847 | 847 | 1984-01-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | JEAN Y. COLLEGE | Available-FARA-Public-Office | ||
848 | 848 | 1984-01-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | KRISTINE HEINE | Available-FARA-Public-Office | ||
849 | 849 | 1984-01-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | ROBERT K. GRAY | Available-FARA-Public-Office | ||
850 | 850 | 1984-01-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | ROBERT V. WITECK | Available-FARA-Public-Office | ||
851 | 851 | 1984-01-01 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | WILLIAM C. BENNETT | 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]) );