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

63 rows where Registration_Number = 5926

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 63

Registration_Number 1

  • Podesta Group, Inc. · 63 ✖

Registrant_Name 1

  • Podesta Group, Inc. 63

City 1

  • Washington 63
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
2873 2873 2010-01-01 2009-04-01 Scofield John Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
2878 2878 2010-01-01 2009-09-25 Lewin Andrew Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
2879 2879 2010-01-01 2009-09-25 Young Nicole Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
2890 2890 2011-01-01 2010-11-08 Marin David Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
3540 3540 2014-01-10 2013-04-19 Hatch Erin Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
4656 4656 2012-01-27 2009-04-01 Morra Elizabeth Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
8258 8258 2013-02-28 2012-04-10 Griffis Kevin Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
8272 8272 2014-02-28 2012-04-09 Rought Cathy Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
10716 10716 2017-03-24 2013-03-08 Morgenstern David Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
12744 12744 2013-04-04 2013-02-06 Chang Benjamin Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
13884 13884 2017-04-21 2015-08-10 Valdes Jordan Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
15067 15067 2015-04-30 2015-01-29 Lillenfeld Claudio Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
16339 16339 2011-05-14 2011-01-28 Scofield John Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
16679 16679 2011-05-18 2010-07-16 Rought Cathy Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
19123 19123 2011-06-09 2010-12-28 Oak Dale Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
19619 19619 2017-06-15 2016-03-22 Afkhami Hastie Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
19620 19620 2017-06-15 2013-06-11 Bohlen Will Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
21701 21701 2012-06-30 2011-07-29 Brathwaite Paul Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
21702 21702 2012-06-30 2011-07-29 James Claudia Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
21877 21877 2017-06-30 2013-09-16 Brathwaite Paul Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
22793 22793 2012-07-08 2009-11-19 Baierlein Daniele Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
23751 23751 2017-07-21 2011-04-15 Rademaker Stephen Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
24239 24239 2012-07-27 2010-11-05 Clark Christine Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
26645 26645 2015-08-14 2009-09-25 Lawrence-Vaca Jessica Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
26795 26795 2014-08-15 2013-08-04 Olson Zach Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
28583 28583 2012-08-31 2009-09-16 McKew Molly Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
29123 29123 2010-09-03 2009-04-01 Pryor Walter Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
29694 29694 2011-09-13 2010-11-05 Shagabutdinova Ella Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
30324 30324 2013-09-23 2013-07-31 Fang Bay Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
32036 32036 2010-10-01 2009-04-17 Baker Teal Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
33035 33035 2015-10-16 2013-04-10 Amsler Andrew Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
34658 34658 2013-10-31 2009-11-19 Glassco Tim Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35915 35915 2017-11-15 2017-01-12 Thompson Dana Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35916 35916 2017-11-15 2017-01-30 Neal Terry Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35917 35917 2017-11-15 2013-02-11 Antelo Cristina Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35918 35918 2017-11-15 2009-04-01 Gerard Randall Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35919 35919 2017-11-15 2009-04-01 Kauders Andrew Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35920 35920 2017-11-15 2013-04-19 Billings Erin Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35921 35921 2017-11-15 2016-04-19 Chandra Tara Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35922 35922 2017-11-15 2016-04-20 Lahey Josh Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35923 35923 2017-11-15 2011-07-29 Lewin Andrew Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35924 35924 2017-11-15 2017-09-05 Barreix Maria Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35925 35925 2017-11-15 2017-09-05 Marin David Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35926 35926 2017-11-15 2017-09-05 Schmidt Connor Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35928 35928 2017-11-15 2010-11-05 Ramirez Oscar Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
35929 35929 2017-11-15 2012-11-29 Tavlarides Mark Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
37009 37009 2010-11-30 2010-06-21 Merz Melissa Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
41698 41698 2010-12-31 2010-03-19 Northrup Stephen James Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
41700 41700 2010-12-31 2010-03-26 James Claudia Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
41701 41701 2010-12-31 2009-04-01 Brathwaite Paul A. Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
41916 41916 2014-12-31 2013-03-08 Baierlein Daniele Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
41955 41955 2014-12-31 2013-07-30 Hardin Trey Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42111 42111 2017-12-31 2013-01-31 Dyer James Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42112 42112 2017-12-31 2013-01-31 Holly Josh Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42113 42113 2017-12-31 2010-02-03 Anderson John Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42115 42115 2017-12-31 2014-02-10 Kirsch Steven Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42117 42117 2017-12-31 2013-03-01 Moore Riley Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42118 42118 2017-12-31 2009-04-01 Podesta Anthony T. Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42146 42146 2017-12-31 2014-07-30 Adams David Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42147 42147 2017-12-31 2014-07-30 Wohlford Katelyn Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42161 42161 2017-12-31 2017-09-05 Beck Katherine Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42162 42162 2017-12-31 2017-09-05 Bohlen Will Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001
42166 42166 2017-12-31 2014-11-18 Johnson Rachelle Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 1001 G Street, NW Suite 1000 West Washington DC 20001

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 486.943ms · 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