FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Registration_Number = 5926 and "Short_Form_Termination_Date" is on date 2017-11-15
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date (date)
State 1
- DC 14
Registration_Number 1
- Podesta Group, Inc. · 14 ✖
Registrant_Name 1
City 1
- Washington 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );