FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where "Short_Form_Termination_Date" is on date 2018-05-31
This data as json, CSV (advanced)
Suggested facets: Address_1
Registration_Number 10
Registrant_Name 10
City 5
- Washington 13
- New York 2
- Alexandria 1
- Miami 1
- Overland Park 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18195 | 18195 | 2018-05-31 | 2016-01-13 | Olander | David | Capitol Counsel, LLC 6328 | 2015-11-19 | Capitol Counsel, LLC | 700 13th Street, NW | Suite 200 | Washington | DC | 20005 |
18196 | 18196 | 2018-05-31 | 2018-03-16 | Treanor | Christopher | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | |
18197 | 18197 | 2018-05-31 | 2018-04-03 | Alvarez | Danielle Marie | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
18198 | 18198 | 2018-05-31 | 2017-06-29 | Bonazzi | Anne | Information Management Services, Inc. 6442 | 2017-06-29 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 |
18199 | 18199 | 2018-05-31 | 2017-06-29 | Huegel | Monica | Information Management Services, Inc. 6442 | 2017-06-29 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 |
18200 | 18200 | 2018-05-31 | 2017-06-29 | Klueter | Jeffrey S. | Information Management Services, Inc. 6442 | 2017-06-29 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 |
18201 | 18201 | 2018-05-31 | 2017-06-29 | Purpura | Amy | Information Management Services, Inc. 6442 | 2017-06-29 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 |
18202 | 18202 | 2018-05-31 | 2017-06-29 | Stenn | Lillian | Information Management Services, Inc. 6442 | 2017-06-29 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 |
18203 | 18203 | 2018-05-31 | 2009-08-20 | Ruthven | Alexander Wyeth | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
18204 | 18204 | 2018-05-31 | 2017-08-21 | Dove | Caroline | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18205 | 18205 | 2018-05-31 | 2017-08-21 | Footlik | Jay K. | DLA Piper US LLP 3712 | 1985-08-05 | DLA Piper US LLP | 500 8th Street, NW | Washington | DC | 20004 | |
18206 | 18206 | 2018-05-31 | 2017-08-23 | Mitchell | Devin | Information Management Services, Inc. 6442 | 2017-06-29 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 |
18207 | 18207 | 2018-05-31 | 2018-09-07 | Quevedo Vallejo | Mariana | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | 1359 Broadway | Suite 1102 | New York | NY | 10018 |
18208 | 18208 | 2018-05-31 | 2018-09-07 | Vallejo | Mariana Quevedo | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | 1359 Broadway | Suite 1102 | New York | NY | 10018 |
18209 | 18209 | 2018-05-31 | 2017-10-03 | Schaub | Matthew | Information Management Services, Inc. 6442 | 2017-06-29 | Information Management Services, Inc. | 1201 16th Street, NW | Suite 414 | Washington | DC | 20036 |
18210 | 18210 | 2018-05-31 | 2016-10-27 | Ferry | Christian | Trailblazer Group 6385 | 2016-10-27 | Trailblazer Group | 901 King Street | Suite 400 | Alexandria | VA | 22314 |
18211 | 18211 | 2018-05-31 | 2017-11-27 | O'Neal | Leslie | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
18212 | 18212 | 2018-05-31 | 2017-12-22 | Melendez | Jennefer | Burson-Marsteller, LLC (Miami Office) 6223 | 2014-05-20 | Burson-Marsteller, LLC (Miami Office) | 601 Brickell Key Drive | Suite 900 | Miami | FL | 33131 |
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]) );