FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
106 rows where State = "CO"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
25767 | 25767 | 2022-08-01 | 2022-04-01 | Duffy | Mark | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
28006 | 28006 | 1978-08-31 | 1973-08-24 | Elger | Hermann W. | Mexican Government Tourism Office, Denver 2455 | 1973-08-24 | Mexican Government Tourism Office, Denver | 425 South Cherry Street | Suite 640 | Denver | CO | 80222 |
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 |
28685 | 28685 | 2020-08-31 | 2019-04-10 | McKeon | Brian | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
28694 | 28694 | 2020-08-31 | 2019-12-02 | Saade | Carol | Summit Information Services Inc. 6760 | 2019-12-02 | Summit Information Services Inc. | 110 2nd Avenue, Suite 201 | PO Box 4683 | Frisco | CO | 80443 |
28955 | 28955 | 2008-09-01 | 2008-06-16 | Hohlt | Richard | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
29249 | 29249 | 2018-09-05 | 2016-09-22 | Gore | Elizabeth | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
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 |
29548 | 29548 | 2021-09-10 | 2020-11-19 | Carstens | Charlotte | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
31410 | 31410 | 2008-09-30 | 2008-06-16 | Flood | James G. | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
32387 | 32387 | 2017-10-06 | 2017-02-07 | Maguire | Douglas | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
32388 | 32388 | 2017-10-06 | 2017-03-22 | Maier | Elizabeth | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
33080 | 33080 | 2007-10-17 | 2007-07-02 | Black | Judy A. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33081 | 33081 | 2007-10-17 | 2007-07-02 | Brownstein | Norman | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33082 | 33082 | 2007-10-17 | 2007-07-02 | Cohen | David P. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33083 | 33083 | 2007-10-17 | 2007-07-02 | Dahl | Alexander R. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33084 | 33084 | 2007-10-17 | 2007-07-02 | Flood | James G. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33085 | 33085 | 2007-10-17 | 2007-07-02 | Levy | Michael B. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
33086 | 33086 | 2007-10-17 | 2007-07-02 | Mottur | Alfred E. | Brownstein Hyatt Farber Schreck, P.C. 5818 | 2007-07-02 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 |
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 |
34248 | 34248 | 1984-10-31 | 1979-10-01 | Bayardo | Francisco | Mexican Government Tourism Office, Denver 2455 | 1973-08-24 | Mexican Government Tourism Office, Denver | 425 South Cherry Street | Suite 640 | Denver | CO | 80222 |
35076 | 35076 | 2021-11-01 | 2021-10-25 | Pryor | Mark | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
35733 | 35733 | 2017-11-13 | 2017-07-19 | Wild | Brian | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
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 |
41709 | 41709 | 2010-12-31 | 2008-06-16 | Dahl | Alexander R. | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
41713 | 41713 | 2010-12-31 | 2010-07-29 | Mottur | Alfred E. | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
42207 | 42207 | 2018-12-31 | 2017-11-29 | Dalal | Milan | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
42327 | 42327 | 2020-12-31 | 2019-06-20 | Arneson | Micaela | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
42381 | 42381 | 2021-12-31 | 2022-03-30 | Bole | Robert | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
42415 | 42415 | 2021-12-31 | 2021-11-24 | Bole | Robert | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
42416 | 42416 | 2021-12-31 | 2021-11-24 | Duffy | Mark | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
42417 | 42417 | 2021-12-31 | 2021-11-24 | Roger Graham | Julian Sequoyah | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
42428 | 42428 | 2022-12-31 | 2022-01-10 | Wild | Brian | Brownstein Hyatt Farber Schreck, LLP 5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 |
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]) );