FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Document_Type = "Short-Form" and Registrant_Name = "JFCC, WASHINGTON OFFICE"
This data as json, CSV (advanced)
Registrant_Name 1
- JFCC, WASHINGTON OFFICE · 8 ✖
Foreign_Principal_Name 1
- - 8
Foreign_Principal_Country 1
- - 8
Document_Type 1
- Short-Form · 8 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
61451 | 61451 | 1993-06-01 | JFCC, WASHINGTON OFFICE | JFCC, Washington Office 4440 | Short-Form | HITOSHI MATSUZAKI | Available-FARA-Public-Office | ||
69109 | 69109 | 1994-06-30 | JFCC, WASHINGTON OFFICE | JFCC, Washington Office 4440 | Short-Form | TAKASHI DOKIYA | Available-FARA-Public-Office | ||
69110 | 69110 | 1994-06-30 | JFCC, WASHINGTON OFFICE | JFCC, Washington Office 4440 | Short-Form | TETSUYA ISHIKAWA | Available-FARA-Public-Office | ||
106138 | 106138 | 1991-10-02 | JFCC, WASHINGTON OFFICE | JFCC, Washington Office 4440 | Short-Form | SHINTARO TAKEMOTO | Available-FARA-Public-Office | ||
106139 | 106139 | 1991-10-02 | JFCC, WASHINGTON OFFICE | JFCC, Washington Office 4440 | Short-Form | SHUNZABURO KOBAYASHI | Available-FARA-Public-Office | ||
115403 | 115403 | 1990-11-01 | JFCC, WASHINGTON OFFICE | JFCC, Washington Office 4440 | Short-Form | TAKASHI YOSHINO | Available-FARA-Public-Office | ||
131941 | 131941 | 1996-12-19 | JFCC, WASHINGTON OFFICE | JFCC, Washington Office 4440 | Short-Form | KENJI HIROTA | Available-FARA-Public-Office | ||
132816 | 132816 | 1998-12-22 | JFCC, WASHINGTON OFFICE | JFCC, Washington Office 4440 | Short-Form | TOSHIO TAKAHASHI | 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]) );