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

View and edit SQL

Suggested facets: Short_Form_Termination_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     Bing Jonathan Lloyd 5712 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, N.W. Suite 1000 Washington DC 20037
2     Disler Mark 6112 6112 2012-07-02 Prime Policy Group 1110 Vermont Avenue, NW Suite 1000 Washington DC 20005
3     Hekmat Farid 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
4     Huneault Philippe 1787 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
5     Krasnitski Sergei 6762 6762 2019-12-03 ITBC LLC 1829 Reisterstown Road Suite 350 Pikesville MD 21208
6     Lamm Carolyn Beth 55 55 1943-03-01 Switzerland Tourism 608 Fifth Avenue   New York NY 10020-2303
7     Lamsam Larada Songkanda 6568 6568 2018-07-05 Luque PLLC 25 Broadway 9th Floor New York NY 10004
8     McHugh John 5970 5970 2010-01-07 Hedges Strategies 5909 32nd Street, NW   Washington DC 20015
9     Pagliery Patricia 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
10     Painter Sally 6587 6587 2018-09-06 Blue Star Strategies, LLC 888 17th Street, NW Suite 800 Washington DC 20006
11     Peckinpaugh Tim 6331 6331 2015-12-18 K&L Gates, LLP 210 Sixth Avenue   Pittsburgh PA 15222
12     Raffaelli John D. 5653 5653 2004-10-26 Mohamed, Koshin A. 1215 Central Avenue South Suite 215 Kent WA 98032-7437
13     Rozsa Gabor J 6112 6112 2012-07-02 Prime Policy Group 1110 Vermont Avenue, NW Suite 1000 Washington DC 20005
14     Weprin Mark 5712 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, N.W. Suite 1000 Washington DC 20037
15     Wyruchowski Dawn 2438 2438 1973-07-02 Kobe Trade Information Office 1001 Fourth Avenue Suite 4310 Seattle WA 98154
16   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
17   2018-01-01 Cruz Monica 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
18   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
19   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
20   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
21   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
22   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
23   2018-01-01 Llanos Idalma 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
24   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
25   2018-01-01 Ruiz Maria 6621 6621 2018-12-21 Media Planning International Corporation c/o Havas Creative Group 200 Hudson Street New York NY 10013
26   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
27   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
28   2017-01-02 Barbour Haley 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
29   2017-01-02 Munson Lester 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
30   2017-01-02 Seiden Maya 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
31   2019-01-02 Pereira Roman Francis 2329 2329 1972-04-05 India Tourism, New York 1270 Avenue of the Americas Suite 303 New York NY 10020-1700
32   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
33   2011-01-03 Aminian Shiva 3492 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2001 K Street, NW   Washington DC 20006
34   2019-01-03 Tayla Suheyla 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
35   2020-01-03 Ellis Alex 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
36   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
37   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
38   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
39   2009-01-05 Georgala Lena 5334 5334 1999-10-12 Commonwealth of Dominica Maritime Registry, Inc. 32 Washington Street   Fairhaven MA 02719
40   2009-01-05 Shupp Michael A. 5401 5401 2000-12-14 Van Scoyoc Associates, Inc. 800 Maine Avenue, SW Suite 800 Washington DC 20024
41   2017-01-05 Gonda Tadashi 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
42   2018-01-05 Carter Sullivan Juliane 6396 6396 2016-11-30 CGCN Group 1101 K Street, NW Suite 650 Washington DC 20005
43   2018-01-05 Prakongpan Montira 1897 1897 1965-06-01 Tourism Authority of Thailand, New York 61 Broadway Suite 2810 New York NY 10006
44   2020-01-06 Blake Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
45   2020-01-06 Carpenter Brendan 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
46   2020-01-06 Coster John 6698 6698 2019-07-08 Teneo Strategy LLC 280 Park Avenue 4th Floor New York NY 10017
47   2020-01-06 Gungor Leyla S. 2244 2244 1971-02-18 Hogan Lovells US LLP 555 - 13th Street, N.W. Columbia Square Washington DC 20004-1109
48   2020-01-06 McCaleb Ian 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
49   2020-01-06 Ostrove Amanda 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
50   2020-01-06 Riley David 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
51   2020-01-06 Stine Danielle 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
52   2020-01-06 Wahrman Alyssa 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
53   2020-01-06 Worley Allison 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
54   2016-01-07 Kim Junil 3327 3327 1982-02-01 Korea Economic Institute 1800 K Street, NW Suite 1010 Washington DC 20006
55   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
56   2019-01-07 Petrone Brent James 6170 6170 2013-05-14 Mercury Public Affairs, LLC 300 Tingey Street Suite 202 Washington DC 20003
57   2020-01-07 Stenseth Joel Tyler 6749 6749 2019-11-12 Larson Shannahan Slifka Group, LLC 510 E. Locust Street Suite 200 Des Moines IA 50309
58   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
59   2019-01-09 Hulsey G. Scott 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
60   2019-01-09 Kolton Chad 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
61   2019-01-09 Morrell James C. 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
62   2019-01-09 Petrovic Vladimir 6627 6627 2019-01-09 PAVEA, LLC 1015 15th Street, NW #600 Washington DC 20005
63   2019-01-09 Stavinsky Meital 3718 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
64   2019-01-09 Weems L. Wade 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
65   2019-01-09 West Hartley 6604 6604 2018-10-31 Kobre & Kim LLP 800 Third Avenue   New York NY 10022
66   2020-01-09 Furujo Tatsuya 1643 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
67   2020-01-09 Renezeder Fiona 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
68   2013-01-10 Kent Jr Donald H. 6089 6089 2012-02-15 Nickles Group, LLC 601 13th Street, NW Suite 250N Washington DC 20005
69   2019-01-10 Norton Travis 5870 5870 2008-06-16 Brownstein Hyatt Farber Schreck, LLP 410 Seventeenth Street Suite 2200 Denver CO 80202-4432
70   2019-01-10 Reeder Emily 1750 1750 1964-06-04 Arnold & Porter Kaye Scholer, LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
71   2019-01-10 Shin Woojin 5928 5928 2009-04-10 Nelson Mullins Riley & Scarborough, LLP 1320 Main Street 17th Floor Columbia SC 29201
72   2020-01-10 Porer Hugh Marc 6615 6615 2019-01-13 STRATCOMMS, LLC 3993 Howard Hughes Parkway Suite 780 Las Vegas NV 89169
73   2010-01-11 O'Brien David 5971 5971 2010-01-11 O'Brien Gentry & Scott, LLC 201 C Street, SE   Washington DC 20003
74   2010-01-11 Gentry James 5971 5971 2010-01-11 O'Brien Gentry & Scott, LLC 201 C Street, SE   Washington DC 20003
75   2018-01-11 Christoferson James P. 6505 6505 2018-01-11 JPC Strategies, LLC 812 K Street, NE   Washington DC 20002
76   2018-01-11 King Andrew 5666 5666 2005-01-31 Glover Park Group, LLC 1025 F Street, NW 9th Floor Washington DC 20004
77   2019-01-11 Meyers Hannah 6571 6571 2018-07-13 Guidepost Solutions LLC 415 Madison Avenue 11th Floor New York NY 10017
78   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
79   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
80   2018-01-12 Gadio Kalidou 6506 6506 2018-01-12 Manatt, Phelps & Phillips LLP 1050 Connecticut Avenue, NW Suite 600 Washington DC 20036
81   2018-01-12 Quinn John M. 6506 6506 2018-01-12 Manatt, Phelps & Phillips LLP 1050 Connecticut Avenue, NW Suite 600 Washington DC 20036
82   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
83   2014-01-13 Ahrens Frank 5430 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
84   2019-01-13 Porter H. Marc 6615 6615 2019-01-13 STRATCOMMS, LLC 3993 Howard Hughes Parkway Suite 780 Las Vegas NV 89169
85   2019-01-14 Cano Ines 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
86   2019-01-14 Footlik Jay 6540 6540 2018-04-13 ThirdCircle, Inc. 1111 Penhurst Lane   Penn Valley PA 19702
87   2019-01-14 Gaggioni Andrea 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
88   2019-01-14 Guest Thalia 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
89   2019-01-14 Konczal Blair 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
90   2019-01-14 Layland Brandon 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
91   2019-01-14 Leon Christopher 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
92   2019-01-14 Lewin Joshua 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
93   2019-01-14 Lopina Brian 6616 6616 2019-01-14 Lungren Lopina LLC 3305 Bywater Ct.   Oak Hill VA 20171
94   2019-01-14 Luckey Chris 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
95   2019-01-14 Lungren Dan 6616 6616 2019-01-14 Lungren Lopina LLC 3305 Bywater Ct.   Oak Hill VA 20171
96   2019-01-14 Martinez Natalia Perez 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
97   2019-01-14 McAtee Brett 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
98   2019-01-14 Monter Ashley 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
99   2019-01-14 Van Patten Amy 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112
100   2019-01-14 Whitley Alexis 6492 6492 2017-11-27 MMGY Global, LLC 4601 Madison Avenue   Kansas City MO 64112

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