FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Foreign_Principal_Country = "JAPAN" and Foreign_Principal_Name = "JAPAN EXTERNAL TRADE ORGANIZATION (JETRO)"
This data as json, CSV (advanced)
Registrant_Name 9
Foreign_Principal_Name 1
- JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) · 11 ✖
Foreign_Principal_Country 1
- JAPAN · 11 ✖
Document_Type 1
- Exhibit AB 11
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
10539 | 10539 | 1965-02-01 | JETRO, CHICAGO | JETRO, Chicago 1850 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/1850-Exhibit-AB-19650201-CZ2HIT02.pdf | |
70609 | 70609 | 1971-07-01 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/1833-Exhibit-AB-19710701-CZ2D1B02.pdf | |
71603 | 71603 | 1987-07-01 | JETRO, DENVER | JETRO, Denver 4017 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/4017-Exhibit-AB-19870701-D1J22602.pdf | |
81729 | 81729 | 1971-08-01 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/1833-Exhibit-AB-19710801-CZ2E0M02.pdf | |
91778 | 91778 | 1971-09-01 | JETRO, HOUSTON | JETRO, Houston 2277 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/2277-Exhibit-AB-19710901-CZC87403.pdf | |
113930 | 113930 | 1964-11-01 | JETRO, SAN FRANCISCO | JETRO, San Francisco 1813 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/1813-Exhibit-AB-19641101-CZ166P02.pdf | |
121538 | 121538 | 1997-11-24 | BUSINESS NETWORK CORPORATION | Business Network Corporation 4513 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/4513-Exhibit-AB-19971124-EM2CUN03.pdf | |
123894 | 123894 | 1964-12-01 | JETRO, LOS ANGELES | JETRO, Los Angeles 1833 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/1833-Exhibit-AB-19641201-CZ2G4702.pdf | |
125862 | 125862 | 1987-12-01 | JETRO, ATLANTA | JETRO, Atlanta 4069 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/4069-Exhibit-AB-19871201-D1IHAG02.pdf | |
129122 | 129122 | 1997-12-05 | SMITH MCCABE, LTD. | Smith McCabe, Ltd. 4687 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/4687-Exhibit-AB-19971205-EO6KGP03.pdf | |
134067 | 134067 | 1970-12-29 | VAN BRUNT & COMPANY ADVERTISING-MARKETING, INC. | Van Brunt & Company Advertising-Marketing, Inc. 1704 | Exhibit AB | JAPAN EXTERNAL TRADE ORGANIZATION (JETRO) | JAPAN | https://efile.fara.gov/docs/1704-Exhibit-AB-19701229-CYPRJY02.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]) );