FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
153 rows where Registrant_Name = "Mercury Public Affairs, LLC" and State = "DC"
This data as json, CSV (advanced)
State 1
- DC · 53 ✖
Registration_Number 1
Registrant_Name 1
- Mercury Public Affairs, LLC · 53 ✖
City 1
- Washington 53
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33094 | 33094 | 2018-10-17 | 2018-02-22 | Toomey | Molly | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
33095 | 33095 | 2018-10-17 | 2018-09-17 | Wilson | Louis J. | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
33096 | 33096 | 2018-10-17 | 2018-12-29 | Toomey | Molly | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
33180 | 33180 | 2021-10-18 | 2021-04-26 | Royster | Avery Rose | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
33522 | 33522 | 2020-10-23 | 2019-04-26 | Lewis | Katherine | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
33580 | 33580 | 2016-10-24 | 2014-08-04 | Ereli | Adam | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
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 |
36408 | 36408 | 2020-11-25 | 2020-10-05 | Bramwell | Adam | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
36410 | 36410 | 2020-11-25 | 2019-12-10 | Arnaldo | Zharina | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37040 | 37040 | 2013-11-30 | 2013-08-02 | Goncharenko | Kirill | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37099 | 37099 | 2018-11-30 | 2015-01-09 | Braden | Mark | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37104 | 37104 | 2018-11-30 | 2018-03-29 | Garcia | Jose Antonio | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37106 | 37106 | 2018-11-30 | 2018-04-02 | Hernandez | Michael Anthony | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37109 | 37109 | 2018-11-30 | 2013-05-14 | Lewis | Katherine | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37123 | 37123 | 2018-11-30 | 2016-12-09 | Kaufmann | Jennifer | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37124 | 37124 | 2019-11-30 | 2019-03-10 | Braden | Mark | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37130 | 37130 | 2019-11-30 | 2019-03-28 | 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 |
37133 | 37133 | 2019-11-30 | 2018-07-09 | Rajaiah | Daniel | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37135 | 37135 | 2019-11-30 | 2018-08-16 | Rehberg | Denny | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37136 | 37136 | 2019-11-30 | 2018-08-16 | Simpson | Al | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37517 | 37517 | 2014-12-01 | 2014-07-30 | Mullen | Erick | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37520 | 37520 | 2015-12-01 | 2014-05-12 | Toomey | Molly | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37521 | 37521 | 2015-12-01 | 2013-05-14 | Reid | Morris L. | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37527 | 37527 | 2015-12-01 | 2015-12-01 | Mullen | Erick | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37528 | 37528 | 2015-12-01 | 2013-12-11 | Bucaciuc | Alexandra | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
37534 | 37534 | 2017-12-01 | 2015-06-10 | Rehberg | Denny | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
38335 | 38335 | 2018-12-14 | 2018-07-17 | Epple | Garrett | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
41943 | 41943 | 2014-12-31 | 2014-07-18 | Fay | Chapin | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
41956 | 41956 | 2014-12-31 | 2014-07-30 | Gould | Sarah | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
42021 | 42021 | 2016-12-31 | 2016-02-04 | Threadgill | Tyler | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
42320 | 42320 | 2020-12-31 | 2019-04-30 | Vilkos | Yulianna | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
42329 | 42329 | 2020-12-31 | 2019-06-28 | Wilson | Louis J. | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
42451 | 42451 | 2022-12-31 | 2022-09-06 | Alvarado-Behl | Maria | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 1615 L Street, NW | Suite 400 | Washington | DC | 20036 |
42452 | 42452 | 2022-12-31 | 2022-09-06 | Garcia | Jose Antonio | 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]) );