FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where "Short_Form_Date" is on date 2004-10-08
This data as json, CSV (advanced)
Suggested facets: Address_1, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5367 | 5367 | 2006-01-31 | 2004-10-08 | Hofreiter | Christian | Alexander Strategy Group 5557 | 2003-04-23 | Alexander Strategy Group | 3000 K Street, N.W. | Suite 101 | Washington | DC | 20007 |
7226 | 7226 | 2005-02-18 | 2004-10-08 | Weil | Jung | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
14978 | 14978 | 2008-04-30 | 2004-10-08 | Smith | Larry J. | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
15826 | 15826 | 2005-05-06 | 2004-10-08 | Keller | Lindsay J. | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
23134 | 23134 | 2006-07-14 | 2004-10-08 | Lee | Edison C. | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
27359 | 27359 | 2006-08-24 | 2004-10-08 | Sobel | Scott | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
30623 | 30623 | 2005-09-27 | 2004-10-08 | Cushing | Mark L. | Sonnenschein Nath & Rosenthal, LLP 5650 | 2004-10-08 | Sonnenschein Nath & Rosenthal, LLP | 1301 K Street, N.W. | Suite 600, East Tower | Washington | DC | 20005 |
30624 | 30624 | 2005-09-27 | 2004-10-08 | Gluck | Adam | Sonnenschein Nath & Rosenthal, LLP 5650 | 2004-10-08 | Sonnenschein Nath & Rosenthal, LLP | 1301 K Street, N.W. | Suite 600, East Tower | Washington | DC | 20005 |
30625 | 30625 | 2005-09-27 | 2004-10-08 | Grainger | Amanda | Sonnenschein Nath & Rosenthal, LLP 5650 | 2004-10-08 | Sonnenschein Nath & Rosenthal, LLP | 1301 K Street, N.W. | Suite 600, East Tower | Washington | DC | 20005 |
30626 | 30626 | 2005-09-27 | 2004-10-08 | Kavinoky | Paul | Sonnenschein Nath & Rosenthal, LLP 5650 | 2004-10-08 | Sonnenschein Nath & Rosenthal, LLP | 1301 K Street, N.W. | Suite 600, East Tower | Washington | DC | 20005 |
31351 | 31351 | 2005-09-30 | 2004-10-08 | Sarno | Amy Elizabeth | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
32942 | 32942 | 2008-10-15 | 2004-10-08 | Robinson | Michael W. | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
41790 | 41790 | 2011-12-31 | 2004-10-08 | Grabowski | Gene | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | Suite 400 | Washington | DC | 20036 |
41791 | 41791 | 2011-12-31 | 2004-10-08 | Levick | Richard S. | Levick Strategic Communications 5649 | 2004-10-08 | Levick Strategic Communications | 1900 M Street, N.W. | 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]) );