FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

153 rows where Registration_Number = 6170

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date (date)

These facets timed out: City, State

Registration_Number 1

  • Mercury Public Affairs, LLC · 153 ✖

Registrant_Name 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
89 89   2020-01-10 Weber John Vincent Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
219 219   2015-01-29 Soliman Michael Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
430 430   2020-02-20 Melli Juan Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
543 543   2019-03-10 Lanza Bryan Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
587 587   2022-03-17 Dilemani Jake Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
589 589   2022-03-17 McCaleb Ian Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
787 787   2021-04-14 Moffett Anthony Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
861 861   2015-04-23 McSherry Michael Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
952 952   2019-05-01 Lefkowitz Trent Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
958 958   2018-05-04 Vitter David Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
998 998   2018-05-11 Stach Deirdre Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
1084 1084   2018-05-23 Lonergan John Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
1353 1353   2021-07-02 Kucik Peter Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
1363 1363   2023-07-05 Tayla Suheyla Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
1968 1968   2019-10-16 Bank Daniel Marc Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
2122 2122   2022-11-08 Costello Patrick Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
2123 2123   2022-11-08 Murphy Chris Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
2124 2124   2022-11-08 Ribenboim Bernardo Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
2403 2403   2020-12-15 Drilling Gregory Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
3145 3145 2022-01-03 2020-08-17 Delleney Caroline Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
3637 3637 2021-01-12 2021-01-08 Boxer Barbara Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
3831 3831 2016-01-15 2015-01-15 Frillici Vincent Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
4778 4778 2020-01-29 2019-08-22 Boudet Otto Francisco Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
4779 4779 2020-01-29 2019-10-02 Bender Sharon Alexandria Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
5518 5518 2017-01-31 2016-12-13 Dilemani Jake Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
5900 5900 2019-02-01 2018-04-04 McNeil Christopher Collins Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
5903 5903 2019-02-01 2018-07-03 Randolph Lindsay Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
6489 6489 2021-02-09 2020-01-15 Gallagher John Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
6490 6490 2021-02-09 2018-05-04 Myagkova Ekaterina Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
7265 7265 2021-02-19 2019-10-04 Russell Jennifer Kaufmann Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
7408 7408 2021-02-22 2021-01-26 Cockfield Amaris Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
7410 7410 2021-02-22 2019-10-04 Kaufmann Jennifer Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
7412 7412 2023-02-22 2019-01-03 Tayla Suheyla Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
7413 7413 2023-02-22 2022-01-03 Royster Avery Rose Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
7414 7414 2023-02-22 2019-07-16 Wilson Daniel Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
7415 7415 2023-02-22 2022-07-26 Bloom Eric Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
7560 7560 2022-02-24 2018-06-25 Murphy Christopher Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
8420 8420 2022-02-28 2020-01-06 McCaleb Ian Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
8421 8421 2022-02-28 2020-01-30 Tomlin John Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
8425 8425 2022-02-28 2020-02-26 Yousef Asma Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
8429 8429 2022-02-28 2019-04-29 DeFalco Beth Helene Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
8909 8909 2017-03-01 2016-12-09 Schembari Frank Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
8910 8910 2017-03-01 2013-12-11 Cpin John Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
9796 9796 2018-03-13 2018-02-23 Alvarez Danielle Marie Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
10002 10002 2017-03-15 2017-03-01 Vitter David Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
12222 12222 2018-03-31 2017-03-01 Reid Morris Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
12224 12224 2018-03-31 2017-05-24 Garrido Jorge Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
12225 12225 2018-03-31 2017-05-24 McFetridge Duncan Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
12226 12226 2018-03-31 2017-05-24 Romano Luis Rosendo Gutierrez Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
12272 12272 2021-03-31 2019-01-07 Petrone Brent James Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
12303 12303 2021-03-31 2019-11-26 Aaron Jr. Stephen J. Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
12858 12858 2021-04-06 2020-01-27 Kredisova Anna Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13196 13196 2019-04-11 2018-05-04 Wilson Dan Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13259 13259 2019-04-12 2019-01-07 Lapham Elizabeth Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13342 13342 2021-04-14 2019-04-30 Toro Brian Scott Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13343 13343 2021-04-14 2018-05-11 Emery Rodney Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13344 13344 2021-04-14 2019-11-25 Deschauer John Anthony Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13659 13659 2019-04-17 2019-02-04 King Charles Gordon Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13660 13660 2019-04-17 2019-03-05 McKeon Michael Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13823 13823 2022-04-20 2019-01-14 Garcia Jose Antonio Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13824 13824 2022-04-20 2019-04-26 Smith Adam Covington Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13825 13825 2022-04-20 2021-09-02 Bauman Ashley Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
13826 13826 2022-04-20 2021-09-28 Bloom Eric Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
14157 14157 2019-04-26 2019-04-12 Lloyd Rebecca Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
14158 14158 2019-04-26 2018-09-18 Sata Neha Sameer Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
15161 15161 2019-04-30 2018-05-17 Howard Greg Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
15167 15167 2019-04-30 2018-07-03 Chabria Jai Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
15193 15193 2020-04-30 2019-03-07 Arnavat Gustavo Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
16918 16918 2020-05-22 2018-05-04 Crittenden Michael Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
17321 17321 2020-05-28 2018-05-04 Hilton Steven Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
17322 17322 2020-05-28 2020-05-26 Bramwell Adam Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
17323 17323 2020-05-28 2019-10-02 Harley Siobhan Marie Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
17324 17324 2020-05-28 2018-12-06 Dumas Mamyrah Erica Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
18122 18122 2014-05-31 2013-05-14 Mullen Erick Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
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
18215 18215 2019-05-31 2018-05-04 Haile Graham Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
18224 18224 2019-05-31 2017-12-22 Pelton Erin Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
18560 18560 2014-06-01 2013-05-14 Kutler Edward Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
18588 18588 2018-06-01 2018-04-16 Alvarado-Behl Maria Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
19622 19622 2017-06-15 2016-11-29 Toomey Molly Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
21945 21945 2020-06-30 2019-03-05 Reid Lisa H. Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
22491 22491 2018-07-02 2017-12-22 Adair Ross Davidson Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
22869 22869 2020-07-09 2019-02-04 Eibensteiner Hannah Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
23079 23079 2018-07-13 2018-05-04 Espuleas Fernando Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
26519 26519 2022-08-12 2021-02-24 Patala Katherine Lewis Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
26649 26649 2018-08-14 2018-02-22 Lanza Bryan Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
26660 26660 2020-08-14 2017-12-22 Otterbacher Kaylee Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
26899 26899 2018-08-17 2018-06-06 Vigio Nicola Cardoso Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
27240 27240 2018-08-22 2018-08-08 Aaron Stephen Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
27504 27504 2021-08-26 2019-04-29 Westlate-Tritton Benjamin Stanley Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
29543 29543 2019-09-10 2013-05-14 Weber John Vincent Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
29544 29544 2019-09-10 2019-07-02 Webster Morgan Ashley Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
29778 29778 2016-09-14 2016-03-17 Copper Tarrah Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
31631 31631 2018-09-30 2018-04-11 Klevorick Caitlin Bender Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
32184 32184 2020-10-02 2020-02-05 Kimmelman Alicia Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
32185 32185 2020-10-02 2019-09-25 Dargahi Lucy Ann Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
32186 32186 2020-10-02 2019-11-06 Ogborn William Lon Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
32294 32294 2019-10-04 2017-09-14 Golin-Blaugrund Bari Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
32421 32421 2013-10-07 2013-08-02 Weiss Jeffrey Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036
32961 32961 2019-10-15 2017-12-22 Butcher-Nesbitt Robert Alexander Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 1615 L Street, NW Suite 400 Washington DC 20036

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);