FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Document_Type = "Short-Form" and Registrant_Name = "JETRO, DENVER"
This data as json, CSV (advanced)
Registrant_Name 1
- JETRO, DENVER · 14 ✖
Foreign_Principal_Name 1
- - 14
Foreign_Principal_Country 1
- - 14
Document_Type 1
- Short-Form · 14 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
12348 | 12348 | 1991-02-01 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | FUJIYA YAMAGATA | Available-FARA-Public-Office | ||
12649 | 12649 | 1992-02-01 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | MIKIO NAGATA | Available-FARA-Public-Office | ||
25368 | 25368 | 1997-03-05 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | SATOSHI SATO | Available-FARA-Public-Office | ||
52871 | 52871 | 1994-05-18 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | RICHARD COUNIHAN | Available-FARA-Public-Office | ||
72618 | 72618 | 1992-07-01 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | JOHN M. FLANAGAN | Available-FARA-Public-Office | ||
79419 | 79419 | 1987-07-28 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | CRAIG GARBY | Available-FARA-Public-Office | ||
79420 | 79420 | 1987-07-28 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | FUMIAKI KURAISHI | Available-FARA-Public-Office | ||
83030 | 83030 | 1989-08-01 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | DAVID ULUM | Available-FARA-Public-Office | ||
86962 | 86962 | 1994-08-11 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | AKINORI OKADA | Available-FARA-Public-Office | ||
93093 | 93093 | 1988-09-01 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | JAY SLOVICK | Available-FARA-Public-Office | ||
98905 | 98905 | 1997-09-19 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | TAKASHI YOSHIDA | Available-FARA-Public-Office | ||
98906 | 98906 | 1997-09-19 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | TAKEYOSHI KAWAGUCHI | Available-FARA-Public-Office | ||
116488 | 116488 | 1993-11-01 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | SHINKICHI KIUCHI | Available-FARA-Public-Office | ||
130484 | 130484 | 1995-12-12 | JETRO, DENVER | JETRO, Denver 4017 | Short-Form | HIROMI YAMAMOTO | 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]) );