FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where Registration_Number = 6170 and "Short_Form_Termination_Date" is on date 2021-11-01
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date (date), Registration_Date (date)
State 1
- DC 20
Registration_Number 1
- Mercury Public Affairs, LLC · 20 ✖
Registrant_Name 1
City 1
- Washington 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35051 | 35051 | 2021-11-01 | 2020-01-08 | Denselow | Toby | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35052 | 35052 | 2021-11-01 | 2020-01-08 | Tucker | George | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35053 | 35053 | 2021-11-01 | 2021-01-20 | Passe | Djenny | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35054 | 35054 | 2021-11-01 | 2020-01-24 | Rynsard | Louis | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35055 | 35055 | 2021-11-01 | 2020-01-27 | Artunkal | Nijat Tahsin Can | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35056 | 35056 | 2021-11-01 | 2021-02-17 | Hassan | Miran | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35057 | 35057 | 2021-11-01 | 2019-04-08 | Reid | Morris | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35060 | 35060 | 2021-11-01 | 2020-04-09 | Sculthorpe | Timothy | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35061 | 35061 | 2021-11-01 | 2020-04-17 | Kennedy | Karen | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35062 | 35062 | 2021-11-01 | 2019-04-26 | Walker | Alexander DJ | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35063 | 35063 | 2021-11-01 | 2021-04-28 | Gregory | Katie | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35064 | 35064 | 2021-11-01 | 2018-05-04 | Flotteron | Nicole | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35065 | 35065 | 2021-11-01 | 2019-05-09 | Toomey | Molly | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35066 | 35066 | 2021-11-01 | 2020-05-13 | McMillan | Thomas Jock | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35068 | 35068 | 2021-11-01 | 2021-06-03 | Smith II | Robert Leverett | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35069 | 35069 | 2021-11-01 | 2021-06-23 | Collier | Benjamin Britworth | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35071 | 35071 | 2021-11-01 | 2021-07-16 | Ogborn | William | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35073 | 35073 | 2021-11-01 | 2021-08-02 | Baker | Zara | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35074 | 35074 | 2021-11-01 | 2019-09-11 | Birnbaum | George Eli | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
35075 | 35075 | 2021-11-01 | 2019-09-11 | Galan | Vladislava | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | 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]) );