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

78 rows where State = "CO"

✎ 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

City

State

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
69 69   2019-01-10 Norton Travis 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
135 135   2019-01-22 Zimmerman Ari 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
243 243   2009-02-02 Moschella William 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
330 330   2020-02-14 Royce Edward 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
432 432   2018-03-07 Stratton Michael 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
620 620   2019-04-10 McKeon Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
646 646   2019-04-16 Maguire Douglas 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
908 908   2019-05-23 Wild Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
966 966   2019-05-30 Maier Elizabeth 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1056 1056   2019-06-20 Arneson Micaela 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1127 1127   2019-07-01 Burke Martha 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1194 1194   2018-07-15 Cohen David 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1201 1201   2012-07-17 Lampkin Marc 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1280 1280   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
1507 1507   2017-09-08 Joynes Greta 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1593 1593   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
1594 1594   2016-09-22 Pfister Zach 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1850 1850   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
1884 1884   2019-10-27 Harju Lori 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2145 2145   2017-11-30 Littman Andrew 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2173 2173   2019-12-02 Cunningham David 6760 6760 2019-12-02 Summit Information Services Inc. 110 2nd Avenue, Suite 201 PO Box 4683 Frisco CO 80443
2180 2180   2019-12-02 Mason Karen 6760 6760 2019-12-02 Summit Information Services Inc. 110 2nd Avenue, Suite 201 PO Box 4683 Frisco CO 80443
2184 2184   2019-12-02 Saade Carol 6760 6760 2019-12-02 Summit Information Services Inc. 110 2nd Avenue, Suite 201 PO Box 4683 Frisco CO 80443
2596 2596 1992-01-01 1989-08-29 Ulum David 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6011 6011 1984-02-08 1983-08-16 Kostka William , Jr. 3511 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6012 6012 1984-02-08 1983-08-16 Webb Peter James 3511 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6069 6069 1988-02-09 1987-07-28 Garby Craig 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6105 6105 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
6106 6106 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
6107 6107 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
6108 6108 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
6760 6760 2001-02-18 1997-09-19 Kawaguchi Takeyoshi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
8544 8544 1998-03-05 1997-03-05 Sato Satoshi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
8866 8866 1994-03-09 1991-02-22 Yamagata Fujiya 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
9998 9998 1997-03-24 1994-08-11 Okada Akinori 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10010 10010 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
10011 10011 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
10012 10012 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
10013 10013 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
10888 10888 1989-03-31 1988-09-15 Slovick Jay 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
14584 14584 2000-05-04 1997-09-19 Yoshida Takashi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
14998 14998 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
15304 15304 2013-05-15 2009-03-09 Katz Jason 5916 5916 2009-03-09 Tool Shed Group, LLC 21382 Unbridled Drive   Parker CO 80138
15591 15591 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
15592 15592 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
15593 15593 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
15594 15594 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
15595 15595 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
15596 15596 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
15978 15978 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
17295 17295 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
19153 19153 1999-06-29 1995-12-12 Yamamoto Hiromi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
20091 20091 2004-06-30 2001-09-17 Koshio Takaaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21334 21334 1998-07-10 1994-05-18 Counihan Richard 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21783 21783 2004-07-16 2002-09-04 Mooney Timothy P. 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
26124 26124 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
26450 26450 1997-08-31 1993-11-12 Kiuchi Shinkichi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
27033 27033 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
27315 27315 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
27339 27339 1994-09-06 1992-07-27 Flanagan John M. 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
29413 29413 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
30294 30294 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
30295 30295 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
30943 30943 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
30944 30944 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
30945 30945 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
30946 30946 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
30947 30947 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
30948 30948 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
30949 30949 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
31150 31150 1990-10-21 1987-07-28 Kuraishi Fumiaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
31630 31630 2004-10-28 2001-03-16 Endo Toshiaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
32062 32062 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
33431 33431 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
34164 34164 1995-11-28 1993-02-24 Nagata Mikio 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
39176 39176 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
39180 39180 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
39657 39657 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 343.812ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history