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

This data as json, atom, CSV (advanced)

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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