FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where City = "Washington", Short_Form_Date = "2011-07-29" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7555 | 7555 | 2012-02-24 | 2011-07-29 | Taitel | Daphny | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
8568 | 8568 | 2012-02-29 | 2011-07-29 | Woods | Laura | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
14156 | 14156 | 2014-04-26 | 2011-07-29 | Estabrook | Aaron | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
16036 | 16036 | 2013-05-10 | 2011-07-29 | Grozalsky | Jill | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
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 |
26516 | 26516 | 2011-08-12 | 2011-07-29 | Biskey | Bethany | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
26794 | 26794 | 2012-08-15 | 2011-07-29 | Friend | Megan | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
30630 | 30630 | 2011-09-27 | 2011-07-29 | Larizadeh | Reza | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
32062 | 32062 | 2013-10-01 | 2011-07-29 | Ganjei | John | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
32063 | 32063 | 2013-10-01 | 2011-07-29 | Hudson | Greg | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
32064 | 32064 | 2013-10-01 | 2011-07-29 | Ramirez | Catherine Cecilia Castro | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
32222 | 32222 | 2013-10-03 | 2011-07-29 | Van Antwerpen | Julie | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
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 |
36071 | 36071 | 2012-11-19 | 2011-07-29 | Harrell | Sarah Maria | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
37523 | 37523 | 2015-12-01 | 2011-07-29 | Nagey | Stefan | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
37991 | 37991 | 2011-12-09 | 2011-07-29 | Martin | Caroline | Blank Rome Government Relations, LLC 6025 | 2010-12-03 | Blank Rome Government Relations, LLC | Watergate Office Building | 600 New Hampshire Avenue, NW | Washington | DC | 20037 |
41777 | 41777 | 2011-12-31 | 2011-07-29 | Taylor | Alyssa | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
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]) );