FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
135,872 rows sorted by rowid descending
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Name, Foreign_Principal_Country
Link | rowid ▲ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
122068 | 122068 | 2013-11-27 | Korea Business Center | KOTRA 1619 | Short-Form | Kim, Chanyoul | https://efile.fara.gov/docs/1619-Short-Form-20131127-304.pdf | ||
122067 | 122067 | 2013-11-27 | Jones Walker, LLP | Jones Walker, LLP 6165 | Supplemental Statement | https://efile.fara.gov/docs/6165-Supplemental-Statement-20131127-1.pdf | |||
122066 | 122066 | 2013-11-27 | Independent Diplomat, Inc. | Independent Diplomat, Inc. 5860 | Supplemental Statement | https://efile.fara.gov/docs/5860-Supplemental-Statement-20131127-11.pdf | |||
122065 | 122065 | 2013-11-27 | Independent Diplomat, Inc. | Independent Diplomat, Inc. 5860 | Exhibit AB | Government of Southern Sudan (GOSS) | REPUBLIC OF SOUTH SUDAN | https://efile.fara.gov/docs/5860-Exhibit-AB-20131127-14.pdf | |
122064 | 122064 | 2013-11-27 | Independent Diplomat, Inc. | Independent Diplomat, Inc. 5860 | Amendment | https://efile.fara.gov/docs/5860-Amendment-20131127-16.pdf | |||
122063 | 122063 | 2013-11-27 | Friends of Sinn Fein, Inc. | Friends of Sinn Fein, Inc. 5006 | Supplemental Statement | https://efile.fara.gov/docs/5006-Supplemental-Statement-20131127-19.pdf | |||
122062 | 122062 | 2013-11-27 | Friends of Sinn Fein, Inc. | Friends of Sinn Fein, Inc. 5006 | Exhibit D | https://efile.fara.gov/docs/5006-Exhibit-D-20131127-32.pdf | |||
122061 | 122061 | 2013-11-27 | Bryan Cave, LLP | Bryan Cave, LLP 6163 | Supplemental Statement | https://efile.fara.gov/docs/6163-Supplemental-Statement-20131127-1.pdf | |||
122060 | 122060 | 2013-11-27 | 30 Point Strategies, LLC | 30 Point Strategies, LLC 5884 | Supplemental Statement | https://efile.fara.gov/docs/5884-Supplemental-Statement-20131127-11.pdf | |||
122059 | 122059 | 2012-11-27 | Ruder Finn, Inc. | Ruder Finn, Inc. 1481 | Short-Form | Polskin, Philippa | https://efile.fara.gov/docs/1481-Short-Form-20121127-20.pdf | ||
122058 | 122058 | 2012-11-27 | Moroccan-American Center for Policy, Inc. | Moroccan-American Center for Policy, Inc. 5648 | Supplemental Statement | https://efile.fara.gov/docs/5648-Supplemental-Statement-20121127-17.pdf | |||
122057 | 122057 | 2012-11-27 | Moffett Group, LLC | Moffett Group, LLC 5802 | Supplemental Statement | https://efile.fara.gov/docs/5802-Supplemental-Statement-20121127-12.pdf | |||
122056 | 122056 | 2012-11-27 | Marston Webb & Associates | Marston Webb & Associates 5929 | Supplemental Statement | https://efile.fara.gov/docs/5929-Supplemental-Statement-20121127-6.pdf | |||
122055 | 122055 | 2012-11-27 | Kurdistan Regional Government - Liaison Office - USA | Kurdistan Regional Government - Liaison Office - USA 5783 | Supplemental Statement | https://efile.fara.gov/docs/5783-Supplemental-Statement-20121127-7.pdf | |||
122054 | 122054 | 2012-11-27 | International Merchandising Corporation | International Merchandising Corporation 6032 | Supplemental Statement | https://efile.fara.gov/docs/6032-Supplemental-Statement-20121127-3.pdf | |||
122053 | 122053 | 2012-11-27 | Goumbri, Olivia | Goumbri, Olivia 5957 | Supplemental Statement | https://efile.fara.gov/docs/5957-Supplemental-Statement-20121127-6.pdf | |||
122052 | 122052 | 2012-11-27 | Deutsche Telekom, Inc. | Deutsche Telekom, Inc. 4419 | Supplemental Statement | https://efile.fara.gov/docs/4419-Supplemental-Statement-20121127-16.pdf | |||
122051 | 122051 | 2012-11-27 | British Virgin Islands Tourist Board | British Virgin Islands Tourist Board 3354 | Supplemental Statement | https://efile.fara.gov/docs/3354-Supplemental-Statement-20121127-16.pdf | |||
122050 | 122050 | 2009-11-27 | Maynard, Cooper and Gale, P.C. | Maynard, Cooper and Gale, P.C. 5716 | Supplemental Statement | https://efile.fara.gov/docs/5716-Supplemental-Statement-20091127-8.pdf | |||
122049 | 122049 | 2009-11-27 | Korea National Tourism Organization, New Jersey | Korea National Tourism Organization, New Jersey 2614 | Supplemental Statement | https://efile.fara.gov/docs/2614-Supplemental-Statement-20091127-10.pdf | |||
122048 | 122048 | 2009-11-27 | Korea National Tourism Organization, New Jersey | Korea National Tourism Organization, New Jersey 2614 | Short-Form | Park, Younghee | https://efile.fara.gov/docs/2614-Short-Form-20091127-16.pdf | ||
122047 | 122047 | 2009-11-27 | Jamaica Tourist Board, Florida | Jamaica Tourist Board, Florida 2360 | Supplemental Statement | https://efile.fara.gov/docs/2360-Supplemental-Statement-20091127-10.pdf | |||
122046 | 122046 | 2009-11-27 | Global Communicators, LLC | Global Communicators, LLC 5817 | Amendment | https://efile.fara.gov/docs/5817-Amendment-20091127-7.pdf | |||
122045 | 122045 | 2007-11-27 | Rude, Marianne Haslund | Rude, Marianne Haslund 5767 | Supplemental Statement | https://efile.fara.gov/docs/5767-Supplemental-Statement-20071127-2.pdf | |||
122044 | 122044 | 2007-11-27 | Miller & Chevalier, Chartered | Miller & Chevalier, Chartered 5365 | Supplemental Statement | https://efile.fara.gov/docs/5365-Supplemental-Statement-20071127-7.pdf | |||
122043 | 122043 | 2007-11-27 | Ethiopian Peoples' Revolutionary Party | Ethiopian People's Revolutionary Party 4789 | Supplemental Statement | https://efile.fara.gov/docs/4789-Supplemental-Statement-20071127-6.pdf | |||
122042 | 122042 | 2006-11-27 | Troutman Sanders LLP | Troutman Sanders LLP 5618 | Supplemental Statement | https://efile.fara.gov/docs/5618-Supplemental-Statement-20061127-5.pdf | |||
122041 | 122041 | 2006-11-27 | Shemdin, Nijyar H. | Shemdin, Nijyar H. 5196 | Supplemental Statement | https://efile.fara.gov/docs/5196-Supplemental-Statement-20061127-5.pdf | |||
122040 | 122040 | 2006-11-27 | Public Strategies Washington, Inc. | Public Strategies Washington, Inc. 4486 | Supplemental Statement | https://efile.fara.gov/docs/4486-Supplemental-Statement-20061127-3.pdf | |||
122039 | 122039 | 2006-11-27 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Ichiki, Tomoko | Available-FARA-Public-Office | ||
122038 | 122038 | 2006-11-27 | Levick Strategic Communications | Levick Strategic Communications 5649 | Short-Form | Kerr, Meghan | Available-FARA-Public-Office | ||
122037 | 122037 | 2006-11-27 | Levick Strategic Communications | Levick Strategic Communications 5649 | Short-Form | Cohen, Stacy | Available-FARA-Public-Office | ||
122036 | 122036 | 2006-11-27 | Levick Strategic Communications | Levick Strategic Communications 5649 | Short-Form | Cline, Korenna | Available-FARA-Public-Office | ||
122035 | 122035 | 2006-11-27 | Korea Trade Promotion Center | KOTRA 1619 | Supplemental Statement | https://efile.fara.gov/docs/1619-Supplemental-Statement-20061127-3.pdf | |||
122034 | 122034 | 2006-11-27 | Korea Trade Promotion Center | KOTRA 1619 | Short-Form | Lee, Seung Ki | Available-FARA-Public-Office | ||
122033 | 122033 | 2006-11-27 | Korea Trade Promotion Center | KOTRA 1619 | Short-Form | Koh, Kwang Wouck | Available-FARA-Public-Office | ||
122032 | 122032 | 2006-11-27 | Korea Trade Promotion Center | KOTRA 1619 | Short-Form | Kim, Moon Young | Available-FARA-Public-Office | ||
122031 | 122031 | 2006-11-27 | Korea Trade Promotion Center | KOTRA 1619 | Short-Form | Kim, Min Jo | Available-FARA-Public-Office | ||
122030 | 122030 | 2006-11-27 | Korea Trade Promotion Center | KOTRA 1619 | Short-Form | Hwang, Min Ha | Available-FARA-Public-Office | ||
122029 | 122029 | 2006-11-27 | Korea Trade Promotion Center | KOTRA 1619 | Short-Form | Ahn, Sang Keun | Available-FARA-Public-Office | ||
122028 | 122028 | 2006-11-27 | Hastings, Jay Donald | Hastings, Jay Donald 2867 | Supplemental Statement | https://efile.fara.gov/docs/2867-Supplemental-Statement-20061127-4.pdf | |||
122027 | 122027 | 2006-11-27 | Gabriel Company, LLC | Gabriel Company, LLC 5523 | Supplemental Statement | https://efile.fara.gov/docs/5523-Supplemental-Statement-20061127-4.pdf | |||
122026 | 122026 | 2002-11-27 | Skadden, Arps, Slate, Meagher & Flom, LLP | Skadden, Arps, Slate, Meagher & Flom, LLP 5460 | Amendment | https://efile.fara.gov/docs/5460-Amendment-20021127-HCU0VQ03.pdf | |||
122025 | 122025 | 2002-11-27 | Skadden, Arps, Slate, Meagher & Flom, LLP | Skadden, Arps, Slate, Meagher & Flom, LLP 5460 | Amendment | https://efile.fara.gov/docs/5460-Amendment-20021127-HCU0TX03.pdf | |||
122024 | 122024 | 2002-11-27 | Skadden, Arps, Slate, Meagher & Flom, LLP | Skadden, Arps, Slate, Meagher & Flom, LLP 5460 | Amendment | https://efile.fara.gov/docs/5460-Amendment-20021127-HCU0S703.pdf | |||
122023 | 122023 | 2002-11-27 | Patrice Tanaka & Company, Inc. | Patrice Tanaka & Company, Inc. 5426 | Short-Form | Kazam,Keren | Available-FARA-Public-Office | ||
122022 | 122022 | 2002-11-27 | Greenberg Traurig, L.L.P. | Greenberg Traurig, L.L.P. 5494 | Exhibit C | https://efile.fara.gov/docs/5494-Exhibit-C-20021127-H6WV2N03.pdf | |||
122021 | 122021 | 2002-11-27 | Barbour Griffith & Rogers, LLC | BGR Government Affairs, LLC 5430 | Exhibit AB | Embassy of Honduras | HONDURAS | https://efile.fara.gov/docs/5430-Exhibit-AB-20021127-23.pdf | |
122020 | 122020 | 2001-11-27 | Whitmore, Judith M. | Whitmore, Judith M. 4336 | Amendment | https://efile.fara.gov/docs/4336-Amendment-20011127-GSO8OT03.pdf | |||
122019 | 122019 | 1998-11-27 | GOVERNMENT OF DUBAI, DEPT. OF TOURISM & COMMERCE MARKETING | Government of Dubai, Dept. of Tourism & Commerce Marketing 4217 | Short-Form | PETER G. STRENG | Available-FARA-Public-Office | ||
122018 | 122018 | 1995-11-27 | SZLAVIK, HOGAN & MILLER, INC. | Szlavik, Hogan & Miller, Inc. 4716 | Amendment | https://efile.fara.gov/docs/4716-Amendment-19951127-DJSFUW03.pdf | |||
122017 | 122017 | 1995-11-27 | JWI, L.L.C. | JWI, LLC 4990 | Short-Form | WILLIAM D. MUTCH | Available-FARA-Public-Office | ||
122016 | 122016 | 1995-11-27 | BERRY, MAX N. | Berry, Max N. 2216 | Exhibit AB | TILDA RICE | GREAT BRITAIN | https://efile.fara.gov/docs/2216-Exhibit-AB-19951127-DJMUUQ94.pdf | |
122015 | 122015 | 1994-11-27 | SINGAPORE TRADE DEVELOPMENT BOARD | Singapore Trade Development Board 2979 | Supplemental Statement | https://efile.fara.gov/docs/2979-Supplemental-Statement-19941127-DQS9DG03.pdf | |||
122014 | 122014 | 1994-11-27 | DEWEY BALLANTINE | Dewey Ballantine 3759 | Supplemental Statement | https://efile.fara.gov/docs/3759-Supplemental-Statement-19941127-DNV2QR92.pdf | |||
122013 | 122013 | 1992-11-27 | NUTTER & HARRIS, INC. | Nutter & Harris, Inc. 4635 | Exhibit AB | CENTRAL MEDICAL ADMINISTRATION OF MOSCOW | RUSSIA | https://efile.fara.gov/docs/4635-Exhibit-AB-19921127-D1WANA04.pdf | |
122012 | 122012 | 1991-11-27 | CONNAUGHT LABORATORIES, INC. | Connaught Laboratories, Inc. 4129 | Short-Form | PINYA COHEN | Available-FARA-Public-Office | ||
122011 | 122011 | 1991-11-27 | BURSON-MARSTELLER | Burson-Marsteller 2469 | Short-Form | KAREN E. HAINES | Available-FARA-Public-Office | ||
122010 | 122010 | 1990-11-27 | HILL & KNOWLTON, INC. | Hill and Knowlton Strategies, LLC 3301 | Short-Form | GREGORY W. LABRACHE | Available-FARA-Public-Office | ||
122009 | 122009 | 1990-11-27 | AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | Exhibit AB | MATSUSHITA ELECTRONICS CORPORATION | JAPAN | https://efile.fara.gov/docs/3492-Exhibit-AB-19901127-D0U7UO01.pdf | |
122008 | 122008 | 1989-11-27 | Amtorg Trading Corporation | Amtorg Trading Corporation 596 | Short-Form | Teteryukov ,Viacheslav B. | Available-FARA-Public-Office | ||
122007 | 122007 | 1989-11-27 | Amtorg Trading Corporation | Amtorg Trading Corporation 596 | Short-Form | Romanov ,Gennadiy T. | Available-FARA-Public-Office | ||
122006 | 122006 | 1989-11-27 | Amtorg Trading Corporation | Amtorg Trading Corporation 596 | Short-Form | Godakov ,Anatoly E. | Available-FARA-Public-Office | ||
122005 | 122005 | 1985-11-27 | DEWEY BALLANTINE | Dewey Ballantine 3759 | Short-Form | JOHN J. SALMON | Available-FARA-Public-Office | ||
122004 | 122004 | 1985-11-27 | DEWEY BALLANTINE | Dewey Ballantine 3759 | Short-Form | JAYNE F. BOYLE | Available-FARA-Public-Office | ||
122003 | 122003 | 1981-11-27 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | JACOB J. EBELING-KONING | Available-FARA-Public-Office | ||
122002 | 122002 | 1981-11-27 | NETHERLANDS CHAMBER OF COMMERCE IN THE U.S., INC. | Netherlands Chamber of Commerce in the U.S., Inc. 456 | Short-Form | C. J. P. VAN BAASBANK | Available-FARA-Public-Office | ||
122001 | 122001 | 1976-11-27 | JAPAN ECONOMIC INSTITUTE OF AMERICA | Japan Economic Institute of America 929 | Short-Form | LAWRENCE R. WALDERS | Available-FARA-Public-Office | ||
122000 | 122000 | 1976-11-27 | JAPAN ECONOMIC INSTITUTE OF AMERICA | Japan Economic Institute of America 929 | Short-Form | LAWRENCE R. WALDERS | Available-FARA-Public-Office | ||
121999 | 121999 | 1976-11-27 | JAPAN ECONOMIC INSTITUTE OF AMERICA | Japan Economic Institute of America 929 | Short-Form | JOHN A. KENNEDY, JR. | Available-FARA-Public-Office | ||
121998 | 121998 | 1976-11-27 | JAPAN ECONOMIC INSTITUTE OF AMERICA | Japan Economic Institute of America 929 | Short-Form | J OHN A. KENNEDY, JR. | Available-FARA-Public-Office | ||
121997 | 121997 | 1973-11-27 | KEATING GROUP, INC. | Keating Group, Inc. 2478 | Short-Form | HENRY BIONDOLILLO | Available-FARA-Public-Office | ||
121996 | 121996 | 1972-11-27 | Arab Information Center | Arab Information Center 876 | Exhibit AB | League of Arab States | INTERNATIONAL | https://efile.fara.gov/docs/876-Exhibit-AB-19721127-HAXJY303.pdf | |
121995 | 121995 | 1964-11-27 | Boukstein, Maurice M. | Boukstein, Maurice M. 544 | Supplemental Statement | https://efile.fara.gov/docs/544-Supplemental-Statement-19641127-35.pdf | |||
121994 | 121994 | 2022-11-26 | ANC-Global, Inc. | ANC-Global, Inc. 6731 | Amendment | https://efile.fara.gov/docs/6731-Amendment-20221126-8.pdf | |||
121993 | 121993 | 2021-11-26 | Ghebi LLC | Ghebi LLC 6869 | Informational Materials | Federal State Unitary Enterprise Rossiya Segodnya International Information Agency | RUSSIA | https://efile.fara.gov/docs/6869-Informational-Materials-20211126-385.pdf | |
121992 | 121992 | 2021-11-26 | Actum International UK Limited | Actum International UK Limited 7033 | Amendment | https://efile.fara.gov/docs/7033-Amendment-20211126-2.pdf | |||
121991 | 121991 | 2021-11-26 | Actum International UK Limited | Actum International UK Limited 7033 | Amendment | https://efile.fara.gov/docs/7033-Amendment-20211126-1.pdf | |||
121990 | 121990 | 2019-11-26 | theGroup DC, LLC | theGroup DC, LLC 6388 | Supplemental Statement | https://efile.fara.gov/docs/6388-Supplemental-Statement-20191126-6.pdf | |||
121989 | 121989 | 2019-11-26 | White House Writers Group, Inc. | White House Writers Group, Inc. 6477 | Supplemental Statement | https://efile.fara.gov/docs/6477-Supplemental-Statement-20191126-4.pdf | |||
121988 | 121988 | 2019-11-26 | Taiwan Democratic Progressive Party Mission in the U.S. | Taiwan Democratic Progressive Party Mission in the U.S. 6187 | Informational Materials | Democratic Progressive Party | TAIWAN | https://efile.fara.gov/docs/6187-Informational-Materials-20191126-11.pdf | |
121987 | 121987 | 2019-11-26 | Rubenstein Public Relations, Inc. | Rubenstein Public Relations, Inc. 6691 | Informational Materials | Consulate General of the Dominican Republic | DOMINICAN REPUBLIC | https://efile.fara.gov/docs/6691-Informational-Materials-20191126-11.pdf | |
121986 | 121986 | 2019-11-26 | Rosemont Associates, LLC | Rosemont Associates, LLC 6161 | Supplemental Statement | https://efile.fara.gov/docs/6161-Supplemental-Statement-20191126-14.pdf | |||
121985 | 121985 | 2019-11-26 | Representative of the Turkish Republic of Northern Cyprus | Representative of the Turkish Republic of Northern Cyprus 2619 | Supplemental Statement | https://efile.fara.gov/docs/2619-Supplemental-Statement-20191126-30.pdf | |||
121984 | 121984 | 2019-11-26 | Representative of the Turkish Republic of Northern Cyprus | Representative of the Turkish Republic of Northern Cyprus 2619 | Amendment | https://efile.fara.gov/docs/2619-Amendment-20191126-35.pdf | |||
121983 | 121983 | 2019-11-26 | Polish Chamber of Commerce in the US | Polish Chamber of Commerce in the US 6545 | Amendment | https://efile.fara.gov/docs/6545-Amendment-20191126-4.pdf | |||
121982 | 121982 | 2019-11-26 | Nelson Mullins Riley & Scarborough, LLP | Nelson Mullins Riley & Scarborough, LLP 5928 | Supplemental Statement | https://efile.fara.gov/docs/5928-Supplemental-Statement-20191126-21.pdf | |||
121981 | 121981 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Supplemental Statement | https://efile.fara.gov/docs/6549-Supplemental-Statement-20191126-4.pdf | |||
121980 | 121980 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | Oceguera, Fernanda Melgoza | https://efile.fara.gov/docs/6549-Short-Form-20191126-126.pdf | ||
121979 | 121979 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | McCarthy, Taryn | https://efile.fara.gov/docs/6549-Short-Form-20191126-132.pdf | ||
121978 | 121978 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | Luckey, Chris | https://efile.fara.gov/docs/6549-Short-Form-20191126-120.pdf | ||
121977 | 121977 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | Hefflinger, Amanda | https://efile.fara.gov/docs/6549-Short-Form-20191126-118.pdf | ||
121976 | 121976 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | Fox, Dylan | https://efile.fara.gov/docs/6549-Short-Form-20191126-124.pdf | ||
121975 | 121975 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | Felipe, Jessica | https://efile.fara.gov/docs/6549-Short-Form-20191126-128.pdf | ||
121974 | 121974 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | DeMirci, Walter | https://efile.fara.gov/docs/6549-Short-Form-20191126-136.pdf | ||
121973 | 121973 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | Click, Collin | https://efile.fara.gov/docs/6549-Short-Form-20191126-122.pdf | ||
121972 | 121972 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | Carvajal, Tricia | https://efile.fara.gov/docs/6549-Short-Form-20191126-134.pdf | ||
121971 | 121971 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Short-Form | Averay Cuesta, Julie | https://efile.fara.gov/docs/6549-Short-Form-20191126-130.pdf | ||
121970 | 121970 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Exhibit AB | Turismo de Tenerife | SPAIN | https://efile.fara.gov/docs/6549-Exhibit-AB-20191126-38.pdf | |
121969 | 121969 | 2019-11-26 | Myriad International Marketing, LLC | Myriad International Marketing, LLC 6549 | Exhibit AB | Turismo de Portugal | PORTUGAL | https://efile.fara.gov/docs/6549-Exhibit-AB-20191126-37.pdf |
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]) );