FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Termination_Date" is on date 2018-11-30 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37099 | 37099 | 2018-11-30 | 2015-01-09 | Braden | Mark | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37103 | 37103 | 2018-11-30 | 2018-03-20 | Mitchell | Kathryn Rae | CGCN Group 6396 | 2016-11-30 | CGCN Group | 1307 New York Avenue, NW | 6th Floor | Washington | DC | 20005 |
37104 | 37104 | 2018-11-30 | 2018-03-29 | Garcia | Jose Antonio | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37106 | 37106 | 2018-11-30 | 2018-04-02 | Hernandez | Michael Anthony | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37108 | 37108 | 2018-11-30 | 2017-05-05 | Zhang | Yizhi Jing Jing | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | 1001 Pennsylvania Avenue, N.W. | Suite 1275 | Washington | DC | 20004-2595 |
37109 | 37109 | 2018-11-30 | 2013-05-14 | Lewis | Katherine | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37114 | 37114 | 2018-11-30 | 2008-09-11 | Gilliland | John R. | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
37116 | 37116 | 2018-11-30 | 2017-11-01 | Faraci | Daniel | Grassroots Political Consulting LLC 6483 | 2017-11-01 | Grassroots Political Consulting LLC | P.O. Box 65459 | Washington | DC | 20035 | |
37118 | 37118 | 2018-11-30 | 2017-11-09 | Feraci | Manning | Playmaker Strategies, LLC 6487 | 2017-11-09 | Playmaker Strategies, LLC | 750 Ninth Street, NW | Suite 650 | Washington | DC | 20001 |
37122 | 37122 | 2018-11-30 | 2016-11-30 | Clark | Steve | CGCN Group 6396 | 2016-11-30 | CGCN Group | 1307 New York Avenue, NW | 6th Floor | Washington | DC | 20005 |
37123 | 37123 | 2018-11-30 | 2016-12-09 | Kaufmann | Jennifer | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | 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]) );