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

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

City 3

State 1

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   2022-01-10 Wild Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
138 138   2019-01-22 Zimmerman Ari Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
257 257   2022-02-03 Anderson LaKeitha Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
317 317   2022-02-10 Keating Timothy John Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
329 329   2020-02-14 Royce Edward Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
349 349   2021-02-16 Carl-Yoder Samantha Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
359 359   2022-02-18 Norton Travis Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
696 696   2022-04-01 Duffy Mark Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
789 789   2019-04-16 Maguire Douglas Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
793 793   2021-04-16 McGuire Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
862 862   2022-04-28 Diekman Lauren Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1075 1075   2021-05-26 Lyng Michelle Novitas Communication Inc. 6965 2021-05-26 Novitas Communication Inc. 1732 Wazee Street Suite 201 Denver CO 80202
1276 1276   2019-07-01 Burke Martha Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1331 1331   2018-07-15 Cohen David Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1336 1336   2012-07-17 Lampkin Marc S. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1593 1593   2021-09-04 Marshall Zachary A. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1622 1622   2017-09-08 Joynes Greta Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1673 1673   2016-09-22 Mottur Alfred E. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1674 1674   2016-09-22 Pfister Zach Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1864 1864   2016-10-24 Nicholson Robert James Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
1990 1990   2020-11-09 Elshami Nadeam Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2150 2150   2017-11-30 Littman Andrew Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2285 2285   2020-12-16 Begich Mark Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
2591 2591 1992-01-01 1989-08-29 Ulum David JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
2882 2882 2020-01-01 2009-02-02 Moschella William Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
3205 3205 2022-01-07 2019-01-10 Norton Travis Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
3747 3747 2022-01-16 2019-12-02 Cunningham David Summit Information Services Inc. 6760 2019-12-02 Summit Information Services Inc. 110 2nd Avenue, Suite 201 PO Box 4683 Frisco CO 80443
3748 3748 2022-01-16 2019-12-02 Mason Karen Summit Information Services Inc. 6760 2019-12-02 Summit Information Services Inc. 110 2nd Avenue, Suite 201 PO Box 4683 Frisco CO 80443
5882 5882 2022-02-03 2021-03-10 Callahan Sean Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
6131 6131 2022-02-07 2022-03-30 Graham Julian Sequoyah Roger Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
6185 6185 1984-02-08 1983-08-16 Kostka William , Jr. William Kostka & Associates, Inc. 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6186 6186 1984-02-08 1983-08-16 Webb Peter James William Kostka & Associates, Inc. 3511 1983-08-16 William Kostka & Associates, Inc. 1407 Larimer Square   Denver CO 80202
6243 6243 1988-02-09 1987-07-28 Garby Craig JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6281 6281 1981-02-10 1979-12-11 Hughes Gordon J. , Jr. Noranda Exploration, Inc. 3074 1979-12-11 Noranda Exploration, Inc. 12640 West Cedar Drive Post Office Box 15638 Denver CO 80214
6282 6282 1981-02-10 1979-12-11 McIntyre Stephen G. Noranda Exploration, Inc. 3074 1979-12-11 Noranda Exploration, Inc. 12640 West Cedar Drive Post Office Box 15638 Denver CO 80214
6283 6283 1981-02-10 1979-12-11 Nichols Mary Ann Noranda Exploration, Inc. 3074 1979-12-11 Noranda Exploration, Inc. 12640 West Cedar Drive Post Office Box 15638 Denver CO 80214
6284 6284 1981-02-10 1979-12-11 Snow Geoffrey G. Noranda Exploration, Inc. 3074 1979-12-11 Noranda Exploration, Inc. 12640 West Cedar Drive Post Office Box 15638 Denver CO 80214
6987 6987 2001-02-18 1997-09-19 Kawaguchi Takeyoshi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
7409 7409 2021-02-25 2018-07-30 Khachigian Kenneth L. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
8169 8169 2021-02-28 2019-05-23 Wild Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
8183 8183 2022-02-28 2019-05-30 Maier Elizabeth Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
8186 8186 2022-02-28 2019-09-27 Harju Lori Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
8187 8187 2022-02-28 2021-10-25 Pryor Mark Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
8915 8915 1998-03-05 1997-03-05 Sato Satoshi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
9241 9241 1994-03-09 1991-02-22 Yamagata Fujiya JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10397 10397 1997-03-24 1994-08-11 Okada Akinori JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10409 10409 2009-03-24 2009-01-30 Nicholson James Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
10410 10410 2009-03-24 2008-06-16 Cohen David P. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
10411 10411 2009-03-24 2008-06-16 Mottur Alfred E. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
10412 10412 2009-03-24 2008-06-16 Vickers Elizabeth W. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
11302 11302 1989-03-31 1988-09-15 Slovick Jay JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
15293 15293 2000-05-04 1997-09-19 Yoshida Takashi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
15723 15723 2017-05-12 2017-05-12 Burke Martha Ann Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
16036 16036 2013-05-15 2009-03-09 Katz Jason Tool Shed Group, LLC 5916 2009-03-09 Tool Shed Group, LLC 21382 Unbridled Drive   Parker CO 80138
16336 16336 2018-05-20 2018-02-09 Khachigian Kenneth L. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
16337 16337 2018-05-20 2018-02-13 Friednash Douglas Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
16338 16338 2018-05-20 2018-03-07 Stratton Michael Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
16339 16339 2018-05-20 2018-03-13 Blake Melissa Kuipers Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
16340 16340 2018-05-20 2017-12-06 Maguire Douglas Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
16341 16341 2018-05-20 2017-12-06 Maier Elizabeth Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
16342 16342 2018-05-20 2017-12-06 Pfister Zack Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
16739 16739 1994-05-26 1992-11-03 Lush Pamela G. DGL International Publishing, Ltd., Liability Company 4730 1992-11-03 DGL International Publishing, Ltd., Liability Company C/O Denver Centerpoint 3900 East Mexico Avenue #330 Denver CO 80210
18127 18127 1975-06-02 1974-02-28 Yim Choon Hui Korea Trade Promotion Office, Denver 2499 1974-02-28 Korea Trade Promotion Office, Denver 718 - 17th Street   Denver CO 80202
20037 20037 1999-06-29 1995-12-12 Yamamoto Hiromi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
20976 20976 2004-06-30 2001-09-17 Koshio Takaaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
22339 22339 1998-07-10 1994-05-18 Counihan Richard JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
22801 22801 2004-07-16 2002-09-04 Mooney Timothy P. JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
27311 27311 1978-08-31 1973-08-24 Elger Hermann W. Mexican Government Tourism Office, Denver 2455 1973-08-24 Mexican Government Tourism Office, Denver 425 South Cherry Street Suite 640 Denver CO 80222
27637 27637 1997-08-31 1993-11-12 Kiuchi Shinkichi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
27993 27993 2020-08-31 2019-04-10 McKeon Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
27999 27999 2020-08-31 2019-12-02 Saade Carol Summit Information Services Inc. 6760 2019-12-02 Summit Information Services Inc. 110 2nd Avenue, Suite 201 PO Box 4683 Frisco CO 80443
28252 28252 2008-09-01 2008-06-16 Hohlt Richard Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
28545 28545 2018-09-05 2016-09-22 Gore Elizabeth Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
28572 28572 1994-09-06 1992-07-27 Flanagan John M. JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
28835 28835 2021-09-10 2020-11-19 Carstens Charlotte Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
30680 30680 2008-09-30 2008-06-16 Flood James G. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
31624 31624 2017-10-06 2017-02-07 Maguire Douglas Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
31625 31625 2017-10-06 2017-03-22 Maier Elizabeth Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
32299 32299 2007-10-17 2007-07-02 Black Judy A. Brownstein Hyatt Farber Schreck, P.C. 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
32300 32300 2007-10-17 2007-07-02 Brownstein Norman Brownstein Hyatt Farber Schreck, P.C. 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
32301 32301 2007-10-17 2007-07-02 Cohen David P. Brownstein Hyatt Farber Schreck, P.C. 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
32302 32302 2007-10-17 2007-07-02 Dahl Alexander R. Brownstein Hyatt Farber Schreck, P.C. 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
32303 32303 2007-10-17 2007-07-02 Flood James G. Brownstein Hyatt Farber Schreck, P.C. 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
32304 32304 2007-10-17 2007-07-02 Levy Michael B. Brownstein Hyatt Farber Schreck, P.C. 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
32305 32305 2007-10-17 2007-07-02 Mottur Alfred E. Brownstein Hyatt Farber Schreck, P.C. 5818 2007-07-02 Brownstein Hyatt Farber Schreck, P.C. 410 Seventeenth Street Suite 2200 Denver CO 80802-4437
32521 32521 1990-10-21 1987-07-28 Kuraishi Fumiaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
33020 33020 2004-10-28 2001-03-16 Endo Toshiaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
33460 33460 1984-10-31 1979-10-01 Bayardo Francisco Mexican Government Tourism Office, Denver 2455 1973-08-24 Mexican Government Tourism Office, Denver 425 South Cherry Street Suite 640 Denver CO 80222
34920 34920 2017-11-13 2017-07-19 Wild Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
35697 35697 1995-11-28 1993-02-24 Nagata Mikio JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
40853 40853 2010-12-31 2008-06-16 Dahl Alexander R. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
40857 40857 2010-12-31 2010-07-29 Mottur Alfred E. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
41351 41351 2018-12-31 2017-11-29 Dalal Milan Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
41472 41472 2020-12-31 2019-06-20 Arneson Micaela Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
41516 41516 2021-12-31 2022-03-30 Bole Robert Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
41541 41541 2021-12-31 2021-11-24 Bole Robert Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
41542 41542 2021-12-31 2021-11-24 Duffy Mark Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
41543 41543 2021-12-31 2021-11-24 Roger Graham Julian Sequoyah Brownstein Hyatt Farber Schreck, LLP 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])
);