home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

94 rows where City = "Denver"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)

Registration_Number 9

  • Brownstein Hyatt Farber Schreck, LLP 59
  • JETRO, Denver 17
  • Brownstein Hyatt Farber Schreck, P.C. 7
  • Noranda Exploration, Inc. 4
  • Mexican Government Tourism Office, Denver 2
  • William Kostka & Associates, Inc. 2
  • Korea Trade Promotion Office, Denver 1
  • DGL International Publishing, Ltd., Liability Company 1
  • Novitas Communication Inc. 1

Registrant_Name 9

  • Brownstein Hyatt Farber Schreck, LLP 59
  • JETRO, Denver 17
  • Brownstein Hyatt Farber Schreck, P.C. 7
  • Noranda Exploration, Inc. 4
  • Mexican Government Tourism Office, Denver 2
  • William Kostka & Associates, Inc. 2
  • DGL International Publishing, Ltd., Liability Company 1
  • Korea Trade Promotion Office, Denver 1
  • Novitas Communication Inc. 1

State 1

  • CO 94

City 1

  • Denver · 94 ✖
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
72 72   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
250 250   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
307 307   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
319 319   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
339 339   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
348 348   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
671 671   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
762 762   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
766 766   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
829 829   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
1281 1281   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
1352 1352   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
1359 1359   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
1695 1695   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
1720 1720   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
1769 1769   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
1770 1770   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
1941 1941   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
2059 2059   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
2213 2213   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
2337 2337   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
2639 2639 1992-01-01 1989-08-29 Ulum David JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
2930 2930 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
3258 3258 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
5942 5942 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
6191 6191 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
6245 6245 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
6246 6246 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
6304 6304 1988-02-09 1987-07-28 Garby Craig JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
6342 6342 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
6343 6343 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
6344 6344 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
6345 6345 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
7048 7048 2001-02-18 1997-09-19 Kawaguchi Takeyoshi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
7472 7472 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
8232 8232 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
8246 8246 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
8249 8249 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
8250 8250 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
8982 8982 1998-03-05 1997-03-05 Sato Satoshi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
9308 9308 1994-03-09 1991-02-22 Yamagata Fujiya JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10468 10468 1997-03-24 1994-08-11 Okada Akinori JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
10480 10480 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
10481 10481 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
10482 10482 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
10483 10483 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
11374 11374 1989-03-31 1988-09-15 Slovick Jay JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
15376 15376 2000-05-04 1997-09-19 Yoshida Takashi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
15813 15813 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
16431 16431 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
16432 16432 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
16433 16433 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
16434 16434 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
16435 16435 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
16436 16436 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
16437 16437 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
16834 16834 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
18234 18234 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
20156 20156 1999-06-29 1995-12-12 Yamamoto Hiromi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
21096 21096 2004-06-30 2001-09-17 Koshio Takaaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
22473 22473 1998-07-10 1994-05-18 Counihan Richard JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
22939 22939 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
27460 27460 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
27786 27786 1997-08-31 1993-11-12 Kiuchi Shinkichi JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
28140 28140 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
28402 28402 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
28695 28695 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
28722 28722 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
28985 28985 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
30831 30831 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
31773 31773 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
31774 31774 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
32448 32448 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
32449 32449 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
32450 32450 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
32451 32451 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
32452 32452 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
32453 32453 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
32454 32454 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
32670 32670 1990-10-21 1987-07-28 Kuraishi Fumiaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
33169 33169 2004-10-28 2001-03-16 Endo Toshiaki JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
33609 33609 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
35074 35074 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
35851 35851 1995-11-28 1993-02-24 Nagata Mikio JETRO, Denver 4017 1987-07-28 JETRO, Denver 1200 - 17th Street Suite 1110 Denver CO 80202
36522 36522 2021-11-30 2021-05-26 Lyng Michelle Novitas Communication Inc. 6965 2021-05-26 Novitas Communication Inc. 1732 Wazee Street Suite 201 Denver CO 80202
41014 41014 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
41018 41018 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
41512 41512 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
41632 41632 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
41679 41679 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
41713 41713 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
41714 41714 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
41715 41715 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])
);
Powered by Datasette · Queries took 282.379ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history