FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

15,403 rows where State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

  • DC · 15,403 ✖
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
1 1     AlMaskati Mohammed Emad 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
3 3     Bailey Ashley 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
6 6     Nye Stephanie 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
8 8     Shulklapper Max 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
9 9     Smith William Francis 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
10 10     Stewart Ashley 6653 6653 2019-03-22 Steptoe & Johnson, LLP 1330 Connecticut Avenue, NW   Washington DC 20036
23 23   2017-01-02 Munson Lester 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
24 24   2017-01-02 Seiden Maya 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
27 27   2019-01-03 Tayla Suheyla 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
28 28   2020-01-03 Ellis Alex 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
33 33   2009-01-05 Shupp Michael A. 5401 5401 2000-12-14 Van Scoyoc Associates, Inc. 800 Maine Avenue, SW Suite 800 Washington DC 20024
35 35   2018-01-05 Carter Sullivan Juliane 6396 6396 2016-11-30 CGCN Group 1101 K Street, NW Suite 650 Washington DC 20005
40 40   2020-01-06 Gungor Leyla S. 2244 2244 1971-02-18 Hogan Lovells US LLP 555 - 13th Street, NW Columbia Square Washington DC 20004-1109
41 41   2020-01-06 McCaleb Ian 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
47 47   2016-01-07 Kim Junil 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
49 49   2019-01-07 Petrone Brent James 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
52 52   2020-01-08 Denselow Toby 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
53 53   2020-01-08 Tucker George 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
54 54   2019-01-09 Stavinsky Meital 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
57 57   2013-01-10 Kent Jr Donald H. 6089 6089 2012-02-15 Nickles Group, LLC 601 13th Street, NW Suite 250N Washington DC 20005
59 59   2019-01-10 Reeder Emily 1750 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
62 62   2020-01-10 Weber John 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
63 63   2010-01-11 O'Brien David 5971 5971 2010-01-11 O'Brien Gentry & Scott, LLC 201 C Street, SE   Washington DC 20003
64 64   2010-01-11 Gentry James 5971 5971 2010-01-11 O'Brien Gentry & Scott, LLC 201 C Street, SE   Washington DC 20003
65 65   2018-01-11 Christoferson James P. 6505 6505 2018-01-11 JPC Strategies, LLC 812 K Street, NE   Washington DC 20002
71 71   2014-01-13 Ahrens Frank 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
84 84   2020-01-15 Gallagher John 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
85 85   2018-01-16 Tsering Ngodup 1699 1699 1964-03-14 Office of Tibet 1228 17th Street, NW   Washington DC 20036
86 86   2019-01-16 Brown William B. 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
87 87   2019-01-16 Hassig Kongdan Oh 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
88 88   2019-01-16 Kim June Dong 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
89 89   2019-01-16 Suh Changhoon 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
91 91   2020-01-16 Maney Jo 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
95 95   2018-01-17 Osborne Jason 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
98 98   2020-01-17 Painter Sally 6587 6587 2018-09-06 Blue Star Strategies, LLC 888 17th Street, NW Suite 800 Washington DC 20006
104 104   2017-01-19 Broydrick William B. 5444 5444 2001-07-02 Malaysian Rubber Export Promotion Council (USA) 3516 International Court, N.W.   Washington DC 20008
105 105   2018-01-19 Aho Loren 5931 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
107 107   2017-01-20 Richards James 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
109 109   2020-01-21 Ros-Lehtinen Ileana 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
110 110   2002-01-22 Newberry Edward J. 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
111 111   2018-01-22 Clerc Pascaline 6510 6510 2018-01-22 Meliora Strategy 1813 13th Street, NW Suite 2 Washington DC 20009
112 112   2019-01-22 Wiles Susan 6415 6415 2017-04-05 Ballard Partners 601 Thirteenth Street, NW Suite 450 N Washington DC 20005
116 116   2020-01-22 Lovallo John 6642 6642 2019-03-06 Levick Strategic Communications, LP 1900 M Street, NW 4th Floor Washington DC 20036
120 120   2020-01-23 El-Erian Mostafa Ali 6786 6786 2020-01-23 Cogent Law Group LLP 1875 K Street, NW 4th Floor Washington DC 20006
122 122   2018-01-24 Disler Mark 6377 6377 2016-09-19 Prime Policy Group 1801 K Street, NW Suite 9000 Washington DC 20006
128 128   2020-01-24 Elawad Hagir H. 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
130 130   2020-01-24 Rynsard Louis 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
132 132   2006-01-25 Altschuler Irwin 5712 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
133 133   2006-01-25 Stein Donald P. 5712 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
135 135   2012-01-25 Hutcheson Ron 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC 607 Fourteenth Street, NW Suite 300 Washington DC 20005
140 140   2019-01-25 Lavoie Alyse 6518 6518 2018-02-02 Chartwell Strategy Group, LLC 701 8th Street, NW, Suite 620   Washington DC 20001
142 142   2015-01-27 Savelieff (Kasulke) Ludmilla Lydia 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
145 145   2020-01-27 Artunkal Nijat Tahsin Can 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
147 147   2020-01-27 Hekmat Farid 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
148 148   2020-01-27 Kredisova Anna 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
151 151   2020-01-27 Tritton Benjamin Westlake 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
155 155   2019-01-28 Park Irene 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
156 156   2019-01-28 Stuaan Abbi 6377 6377 2016-09-19 Prime Policy Group 1801 K Street, NW Suite 9000 Washington DC 20006
160 160   2013-01-29 Wilson Ellen 3911 3911 1986-12-01 CMGRP, Inc. 733 Tenth Street, NW   Washington DC 20001
161 161   2015-01-29 Soliman Michael 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
162 162   2019-01-29 Fadlallah Mac 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
165 165   2017-01-30 Tucker James 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
166 166   2018-01-30 Jablon Ann 6328 6328 2015-11-19 Capitol Counsel, LLC 700 13th Street, NW Suite 200 Washington DC 20005
168 168   2019-01-30 Samarripa Stefanie 3911 3911 1986-12-01 CMGRP, Inc. 733 Tenth Street, NW   Washington DC 20001
169 169   2020-01-30 Boonshoft Emma 3911 3911 1986-12-01 CMGRP, Inc. 733 Tenth Street, NW   Washington DC 20001
171 171   2020-01-30 Foxman Elizabeth 3911 3911 1986-12-01 CMGRP, Inc. 733 Tenth Street, NW   Washington DC 20001
172 172   2020-01-30 Hobbs Lemondria 3911 3911 1986-12-01 CMGRP, Inc. 733 Tenth Street, NW   Washington DC 20001
173 173   2020-01-30 McKenna Kelly 3911 3911 1986-12-01 CMGRP, Inc. 733 Tenth Street, NW   Washington DC 20001
178 178   2020-01-30 Tomlin John 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
190 190   2018-01-31 Al Hendi Ahed 6516 6516 2018-01-31 U.S. Mission of the Syrian Democratic Council 807 Capitol Square Place, SW   Washington DC 20024
191 191   2018-01-31 Ishak Bassam Said 6516 6516 2018-01-31 U.S. Mission of the Syrian Democratic Council 807 Capitol Square Place, SW   Washington DC 20024
192 192   2018-01-31 Mohamad Senam 6516 6516 2018-01-31 U.S. Mission of the Syrian Democratic Council 807 Capitol Square Place, SW   Washington DC 20024
193 193   2018-01-31 Mustafa Nobahar 6516 6516 2018-01-31 U.S. Mission of the Syrian Democratic Council 807 Capitol Square Place, SW   Washington DC 20024
196 196   2020-01-31 Hyun Minchi 6397 6397 2016-12-01 Overseas Korean Cultural Heritage Foundation, USA 1500 13th Street, NW   Washington DC 20005
198 198   2020-01-31 Kim Sangyeop 6397 6397 2016-12-01 Overseas Korean Cultural Heritage Foundation, USA 1500 13th Street, NW   Washington DC 20005
210 210   1999-02-02 Zagaris Bruce 5299 5299 1999-02-02 Berliner Corcoran & Rowe, LLP 1101 17th Street, NW Suite 1100 Washington DC 20036
211 211   2018-02-02 Ariale John Michael 6517 6517 2018-02-02 Husch Blackwell Strategies, LLC 300 M Street, SE Suite 402 Washington DC 20003
214 214   2018-02-02 Epperly Matthew 6518 6518 2018-02-02 Chartwell Strategy Group, LLC 701 8th Street, NW, Suite 620   Washington DC 20001
215 215   2018-02-02 Fox William 6517 6517 2018-02-02 Husch Blackwell Strategies, LLC 300 M Street, SE Suite 402 Washington DC 20003
216 216   2018-02-02 Hartley Gregg L. 6517 6517 2018-02-02 Husch Blackwell Strategies, LLC 300 M Street, SE Suite 402 Washington DC 20003
219 219   2018-02-02 Mullon Jr. David A. 5931 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
220 220   2018-02-02 Palomo Oswaldo 6518 6518 2018-02-02 Chartwell Strategy Group, LLC 701 8th Street, NW, Suite 620   Washington DC 20001
222 222   2018-02-02 Tamasi David 6518 6518 2018-02-02 Chartwell Strategy Group, LLC 701 8th Street, NW, Suite 620   Washington DC 20001
224 224   2017-02-03 Murphy Rory 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
231 231   2019-02-04 Eibensteiner Hannah 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
233 233   2020-02-04 Beattie Geoffrey S 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
234 234   2020-02-04 Browne Sabrina N. 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
235 235   2020-02-04 Khouri Nonna 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
236 236   2020-02-04 Lagana Susan 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
238 238   2018-02-05 Finestone Josh 5931 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
239 239   2019-02-05 Burghoff Mary Claire 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
240 240   2020-02-05 Kimmelman Alicia 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
241 241   1995-02-06 Waterman Charles E. 4990 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
242 242   1995-02-06 Wyman Samuel H. 4990 4990 1995-02-06 JWI, LLC 700 New Hampshire Avenue, NW Watergate South, Suite 1019 Washington DC 20037
243 243   2014-02-06 Galano Michael 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
244 244   2018-02-06 Forbes Randy 5712 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
245 245   2020-02-06 Stewart Jennifer 6790 6790 2020-02-06 Williams Group 302 3rd Street, SE   Washington DC 20003
246 246   2020-02-06 Williams Michael W. 6790 6790 2020-02-06 Williams Group 302 3rd Street, SE   Washington DC 20003
250 250   2020-02-08 Bell Michael J. 2244 2244 1971-02-18 Hogan Lovells US LLP 555 - 13th Street, NW Columbia Square Washington DC 20004-1109
252 252   2016-02-10 Ervin Clark Kent 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350

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)
);
Powered by Datasette · Query took 648.508ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history