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

106 rows where State = "CO"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date)

City 3

State 1

  • CO · 106 ✖
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
163 163   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
296 296   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
352 352   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
366 366   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
412 412   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
422 422   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
702 702   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
810 810   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
813 813   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
901 901   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
1113 1113   2021-05-26 Lyng Michelle Novitas Communication Inc. 6965 2021-05-26 Novitas Communication Inc. 1732 Wazee Street Suite 201 Denver CO 80202
1198 1198   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
1327 1327   2023-06-29 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
1329 1329   2023-06-29 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
1345 1345   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
1403 1403   2023-07-13 Grunes Allen Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1404 1404   2023-07-13 Hancock Harold Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1408 1408   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
1413 1413   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
1499 1499   2023-07-27 Sullivan Russell Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
1720 1720   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
1745 1745   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
1785 1785   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
1822 1822   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
1823 1823   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
2024 2024   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
2126 2126   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
2289 2289   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
2413 2413   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
2721 2721 1992-01-01 1989-08-29 Ulum David JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
3012 3012 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
3019 3019 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
3928 3928 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
3929 3929 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
6096 6096 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
6350 6350 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
6405 6405 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
6406 6406 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
6464 6464 1988-02-09 1987-07-28 Garby Craig JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6503 6503 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
6504 6504 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
6505 6505 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
6506 6506 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
7224 7224 2001-02-18 1997-09-19 Kawaguchi Takeyoshi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
7656 7656 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
8413 8413 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
8430 8430 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
8433 8433 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
9183 9183 1998-03-05 1997-03-05 Sato Satoshi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
9525 9525 1994-03-09 1991-02-22 Yamagata Fujiya JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10698 10698 1997-03-24 1994-08-11 Okada Akinori JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10710 10710 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
10711 10711 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
10712 10712 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
10713 10713 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
11609 11609 1989-03-31 1988-09-15 Slovick Jay JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
15714 15714 2000-05-04 1997-09-19 Yoshida Takashi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
16155 16155 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
16477 16477 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
16783 16783 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
16784 16784 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
16785 16785 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
16786 16786 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
16787 16787 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
16788 16788 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
16789 16789 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
17190 17190 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
18627 18627 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
20569 20569 1999-06-29 1995-12-12 Yamamoto Hiromi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21509 21509 2004-06-30 2001-09-17 Koshio Takaaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
22919 22919 1998-07-10 1994-05-18 Counihan Richard JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
23387 23387 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
25767 25767 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
28006 28006 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
28332 28332 1997-08-31 1993-11-12 Kiuchi Shinkichi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
28685 28685 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
28694 28694 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
28955 28955 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
29249 29249 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
29276 29276 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
29548 29548 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
31410 31410 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
32387 32387 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
32388 32388 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
33080 33080 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
33081 33081 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
33082 33082 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
33083 33083 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
33084 33084 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
33085 33085 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
33086 33086 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
33303 33303 1990-10-21 1987-07-28 Kuraishi Fumiaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
33804 33804 2004-10-28 2001-03-16 Endo Toshiaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
34248 34248 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
35076 35076 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
35733 35733 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
36515 36515 1995-11-28 1993-02-24 Nagata Mikio JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
41709 41709 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
41713 41713 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
42207 42207 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

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