FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

82 rows where State = "CO"

✎ 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

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
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
134 134   2019-01-22 Zimmerman Ari 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
336 336   2020-02-14 Royce Edward 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
345 345   2021-02-16 Carl-Yoder Samantha 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
657 657   2019-04-16 Maguire Douglas 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
863 863   2019-05-23 Wild Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
926 926   2019-05-30 Maier Elizabeth 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1086 1086   2019-07-01 Burke Martha 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1149 1149   2018-07-15 Cohen David 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1154 1154   2012-07-17 Lampkin Marc S. 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1226 1226   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
1451 1451   2017-09-08 Joynes Greta 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1519 1519   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
1520 1520   2016-09-22 Pfister Zach 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1730 1730   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
1755 1755   2019-10-27 Harju Lori 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1851 1851   2020-11-09 Elshami Nadeam 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1935 1935   2020-11-19 Carstens Charlotte 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2028 2028   2017-11-30 Littman Andrew 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2054 2054   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
2058 2058   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
2140 2140   2020-12-16 Begich Mark 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2473 2473 1992-01-01 1989-08-29 Ulum David 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
2764 2764 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
5976 5976 1984-02-08 1983-08-16 Kostka William , Jr. 3511 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
5977 5977 1984-02-08 1983-08-16 Webb Peter James 3511 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6034 6034 1988-02-09 1987-07-28 Garby Craig 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6072 6072 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
6073 6073 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
6074 6074 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
6075 6075 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
6756 6756 2001-02-18 1997-09-19 Kawaguchi Takeyoshi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
8627 8627 1998-03-05 1997-03-05 Sato Satoshi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
8950 8950 1994-03-09 1991-02-22 Yamagata Fujiya 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10087 10087 1997-03-24 1994-08-11 Okada Akinori 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10099 10099 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
10100 10100 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
10101 10101 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
10102 10102 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
10986 10986 1989-03-31 1988-09-15 Slovick Jay 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
14813 14813 2000-05-04 1997-09-19 Yoshida Takashi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
15228 15228 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
15536 15536 2013-05-15 2009-03-09 Katz Jason 5916 5916 2009-03-09 Tool Shed Group, LLC 21382 Unbridled Drive   Parker CO 80138
15832 15832 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
15833 15833 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
15834 15834 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
15835 15835 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
15836 15836 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
15837 15837 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
15838 15838 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
16230 16230 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
17576 17576 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
19461 19461 1999-06-29 1995-12-12 Yamamoto Hiromi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
20399 20399 2004-06-30 2001-09-17 Koshio Takaaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21682 21682 1998-07-10 1994-05-18 Counihan Richard 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
22142 22142 2004-07-16 2002-09-04 Mooney Timothy P. 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
26608 26608 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
26934 26934 1997-08-31 1993-11-12 Kiuchi Shinkichi 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
27288 27288 2020-08-31 2019-04-10 McKeon Brian 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
27293 27293 2020-08-31 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
27533 27533 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
27819 27819 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
27846 27846 1994-09-06 1992-07-27 Flanagan John M. 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
29937 29937 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
30851 30851 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
30852 30852 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
31516 31516 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
31517 31517 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
31518 31518 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
31519 31519 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
31520 31520 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
31521 31521 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
31522 31522 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
31734 31734 1990-10-21 1987-07-28 Kuraishi Fumiaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
32223 32223 2004-10-28 2001-03-16 Endo Toshiaki 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
32659 32659 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
34072 34072 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
34822 34822 1995-11-28 1993-02-24 Nagata Mikio 4017 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
39908 39908 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
39912 39912 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
40397 40397 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
40477 40477 2020-12-31 2019-06-20 Arneson Micaela 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)
);