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

101 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_Date (date), Registration_Date (date)

City 3

State 1

  • CO · 101 ✖
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
158 158   2019-01-22 Zimmerman Ari Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
293 293   2022-02-03 Anderson LaKeitha Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
353 353   2022-02-10 Keating Timothy John Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
367 367   2020-02-14 Royce Edward Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
413 413   2021-02-16 Carl-Yoder Samantha Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
423 423   2022-02-18 Norton Travis Joseph Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
717 717   2023-03-30 Usyk Andrew Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
829 829   2019-04-16 Maguire Douglas Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
832 832   2021-04-16 McGuire Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
920 920   2022-04-28 Diekman Lauren Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1140 1140   2021-05-26 Lyng Michelle Novitas Communication Inc. 6965 2021-05-26 Novitas Communication Inc. 1732 Wazee Street Suite 201 Denver CO 80202
1229 1229   2023-06-06 Wines Phillips Morgan Kelly Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1351 1351   2019-07-01 Burke Martha Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1396 1396   2018-07-15 Cohen David Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1401 1401   2012-07-17 Lampkin Marc S. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1684 1684   2021-09-04 Marshall Zachary A. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1709 1709   2017-09-08 Joynes Greta Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1750 1750   2022-09-14 Mottur Thomas Robb Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1788 1788   2016-09-22 Mottur Alfred E. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1789 1789   2016-09-22 Pfister Zach Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1997 1997   2016-10-24 Nicholson Robert James Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
2099 2099   2020-11-09 Elshami Nadeam Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
2269 2269   2017-11-30 Littman Andrew Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
2398 2398   2020-12-16 Begich Mark Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
2715 2715 1992-01-01 1989-08-29 Ulum David JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
3006 3006 2020-01-01 2009-02-02 Moschella William Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
3013 3013 2022-01-01 2019-01-10 Norton Travis Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
3917 3917 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
3918 3918 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
6078 6078 2022-02-03 2021-03-10 Callahan Sean Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
6331 6331 2022-02-07 2022-03-30 Graham Julian Sequoyah Roger Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
6386 6386 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
6387 6387 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
6445 6445 1988-02-09 1987-07-28 Garby Craig JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6484 6484 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
6485 6485 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
6486 6486 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
6487 6487 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
7193 7193 2001-02-18 1997-09-19 Kawaguchi Takeyoshi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
7623 7623 2021-02-25 2018-07-30 Khachigian Kenneth L. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
8380 8380 2021-02-28 2019-05-23 Wild Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
8397 8397 2022-02-28 2019-05-30 Maier Elizabeth Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
8400 8400 2022-02-28 2019-09-27 Harju Lori Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
9149 9149 1998-03-05 1997-03-05 Sato Satoshi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
9487 9487 1994-03-09 1991-02-22 Yamagata Fujiya JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10656 10656 1997-03-24 1994-08-11 Okada Akinori JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10668 10668 2009-03-24 2009-01-30 Nicholson James Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
10669 10669 2009-03-24 2008-06-16 Cohen David P. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
10670 10670 2009-03-24 2008-06-16 Mottur Alfred E. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
10671 10671 2009-03-24 2008-06-16 Vickers Elizabeth W. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
11565 11565 1989-03-31 1988-09-15 Slovick Jay JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
15661 15661 2000-05-04 1997-09-19 Yoshida Takashi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
16101 16101 2017-05-12 2017-05-12 Burke Martha Ann Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
16421 16421 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
16727 16727 2018-05-20 2018-02-09 Khachigian Kenneth L. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
16728 16728 2018-05-20 2018-02-13 Friednash Douglas Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
16729 16729 2018-05-20 2018-03-07 Stratton Michael Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
16730 16730 2018-05-20 2018-03-13 Blake Melissa Kuipers Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
16731 16731 2018-05-20 2017-12-06 Maguire Douglas Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
16732 16732 2018-05-20 2017-12-06 Maier Elizabeth Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
16733 16733 2018-05-20 2017-12-06 Pfister Zack Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
17134 17134 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
18561 18561 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
20495 20495 1999-06-29 1995-12-12 Yamamoto Hiromi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21435 21435 2004-06-30 2001-09-17 Koshio Takaaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
22836 22836 1998-07-10 1994-05-18 Counihan Richard JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
23304 23304 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
25681 25681 2022-08-01 2022-04-01 Duffy Mark Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
27920 27920 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
28246 28246 1997-08-31 1993-11-12 Kiuchi Shinkichi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
28599 28599 2020-08-31 2019-04-10 McKeon Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
28608 28608 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
28868 28868 2008-09-01 2008-06-16 Hohlt Richard Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
29162 29162 2018-09-05 2016-09-22 Gore Elizabeth Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
29189 29189 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
29461 29461 2021-09-10 2020-11-19 Carstens Charlotte Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
31323 31323 2008-09-30 2008-06-16 Flood James G. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
32298 32298 2017-10-06 2017-02-07 Maguire Douglas Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
32299 32299 2017-10-06 2017-03-22 Maier Elizabeth Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
32991 32991 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
32992 32992 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
32993 32993 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
32994 32994 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
32995 32995 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
32996 32996 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
32997 32997 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
33214 33214 1990-10-21 1987-07-28 Kuraishi Fumiaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
33715 33715 2004-10-28 2001-03-16 Endo Toshiaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
34159 34159 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
34986 34986 2021-11-01 2021-10-25 Pryor Mark Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
35641 35641 2017-11-13 2017-07-19 Wild Brian Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
36423 36423 1995-11-28 1993-02-24 Nagata Mikio JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
41615 41615 2010-12-31 2008-06-16 Dahl Alexander R. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
41619 41619 2010-12-31 2010-07-29 Mottur Alfred E. Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
42113 42113 2018-12-31 2017-11-29 Dalal Milan Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
42233 42233 2020-12-31 2019-06-20 Arneson Micaela Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
42289 42289 2021-12-31 2022-03-30 Bole Robert Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
42323 42323 2021-12-31 2021-11-24 Bole Robert Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
42324 42324 2021-12-31 2021-11-24 Duffy Mark Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
42325 42325 2021-12-31 2021-11-24 Roger Graham Julian Sequoyah Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432

Next page

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])
);