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

74 rows where City = "Denver"

✎ View and edit SQL

This data as json, 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 · 74 ✖
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
58 58   2019-01-10 Norton Travis 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
113 113   2019-01-22 Zimmerman Ari 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
282 282   2020-02-14 Royce Edward 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
659 659   2019-04-10 McKeon Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
681 681   2019-04-16 Maguire Douglas 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
968 968   2019-05-23 Wild Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1049 1049   2019-05-30 Maier Elizabeth 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1173 1173   2019-06-20 Arneson Micaela 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1249 1249   2019-07-01 Burke Martha 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1339 1339   2018-07-15 Cohen David 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1346 1346   2012-07-17 Lampkin Marc 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1441 1441   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
1662 1662   2017-09-08 Joynes Greta 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1738 1738   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
1739 1739   2016-09-22 Pfister Zach 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1957 1957   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
1984 1984   2019-10-27 Harju Lori 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2220 2220   2017-11-30 Littman Andrew 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2647 2647 1992-01-01 1989-08-29 Ulum David 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
2936 2936 2020-01-01 2009-02-02 Moschella William 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
6098 6098 1984-02-08 1983-08-16 Kostka William , Jr. 3511 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6099 6099 1984-02-08 1983-08-16 Webb Peter James 3511 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6156 6156 1988-02-09 1987-07-28 Garby Craig 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6192 6192 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
6193 6193 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
6194 6194 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
6195 6195 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
6852 6852 2001-02-18 1997-09-19 Kawaguchi Takeyoshi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
8665 8665 1998-03-05 1997-03-05 Sato Satoshi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
8988 8988 1994-03-09 1991-02-22 Yamagata Fujiya 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10124 10124 1997-03-24 1994-08-11 Okada Akinori 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10136 10136 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
10137 10137 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
10138 10138 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
10139 10139 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
11021 11021 1989-03-31 1988-09-15 Slovick Jay 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
14791 14791 2000-05-04 1997-09-19 Yoshida Takashi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
15205 15205 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
15801 15801 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
15802 15802 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
15803 15803 2018-05-20 2018-03-07 Stratton Michael 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
15804 15804 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
15805 15805 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
15806 15806 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
15807 15807 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
16192 16192 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
17522 17522 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
19389 19389 1999-06-29 1995-12-12 Yamamoto Hiromi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
20327 20327 2004-06-30 2001-09-17 Koshio Takaaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21593 21593 1998-07-10 1994-05-18 Counihan Richard 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
22043 22043 2004-07-16 2002-09-04 Mooney Timothy P. 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
26406 26406 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
26732 26732 1997-08-31 1993-11-12 Kiuchi Shinkichi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
27319 27319 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
27602 27602 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
27627 27627 1994-09-06 1992-07-27 Flanagan John M. 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
29708 29708 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
30596 30596 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
30597 30597 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
31251 31251 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
31252 31252 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
31253 31253 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
31254 31254 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
31255 31255 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
31256 31256 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
31257 31257 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
31460 31460 1990-10-21 1987-07-28 Kuraishi Fumiaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
31941 31941 2004-10-28 2001-03-16 Endo Toshiaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
32373 32373 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
33757 33757 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
34492 34492 1995-11-28 1993-02-24 Nagata Mikio 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
39530 39530 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
39534 39534 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
40018 40018 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 383.642ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history