FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where "Short_Form_Termination_Date" is on date 2014-12-31 and State = "DC"
This data as json, CSV (advanced)
Registration_Number 10
- Cornerstone Government Affairs, LLC 7
- Blank Rome Government Relations, LLC 3
- Roberti + White, LLC 3
- Podesta Group, Inc. 2
- Mercury Public Affairs, LLC 2
- Sidley Austin LLP 1
- Kurdistan Regional Government - Liaison Office - USA 1
- Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 1
- Majority Group, LLC 1
- Winning Strategies Washington 1
Registrant_Name 10
- Cornerstone Government Affairs, LLC 7
- Blank Rome Government Relations, LLC 3
- Roberti + White, LLC 3
- Mercury Public Affairs, LLC 2
- Podesta Group, Inc. 2
- Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 1
- Kurdistan Regional Government - Liaison Office - USA 1
- Majority Group, LLC 1
- Sidley Austin LLP 1
- Winning Strategies Washington 1
State 1
- DC · 22 ✖
City 1
- Washington 22
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41907 | 41907 | 2014-12-31 | 2012-02-03 | Minnick | Walter C. | Majority Group, LLC 6087 | 2012-02-03 | Majority Group, LLC | 19 D Street, SE | Washington | DC | 20003 | |
41910 | 41910 | 2014-12-31 | 2014-03-07 | Essalih | Hassan Anthony | Cornerstone Government Affairs, LLC 6211 | 2014-03-07 | Cornerstone Government Affairs, LLC | 300 Independence Avenue, S.E. | Washington | DC | 20003 | |
41911 | 41911 | 2014-12-31 | 2014-03-07 | Gonella | Geoff | Cornerstone Government Affairs, LLC 6211 | 2014-03-07 | Cornerstone Government Affairs, LLC | 300 Independence Avenue, S.E. | Washington | DC | 20003 | |
41912 | 41912 | 2014-12-31 | 2014-03-07 | Keast | John | Cornerstone Government Affairs, LLC 6211 | 2014-03-07 | Cornerstone Government Affairs, LLC | 300 Independence Avenue, S.E. | Washington | DC | 20003 | |
41913 | 41913 | 2014-12-31 | 2014-03-07 | Mrdeza | Michelle | Cornerstone Government Affairs, LLC 6211 | 2014-03-07 | Cornerstone Government Affairs, LLC | 300 Independence Avenue, S.E. | Washington | DC | 20003 | |
41914 | 41914 | 2014-12-31 | 2014-03-07 | Richards | James | Cornerstone Government Affairs, LLC 6211 | 2014-03-07 | Cornerstone Government Affairs, LLC | 300 Independence Avenue, S.E. | Washington | DC | 20003 | |
41915 | 41915 | 2014-12-31 | 2011-03-08 | Green | Thomas C. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
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 |
41918 | 41918 | 2014-12-31 | 2014-04-01 | Kaufman | William Campbell | Cornerstone Government Affairs, LLC 6211 | 2014-03-07 | Cornerstone Government Affairs, LLC | 300 Independence Avenue, S.E. | Washington | DC | 20003 | |
41919 | 41919 | 2014-12-31 | 2014-04-01 | Perry III | Schley Louis | Cornerstone Government Affairs, LLC 6211 | 2014-03-07 | Cornerstone Government Affairs, LLC | 300 Independence Avenue, S.E. | Washington | DC | 20003 | |
41941 | 41941 | 2014-12-31 | 2014-07-03 | Irizarry | Steven | Roberti + White, LLC 6065 | 2011-09-23 | Roberti + White, LLC | 900 G Street NW | Suite 301 | Washington | DC | 20001 |
41942 | 41942 | 2014-12-31 | 2014-07-03 | Petrovic | Vladimir | Roberti + White, LLC 6065 | 2011-09-23 | Roberti + White, LLC | 900 G Street NW | Suite 301 | Washington | DC | 20001 |
41943 | 41943 | 2014-12-31 | 2014-07-18 | Fay | Chapin | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
41946 | 41946 | 2014-12-31 | 2013-07-26 | Grasso | Jeanne M. | 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 |
41949 | 41949 | 2014-12-31 | 2013-07-26 | Peranich | Stephen | 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 |
41954 | 41954 | 2014-12-31 | 2013-07-26 | Waldron | Jon | 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 |
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 |
41956 | 41956 | 2014-12-31 | 2014-07-30 | Gould | Sarah | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
41961 | 41961 | 2014-12-31 | 2014-08-19 | Heimov | Brett | Winning Strategies Washington 6242 | 2014-08-19 | Winning Strategies Washington | 409 7th Street, NW | Suite 450 | Washington | DC | 20004 |
41972 | 41972 | 2014-12-31 | 2011-09-23 | Roberti Sr. | Vincent A. | Roberti + White, LLC 6065 | 2011-09-23 | Roberti + White, LLC | 900 G Street NW | Suite 301 | Washington | DC | 20001 |
41984 | 41984 | 2014-12-31 | 2010-11-01 | Chadwick | Kirsten A. | Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock 5950 | 2009-09-08 | Chadwick, Kirsten A./Fierce, Isakowitz, & Blalock | 1155 F Street, NW | Suite 950 | Washington | DC | 20004 |
41990 | 41990 | 2014-12-31 | 2006-12-28 | Talabany | Qubad J. | Kurdistan Regional Government - Liaison Office - USA 5783 | 2006-12-28 | Kurdistan Regional Government - Liaison Office - USA | 1532 16th Street, NW | Washington | DC | 20036-1402 |
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]) );