FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
31 rows where "Short_Form_Termination_Date" is on date 2016-05-31 sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18183 | 18183 | 2016-05-31 | 2014-12-30 | Schonig | Elizabeth | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18182 | 18182 | 2016-05-31 | 2014-12-30 | Ludlum | Nicholas Stuart | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18181 | 18181 | 2016-05-31 | 2014-12-30 | Levoff | Remi | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18180 | 18180 | 2016-05-31 | 2014-12-30 | Horn | Michelle | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18179 | 18179 | 2016-05-31 | 2014-12-30 | Colon | Carol Lyn | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18178 | 18178 | 2016-05-31 | 2014-12-30 | Banovetz | Jennifer | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18177 | 18177 | 2016-05-31 | 2013-12-23 | Sauerman | Samantha L. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18176 | 18176 | 2016-05-31 | 2013-12-23 | Johnes | Stacey | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18175 | 18175 | 2016-05-31 | 2011-12-23 | Hasenfus | Kedsarin | Tourism Authority of Thailand, New York 1897 | 1965-06-01 | Tourism Authority of Thailand, New York | 61 Broadway | Suite 2810 | New York | NY | 10006 |
18174 | 18174 | 2016-05-31 | 2015-12-08 | Levinson | Lauren Kerry Glassner | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
18173 | 18173 | 2016-05-31 | 2015-12-08 | D'Amico | Kathleen Cavanaugh | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
18172 | 18172 | 2016-05-31 | 2012-10-01 | Faulkner | Charles | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 601 Thirteenth Street, NW | Eleventh Floor South | Washington | DC | 20005 |
18171 | 18171 | 2016-05-31 | 2015-09-16 | Fortson | Robert L. | McGuireWoods Consulting, LLC 6295 | 2015-05-19 | McGuireWoods Consulting, LLC | 800 East Canal Street | Richmond | VA | 23219 | |
18170 | 18170 | 2016-05-31 | 2015-08-31 | Stoltz | Elizabeth Anne | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
18169 | 18169 | 2016-05-31 | 2015-08-31 | Schoeneman | Kayanna Panagi | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
18168 | 18168 | 2016-05-31 | 2015-08-31 | Germaine | Mary Elizabeth | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
18167 | 18167 | 2016-05-31 | 2015-08-31 | Brandon | Emily Keiko | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
18166 | 18166 | 2016-05-31 | 2015-06-30 | Valeriano | Julio | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18165 | 18165 | 2016-05-31 | 2015-06-30 | Moller | James William | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18164 | 18164 | 2016-05-31 | 2015-06-30 | Jenkins | Gilowen | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18163 | 18163 | 2016-05-31 | 2015-06-30 | Caamano | Antonia | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18162 | 18162 | 2016-05-31 | 2014-06-30 | Penagos | Denise | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18161 | 18161 | 2016-05-31 | 2014-06-30 | Beilock | Alexandra Ola | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18160 | 18160 | 2016-05-31 | 2016-06-15 | Brownstein | Craig | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
18159 | 18159 | 2016-05-31 | 2016-03-31 | Kaplan | H. Deen | Hogan Lovells US LLP 2244 | 1971-02-18 | Hogan Lovells US LLP | 555 13th Street, NW | Columbia Square | Washington | DC | 20004-1109 |
18158 | 18158 | 2016-05-31 | 2016-02-08 | Mann | Nicole | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
18157 | 18157 | 2016-05-31 | 2016-01-13 | Zumwalt | Denee | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18156 | 18156 | 2016-05-31 | 2016-01-13 | Mullins | Tara | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18155 | 18155 | 2016-05-31 | 2016-01-13 | Martinez-Malavet | Suzzette M. | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18154 | 18154 | 2016-05-31 | 2016-01-13 | Cheney | Kerry | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | Washington | DC | 20036 |
18153 | 18153 | 2016-05-31 | Telson | Natalie | Ogilvy Public Relations Worldwide 5807 | 2007-05-07 | Ogilvy Public Relations Worldwide | 1111 19th Street, NW | 3rd Floor | 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]) );