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

39,667 rows

View and edit SQL

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   2019-01-14 Van Patten Amy 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
102   2019-01-14 Whitley Alexis 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
103   2019-01-14 Woolery Andrew 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
104   2020-01-14 Metz Craig H. 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
105   2020-01-15 Gallagher John 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
106   2018-01-16 Tsering Ngodup 1699 1699 1964-03-14 Office of Tibet 1228 17th Street, NW   Washington DC 20036
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   2019-01-16 Hassig Kongdan Oh 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
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   2019-01-16 Suh Changhoon 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
111   2020-01-16 Comins Marshall 6783 6783 2020-01-16 Stone Strategic Solutions SRL 19-21 Sos. Bucuresti-Ploiesti, Baneasa Business Park 6th Floor Sec. 1, Bucharest    
112   2020-01-16 Maney Jo 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
113   2020-01-16 Stone Alan Blaine 6783 6783 2020-01-16 Stone Strategic Solutions SRL 19-21 Sos. Bucuresti-Ploiesti, Baneasa Business Park 6th Floor Sec. 1, Bucharest    
114   2014-01-17 Grothaus Nicholas 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
115   2017-01-17 Jalaludin Faizal 2331 2331 1972-04-17 Malaysian Industrial Development Authority 875 North Michigan Avenue Suite 1515 Chicago IL 60611
116   2018-01-17 Osborne Jason 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
117   2020-01-17 Harper Gregg 6784 6784 2020-01-17 Watkins & Eager, PLLC 400 East Capitol Street   Jackson MS 39201
118   2020-01-17 Ott Laura O'Neill 6635 6635 2019-02-11 Barzan Aeronautical LLC 200 Meeting Street Suite 305 Charleston SC 29401
119   1996-01-18 Morgan Irene 4450 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
120   2019-01-18 Hartwell Robert 6620 6620 2019-01-18 Hartwell Capitol Consulting LLC 1219 3rd Street Drive East   Palmetto FL 34221
121   2015-01-19 Cole Christopher 6274 6274 2015-01-19 Rogich Communications Group 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
122   2015-01-19 Rogich Sigmund 6274 6274 2015-01-19 Rogich Communications Group 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
123   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
124   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
125   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
126   2018-01-19 Aho Loren 5931 5931 2009-04-17 Venable, LLP 600 Massachusetts Ave, NW   Washington DC 20001
127   2018-01-19 Loh Choon Hong 5350 5350 1999-12-10 Malaysian Investment Development Authority 226 Airport Parkway Suite 480 San Jose CA 95110
128   2016-01-20 Larson Stephen 6337 6337 2016-01-20 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
129   2016-01-20 McEfee Camden S. 6337 6337 2016-01-20 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
130   2017-01-20 Richards James 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
131   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
132   2020-01-21 Ros-Lehtinen Ileana 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
133   2002-01-22 Newberry Edward J. 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
134   2018-01-22 Clerc Pascaline 6510 6510 2018-01-22 Meliora Strategy 1813 13th Street, NW Suite 2 Washington DC 20009
135   2019-01-22 Fan Xiuyun 3318 3318 1981-12-30 China National Tourist Office 370 Lexington Avenue Suite 912 New York NY 10017
136   2019-01-22 Wiles Susan 6415 6415 2017-04-05 Ballard Partners 601 Thirteenth Street, N.W. Suite 450 N Washington DC 20005
137   2019-01-22 Zimmerman Ari 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
138   2020-01-22 Beard Hannah 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
139   2020-01-22 Hilton Max 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
140   2020-01-22 Lovallo John 6642 6642 2019-03-06 Levick Strategic Communications, LP 1900 M Street, NW 4th Floor Washington DC 20036
141   2020-01-22 Vertrano Kalli 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
142   2017-01-23 Gold Amrei 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
143   2017-01-23 Kelly Jr. Daniel Peter 6381 6381 2016-09-30 MWW Group, LLC One Meadowlands Plaza   East Rutherford NJ 07073
144   2017-01-23 Nuss Linda 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
145   2019-01-23 McGlone William M. 6628 6628 2019-01-23 Latham & Watkins LLP 555 Eleventh Street, NW Suite 1000 Washington DC 20004
146   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
147   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
148   2018-01-24 Disler Mark 6377 6377 2016-09-19 Prime Policy Group 1801 K Street, NW Suite 9000 Washington DC 20006
149   2019-01-24 Henoch Robert 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
150   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
151   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
152   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
153   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
154   2020-01-24 Elawad Hagir H. 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
155   2020-01-24 Kise Christopher 6787 6787 2020-01-24 Foley & Lardner LLP 777 East Wisconsin Ave.   Milwaukee WI 53202
156   2020-01-24 Rynsard Louis 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
157   2020-01-24 Swift Christopher 6787 6787 2020-01-24 Foley & Lardner LLP 777 East Wisconsin Ave.   Milwaukee WI 53202
158   2006-01-25 Altschuler Irwin 5712 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, N.W. Suite 1000 Washington DC 20037
159   2006-01-25 Stein Donald P. 5712 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, N.W. Suite 1000 Washington DC 20037
160   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
161   2012-01-25 Hutcheson Ron 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC 607 Fourteenth Street, NW Suite 300 Washington DC 20005
162   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
163   2018-01-25 Kuriyama Ai 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
164   2018-01-25 Murata Soma 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
165   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
166   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
167   2018-01-25 Yoneyama Lena 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
168   2019-01-25 Ballman Luke 6518 6518 2018-02-02 Chartwell Strategy Group, LLC 701 8th Street, NW, Suite 620   Washington DC 20001
169   2019-01-25 Barnes Beaudre D. 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
170   2019-01-25 Lavoie Alyse 6518 6518 2018-02-02 Chartwell Strategy Group, LLC 701 8th Street, NW, Suite 620   Washington DC 20001
171   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
172   2015-01-27 Savelieff (Kasulke) Ludmilla Lydia 2165 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
173   2017-01-27 Pizziferri Michael 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
174   2017-01-27 Westfall Leslie Cecile 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
175   2020-01-27 Artunkal Nijat Tahsin Can 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
176   2020-01-27 Carbonara Kristina 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
177   2020-01-27 Kredisova Anna 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
178   2020-01-27 Love Michael 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
179   2020-01-27 Singh Nirmala 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
180   2020-01-27 Tritton Benjamin Westlake 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
181   2020-01-27 Yohannan Calvin 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
182   2016-01-28 Kazlauskas Kirsten Constance 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
183   2016-01-28 Larouche Benoit 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
184   2016-01-28 MacKay Elizabeth 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
185   2019-01-28 Lande Stephen 6632 6632 2019-01-28 Manchester Trade Inc Ltd 2200 Pennsylvania Avenue, NW Suite 4086E Washington DC 20053
186   2019-01-28 Park Irene 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
187   2019-01-28 Stuaan Abbi 6377 6377 2016-09-19 Prime Policy Group 1801 K Street, NW Suite 9000 Washington DC 20006
188   2020-01-28 Garry Katie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
189   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
190   2020-01-28 Sullivan Brendan 6570 6570 2018-07-10 LGND, LLC 6701 Democracy Blvd Suite 300 Bethesda MD 20817
191   2013-01-29 Wilson Ellen 3911 3911 1986-12-01 CMGRP, Inc. 733 Tenth Street, NW   Washington DC 20001
192   2015-01-29 Soliman Michael 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
193   2018-01-29 Cialdella Michael 6477 6477 2017-10-24 White House Writers Group, Inc. 1025 Thomas Jefferson Street, NW Suite 110G Washington DC 20007
194   2019-01-29 Aisen Mayuka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
195   2019-01-29 Fadlallah Mac 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
196   2020-01-29 Kahn Evan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
197   2020-01-29 Tahan Julie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
198   2006-01-30 Douglas Donna Willa-Mae 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
199   2017-01-30 Cosar Yagmur 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
200   2017-01-30 Tucker James 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006

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 185.003ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history