FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
17 rows where Short_Form_Termination_Date = "2009-12-31" and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_2, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41648 | 41648 | 2009-12-31 | 2009-01-21 | Sanchez-Zinny | Gabriel | DUTKO Worldwide, LLC 5904 | 2009-01-21 | DUTKO Worldwide, LLC | 412 First Street, SE | Suite 100 | Washington | DC | 20003 |
41649 | 41649 | 2009-12-31 | 2009-02-10 | Froemming | Courtney | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41659 | 41659 | 2009-12-31 | 2007-05-07 | Mathias | Robert F. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41660 | 41660 | 2009-12-31 | 2008-05-09 | Coffee | Roy | Locke Lord Strategies, L.P. 5856 | 2008-03-07 | Locke Lord Strategies, L.P. | 701 8th Street, NW | Suite 700 | Washington | DC | 20001 |
41661 | 41661 | 2009-12-31 | 2007-05-29 | LaBrache | Lisa | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
41666 | 41666 | 2009-12-31 | 2007-06-26 | Morales | Michiko M. | Global Communicators, LLC 5817 | 2007-06-26 | Global Communicators, LLC | 1875 I Street, NW | Suite 500 | Washington | DC | 20006 |
41668 | 41668 | 2009-12-31 | 2008-07-01 | Ross | Lisa Osborne | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41669 | 41669 | 2009-12-31 | 2009-07-02 | Murphy | Aaron | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41670 | 41670 | 2009-12-31 | 2009-07-02 | Stauffer | John | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
41672 | 41672 | 2009-12-31 | 2009-07-29 | Black, Jr., | Charles R. | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41674 | 41674 | 2009-12-31 | 2009-07-31 | Godoua | Caitlin | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41675 | 41675 | 2009-12-31 | 2009-07-31 | Schwartz | Stacy | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | 1111 19th Street NW | 3rd Floor | Washington | DC | 20036 |
41676 | 41676 | 2009-12-31 | 2009-08-31 | Colangelo | Lisa Cotter | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41677 | 41677 | 2009-12-31 | 2009-08-31 | Pastrick | R. Scott | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41678 | 41678 | 2009-12-31 | 2009-08-31 | Peckham | Gardner | BKSH & Associates 5402 | 2000-12-14 | BKSH & Associates | 1110 Vermont Avenue, N.W. | Suite 1000 | Washington | DC | 20005 |
41682 | 41682 | 2009-12-31 | 2004-09-10 | Benitez | Juan Carlos | Cassidy & Associates, Inc. 5643 | 2004-09-10 | Cassidy & Associates, Inc. | 700 13th Street, N.W. | Suite 400 | Washington | DC | 20005 |
41685 | 41685 | 2009-12-31 | 2009-12-30 | Brown | Christopher | Manatt, Phelps & Phillips, LLP 5864 | 2008-05-16 | Manatt, Phelps & Phillips, LLP | 700 12th Street, NW | Suite 1100 | Washington | DC | 20005 |
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]) );