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

42,437 rows

✎ View and edit SQL

This data as json, CSV (advanced)

State >30

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
101 101   2014-01-13 Ahrens Frank BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
102 102   2021-01-13 Rermruk Soothawee Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
103 103   2022-01-13 O'Hanlon John Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
104 104   2022-01-13 Ballard Brian Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
105 105   2022-01-13 Cohen Richard Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
106 106   2022-01-13 Diaz Jose Ballard Partners 7070 2022-01-13 Ballard Partners 601 Thirteenth Street, NW Suite 250 S Washington DC 20005
107 107   2022-01-13 Ferraiolo Phoebe Cogent Strategies LLC 6927 2021-02-23 Cogent Strategies LLC 2550 M Street, NW 2nd Floor Washington DC 20037
108 108   2022-01-13 Fischbein Ben Cogent Strategies LLC 6927 2021-02-23 Cogent Strategies LLC 2550 M Street, NW 2nd Floor Washington DC 20037
109 109   2022-01-13 Friedrich Brian Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
110 110   2022-01-13 Oien Patricia Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
111 111   2022-01-13 Pitts Brian Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
112 112   2022-01-13 Tessier Michelle Cogent Strategies LLC 6927 2021-02-23 Cogent Strategies LLC 2550 M Street, NW 2nd Floor Washington DC 20037
113 113   2023-01-13 Cardenas Jose The Cormac Group LLC 7219 2023-01-13 The Cormac Group LLC 800 Connecticut Avenue NW, Suite 300   Washington DC 20006
114 114   2023-01-13 Cartelle Erik The Cormac Group LLC 7219 2023-01-13 The Cormac Group LLC 800 Connecticut Avenue NW, Suite 300   Washington DC 20006
115 115   2023-01-13 Slade Jonathan The Cormac Group LLC 7219 2023-01-13 The Cormac Group LLC 800 Connecticut Avenue NW, Suite 300   Washington DC 20006
116 116   2019-01-14 Cano Ines MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 7309 W. 80th Street #400 Overland Park KS 66204
117 117   2019-01-14 Footlik Jay ThirdCircle, Inc. 6540 2018-04-13 ThirdCircle, Inc. 1111 Penhurst Lane   Penn Valley PA 19702
118 118   2019-01-14 Guest Thalia MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 7309 W. 80th Street #400 Overland Park KS 66204
119 119   2019-01-14 Luckey Chris MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 7309 W. 80th Street #400 Overland Park KS 66204
120 120   2019-01-14 Van Patten Amy MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 7309 W. 80th Street #400 Overland Park KS 66204
121 121   2019-01-14 Whitley Alexis MMGY Global, LLC 6492 2017-11-27 MMGY Global, LLC 7309 W. 80th Street #400 Overland Park KS 66204
122 122   2020-01-14 Metz Craig H. Nelson Mullins Riley & Scarborough, LLP 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
123 123   2019-01-16 Brown William B. Korea Economic Institute 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
124 124   2019-01-16 Hassig Kongdan Oh Korea Economic Institute 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
125 125   2019-01-16 Kim June Dong Korea Economic Institute 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
126 126   2019-01-16 Suh Changhoon Korea Economic Institute 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
127 127   2020-01-16 Maney Jo BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
128 128   2014-01-17 Grothaus Nicholas Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
129 129   2020-01-17 Harper Gregg Watkins & Eager, PLLC 6784 2020-01-17 Watkins & Eager, PLLC 400 East Capitol Street   Jackson MS 39201
130 130   2020-01-17 Ott Laura O'Neill Barzan Aeronautical LLC 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
131 131   2023-01-17 Goldman Kevin Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
132 132   2023-01-17 London Joy Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
133 133   2023-01-17 Perlmutter Rachel Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
134 134   2023-01-17 Pittman Mary Gannon Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
135 135   2023-01-17 Prade Nasir Steven Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
136 136   2023-01-17 Ringler Todd D. Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
137 137   2023-01-17 Teitelman Sarah Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
138 138   1996-01-18 Morgan Irene Destination New South Wales 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
139 139   2022-01-18 Chiimbwe Spencer K. Ambessa Solutions LLC 6962 2021-05-17 Ambessa Solutions LLC 1707 Pleasantdale Road Apartment 103 Vienna VA 22180
140 140   2022-01-18 Orth Richard Kevin Ambessa Solutions LLC 6962 2021-05-17 Ambessa Solutions LLC 1707 Pleasantdale Road Apartment 103 Vienna VA 22180
141 141   2023-01-18 Rogers Sarah Navigators Global LLC 7112 2022-04-29 Navigators Global LLC 901 7th Street, NW Suite 200 Washington DC 20001
142 142   2015-01-19 Vang Tou-Fu United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 35   Pine City MN 55063
143 143   2015-01-19 Vang Victor United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 35   Pine City MN 55063
144 144   2017-01-19 Broydrick William B. Malaysian Rubber Export Promotion Council (USA) 5444 2001-07-02 Malaysian Rubber Export Promotion Council (USA) 3516 International Court, N.W.   Washington DC 20008
145 145   2018-01-19 Aho Loren Venable, LLP 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
146 146   2017-01-20 Richards James Cornerstone Government Affairs 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
147 147   2021-01-20 Fischer Carin I. Chinar Consulting, LLC 6911 2021-01-20 Chinar Consulting, LLC 3636 16th Street, NW Suite B260 Washington DC 20010
148 148   2020-01-21 Ros-Lehtinen Ileana Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
149 149   2021-01-21 Fischer Carin I. Kashmir Action Network, LLC 6912 2021-01-21 Kashmir Action Network, LLC 1300 I Street, NW Suite 400E Washington DC 20005
150 150   2021-01-21 Goto Chikako Japan National Tourism Organization 769 1953-05-26 Japan National Tourism Organization 250 Park Avenue Suite. 1900   New York NY 10177
151 151   2022-01-21 Fawkner Joseph Guzicki Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
152 152   2022-01-21 McCarry Caleb C Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 601 13th Street, NW Suite 900 South Washington DC 20005
153 153   2002-01-22 Newberry Edward J. Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
154 154   2018-01-22 Clerc Pascaline Meliora Strategy 6510 2018-01-22 Meliora Strategy 1813 13th Street, NW Suite 2 Washington DC 20009
155 155   2019-01-22 Zimmerman Ari Brownstein Hyatt Farber Schreck, LLP 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 675 15th Street Suite 2900 Denver CO 80202-4432
156 156   2020-01-22 Beard Hannah Peregrine Communications Inc. 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
157 157   2020-01-22 Hilton Max Peregrine Communications Inc. 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
158 158   2020-01-22 Vertrano Kalli Peregrine Communications Inc. 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
159 159   2023-01-22 Noirbent Pauette F Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
160 160   2023-01-22 Ouelltte Noah Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
161 161   2023-01-22 Spruell Connor Mitchell Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
162 162   2020-01-23 El-Erian Mostafa Ali Cogent Law Group LLP 6786 2020-01-23 Cogent Law Group LLP 1875 K Street, NW 4th Floor Washington DC 20006
163 163   2021-01-23 Benitez Rojas Felipe Carlos Benitez Strategies 6914 2021-01-23 Benitez Strategies 1015 15th Street, NW   Washington DC 20005
164 164   2021-01-23 Randall Nicole Lee Benitez Strategies 6914 2021-01-23 Benitez Strategies 1015 15th Street, NW   Washington DC 20005
165 165   2023-01-23 Caraway Chanel Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
166 166   2023-01-23 Cockfield Jr. Errol Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
167 167   2023-01-23 Ghiheen Julia Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
168 168   2023-01-23 Safler Noam Brunswick Group LLC 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
169 169   2003-01-24 Kor Sabrina (Ya-Rei) Far East Trade Services, Inc. 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
170 170   2018-01-24 Disler Mark Prime Policy Group 6377 2016-09-19 Prime Policy Group 1801 K Street, NW Suite 9000 Washington DC 20006
171 171   2019-01-24 Sullivan III Daniel J. SST Aerospace, LLC 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
172 172   2019-01-24 Tarpenning Kory SST Aerospace, LLC 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
173 173   2019-01-24 Terry Benjamin Scott SST Aerospace, LLC 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
174 174   2019-01-24 Terry Katherine Payne SST Aerospace, LLC 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
175 175   2022-01-24 Crawford Camilyn Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
176 176   2022-01-24 Dickinson Timothy Paul Hastings LLP 6743 2019-10-25 Paul Hastings LLP 875 15th Street, NW   Washington DC 20005
177 177   2022-01-24 Hanna Edmund Ogilvy Group LLC 6797 2020-03-04 Ogilvy Group LLC 636 11th Avenue   New York NY 10036
178 178   2023-01-24 Perez Yanet Brunet The Cormac Group LLC 7219 2023-01-13 The Cormac Group LLC 800 Connecticut Avenue NW, Suite 300   Washington DC 20006
179 179   2006-01-25 Tsai Chia-Hsuan Far East Trade Services, Inc. 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
180 180   2018-01-25 Baker Christopher JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
181 181   2018-01-25 Torres Kumiko Tanaka JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
182 182   2018-01-25 Vermeiren Sachie JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
183 183   2021-01-25 Breach Brian McLane ADLAB, LLC 6916 2021-01-25 ADLAB, LLC 3 WTC - 175 Greenwich Street 31st Floor New York NY 10007
184 184   2021-01-25 Lawhead Nicholas Anthony ADLAB, LLC 6916 2021-01-25 ADLAB, LLC 3 WTC - 175 Greenwich Street 31st Floor New York NY 10007
185 185   2022-01-25 Hong Andy Korea Economic Institute 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
186 186   2022-01-25 Pressley Mai Anna Korea Economic Institute 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
187 187   2022-01-25 Tamaki Katsuya Okinawa Prefecture DC Office, Inc. 6332 2015-12-23 Okinawa Prefecture DC Office, Inc. 1101 Connecticut Avenue, NW Suite 450 Washington DC 20036
188 188   2023-01-25 Chitwood Matthew McKenzie Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
189 189   2023-01-25 Garsko Summer Daniel J. Edelman, Inc. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
190 190   2021-01-26 Garrett Eulice Brandon Empire Consulting Group, Inc. 6919 2021-01-26 Empire Consulting Group, Inc. 1717 K Street, NW 9th Floor Washington DC 20006
191 191   2021-01-26 Hardwick John Barzan Aeronautical LLC 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
192 192   2021-01-26 Jackson Robert Horizon Client Access, Inc. 6918 2021-01-26 Horizon Client Access, Inc. 110 Lafayette Street Suite 603 New York NY 10013
193 193   2021-01-26 McKay Mike Empire Consulting Group, Inc. 6919 2021-01-26 Empire Consulting Group, Inc. 1717 K Street, NW 9th Floor Washington DC 20006
194 194   2021-01-26 Straughn Gerald Barzan Aeronautical LLC 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
195 195   2022-01-26 Pongjaroen Prin Tourism Authority of Thailand, New York 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
196 196   2023-01-26 Ma Yunfei China National Tourist Office 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
197 197   2015-01-27 Savelieff (Kasulke) Ludmilla Lydia Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
198 198   2017-01-27 Pizziferri Michael Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
199 199   2021-01-27 Gray Justin Gray Global Advisors, LLC 6892 2020-11-19 Gray Global Advisors, LLC 300 New Jersey Avenue, NW Suite 900 Washington DC 20001
200 200   2022-01-27 Fryer Bruce Future Pact LLC 7074 2022-01-27 Future Pact LLC 1276 Owen P1 Apt. A Washington DC 20002

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