FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Registrant_Name = "JETRO, Denver" and State = "CO" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Date (date)
State 1
- CO · 17 ✖
Registration_Number 1
Registration_Date (date) 1 ✖
- 1987-07-28 17
Registrant_Name 1
- JETRO, Denver · 17 ✖
City 1
- Denver 17
Link | rowid ▲ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
36515 | 36515 | 1995-11-28 | 1993-02-24 | Nagata | Mikio | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
33804 | 33804 | 2004-10-28 | 2001-03-16 | Endo | Toshiaki | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
33303 | 33303 | 1990-10-21 | 1987-07-28 | Kuraishi | Fumiaki | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
29276 | 29276 | 1994-09-06 | 1992-07-27 | Flanagan | John M. | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
28332 | 28332 | 1997-08-31 | 1993-11-12 | Kiuchi | Shinkichi | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
23387 | 23387 | 2004-07-16 | 2002-09-04 | Mooney | Timothy P. | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
22919 | 22919 | 1998-07-10 | 1994-05-18 | Counihan | Richard | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
21509 | 21509 | 2004-06-30 | 2001-09-17 | Koshio | Takaaki | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
20569 | 20569 | 1999-06-29 | 1995-12-12 | Yamamoto | Hiromi | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
15714 | 15714 | 2000-05-04 | 1997-09-19 | Yoshida | Takashi | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
11609 | 11609 | 1989-03-31 | 1988-09-15 | Slovick | Jay | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
10698 | 10698 | 1997-03-24 | 1994-08-11 | Okada | Akinori | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
9525 | 9525 | 1994-03-09 | 1991-02-22 | Yamagata | Fujiya | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
9183 | 9183 | 1998-03-05 | 1997-03-05 | Sato | Satoshi | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
7224 | 7224 | 2001-02-18 | 1997-09-19 | Kawaguchi | Takeyoshi | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
6464 | 6464 | 1988-02-09 | 1987-07-28 | Garby | Craig | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
2721 | 2721 | 1992-01-01 | 1989-08-29 | Ulum | David | JETRO, Denver 4017 | 1987-07-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );