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

40,504 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 Woolery Andrew 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
102 102   2020-01-14 Metz Craig H. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
103 103   2018-01-16 Tsering Ngodup 1699 1699 1964-03-14 Office of Tibet 1228 17th Street, NW   Washington DC 20036
104 104   2019-01-16 Brown William B. 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
105 105   2019-01-16 Hassig Kongdan Oh 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
106 106   2019-01-16 Kim June Dong 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
107 107   2019-01-16 Suh Changhoon 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
108 108   2020-01-16 Maney Jo 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
109 109   2014-01-17 Grothaus Nicholas 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
110 110   2017-01-17 Jalaludin Faizal 2331 2331 1972-04-17 Malaysian Industrial Development Authority 875 North Michigan Avenue Suite 1515 Chicago IL 60611
111 111   2018-01-17 Osborne Jason 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
112 112   2020-01-17 Harper Gregg 6784 6784 2020-01-17 Watkins & Eager, PLLC 400 East Capitol Street   Jackson MS 39201
113 113   2020-01-17 Ott Laura O'Neill 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
114 114   1996-01-18 Morgan Irene 4450 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
115 115   2021-01-18 Akram Mohammad 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
116 116   2021-01-18 Khan Adbul Hafeez 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
117 117   2021-01-18 Khan Qamar Zaman 6908 6908 2021-01-18 PTI SCAD NA 50-54 Polk Avenue   Hempstead NY 11550
118 118   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
119 119   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
120 120   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
121 121   2018-01-19 Aho Loren 5931 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
122 122   2018-01-19 Loh Choon Hong 5350 5350 1999-12-10 Malaysian Investment Development Authority 226 Airport Parkway Suite 480 San Jose CA 95110
123 123   2017-01-20 Richards James 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
124 124   2021-01-20 Fischer Carin I. 6911 6911 2021-01-20 Chinar Consulting, LLC 3636 16th Street, NW Suite B260 Washington DC 20010
125 125   2021-01-20 Passe-Rodriguez Djenny 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
126 126   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
127 127   2020-01-21 Ros-Lehtinen Ileana 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
128 128   2021-01-21 Fischer Carin I. 6912 6912 2021-01-21 Kashmir Action Network, LLC 3636 16th Street, NW Suite B260 Washington DC 20010
129 129   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
130 130   2021-01-21 Rand Amy 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
131 131   2002-01-22 Newberry Edward J. 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
132 132   2018-01-22 Clerc Pascaline 6510 6510 2018-01-22 Meliora Strategy 1813 13th Street, NW Suite 2 Washington DC 20009
133 133   2019-01-22 Wiles Susan 6415 6415 2017-04-05 Ballard Partners 601 Thirteenth Street, NW Suite 450 N Washington DC 20005
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   2021-01-22 Rabinowitz Steven 6913 6913 2021-01-22 Rabinowitz, Inc. d/b/a Bluelight Strategies 4201 Connecticut Avenue, NW Suite 211 Washington DC 20008
139 139   2017-01-23 Gold Amrei 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
140 140   2017-01-23 Nuss Linda 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
141 141   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
142 142   2021-01-23 Benitez Rojas Felipe Carlos 6914 6914 2021-01-23 Benitez Strategies 1015 15th Street, NW   Washington DC 20005
143 143   2021-01-23 Randall Nicole Lee 6914 6914 2021-01-23 Benitez Strategies 1015 15th Street, NW   Washington DC 20005
144 144   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
145 145   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
146 146   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
147 147   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
148 148   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
149 149   2020-01-24 Elawad Hagir H. 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
150 150   2020-01-24 Rynsard Louis 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
151 151   2021-01-24 Jackson Robert Porter 6915 6915 2021-01-24 Jackson, Robert Porter 9723 Spring Ridge Lane   Vienna VA 22182-1451
152 152   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
153 153   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
154 154   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
155 155   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
156 156   2019-01-25 Lavoie Alyse 6518 6518 2018-02-02 Chartwell Strategy Group, LLC 701 8th Street, NW, Suite 620   Washington DC 20001
157 157   2021-01-25 Breach Brian McLane 6916 6916 2021-01-25 ADLAB, LLC 3 WTC - 175 Greenwich Street 31st Floor New York NY 10007
158 158   2021-01-25 Lawhead Nicholas Anthony 6916 6916 2021-01-25 ADLAB, LLC 3 WTC - 175 Greenwich Street 31st Floor New York NY 10007
159 159   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
160 160   2021-01-26 Amsterdam Robert Ross 6325 6325 2015-10-26 Amsterdam & Partners, LLP 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
161 161   2021-01-26 Arker Josh 6917 6917 2021-01-26 Berger Hirschberg Strategies, LLC 5114 Saratoga Avenue   Bethesda MD 20816
162 162   2021-01-26 Berger Stephanie 6917 6917 2021-01-26 Berger Hirschberg Strategies, LLC 5114 Saratoga Avenue   Bethesda MD 20816
163 163   2021-01-26 Durkovic Andrew 6325 6325 2015-10-26 Amsterdam & Partners, LLP 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
164 164   2021-01-26 Garrett Eulice Brandon 6919 6919 2021-01-26 Empire Consulting Group, Inc. 1717 K Street, NW 9th Floor Washington DC 20006
165 165   2021-01-26 Hardwick John 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
166 166   2021-01-26 Jackson Robert 6918 6918 2021-01-26 Horizon Client Access, Inc. 110 Lafayette Street Suite 603 New York NY 10013
167 167   2021-01-26 McKay Mike 6919 6919 2021-01-26 Empire Consulting Group, Inc. 1717 K Street, NW 9th Floor Washington DC 20006
168 168   2021-01-26 Straughn Gerald 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
169 169   2015-01-27 Savelieff (Kasulke) Ludmilla Lydia 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
170 170   2017-01-27 Pizziferri Michael 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
171 171   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
172 172   2020-01-27 Carbonara Kristina 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
173 173   2020-01-27 Kredisova Anna 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
174 174   2020-01-27 Love Michael 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
175 175   2020-01-27 Singh Nirmala 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
176 176   2020-01-27 Tritton Benjamin Westlake 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
177 177   2020-01-27 Yohannan Calvin 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
178 178   2021-01-27 Gray Justin 6892 6892 2020-11-19 Gray Global Advisors, LLC 300 New Jersey Avenue, NW Suite 900 Washington DC 20001
179 179   2016-01-28 Larouche Benoit 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
180 180   2019-01-28 Park Irene 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
181 181   2020-01-28 Garry Katie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
182 182   2020-01-28 Hada Kunio 769 769 1953-05-26 Japan National Tourism Organization One Grand Central Place 60th East 42nd Street, Suite 448 New York NY 10165
183 183   2020-01-28 Sullivan Brendan 6570 6570 2018-07-10 LGND, LLC 6701 Democracy Blvd Suite 300 Bethesda MD 20817
184 184   2021-01-28 Balough Rebecca 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
185 185   2021-01-28 Clark Matthew 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
186 186   2021-01-28 Dilyard Katharine 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
187 187   2021-01-28 Frangos Constantine 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
188 188   2021-01-28 Isola Meredith 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
189 189   2021-01-28 Lewis David 6906 6906 2021-01-09 The Cormac Group LLC 800 Connecticut Avenue, NW Suite 300 Washington DC 20006
190 190   2021-01-28 Marshall Monica 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
191 191   2021-01-28 Matos Christopher 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
192 192   2021-01-28 McCaffrey Evan 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
193 193   2021-01-28 Nardeo Nira 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
194 194   2021-01-28 Naylor McKenzie 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
195 195   2021-01-28 Nolan John 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
196 196   2021-01-28 Stout Samantha 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
197 197   2021-01-28 Totade Tejas 6840 6840 2020-06-22 Ruder Finn, Inc. 425 East 53rd Street   New York NY 10022
198 198   2013-01-29 Wilson Ellen 3911 3911 1986-12-01 IPG DXTRA, Inc 733 Tenth Street, NW   Washington DC 20001
199 199   2019-01-29 Fadlallah Mac 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
200 200   2020-01-29 Kahn Evan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601

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