FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
179 rows where Foreign_Principal_Country = "" and Registration_Number = 2438 sorted by URL
This data as json, CSV (advanced)
Suggested facets: Date_Stamped (date)
Document_Type 5
Registrant_Name 2
Foreign_Principal_Name 1
- - 179
Foreign_Principal_Country 1
- - · 179 ✖
Link | rowid | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL ▼ |
---|---|---|---|---|---|---|---|---|---|
426 | 426 | 1978-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | 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 | ||
6472 | 6472 | 1976-01-21 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | FUGIE ROSE KAJIMURA | Available-FARA-Public-Office | ||
6473 | 6473 | 1976-01-21 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | Available-FARA-Public-Office | ||
10799 | 10799 | 1976-02-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | GORDAN S. CLINTON | Available-FARA-Public-Office | ||
12364 | 12364 | 1991-02-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KEITH C. THOMSON | Available-FARA-Public-Office | ||
20886 | 20886 | 1976-03-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | FUGIE ROSE KAJIMURA | Available-FARA-Public-Office | ||
36106 | 36106 | 1992-04-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIAKI BABA | Available-FARA-Public-Office | ||
39203 | 39203 | 1995-04-10 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | UEDA, KYOJI | Available-FARA-Public-Office | ||
42888 | 42888 | 1977-04-26 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | FUGIE ROSE KAJIMURA | Available-FARA-Public-Office | ||
42889 | 42889 | 1977-04-26 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | Available-FARA-Public-Office | ||
43901 | 43901 | 1994-04-29 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | BABA, TOSHIAKI | Available-FARA-Public-Office | ||
43902 | 43902 | 1994-04-29 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | PAMELA S. COWAN | Available-FARA-Public-Office | ||
43903 | 43903 | 1994-04-29 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | UEDA, KYOJI | Available-FARA-Public-Office | ||
45779 | 45779 | 1978-05-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | FUGIE ROSE KAJIMURA | Available-FARA-Public-Office | ||
45780 | 45780 | 1978-05-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | Available-FARA-Public-Office | ||
46560 | 46560 | 1987-05-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIYUKI ISHIDA | Available-FARA-Public-Office | ||
52051 | 52051 | 1991-05-15 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIAKI BABA | Available-FARA-Public-Office | ||
52052 | 52052 | 1991-05-15 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIYUKI ISHIDA | Available-FARA-Public-Office | ||
58643 | 58643 | 1982-06-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIYUKI ISHIDA | Available-FARA-Public-Office | ||
70687 | 70687 | 1973-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Registration Statement | Available-FARA-Public-Office | |||
70688 | 70688 | 1973-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | Available-FARA-Public-Office | ||
70980 | 70980 | 1980-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | Available-FARA-Public-Office | ||
71054 | 71054 | 1981-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | KOTARO YAMADA | Available-FARA-Public-Office | ||
73515 | 73515 | 1997-07-02 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIHIKO ONO | Available-FARA-Public-Office | ||
82265 | 82265 | 1982-08-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIYUKI ISHIDA | Available-FARA-Public-Office | ||
82336 | 82336 | 1983-08-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIYUKI ISHIDA | Available-FARA-Public-Office | ||
84457 | 84457 | 2002-08-01 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Matsuda,Takaaki | Available-FARA-Public-Office | ||
86063 | 86063 | 2003-08-07 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Tokizawa,Devin | Available-FARA-Public-Office | ||
86064 | 86064 | 2003-08-07 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Weiss,Sandra L. | Available-FARA-Public-Office | ||
86065 | 86065 | 2003-08-07 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Yamamoto,Takeshi | Available-FARA-Public-Office | ||
90767 | 90767 | 2005-08-30 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Weiss-Plass, Sandra L. | Available-FARA-Public-Office | ||
93100 | 93100 | 1988-09-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Short-Form | TOSHIYUKI ISHIDA | Available-FARA-Public-Office | ||
100565 | 100565 | 2006-09-26 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Uematsu, Kenji | Available-FARA-Public-Office | ||
70395 | 70395 | 1942-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Amendment | https://efile.fara.gov/docs/2438-Amendment-19420701-DOL42I01.pdf | |||
111726 | 111726 | 1997-10-28 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Amendment | https://efile.fara.gov/docs/2438-Amendment-19971028-EN3M1505.pdf | |||
120338 | 120338 | 1997-11-18 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Amendment | https://efile.fara.gov/docs/2438-Amendment-19971118-EMJ2UE05.pdf | |||
16986 | 16986 | 2012-02-17 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Amendment | https://efile.fara.gov/docs/2438-Amendment-20120217-1.pdf | |||
19329 | 19329 | 2015-02-27 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Amendment | https://efile.fara.gov/docs/2438-Amendment-20150227-2.pdf | |||
30560 | 30560 | 2022-03-24 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Amendment | https://efile.fara.gov/docs/2438-Amendment-20220324-3.pdf | |||
12363 | 12363 | 1991-02-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19910201-CZMXPQ02.pdf | |||
35599 | 35599 | 1991-04-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19910401-CZMXP902.pdf | |||
104919 | 104919 | 1991-10-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19911001-CZMQPV02.pdf | |||
127013 | 127013 | 1991-12-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19911201-CZMQPM02.pdf | |||
23295 | 23295 | 1992-03-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19920301-CZMSTN02.pdf | |||
23296 | 23296 | 1992-03-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19920301-CZMSTV02.pdf | |||
36105 | 36105 | 1992-04-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19920401-CZMRVA02.pdf | |||
60851 | 60851 | 1992-06-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19920601-CZMRQ902.pdf | |||
72638 | 72638 | 1992-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19920701-CZMV3002.pdf | |||
83804 | 83804 | 1992-08-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19920801-CZMS4802.pdf | |||
116155 | 116155 | 1992-11-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19921101-CZMV1K02.pdf | |||
116156 | 116156 | 1992-11-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19921101-CZMV5P02.pdf | |||
127595 | 127595 | 1992-12-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19921201-CZMSTE02.pdf | |||
2464 | 2464 | 1993-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19930101-CZMSFC02.pdf | |||
13007 | 13007 | 1993-02-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19930201-CZMST502.pdf | |||
13008 | 13008 | 1993-02-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19930201-CZMUWZ02.pdf | |||
23765 | 23765 | 1993-03-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19930301-CZMV1702.pdf | |||
23766 | 23766 | 1993-03-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19930301-CZMVIZ02.pdf | |||
36672 | 36672 | 1993-04-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19930401-CZMVIQ02.pdf | |||
105784 | 105784 | 1993-10-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19931001-CZMYTX02.pdf | |||
133821 | 133821 | 1994-12-28 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19941228-E93K1003.pdf | |||
56537 | 56537 | 1995-05-31 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19950531-DZUA5K03.pdf | |||
68445 | 68445 | 1995-06-29 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19950629-DZMX9F04.pdf | |||
75334 | 75334 | 1995-07-11 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Dissemination Report | https://efile.fara.gov/docs/2438-Dissemination-Report-19950711-DZOQML03.pdf | |||
89620 | 89620 | 2008-08-25 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Menard, Marie | https://efile.fara.gov/docs/2438-Short-Form-20080825-6.pdf | ||
95194 | 95194 | 2009-09-02 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Nakamura, Toshihiko | https://efile.fara.gov/docs/2438-Short-Form-20090902-8.pdf | ||
84857 | 84857 | 2011-08-02 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Hoak-Kagey, Laura | https://efile.fara.gov/docs/2438-Short-Form-20110802-10.pdf | ||
77094 | 77094 | 2012-07-19 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Kakiuchi, Masao | https://efile.fara.gov/docs/2438-Short-Form-20120719-12.pdf | ||
88335 | 88335 | 2015-08-18 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Sometani, Tetsuya | https://efile.fara.gov/docs/2438-Short-Form-20150818-14.pdf | ||
88334 | 88334 | 2015-08-18 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Seely, Holly | https://efile.fara.gov/docs/2438-Short-Form-20150818-16.pdf | ||
15309 | 15309 | 2016-02-09 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Nave, Andrew | https://efile.fara.gov/docs/2438-Short-Form-20160209-18.pdf | ||
89300 | 89300 | 2018-08-23 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Nagamine, Masanori | https://efile.fara.gov/docs/2438-Short-Form-20180823-20.pdf | ||
89299 | 89299 | 2018-08-23 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Corpuz, Samantha | https://efile.fara.gov/docs/2438-Short-Form-20180823-22.pdf | ||
87840 | 87840 | 2019-08-15 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Wyruchowski, Dawn | https://efile.fara.gov/docs/2438-Short-Form-20190815-24.pdf | ||
87841 | 87841 | 2019-08-15 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Wyruchowski, Dawn | https://efile.fara.gov/docs/2438-Short-Form-20190815-26.pdf | ||
90056 | 90056 | 2020-08-27 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Wyruchowski, Dawn | https://efile.fara.gov/docs/2438-Short-Form-20200827-28.pdf | ||
121291 | 121291 | 2021-11-22 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Inada, Kenju | https://efile.fara.gov/docs/2438-Short-Form-20211122-30.pdf | ||
121292 | 121292 | 2021-11-22 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Tippens, Teresa | https://efile.fara.gov/docs/2438-Short-Form-20211122-32.pdf | ||
20185 | 20185 | 2022-02-28 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Van Ginhoven, Sam | https://efile.fara.gov/docs/2438-Short-Form-20220228-34.pdf | ||
26889 | 26889 | 2022-03-10 | Kobe Trade Information Office | Kobe Trade Information Office 2438 | Short-Form | Van Ginhoven, Sam Roger | https://efile.fara.gov/docs/2438-Short-Form-20220310-36.pdf | ||
276 | 276 | 1974-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19740101-CZN1J902.pdf | |||
70721 | 70721 | 1974-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19740701-CZN1IB02.pdf | |||
318 | 318 | 1975-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19750101-CZN1HE02.pdf | |||
70752 | 70752 | 1975-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19750701-CZN1GG02.pdf | |||
350 | 350 | 1976-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19760101-CZN1FI02.pdf | |||
70792 | 70792 | 1976-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19760701-CZN1DJ02.pdf | |||
385 | 385 | 1977-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19770101-CZN1CI02.pdf | |||
70831 | 70831 | 1977-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19770701-CZN1AZ02.pdf | |||
427 | 427 | 1978-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19780101-CZMYE602.pdf | |||
70877 | 70877 | 1978-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19780701-CZN1OZ02.pdf | |||
480 | 480 | 1979-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19790101-CZN1NU02.pdf | |||
70924 | 70924 | 1979-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19790701-CZN1MH02.pdf | |||
550 | 550 | 1980-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19800101-CZN1LG02.pdf | |||
70981 | 70981 | 1980-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19800701-CZMXUM02.pdf | |||
605 | 605 | 1981-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19810101-CZMYCG02.pdf | |||
71055 | 71055 | 1981-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19810701-CZMYB702.pdf | |||
666 | 666 | 1982-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19820101-CZMYA602.pdf | |||
71107 | 71107 | 1982-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19820701-CZMY8X02.pdf | |||
783 | 783 | 1983-01-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19830101-CZMY7O02.pdf | |||
71168 | 71168 | 1983-07-01 | KOBE TRADE INFORMATION OFFICE | Kobe Trade Information Office 2438 | Supplemental Statement | https://efile.fara.gov/docs/2438-Supplemental-Statement-19830701-CZMY6J02.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]) );