FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where City = "Denver", State = "CO" and Zip = 80202
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1113 | 1113 | 2021-05-26 | Lyng | Michelle | Novitas Communication Inc. 6965 | 2021-05-26 | Novitas Communication Inc. | 1732 Wazee Street | Suite 201 | 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 |
6405 | 6405 | 1984-02-08 | 1983-08-16 | Kostka | William , Jr. | William Kostka & Associates, Inc. 3511 | 1983-08-16 | William Kostka & Associates, Inc. | 1407 Larimer Square | Denver | CO | 80202 | |
6406 | 6406 | 1984-02-08 | 1983-08-16 | Webb | Peter James | William Kostka & Associates, Inc. 3511 | 1983-08-16 | William Kostka & Associates, Inc. | 1407 Larimer Square | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
18627 | 18627 | 1975-06-02 | 1974-02-28 | Yim | Choon Hui | Korea Trade Promotion Office, Denver 2499 | 1974-02-28 | Korea Trade Promotion Office, Denver | 718 - 17th Street | 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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]) );