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,865 rows sorted by Address_1

View and edit SQL

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

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
6690 1984-02-16 1975-04-16 Dingee John H. , Jr. 2576 2576 1975-04-16 Chilton International Company     Radnor PA 19089
34353 1984-11-13 1976-06-12 DeSilva Roland 2576 2576 1975-04-16 Chilton International Company     Radnor PA 19089
34354 1984-11-13 1976-11-08 Englebert Joy 2576 2576 1975-04-16 Chilton International Company     Radnor PA 19089
34355 1984-11-13 1976-11-08 McLaughlin Dennis 2576 2576 1975-04-16 Chilton International Company     Radnor PA 19089
36679 1958-12-12 1958-06-11 O'Donnell Patrick J. 1149 1149 1958-06-11 Irish Republic Army Prisoners' Dependents Fund Committee     Pittsburgh PA  
36680 1958-12-12 1958-06-11 Costello John T. 1149 1149 1958-06-11 Irish Republic Army Prisoners' Dependents Fund Committee     Pittsburgh PA  
36681 1958-12-12 1958-06-11 Davoren Morgan 1149 1149 1958-06-11 Irish Republic Army Prisoners' Dependents Fund Committee     Pittsburgh PA  
36682 1958-12-12 1958-06-11 Stack Cornelius J. 1149 1149 1958-06-11 Irish Republic Army Prisoners' Dependents Fund Committee     Pittsburgh PA  
37066 1946-12-17 1946-12-17 Platek Wendell S. 412 412 1946-12-17 Lettrich, Joseph     Bratislava    
5963 1985-02-07 1973-04-06 Bloch Henry J. 2454 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
5964 1985-02-07 1973-04-06 Feibelmann Alice 2454 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
5965 1985-02-07 1973-04-06 Morris Dorothy L. 2454 2454 1973-09-04 Austrian National Tourist Office for the Pacific Northwest Alaska & Hawaii 1007 Northwest 24th Avenue Portland OR 97210
33165 2001-10-31 1998-10-01 Wides Burton V. 5278 5278 1998-10-01 Burton V. Wides, P.C. General Counsel 105 Cannon House Office Building Washington DC 20515
5183 2016-01-31 2015-01-19 McAllister Singleton 6273 6273 2015-01-19 Husch Blackwell, LLP 750 17th Street, NW Suite 900 Washington DC 20006
13617 2015-04-27 2015-04-24 Orban Russell 6273 6273 2015-01-19 Husch Blackwell, LLP 750 17th Street, NW Suite 900 Washington DC 20006
25957 2015-08-19 2015-01-19 Nottingham Charles 6273 6273 2015-01-19 Husch Blackwell, LLP 750 17th Street, NW Suite 900 Washington DC 20006
25956 2014-08-19 2014-08-19 Wariyo Bekele Wayu 6246 6246 2014-08-19 Sidama National Democratic Movement (SNDM) 806B Kennedy St., NW   Washington DC 20011
12571 1968-04-11 1967-01-06 Root Frederick W. 1382 1382 1960-08-03 Government of Ontario Department of Economics, Development, Trade & Industry Branch 680 Fifth Avenue, Suite 1302 New York NY 10019
12574 1968-04-11 1963-08-19 Mooney Franklin Edward Randall 1382 1382 1960-08-03 Government of Ontario Department of Economics, Development, Trade & Industry Branch 680 Fifth Avenue, Suite 1302 New York NY 10019
28262 1965-09-08 1960-08-03 Probyn Neville 1382 1382 1960-08-03 Government of Ontario Department of Economics, Development, Trade & Industry Branch 680 Fifth Avenue, Suite 1302 New York NY 10019
19874 1961-06-30 1954-08-18 Lam Tit Hong 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
24466 1974-08-01 1966-04-12 Lew Mon Ben 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
24473 1977-08-01 1975-08-21 Gong Shu Chung 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
24485 1981-08-01 1966-02-01 Chew Jong-Yen 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
24489 1981-08-01 1975-08-21 Lee Wallace 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
24501 1983-08-01 1975-08-21 Wong Kai Foon 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
24506 1985-08-01 1972-04-13 Wong Thomas 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26761 1967-08-31 1962-04-23 Soot Hong Gee 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26763 1967-08-31 1954-06-11 Yaw King (aka: Hong Pao) Chang 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26803 1973-08-31 1966-02-18 Wong Sen Chong 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26844 1977-08-31 1972-04-13 Ng Tong 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26845 1977-08-31 1972-04-13 Wong Wah Poy 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26846 1977-08-31 1972-04-13 Wu She Kwan 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26882 1977-08-31 1975-08-21 Wong Kay 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26935 1981-08-31 1975-08-21 Chu Leonard C. 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26936 1981-08-31 1975-08-21 Fong Jimmy H. 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26937 1981-08-31 1975-08-21 Lee Chan Min 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26986 1985-08-31 1975-08-21 Suen Donald 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
26989 1985-08-31 1949-09-19 Liu Pei Chi 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
33927 1974-11-05 1972-04-13 Liu Pei Chi 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
33928 1974-11-05 1973-07-02 Sum Jang Young 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
35971 1985-12-01 1975-08-21 Mock Cheong Hing 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
38460 1973-12-31 1972-04-13 Toy Don 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
38461 1973-12-31 1962-04-23 Kwan Peter Tzu Shu 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
38462 1973-12-31 1962-04-23 Lee Jack Jong 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
38465 1973-12-31 1954-06-11 Lew Goot Chee 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
38466 1973-12-31 1954-06-11 Li Tak (aka D. Foon) 282 282 1945-01-01 Kuomintang of China (Headquarters in America) 844 Stockton Street San Francisco CA 94108
28552 1959-09-14 1957-07-15 Regenspurger Gerte 910 910 1955-09-14 Friedmann, Eric 1 Asbury Avenue   Philadelphia PA  
28553 1959-09-14 1955-11-09 Loeb Ernst Josef 910 910 1955-09-14 Friedmann, Eric 1 Asbury Avenue   Philadelphia PA  
2343 1975-01-01 1974-08-01 Wang Francis S.L. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2346 1976-01-01 1975-02-18 Young John Timothy 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2350 1977-01-01 1975-08-20 Mandel Stuart Jay 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2353 1978-01-01 1975-02-18 Haberkern Roy C. , Jr. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2361 1980-01-01 1977-03-01 Schechter Diane 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2370 1982-01-01 1965-01-11 Kyle Charles Derrick 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2371 1982-01-01 1977-03-01 Rogers John E. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2373 1982-01-01 1974-08-01 Borsook Lana R. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2374 1982-01-01 1976-09-18 Randt Clark T. , Jr. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2406 1986-01-01 1986-01-23 Liu Theodore Em-Po 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2411 1986-01-01 1966-08-09 Shapiro Isaac 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2425 1987-01-01 1986-08-08 Mathias D. Stephen 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2435 1988-01-01 1972-01-20 Smith Briscoe R. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2442 1988-01-01 1974-08-13 Keebler Stuart E. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
2914 1980-01-04 1978-03-01 Castleberry William Lesse 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
3335 1979-01-12 1977-08-23 Conner John T. , Jr. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6187 1992-02-10 1986-01-23 Fletcher Phillip Douglas 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6188 1992-02-10 1986-01-23 Marcuss Stanley J. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6189 1992-02-10 1971-02-19 Mortimer Peter M. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6190 1992-02-10 1977-03-01 Siphron Joseph R. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6191 1992-02-10 1977-03-01 Wight Richard J. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6192 1992-02-10 1978-03-01 Brach Richard S. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6193 1992-02-10 1978-03-01 Gerstell Glenn S. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6194 1992-02-10 1978-03-01 Gewirtz Elliot 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6195 1992-02-10 1978-03-01 Tufaro Richard C. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6196 1992-02-10 1985-03-01 Persinger Joseph M. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6197 1992-02-10 1978-03-06 Dean John W. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6198 1992-02-10 1991-03-27 Bajak Curtis W. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6199 1992-02-10 1991-04-09 von Mehren Philip T. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6200 1992-02-10 1974-04-17 White Harry E. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6201 1992-02-10 1965-06-22 Brewster Walter Rice 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6203 1992-02-10 1987-07-02 Harris David J. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6204 1992-02-10 1987-07-02 Tuttle Baldwin B. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6205 1992-02-10 1990-07-11 Dammers Clifford R. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6206 1992-02-10 1966-08-09 Williams Thomas Allison 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6207 1992-02-10 1971-08-13 Hardin Adlai S. , Jr. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6208 1992-02-10 1974-08-13 Cooke Warren F. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6209 1992-02-10 1974-08-13 Radick Barry G. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6210 1992-02-10 1979-08-15 Immergut Mel M. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6211 1992-02-10 1975-08-20 Farabaugh Eugene F. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6212 1992-02-10 1975-08-21 Brooks Russell E. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6213 1992-02-10 1977-08-23 Forsyth George J. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6214 1992-02-10 1977-08-23 Kneip Frederick C. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6215 1992-02-10 1977-08-23 Siegfried David C. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6216 1992-02-10 1975-09-02 Holderness G. Malcolm 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6217 1992-02-10 1967-10-10 Logan Francis D. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
6218 1992-02-10 1967-10-10 Peet Charles D. , Jr. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
9044 1979-03-09 1977-03-01 Shields Day R. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
9045 1979-03-09 1978-03-01 White Scott Bennett 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
9357 1989-03-14 1965-01-11 McCloy John J. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005
14710 1981-05-01 1978-03-06 Simmons Harry L. 1839 1839 1965-01-11 Milbank, Tweed, Hadley & McCloy 1 Chase Manhattan Plaza   New York NY 10005

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