FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

73 rows where City = "Denver"

View and edit SQL

Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

City

  • Denver · 73
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
71   2019-01-10 Norton Travis 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
137   2019-01-22 Zimmerman Ari 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
237   2009-02-02 Moschella William 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
415   2018-03-07 Stratton Michael 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
604   2019-04-10 McKeon Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
631   2019-04-16 Maguire Douglas 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
893   2019-05-23 Wild Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
951   2019-05-30 Maier Elizabeth 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1042   2019-06-20 Arneson Micaela 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1113   2019-07-01 Burke Martha 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1181   2018-07-15 Cohen David 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1188   2012-07-17 Lampkin Marc 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1268   2018-07-30 Khachigian Kenneth L. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1495   2017-09-08 Joynes Greta 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1581   2016-09-22 Mottur Alfred E. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1582   2016-09-22 Pfister Zach 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1838   2016-10-24 Nicholson Robert James 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1872   2019-10-27 Harju Lori 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2136   2017-11-30 Littman Andrew 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2589 1992-01-01 1989-08-29 Ulum David 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6003 1984-02-08 1983-08-16 Kostka William , Jr. 3511 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6004 1984-02-08 1983-08-16 Webb Peter James 3511 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6061 1988-02-09 1987-07-28 Garby Craig 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6097 1981-02-10 1979-12-11 Hughes Gordon J. , Jr. 3074 3074 1979-12-11 Noranda Exploration, Inc. 12640 West Cedar Drive Post Office Box 15638 Denver CO 80214
6098 1981-02-10 1979-12-11 McIntyre Stephen G. 3074 3074 1979-12-11 Noranda Exploration, Inc. 12640 West Cedar Drive Post Office Box 15638 Denver CO 80214
6099 1981-02-10 1979-12-11 Nichols Mary Ann 3074 3074 1979-12-11 Noranda Exploration, Inc. 12640 West Cedar Drive Post Office Box 15638 Denver CO 80214
6100 1981-02-10 1979-12-11 Snow Geoffrey G. 3074 3074 1979-12-11 Noranda Exploration, Inc. 12640 West Cedar Drive Post Office Box 15638 Denver CO 80214
6752 2001-02-18 1997-09-19 Kawaguchi Takeyoshi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
8536 1998-03-05 1997-03-05 Sato Satoshi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
8858 1994-03-09 1991-02-22 Yamagata Fujiya 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
9990 1997-03-24 1994-08-11 Okada Akinori 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10002 2009-03-24 2009-01-30 Nicholson James 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
10003 2009-03-24 2008-06-16 Cohen David P. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
10004 2009-03-24 2008-06-16 Mottur Alfred E. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
10005 2009-03-24 2008-06-16 Vickers Elizabeth W. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
10880 1989-03-31 1988-09-15 Slovick Jay 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
14575 2000-05-04 1997-09-19 Yoshida Takashi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
14989 2017-05-12 2017-05-12 Burke Martha Ann 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
15582 2018-05-20 2018-02-09 Khachigian Kenneth L. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
15583 2018-05-20 2018-02-13 Friednash Douglas 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
15584 2018-05-20 2018-03-13 Blake Melissa Kuipers 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
15585 2018-05-20 2017-12-06 Maguire Douglas 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
15586 2018-05-20 2017-12-06 Maier Elizabeth 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
15587 2018-05-20 2017-12-06 Pfister Zack 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
15969 1994-05-26 1992-11-03 Lush Pamela G. 4730 4730 1992-11-03 DGL International Publishing, Ltd., Liability Company C/O Denver Centerpoint 3900 East Mexico Avenue #330 Denver CO 80210
17285 1975-06-02 1974-02-28 Yim Choon Hui 2499 2499 1974-02-28 Korea Trade Promotion Office, Denver 718 - 17th Street   Denver CO 80202
19142 1999-06-29 1995-12-12 Yamamoto Hiromi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
20080 2004-06-30 2001-09-17 Koshio Takaaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21322 1998-07-10 1994-05-18 Counihan Richard 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21771 2004-07-16 2002-09-04 Mooney Timothy P. 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
26103 1978-08-31 1973-08-24 Elger Hermann W. 2455 2455 1973-08-24 Mexican Government Tourism Office, Denver 425 South Cherry Street Suite 640 Denver CO 80222
26429 1997-08-31 1993-11-12 Kiuchi Shinkichi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
27012 2008-09-01 2008-06-16 Hohlt Richard 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
27294 2018-09-05 2016-09-22 Gore Elizabeth 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
27318 1994-09-06 1992-07-27 Flanagan John M. 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
29392 2008-09-30 2008-06-16 Flood James G. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
30272 2017-10-06 2017-02-07 Maguire Douglas 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
30273 2017-10-06 2017-03-22 Maier Elizabeth 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
30921 2007-10-17 2007-07-02 Black Judy A. 5818 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
30922 2007-10-17 2007-07-02 Brownstein Norman 5818 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
30923 2007-10-17 2007-07-02 Cohen David P. 5818 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
30924 2007-10-17 2007-07-02 Dahl Alexander R. 5818 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
30925 2007-10-17 2007-07-02 Flood James G. 5818 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
30926 2007-10-17 2007-07-02 Levy Michael B. 5818 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
30927 2007-10-17 2007-07-02 Mottur Alfred E. 5818 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
31127 1990-10-21 1987-07-28 Kuraishi Fumiaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
31606 2004-10-28 2001-03-16 Endo Toshiaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
32038 1984-10-31 1979-10-01 Bayardo Francisco 2455 2455 1973-08-24 Mexican Government Tourism Office, Denver 425 South Cherry Street Suite 640 Denver CO 80222
33407 2017-11-13 2017-07-19 Wild Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
34140 1995-11-28 1993-02-24 Nagata Mikio 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
39150 2010-12-31 2008-06-16 Dahl Alexander R. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
39154 2010-12-31 2010-07-29 Mottur Alfred E. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
39631 2018-12-31 2017-11-29 Dalal Milan 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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)
);
Powered by Datasette · Query took 318.056ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history