FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Short_Form_Termination_Date" is on date 2015-08-31
This data as json, CSV (advanced)
Registration_Number 7
Registrant_Name 7
City 6
- Baton Rouge 5
- New York 3
- San Diego 3
- Washington 2
- Miami 1
- Murfressboro 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28601 | 28601 | 2015-08-31 | 2012-02-15 | Tripodi | Cynthia Merifield | Nickles Group, LLC 6089 | 2012-02-15 | Nickles Group, LLC | 601 13th Street, NW | Suite 250N | Washington | DC | 20005 |
28602 | 28602 | 2015-08-31 | 2015-02-18 | Fallecker | Stephane | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28603 | 28603 | 2015-08-31 | 2014-05-20 | Rivas | Monica | Burson-Marsteller, LLC (Miami Office) 6223 | 2014-05-20 | Burson-Marsteller, LLC (Miami Office) | 601 Brickell Key Drive | Suite 900 | Miami | FL | 33131 |
28604 | 28604 | 2015-08-31 | 2015-06-19 | Johnson | Ashley | Southwest Strategies, LLC 6302 | 2015-06-19 | Southwest Strategies, LLC | 401 B Street, Suite 150 | San Diego | CA | 92101 | |
28605 | 28605 | 2015-08-31 | 2015-06-19 | Jones | Brandon | Southwest Strategies, LLC 6302 | 2015-06-19 | Southwest Strategies, LLC | 401 B Street, Suite 150 | San Diego | CA | 92101 | |
28606 | 28606 | 2015-08-31 | 2015-06-19 | Ziegaus | Alan | Southwest Strategies, LLC 6302 | 2015-06-19 | Southwest Strategies, LLC | 401 B Street, Suite 150 | San Diego | CA | 92101 | |
28607 | 28607 | 2015-08-31 | 2013-07-10 | Terry | Mike | Paramount Strategies 6174 | 2013-07-10 | Paramount Strategies | 1826 Ward Drive | Suite 201 | Murfressboro | TN | 37129 |
28608 | 28608 | 2015-08-31 | 2015-07-14 | Epstein | Jason | Southfive Strategies, LLC 6186 | 2013-09-09 | Southfive Strategies, LLC | 2100 M Street, NW | Suite 170-295 | Washington | DC | 20037 |
28609 | 28609 | 2015-08-31 | 2014-08-04 | Creaghan | James P. | AUX Initiatives, LLC 6238 | 2014-08-04 | AUX Initiatives, LLC | 6298 Seven Oaks Avenue | Baton Rouge | LA | 70806 | |
28610 | 28610 | 2015-08-31 | 2011-08-16 | Houde | Alain | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
28611 | 28611 | 2015-08-31 | 2014-08-18 | Kiley | Gregory Thomas | AUX Initiatives, LLC 6238 | 2014-08-04 | AUX Initiatives, LLC | 6298 Seven Oaks Avenue | Baton Rouge | LA | 70806 | |
28612 | 28612 | 2015-08-31 | 2014-08-18 | Meltz | Gary Charles | AUX Initiatives, LLC 6238 | 2014-08-04 | AUX Initiatives, LLC | 6298 Seven Oaks Avenue | Baton Rouge | LA | 70806 | |
28613 | 28613 | 2015-08-31 | 2014-08-18 | Reilly | Patricia A. | AUX Initiatives, LLC 6238 | 2014-08-04 | AUX Initiatives, LLC | 6298 Seven Oaks Avenue | Baton Rouge | LA | 70806 | |
28614 | 28614 | 2015-08-31 | 2014-08-18 | Shows | Clifford Ronald | AUX Initiatives, LLC 6238 | 2014-08-04 | AUX Initiatives, LLC | 6298 Seven Oaks Avenue | Baton Rouge | LA | 70806 | |
28615 | 28615 | 2015-08-31 | 2011-10-27 | Plante | Sophie | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
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]) );