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

40,072 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   2015-01-19 Rogich Sigmund 6274 6274 2015-01-19 Rogich Communications Group 11920 Southern Highlands Parkway Suite 301 Las Vegas NV 89141
102 102   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
103 103   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
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
106 106   2018-01-19 Loh Choon Hong 5350 5350 1999-12-10 Malaysian Investment Development Authority 226 Airport Parkway Suite 480 San Jose CA 95110
107 107   2017-01-20 Richards James 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
108 108   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
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
113 113   2019-01-22 Zimmerman Ari 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
114 114   2020-01-22 Beard Hannah 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
115 115   2020-01-22 Hilton Max 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
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
117 117   2020-01-22 Vertrano Kalli 6785 6785 2020-01-22 Peregrine Communications Inc. 405 Lexington Avenue 9th Floor New York NY 10174
118 118   2017-01-23 Gold Amrei 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
119 119   2017-01-23 Nuss Linda 616 616 1950-02-28 German National Tourist Office 122 East 42nd Street Suite 2000 New York NY 10168
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
121 121   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
122 122   2018-01-24 Disler Mark 6377 6377 2016-09-19 Prime Policy Group 1801 K Street, NW Suite 9000 Washington DC 20006
123 123   2019-01-24 Henoch Robert 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
124 124   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
125 125   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
126 126   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
127 127   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
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
129 129   2020-01-24 Kise Christopher 6787 6787 2020-01-24 Foley & Lardner LLP 777 East Wisconsin Ave.   Milwaukee WI 53202
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
131 131   2020-01-24 Swift Christopher 6787 6787 2020-01-24 Foley & Lardner LLP 777 East Wisconsin Ave.   Milwaukee WI 53202
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
134 134   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
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
136 136   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
137 137   2018-01-25 Kuriyama Ai 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
138 138   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
139 139   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
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
141 141   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
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
143 143   2017-01-27 Pizziferri Michael 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
144 144   2017-01-27 Westfall Leslie Cecile 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
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
146 146   2020-01-27 Carbonara Kristina 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
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
149 149   2020-01-27 Love Michael 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
150 150   2020-01-27 Singh Nirmala 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
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
152 152   2020-01-27 Yohannan Calvin 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
153 153   2016-01-28 Kazlauskas Kirsten Constance 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
154 154   2016-01-28 Larouche Benoit 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
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
157 157   2020-01-28 Garry Katie 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
158 158   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
159 159   2020-01-28 Sullivan Brendan 6570 6570 2018-07-10 LGND, LLC 6701 Democracy Blvd Suite 300 Bethesda MD 20817
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
163 163   2020-01-29 Kahn Evan 6652 6652 2019-03-18 Zeno Group, Inc. 130 East Randolph Street   Chicago IL 60601
164 164   2006-01-30 Douglas Donna Willa-Mae 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
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
167 167   2019-01-30 Fork William E. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
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
170 170   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
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
174 174   2020-01-30 Pagliery Patricia 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
175 175   2020-01-30 Reich Allegra 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
176 176   2020-01-30 Sepulveda Mayerly 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
177 177   2020-01-30 Sepulveda Mayerly 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
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
179 179   1992-01-31 Cenzuales Giovanni 568 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
180 180   1992-01-31 Manassero Dennis 568 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
181 181   1992-01-31 Scaldaferri Maria C. 568 568 1949-04-21 Italian Government Tourist Board, New York 686 Park Avenue 3rd Floor New York NY 10065
182 182   2005-01-31 O'Brien Brett 5666 5666 2005-01-31 Glover Park Group, LLC 13215 Deer Highlands Way   Silver Spring MD 20906
183 183   2006-01-31 Dobson Christopher George 2360 2360 1972-07-26 Jamaica Tourist Board, Florida 5201 Blue Lagoon Drive Suite 670 Miami FL 33126
184 184   2006-01-31 Harper Cheryl Ann Victoria 2360 2360 1972-07-26 Jamaica Tourist Board, Florida 5201 Blue Lagoon Drive Suite 670 Miami FL 33126
185 185   2006-01-31 Rose Philip Anthony 2360 2360 1972-07-26 Jamaica Tourist Board, Florida 5201 Blue Lagoon Drive Suite 670 Miami FL 33126
186 186   2006-01-31 Senior Kenton Washington 2360 2360 1972-07-26 Jamaica Tourist Board, Florida 5201 Blue Lagoon Drive Suite 670 Miami FL 33126
187 187   2006-01-31 Woolcock John Milton 2360 2360 1972-07-26 Jamaica Tourist Board, Florida 5201 Blue Lagoon Drive Suite 670 Miami FL 33126
188 188   2017-01-31 Nagao Yusuke 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
189 189   2017-01-31 Shartzer Andrew 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
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
194 194   2020-01-31 Davoine Caroline 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
195 195   2020-01-31 Huneault Philippe 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
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
197 197   2020-01-31 Kanji Miyatake 4069 4069 1987-12-01 JETRO, Atlanta 1050 Crown Pointe Parkway Suite 1450 Atlanta GA 30338
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
199 199   2020-01-31 Kolthoff Ishmael 430 430 1947-01-30 Bermuda Tourism Authority 675 Third Avenue 12th Floor New York NY 10017
200 200   2020-01-31 Langlois Frederic 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102

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