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

67 rows where Registration_Number = 5870

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date), Registration_Date (date)

State 1

  • CO 67

Registration_Number 1

  • Brownstein Hyatt Farber Schreck, LLP · 67 ✖

Registrant_Name 1

  • Brownstein Hyatt Farber Schreck, LLP 67

City 1

  • Denver 67
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
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
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
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
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
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
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
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
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
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
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
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
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
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
42327 42327 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
42381 42381 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
42415 42415 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
42416 42416 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
42417 42417 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
42428 42428 2022-12-31 2022-01-10 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

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 624.421ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows