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,635 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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 1     Antognelli Guy 2327 2327 1972-03-21 Monaco Government Tourist Office 565 Fifth Avenue 23rd Floor New York NY 10017
2 2     Chantharangkun Natthinee 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
3 3     Corner Gwendolyn Marie Abigail 6227 6227 2014-06-18 BCW LLC 1801 K Street, NW 9th Floor Washington DC 20006
4 4     Dehqan Ferdous 6817 6817 2020-04-16 Afghanistan-U.S. Democratic Peace and Prosperity Council, Inc. 3436 23rd Street, SE   Washington DC 20002
5 5     Dillman Jess 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
6 6     Dillman Jesse 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
7 7     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
8 8     Hefflinger Amanda 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
9 9     Jang Choong Sik 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
10 10     Kamaras Jacob 6789 6789 2020-01-31 Stellar Jay Communications 8453 Cliffridge Avenue   La Jolla CA 92037
11 11     Kho Dong Hyun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
12 12     Kim Chulmin 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
13 13     Lee Seok Hwan 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
14 14     Lee Yungsun 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
15 15     Loyd Abigail 6837 6837 2020-06-16 Xenophon Strategies, Inc. 1120 G Street, NW Suite 450 Washington DC 20005
16 16     Mulcahy Sarah 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
17 17     Murtha Chelsea 5839 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
18 18     Oceguera Fernanda Melgoza 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
19 19     Powers Shelby Lynn 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
20 20     Raffaelli John D. 5653 5653 2004-10-26 Mohamed, Koshin A. 1215 Central Avenue South Suite 215 Kent WA 98032-7437
21 21     Reiss Kokja Alexander 6645 6645 2019-03-13 NRW.INVEST (NORTH AMERICA) LLC 150 North Michigan Avenue Suite 2940 Chicago IL 60601
22 22     Schmidt Michael T 5801 5801 2007-04-16 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102
23 23     Seo Jiwon 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
24 24     Shulklapper Max 6379 6379 2016-09-20 S.G.R. LLC Government Relations and Lobbying 1775 I Street, NW Suite 410 Washington DC 20006
25 25     Smith William Francis 6401 6401 2017-01-20 Cornerstone Government Affairs 800 Maine Avenue, SW Floor 7 Washington DC 20024
26 26     Sorini Ronald 5839 5839 2007-11-12 Sorini, Samet & Associates, LLC 540 North Lincoln Street   Hinsdale IL 60521
27 27     Whitley Alexis 6549 6549 2018-04-30 Myriad International Marketing, LLC 4601 Madison Avenue   Kansas City MO 64112
28 28     Whiton Christian 6865 6865 2020-09-03 DC International Advisory, LLC 354 W Sunnyside Road Suite A Idaho Falls ID 83402
29 29     Wu Yi-Rou 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
30 30     Youngtae Kim 1619 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
31 31   2018-01-01 Charlier Bissacot Denise Talarico 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
32 32   2018-01-01 Cunillera Cristina 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
33 33   2018-01-01 Di Domizio Eliana 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
34 34   2018-01-01 Elias Virginia 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
35 35   2018-01-01 Ezquerra Maria Jose 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
36 36   2018-01-01 Garrido Wendolyn 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
37 37   2018-01-01 Marino Evelyn 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
38 38   2018-01-01 Soto Lorraine 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
39 39   2018-01-01 de la Torriente Diana 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
40 40   2017-01-02 Munson Lester 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
41 41   2017-01-02 Seiden Maya 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
42 42   2019-01-02 Velayutham Senthur Kumaran 2329 2329 1972-04-05 India Tourism, New York 1270 Avenue of the Americas Suite 303 New York NY 10020-1700
43 43   2021-01-02 Djordjevic Zorica Maric 6707 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
44 44   2021-01-02 Harris Marshall 6707 6707 2019-08-15 Alexandria Group International LLC 4115 S Hicks Street   Lawrenceville VA 23868
45 45   2019-01-03 Tayla Suheyla 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
46 46   2020-01-03 Ellis Alex 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
47 47   2020-01-03 Rabinowitz Matthew R. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
48 48   2021-01-03 Kuykendall Gregory John 5917 5917 2009-03-09 Kuykendall, Gregory J., PC 531 South Convent Avenue   Tucson AZ 85701
49 49   2008-01-04 Bjorkner Arthur C. 4860 4860 1993-10-12 Office of the Deputy Commissioner of Maritime Affairs 39 Broadway Suite 2020 New York NY 10006
50 50   2008-01-04 Rescigno Dorothy A. 4860 4860 1993-10-12 Office of the Deputy Commissioner of Maritime Affairs 39 Broadway Suite 2020 New York NY 10006
51 51   2021-01-04 Desiderio Denise A. 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
52 52   2009-01-05 Georgala Lena 5334 5334 1999-10-12 Commonwealth of Dominica Maritime Registry, Inc. 32 Washington Street   Fairhaven MA 02719
53 53   2018-01-05 Prakongpan Montira 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
54 54   2020-01-06 Blake Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
55 55   2020-01-06 Carpenter Brendan 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
56 56   2020-01-06 Coster John 6698 6698 2019-07-08 Teneo Strategy LLC 280 Park Avenue 4th Floor New York NY 10017
57 57   2020-01-06 McCaleb Ian 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
58 58   2020-01-06 Ostrove Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
59 59   2020-01-06 Riley David 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
60 60   2020-01-06 Stine Danielle 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
61 61   2020-01-06 Wahrman Alyssa 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
62 62   2020-01-06 Worley Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
63 63   2016-01-07 Kim Junil 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
64 64   2019-01-07 Khan Umer 6625 6625 2019-01-07 Pakistan Tehreek-E-Insaf USA, LLC 7207 Regency Square Blvd. Suite 247 Houston TX 77036
65 65   2021-01-07 Cankat Arda 6842 6842 2020-06-29 Saltzman & Evinch, PLLC 1050 K Street, NW Suite 1150 Washington DC 20001
66 66   2021-01-07 Winiarski Artur 6904 6904 2021-01-07 Gaya United Bytowska Street 15 Czarna Dabrowka Pomeranian    
67 67   2019-01-08 Bayounis Abdulrahman 6390 6390 2016-11-14 Aramco Affiliated Services Company (AASC) Two Allen Center 1200 Smith Street, 36th Floor Houston TX 77002
68 68   2020-01-08 Denselow Toby 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
69 69   2020-01-08 Tucker George 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
70 70   2021-01-08 Landgraf L. Charles 1750 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
71 71   2019-01-09 Stavinsky Meital 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
72 72   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
73 73   2020-01-09 Renezeder Fiona 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
74 74   2021-01-09 Cardenas Jose 6906 6906 2021-01-09 The Cormac Group LLC 800 Connecticut Avenue, NW Suite 300 Washington DC 20006
75 75   2021-01-09 Link James 6906 6906 2021-01-09 The Cormac Group LLC 800 Connecticut Avenue, NW Suite 300 Washington DC 20006
76 76   2021-01-09 Reich Otto 6906 6906 2021-01-09 The Cormac Group LLC 800 Connecticut Avenue, NW Suite 300 Washington DC 20006
77 77   2013-01-10 Kent Jr Donald H. 6089 6089 2012-02-15 Nickles Group, LLC 601 13th Street, NW Suite 250N Washington DC 20005
78 78   2019-01-10 Norton Travis 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
79 79   2019-01-10 Shin Woojin 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
80 80   2020-01-10 Porer Hugh Marc 6615 6615 2019-01-13 STRATCOMMS, LLC 3993 Howard Hughes Parkway Suite 780 Las Vegas NV 89169
81 81   2020-01-10 Weber John Vincent 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003
82 82   2010-01-11 O'Brien David 5971 5971 2010-01-11 O'Brien Gentry & Scott, LLC 201 C Street, SE   Washington DC 20003
83 83   2010-01-11 Gentry James 5971 5971 2010-01-11 O'Brien Gentry & Scott, LLC 201 C Street, SE   Washington DC 20003
84 84   2012-01-12 Diaz-Balart Lincoln 6086 6086 2012-01-12 Western Hemisphere Strategies, LLC 999 Ponce de Leon Blvd. Suite 520 Coral Gables FL 33134
85 85   2018-01-12 Brandwein David 2278 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
86 86   2021-01-12 Belz Anne 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
87 87   2021-01-12 Borkhoche Angela 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
88 88   2021-01-12 Campbell Katherine 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
89 89   2021-01-12 Hudak Cheryl 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
90 90   2021-01-12 Vazquez Vanessa 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
91 91   2021-01-12 Yamlikha Sana 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
92 92   2021-01-12 van der Meijden Annabel 6826 6826 2020-05-20 Brunswick Group LLC 245 Park Avenue 14th Floor New York NY 10167
93 93   1998-01-13 Ginther Jeffrey William 2500 2500 1974-03-04 Cayman Islands Department of Tourism 350 5th Avenue Suite 4620 New York NY 10118-1801
94 94   2014-01-13 Ahrens Frank 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
95 95   2019-01-13 Porter H. Marc 6615 6615 2019-01-13 STRATCOMMS, LLC 3993 Howard Hughes Parkway Suite 780 Las Vegas NV 89169
96 96   2021-01-13 Rermruk Soothawee 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
97 97   2019-01-14 Cano Ines 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
98 98   2019-01-14 Footlik Jay 6540 6540 2018-04-13 ThirdCircle, Inc. 1111 Penhurst Lane   Penn Valley PA 19702
99 99   2019-01-14 Gaggioni Andrea 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
100 100   2019-01-14 Garcia Jose Antonio 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street, SE Suite 202 Washington DC 20003

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