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

41,051 rows

✎ View and edit SQL

This data as json, CSV (advanced)

State

Registration_Number

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   2019-01-14 Luckey Chris 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
102 102   2019-01-14 Martinez Natalia Perez 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
103 103   2019-01-14 Van Patten Amy 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
104 104   2019-01-14 Whitley Alexis 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
105 105   2020-01-14 Metz Craig H. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
106 106   2018-01-16 Tsering Ngodup 1699 1699 1964-03-14 Office of Tibet 1228 17th Street, NW   Washington DC 20036
107 107   2019-01-16 Brown William B. 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
108 108   2019-01-16 Hassig Kongdan Oh 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
109 109   2019-01-16 Kim June Dong 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
110 110   2019-01-16 Suh Changhoon 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
111 111   2020-01-16 Maney Jo 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
112 112   2014-01-17 Grothaus Nicholas 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
113 113   2017-01-17 Jalaludin Faizal 2331 2331 1972-04-17 Malaysian Industrial Development Authority 875 North Michigan Avenue Suite 1810 Chicago IL 60611
114 114   2020-01-17 Harper Gregg 6784 6784 2020-01-17 Watkins & Eager, PLLC 400 East Capitol Street   Jackson MS 39201
115 115   2020-01-17 Ott Laura O'Neill 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
116 116   1996-01-18 Morgan Irene 4450 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
117 117   2021-01-18 Akram Mohammad 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
118 118   2021-01-18 Khan Adbul Hafeez 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
119 119   2021-01-18 Khan Qamar Zaman 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
120 120   2015-01-19 Vang Tou-Fu 6130 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 232738   Sacramento CA 95823
121 121   2015-01-19 Vang Victor 6130 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 232738   Sacramento CA 95823
122 122   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
123 123   2018-01-19 Aho Loren 5931 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
124 124   2017-01-20 Richards James 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
125 125   2021-01-20 Fischer Carin I. 6911 6911 2021-01-20 Chinar Consulting, LLC 3636 16th Street, NW Suite B260 Washington DC 20010
126 126   2021-01-20 Passe Djenny 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
127 127   2020-01-21 Mengna LI 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
128 128   2020-01-21 Ros-Lehtinen Ileana 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
129 129   2021-01-21 Fischer Carin I. 6912 6912 2021-01-21 Kashmir Action Network, LLC 3636 16th Street, NW Suite B260 Washington DC 20010
130 130   2021-01-21 Goto Chikako 769 769 1953-05-26 Japan National Tourism Organization One Grand Central Place 60th East 42nd Street, Suite 448 New York NY 10165
131 131   2021-01-21 Rand Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
132 132   2002-01-22 Newberry Edward J. 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
133 133   2018-01-22 Clerc Pascaline 6510 6510 2018-01-22 Meliora Strategy 1813 13th Street, NW Suite 2 Washington DC 20009
134 134   2019-01-22 Zimmerman Ari 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
135 135   2020-01-22 Beard Hannah 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
136 136   2020-01-22 Hilton Max 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
137 137   2020-01-22 Vertrano Kalli 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
138 138   2017-01-23 Gold Amrei 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
139 139   2017-01-23 Nuss Linda 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
140 140   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
141 141   2021-01-23 Benitez Rojas Felipe Carlos 6914 6914 2021-01-23 Benitez Strategies 1634 Eye Street, NW. Suite 1100 Washington DC 20006
142 142   2021-01-23 Randall Nicole Lee 6914 6914 2021-01-23 Benitez Strategies 1634 Eye Street, NW. Suite 1100 Washington DC 20006
143 143   2003-01-24 Kor Sabrina (Ya-Rei) 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
144 144   2019-01-24 Sullivan III Daniel J. 6629 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
145 145   2019-01-24 Tarpenning Kory 6629 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
146 146   2019-01-24 Terry Benjamin Scott 6629 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
147 147   2019-01-24 Terry Katherine Payne 6629 6629 2019-01-24 SST Aerospace, LLC Greenville Downtown Airport/Hangar 1 54 Watson Aviation Road Greenville SC 29607
148 148   2020-01-24 Elawad Hagir H. 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
149 149   2020-01-24 Rynsard Louis 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
150 150   2021-01-24 Jackson Robert Porter 6915 6915 2021-01-24 Jackson, Robert Porter 9723 Spring Ridge Lane   Vienna VA 22182-1451
151 151   2006-01-25 Tsai Chia-Hsuan 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
152 152   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
153 153   2018-01-25 Torres Kumiko Tanaka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
154 154   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
155 155   2021-01-25 Breach Brian McLane 6916 6916 2021-01-25 ADLAB, LLC 3 WTC - 175 Greenwich Street 31st Floor New York NY 10007
156 156   2021-01-25 Lawhead Nicholas Anthony 6916 6916 2021-01-25 ADLAB, LLC 3 WTC - 175 Greenwich Street 31st Floor New York NY 10007
157 157   2017-01-26 Zhao Zhenge 6113 6113 2012-07-06 Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 2001 Jefferson Davis Highway Suite 608 Arlington VA 22202
158 158   2021-01-26 Amsterdam Robert Ross 6325 6325 2015-10-26 Amsterdam & Partners, LLP 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
159 159   2021-01-26 Arker Josh 6917 6917 2021-01-26 Berger Hirschberg Strategies, LLC 5114 Saratoga Avenue   Bethesda MD 20816
160 160   2021-01-26 Berger Stephanie 6917 6917 2021-01-26 Berger Hirschberg Strategies, LLC 5114 Saratoga Avenue   Bethesda MD 20816
161 161   2021-01-26 Durkovic Andrew 6325 6325 2015-10-26 Amsterdam & Partners, LLP 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
162 162   2021-01-26 Garrett Eulice Brandon 6919 6919 2021-01-26 Empire Consulting Group, Inc. 1717 K Street, NW 9th Floor Washington DC 20006
163 163   2021-01-26 Hardwick John 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
164 164   2021-01-26 Jackson Robert 6918 6918 2021-01-26 Horizon Client Access, Inc. 110 Lafayette Street Suite 603 New York NY 10013
165 165   2021-01-26 McKay Mike 6919 6919 2021-01-26 Empire Consulting Group, Inc. 1717 K Street, NW 9th Floor Washington DC 20006
166 166   2021-01-26 Straughn Gerald 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
167 167   2015-01-27 Savelieff (Kasulke) Ludmilla Lydia 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
168 168   2017-01-27 Pizziferri Michael 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
169 169   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
170 170   2020-01-27 Love Michael 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
171 171   2020-01-27 Singh Nirmala 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
172 172   2020-01-27 Yohannan Calvin 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
173 173   2021-01-27 Gray Justin 6892 6892 2020-11-19 Gray Global Advisors, LLC 300 New Jersey Avenue, NW Suite 900 Washington DC 20001
174 174   2016-01-28 Larouche Benoit 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
175 175   2019-01-28 Park Irene 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
176 176   2020-01-28 Sullivan Brendan 6570 6570 2018-07-10 LGND, LLC 6701 Democracy Blvd Suite 300 Bethesda MD 20817
177 177   2021-01-28 Clark Matthew 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
178 178   2021-01-28 Dilyard Katharine 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
179 179   2021-01-28 Isola Meredith 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
180 180   2021-01-28 Marshall Monica 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
181 181   2021-01-28 Matos Christopher 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
182 182   2021-01-28 McCaffrey Evan 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
183 183   2021-01-28 Nardeo Nira 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
184 184   2021-01-28 Naylor McKenzie 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
185 185   2021-01-28 Nolan John 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
186 186   2021-01-28 Stout Samantha 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
187 187   2021-01-28 Totade Tejas 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
188 188   2013-01-29 Wilson Ellen 3911 3911 1986-12-01 IPG DXTRA, Inc 733 Tenth Street, NW   Washington DC 20001
189 189   2019-01-29 Fadlallah Mac 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
190 190   2020-01-29 Kahn Evan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
191 191   2021-01-29 Nakano Chiaki 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
192 192   2021-01-29 Whiton Christian 6865 6865 2020-09-03 DC International Advisory, LLC 354 W Sunnyside Road Suite A Idaho Falls ID 83402
193 193   2021-01-29 Won Hyeshin 6397 6397 2016-12-01 Overseas Korean Cultural Heritage Foundation, USA 1500 13th Street, NW   Washington DC 20005
194 194   2006-01-30 Douglas Donna Willa-Mae 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
195 195   2017-01-30 Tucker James 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
196 196   2018-01-30 Jablon Ann 6328 6328 2015-11-19 Capitol Counsel, LLC 700 13th Street, NW Suite 200 Washington DC 20005
197 197   2020-01-30 Boonshoft Emma 3911 3911 1986-12-01 IPG DXTRA, Inc 733 Tenth Street, NW   Washington DC 20001
198 198   2020-01-30 Cunillera Cristina De Jesus 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
199 199   2020-01-30 Foxman Elizabeth 3911 3911 1986-12-01 IPG DXTRA, Inc 733 Tenth Street, NW   Washington DC 20001
200 200   2020-01-30 Hobbs Lemondria 3911 3911 1986-12-01 IPG DXTRA, Inc 733 Tenth Street, NW   Washington DC 20001

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