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 Short_Form_Date

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
1     Antognelli Guy 2327 2327 1972-03-21 Monaco Government Tourist Office 565 Fifth Avenue 23rd Floor New York NY 10017
2     Beckles Alexander J 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
3     Beckles Alexander J 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
4     Bleckles Alexander J 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
5     Chantharangkun Natthinee 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
6     Ciabatti Michael J 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
7     Corner Gwendolyn Marie Abigail 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
8     Dehqan Ferdous 6817 6817 2020-04-16 Afghanistan-U.S. Democratic Peace and Prosperity Council, Inc. 3436 23rd Street, SE   Washington DC 20002
9     Dillman Jess 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
10     Dillman Jesse 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
11     Hang Tang Chung 2003 2003 1967-02-02 Singapore Economic Development Board 55 East 59th Street Suite 21 B, 21st Floor New York NY 10022
12     Hefflinger Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
13     Jang Choong Sik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14     Kamaras Jacob 6789 6789 2020-01-31 Stellar Jay Communications 8453 Cliffridge Avenue   La Jolla CA 92037
15     Kim Chulmin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
16     Lee Seok Hwan 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
17     Lee Yungsun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
18     Loyd Abigail 6837 6837 2020-06-16 Xenophon Strategies, Inc. 1120 G Street, NW Suite 450 Washington DC 20005
19     Mulcahy Sarah 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
20     Murtha Chelsea 5839 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
21     Oceguera Fernanda Melgoza 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
22     Phipps Ashley 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
23     Powers Shelby Lynn 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
24     Raffaelli John D. 5653 5653 2004-10-26 Mohamed, Koshin A. 1215 Central Avenue South Suite 215 Kent WA 98032-7437
25     Reiss Kokja Alexander 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
26     Ryou Sungwon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
27     Schmidt Michael T 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
28     Seo Jiwon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
29     Shulklapper Max 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
30     Sincere Richard E 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
31     Sincere Richard E 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
32     Sincere Richard E 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
33     Sincere Richard E 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
34     Sincere Richard E 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
35     Smith William Francis 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
36     Sorini Ronald 5839 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
37     Szlavik Joseph 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
38     Szlavik Joseph 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
39     Szlavik Joseph 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
40     Szlavik Joseph 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
41     Szlavik Joseph 6305 6305 2015-07-20 Scribe Strategies & Advisors, Inc. 1050 Connecticut Avenue, NW Suite 500 Washington DC 20036
42     Velitchkov Angel 6707 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
43     Whitley Alexis 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
44     Whiton Christian 6865 6865 2020-09-03 DC International Advisory, LLC 354 W Sunnyside Road Suite A Idaho Falls ID 83402
45     Wu Yi-Rou 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
46     Wylie Sheelagh 579 579 1949-07-07 VisitBritain 885 Second Avenue 28th Floor New York NY 10017
47     Youngtae Kim 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
48     Zemp Claudio 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
3223 2015-01-09   Foley Joe 6239 6239 2014-08-05 Foley Federal & International Affairs P.O. Box 61303   Potomac MD 20859
9071 2014-03-09   Echeverri Olga Lucia Lopez 5676 5676 2005-03-23 Mira Movimiento Politico Inc. 1440 Coral Ridge Drive #102 Coral Springs FL 33071
12915 2015-04-15   Duncan III James Robert 6221 6221 2014-05-15 Cadwalader, Wickersham & Taft, LLP 200 Liberty Street   New York NY 10281
12916 2015-04-15   Gerver Keith 6221 6221 2014-05-15 Cadwalader, Wickersham & Taft, LLP 200 Liberty Street   New York NY 10281
17422 2016-05-31   Telson Natalie 5807 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
25069 2015-08-06   Brown Paul 6263 6263 2014-11-14 Prime Policy Group 1110 Vermont Avenue, NW Suite 1000 Washington DC 20005
25070 2015-08-06   Cosar Yagmur 6263 6263 2014-11-14 Prime Policy Group 1110 Vermont Avenue, NW Suite 1000 Washington DC 20005
25071 2015-08-06   Posner Ralph 6263 6263 2014-11-14 Prime Policy Group 1110 Vermont Avenue, NW Suite 1000 Washington DC 20005
25072 2015-08-06   Taylor Owen 6263 6263 2014-11-14 Prime Policy Group 1110 Vermont Avenue, NW Suite 1000 Washington DC 20005
32812 2012-10-30   Johnson Lester 6135 6135 2012-10-09 Washington Avenue International LLC 1701 Pennsylvania Avenue, NW Suite 300 Washington DC 20006
40260 2011-12-31   Williams Salvatore A. 6012 6012 2010-12-23 Salvatore Services, LLC 1641 Fifth Avenue   Pittsburgh PA 15219
40536 2016-12-31   Hawkins Carly 6361 6361 2016-06-17 Information Management Services, Inc. 1201 16th Street, NW Suite 414 Washington DC 20036
24012 2003-07-31 1900-01-07 Lonie David M. 5352 5352 2000-01-07 Livingston-Solomon Group, L.L.C. 499 South Capitol Street, S.W. Suite 600 Washington DC 20003
5405 1984-02-01 1937-01-01 de Pombo Augusto 1285 1285 1959-10-12 Colombian Government Tourist Office 140 East 57th Street   New York NY 10022
5838 2002-02-05 1937-01-01 Monegro Oscar 1687 1687 1964-02-05 Partido Reformista Social Cristiano 3736 10th Avenue Suite 9A New York NY 10034
7507 1982-02-28 1937-01-01 Muchimba Muuka L.M. 2293 2293 1971-12-06 Zambia National Tourist Board 800 Second Avenue Ninth Floor New York NY 10017
9743 1988-03-18 1937-01-01 Dawson John H. 1782 1782 1964-09-01 British Columbia House 100 Bush Street Suite 400 San Francisco CA 94104
13314 1988-04-22 1937-01-01 Riordan John H. 2275 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
18742 1990-06-15 1937-01-01 Fankell Michael 3506 3506 1983-08-10 Alsace Development International, Inc. Chateau Kiener - 24 rue de Verdum   68000 Colmar    
19784 1949-06-30 1937-01-01 Stubbs Caro R. 447 447 1947-03-14 Netherlands Information Service, New York 711 Third Avenue   New York NY 10017
20233 1988-06-30 1937-01-01 III Edgar F. Heiskell 2275 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
24520 1988-08-01 1937-01-01 Zaprianov Z. 2148 2148 1969-07-18 Bulgarian Tourist Office 161 East 86th Street   New York NY 10028
33024 1991-10-31 1937-01-01 Chapman David R. 2307 2307 1972-01-17 New Zealand Government Tourist Office 10960 Wilshire Boulevard Suite 1530 Los Angeles CA 90024
35251 1977-11-30 1937-01-01 Prag Per 68 68 1942-07-27 Swedish Tourist Office 655 Third Avenue 18th Floor New York NY 10017
37626 1988-12-25 1937-01-01 Essa Aniis A. 3640 3640 1985-01-18 Somaliland Republic Office P.O. Box 90917   Washington DC 20090
37627 1988-12-25 1937-01-01 Hussein Ahmed M. 3640 3640 1985-01-18 Somaliland Republic Office P.O. Box 90917   Washington DC 20090
37880 1983-12-30 1937-01-01 Sand Levar 526 526 1948-05-13 Innovation Norway WeWork Bryant Park 54 W 40t Street New York NY 10018
37886 1985-12-30 1937-01-01 Conradi Trond 526 526 1948-05-13 Innovation Norway WeWork Bryant Park 54 W 40t Street New York NY 10018
38826 1985-12-31 1937-01-01 Mulayantanda Tasker B. 2293 2293 1971-12-06 Zambia National Tourist Board 800 Second Avenue Ninth Floor New York NY 10017
38866 1986-12-31 1937-01-01 Kabemba John T. 2293 2293 1971-12-06 Zambia National Tourist Board 800 Second Avenue Ninth Floor New York NY 10017
9394 1943-03-15 1942-01-16 Jules-Bois Henri Antoine 51 51 1942-07-16 Jules-Bois, Henri Antoine 1580 Amsterdam Avenue   New York NY  
21719 1942-07-07 1942-07-07 Lejeune Hubert 8 8 1942-07-07 French National Railroads, New York 610 Fifth Avenue   New York NY  
3107 1943-01-08 1942-07-08 Bruno Harry A. 19 19 1942-07-08 H.A. Bruno & Associates 30 Rockefeller Plaza   New York NY  
3108 1943-01-08 1942-07-08 Gudgeon Russell D. 19 19 1942-07-08 H.A. Bruno & Associates 30 Rockefeller Plaza   New York NY  
31186 1946-10-08 1942-07-08 Alvarez Victor 16 16 1942-07-08 Garcia & Diaz 17 Battery Place   New York NY  
31187 1946-10-08 1942-07-08 Diaz Manuel 16 16 1942-07-08 Garcia & Diaz 17 Battery Place   New York NY  
31188 1946-10-08 1942-07-08 Garcia Marcelino 16 16 1942-07-08 Garcia & Diaz 17 Battery Place   New York NY  
36615 1950-12-11 1942-07-08 Harris George Ellsworth 17 17 1942-07-08 Gotham Advertising Company 2 West 46th Street   New York NY  
36616 1950-12-11 1942-07-08 Hildebrant W.G. 17 17 1942-07-08 Gotham Advertising Company 2 West 46th Street   New York NY  
36617 1950-12-11 1942-07-08 Kron Arthur Adam 17 17 1942-07-08 Gotham Advertising Company 2 West 46th Street   New York NY  
36618 1950-12-11 1942-07-08 Menkel William 17 17 1942-07-08 Gotham Advertising Company 2 West 46th Street   New York NY  
36619 1950-12-11 1942-07-08 Myers Frank C. 17 17 1942-07-08 Gotham Advertising Company 2 West 46th Street   New York NY  
36620 1950-12-11 1942-07-08 Sutphen Duncan Dunbar , Jr. 17 17 1942-07-08 Gotham Advertising Company 2 West 46th Street   New York NY  
21860 1942-07-09 1942-07-09 de Ayala Javier Gaytan 28 28 1942-07-09 Spanish Library of Information 2 East 34th Street   New York NY  
8190 1946-03-01 1942-07-27 Rousselle Pierre 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
9203 1945-03-12 1942-07-27 de Linclays Henri Morin 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
18454 1945-06-12 1942-07-27 Simon Georges C. 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
23156 1942-07-27 1942-07-27 Atkins Leslie C. 66 66 1942-07-27 Anchor Line, Ltd. 12-14 St. Vincent Place   Glasgow    
23157 1942-07-27 1942-07-27 Hanssler John A. 66 66 1942-07-27 Anchor Line, Ltd. 12-14 St. Vincent Place   Glasgow    
23158 1942-07-27 1942-07-27 Whitmore F.W. 66 66 1942-07-27 Anchor Line, Ltd. 12-14 St. Vincent Place   Glasgow    
23174 1960-07-27 1942-07-27 Borde Pierre 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  
23175 1960-07-27 1942-07-27 Castelnau Marcel 62 62 1942-07-27 Compagnie Generale Transatlantique (French Line) 17 State Street   New York NY  

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