FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Short_Form_Termination_Date = "1987-04-15"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Address_1, Address_2, Short_Form_Date (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13412 | 13412 | 1987-04-15 | 1983-01-12 | Cozart | John R. | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
13413 | 13413 | 1987-04-15 | 1985-05-30 | Antoniades | Roxandra | Brennan & Brennan Communications, Inc. 3621 | 1984-10-18 | Brennan & Brennan Communications, Inc. | 260 Fifth Avenue | New York | NY | 10001 | |
13414 | 13414 | 1987-04-15 | 1985-05-30 | Brennan | Carol | Brennan & Brennan Communications, Inc. 3621 | 1984-10-18 | Brennan & Brennan Communications, Inc. | 260 Fifth Avenue | New York | NY | 10001 | |
13415 | 13415 | 1987-04-15 | 1985-05-30 | Brennan | Eamon | Brennan & Brennan Communications, Inc. 3621 | 1984-10-18 | Brennan & Brennan Communications, Inc. | 260 Fifth Avenue | New York | NY | 10001 | |
13416 | 13416 | 1987-04-15 | 1980-06-03 | Pepperdine | James | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
13417 | 13417 | 1987-04-15 | 1980-06-03 | Varga | Joseph | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
13418 | 13418 | 1987-04-15 | 1980-06-03 | Yesawich | Peter C. | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
13419 | 13419 | 1987-04-15 | 1984-07-04 | Dickinson | Salvatore | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
13420 | 13420 | 1987-04-15 | 1984-07-04 | Myers | Truman M. | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
13421 | 13421 | 1987-04-15 | 1984-07-04 | Pyne | Paris | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
13422 | 13422 | 1987-04-15 | 1983-07-08 | Toole | Judith J. | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
13423 | 13423 | 1987-04-15 | 1983-07-08 | Turley | David L. | Robinsons, Inc. 3110 | 1980-06-03 | Robinsons, Inc. | 2251 Lucien Way | Suite 100 | Maitland | FL | 32751-2021 |
13424 | 13424 | 1987-04-15 | 1985-09-18 | Cooper | Doral S. | Michael K. Deaver & Associates 3734 | 1985-09-18 | Michael K. Deaver & Associates | 3050 K Street, N.W. | Washington | DC | 20007 | |
13425 | 13425 | 1987-04-15 | 1985-09-18 | Deaver | Michael K. | Michael K. Deaver & Associates 3734 | 1985-09-18 | Michael K. Deaver & Associates | 3050 K Street, N.W. | Washington | DC | 20007 | |
13426 | 13426 | 1987-04-15 | 1985-09-18 | Sittmann | William F. | Michael K. Deaver & Associates 3734 | 1985-09-18 | Michael K. Deaver & Associates | 3050 K Street, N.W. | Washington | DC | 20007 | |
13427 | 13427 | 1987-04-15 | 1986-11-21 | Baldrige | Letitia | Brennan & Brennan Communications, Inc. 3621 | 1984-10-18 | Brennan & Brennan Communications, Inc. | 260 Fifth Avenue | New York | NY | 10001 |
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]) );