home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

42,460 rows

✖

✎ View and edit SQL

This data as json, CSV (advanced)

State >30

  • NY 5,257
  • DC 5,013
  • CA 673
  • IL 437
  • VA 283
  • - 276
  • FL 220
  • MA 199
  • TX 162
  • MD 127
  • PA 113
  • MO 111
  • NJ 86
  • MI 85
  • WA 85
  • GA 52
  • KS 47
  • CT 32
  • CO 28
  • MN 26
  • SC 22
  • ME 21
  • IN 18
  • RI 18
  • NV 12
  • LA 11
  • OH 9
  • AZ 8
  • IA 8
  • ID 7
  • …

Registration_Number >30

  • Hill and Knowlton Strategies, LLC 371
  • Daniel J. Edelman, Inc. 198
  • White & Case, LLP 166
  • Burson-Marsteller 157
  • American Section of the Jewish Agency for Israel 131
  • Amtorg Trading Corporation 130
  • Daniel J. Edelman, Inc. 117
  • JETRO, New York 103
  • Arnold & Porter Kaye Scholer LLP 99
  • Ruder Finn, Inc. 94
  • DLA Piper US LLP 88
  • Bahamas Tourist Office 85
  • Squire, Sanders & Dempsey, L.L.P. 84
  • Akin, Gump, Strauss, Hauer & Feld, LLP 84
  • Young & Rubicam, L.P. 81
  • Squire Patton Boggs, LLP 79
  • Agence France-Presse (France-Presse News Agency) 77
  • Netherlands Chamber of Commerce in the U.S., Inc. 77
  • Cassidy & Associates, Inc. 74
  • Quebec Government Office 72
  • Jamaica Progressive League, Inc. 70
  • IPG DXTRA, Inc 70
  • QORVIS LLC 68
  • Mercury Public Affairs, LLC 63
  • Singapore Economic Development Board 59
  • New York Bureau of the Telegraph Agency of Russia (TASS) 58
  • British Information Services 58
  • Ketchum Inc. NY 58
  • BCW LLC 56
  • Modern Education Services, Inc. 55
  • …

Registrant_Name >30

  • Hill and Knowlton Strategies, LLC 371
  • Daniel J. Edelman, Inc. 315
  • White & Case, LLP 166
  • Burson-Marsteller 159
  • American Section of the Jewish Agency for Israel 131
  • Amtorg Trading Corporation 130
  • Ruder Finn, Inc. 126
  • JETRO, New York 103
  • Cassidy & Associates, Inc. 102
  • Arnold & Porter Kaye Scholer LLP 99
  • DLA Piper US LLP 88
  • Bahamas Tourist Office 85
  • Akin, Gump, Strauss, Hauer & Feld, LLP 84
  • Squire, Sanders & Dempsey, L.L.P. 84
  • Young & Rubicam, L.P. 81
  • Squire Patton Boggs, LLP 79
  • Doremus & Company 78
  • Agence France-Presse (France-Presse News Agency) 77
  • Netherlands Chamber of Commerce in the U.S., Inc. 77
  • APCO Worldwide, Inc. 72
  • Quebec Government Office 72
  • Fleishman-Hillard, Inc. 70
  • IPG DXTRA, Inc 70
  • Jamaica Progressive League, Inc. 70
  • QORVIS LLC 68
  • Mercury Public Affairs, LLC 63
  • Singapore Economic Development Board 59
  • British Information Services 58
  • Ketchum Inc. NY 58
  • New York Bureau of the Telegraph Agency of Russia (TASS) 58
  • …

City >30

  • New York 5,054
  • Washington 4,997
  • Chicago 382
  • Los Angeles 337
  • San Francisco 164
  • Miami 159
  • Houston 105
  • Boston 100
  • St. Louis 94
  • Arlington 93
  • Alexandria 88
  • Nassau 85
  • Seattle 77
  • Jamaica 71
  • Philadelphia 64
  • Bethesda 50
  • Atlanta 48
  • Overland Park 46
  • Centerline 43
  • San Juan 43
  • London 42
  • Fairhaven 37
  • Cambridge 35
  • New York 34
  • Denver 28
  • Austin 25
  • Dallas 25
  • Silver Spring 25
  • Bannockburn 23
  • Pittsburgh 22
  • …
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
28970 28970 2011-09-01 2010-12-20 Tjaden Elizabeth Ogilvy Public Relations Worldwide 5807 2007-05-07 Ogilvy Public Relations Worldwide 1111 19th Street, NW 3rd Floor Washington DC 20036
28971 28971 2012-09-01 2008-03-03 Leiter Tara L. Blank Rome, LLP 4929 1994-07-22 Blank Rome, LLP 600 New Hampshire Avenue, N.W. Watergate Washington DC 20037
28972 28972 2012-09-01 2010-11-09 Sng Joanna XiuTing Singapore Economic Development Board 2003 1967-02-02 Singapore Economic Development Board 55 East 59th Street Suite 21 B, 21st Floor New York NY 10022
28973 28973 2012-09-01 2009-11-30 Shin Seung Hoon KOTRA 1619 1963-04-17 KOTRA 460 Park Avenue 14th Floor New York NY 10022
28974 28974 2013-09-01 2012-07-30 Parker Jessica IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022
28975 28975 2014-09-01 2014-02-06 Meissner Mark Holland & Knight 3718 1985-08-07 Holland & Knight 800 17th Street, N.W. Suite 1100 Washington DC 20006
28976 28976 2015-09-01 2014-05-16 Pagan Khalid Rasky Baerlein Strategic Communications, Inc. 6222 2014-05-16 Rasky Baerlein Strategic Communications, Inc. 70 Franklin Street 3rd Floor Boston MA 02110
28977 28977 2015-09-01 1987-05-28 Cooper Doral S. Crowell & Moring International, LLC 3988 1987-05-28 Crowell & Moring International, LLC 1001 Pennsylvania Avenue, N.W. Suite 1275 Washington DC 20004-2595
28978 28978 2015-09-01 2015-07-02 Yonkman David Greenberg Traurig, LLP 5712 2005-10-03 Greenberg Traurig, LLP 2101 L Street, NW Suite 1000 Washington DC 20037
28979 28979 2016-09-01 2010-03-08 Tompkins, Jr. Joseph B. Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 1501 K Street, N.W. 8th Floor Washington DC 20005
28980 28980 2016-09-01 2010-03-08 Yancey Thomas H. Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 1501 K Street, N.W. 8th Floor Washington DC 20005
28981 28981 2016-09-01 2015-09-03 Forgie Anna DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
28982 28982 2016-09-01 2013-10-23 Low Siong Hui Lawrence Singapore Economic Development Board 2003 1967-02-02 Singapore Economic Development Board 55 East 59th Street Suite 21 B, 21st Floor New York NY 10022
28983 28983 2017-09-01 2003-02-04 Bloch Sam World Zionist Organization - American Section, Inc. 2278 1971-09-21 World Zionist Organization - American Section, Inc. 633 Third Avenue 21st Floor New York NY 10017
28984 28984 2017-09-01 2016-09-22 Klenet Scott Prime Strategies, LLC 6378 2016-09-22 Prime Strategies, LLC 1440 G Street, NW 8th Floor Washington DC 20005
28985 28985 2017-09-01 2016-09-22 Sharon Adam Prime Strategies, LLC 6378 2016-09-22 Prime Strategies, LLC 1440 G Street, NW 8th Floor Washington DC 20005
28986 28986 2017-09-01 2016-11-04 Simmons Joseph DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
28987 28987 2017-09-01 2013-12-31 Cartwright Angelika P. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
28988 28988 2019-09-01 2017-02-28 Vajdich Daniel BGR Government Affairs, LLC 5430 2001-05-10 BGR Government Affairs, LLC 601 Thirteenth Street, NW Eleventh Floor South Washington DC 20005
28989 28989 2019-09-01 2012-11-07 Garcia Melanie DLA Piper US LLP 3712 1985-08-05 DLA Piper US LLP 500 8th Street, NW   Washington DC 20004
28990 28990 2020-09-01 2015-06-18 Boucher Rick Sidley Austin LLP 3731 1985-09-13 Sidley Austin LLP 1501 K Street, N.W. 8th Floor Washington DC 20005
28991 28991 2020-09-01 2020-08-07 Bonjean Ron Rokk Solutions LLC 6849 2020-08-07 Rokk Solutions LLC 2020 K Street, NW Suite 510 Washington DC 20006
28992 28992 2020-09-01 2020-08-07 Mollineau Rodell Rokk Solutions LLC 6849 2020-08-07 Rokk Solutions LLC 2020 K Street, NW Suite 510 Washington DC 20006
28993 28993 2021-09-01 2020-02-10 Rhee Soo Mi Arnold & Porter Kaye Scholer LLP 1750 1964-06-04 Arnold & Porter Kaye Scholer LLP 601 Massachusetts Avenue, NW   Washington DC 20001-3743
28994 28994 2021-09-01 2018-08-30 Mitchell Emma IDA Ireland 1770 1964-07-10 IDA Ireland 345 Park Avenue 17th Floor New York NY 10154
28995 28995 2021-09-01 2014-09-30 Friedl Michael Austrian Trade Commission in the U.S., Southern Region 5041 1995-08-17 Austrian Trade Commission in the U.S., Southern Region 3333 Riverwood Parkway, S.E. Suite 200 Atlanta GA 30339
28996 28996 2022-09-01 2022-03-29 Tennant Brandi Broydrick and Associates, Inc. 6796 2020-02-26 Broydrick and Associates, Inc. 101 Constitution Avenue, NW Suite 825 East Washington DC 20001
28997 28997 1951-09-02 1951-05-29 Quinones Fernando Antonio Partido Revolucionario Dominicano, New York 674 1951-05-29 Partido Revolucionario Dominicano, New York 229 West 97th Street Apartment 3C New York NY  
28998 28998 1955-09-02 1955-03-02 Olkhine Eugenie Litoshko, Evgeni Vladimirovich 875 1955-03-02 Litoshko, Evgeni Vladimirovich 316 West 79th Street   New York NY  
28999 28999 1957-09-02 1955-10-10 Matijasavic Scepan Yugoslav National Tourist Office 915 1955-10-10 Yugoslav National Tourist Office 630 Fifth Avenue Suite 280 New York NY 10111
29000 29000 1965-09-02 1965-03-18 Pare M. Louis Quebec Government Office 1787 1964-09-02 Quebec Government Office One Rockefeller Plaza Suite 2600 New York NY 10020-2102
29001 29001 1969-09-02 1969-05-15 Fair Gordon M. , Jr. Checchi & Company 1713 1964-04-14 Checchi & Company 815 Connecticut Avenue, N.W.   Washington DC 20006
29002 29002 1969-09-02 1950-08-22 Gomperts Jack Netherlands Chamber of Commerce in the U.S. 639 1950-08-22 Netherlands Chamber of Commerce in the U.S. 350 South Figueroa Street Suite 901 Los Angeles CA 90017
29003 29003 1970-09-02 1961-03-28 Koehl Albert E. Wolf Shevack, Inc. 1436 1961-03-28 Wolf Shevack, Inc. 111 West 40th Street 18th Floor New York NY 10018
29004 29004 1970-09-02 1965-03-31 Crudgington James W. Downs & Roosevelt, Inc. 1726 1964-05-11 Downs & Roosevelt, Inc. 1629 K Street, N.W.   Washington DC 20006
29005 29005 1970-09-02 1965-12-14 MacGregor George Downs & Roosevelt, Inc. 1726 1964-05-11 Downs & Roosevelt, Inc. 1629 K Street, N.W.   Washington DC 20006
29006 29006 1976-09-02 1975-08-25 Nikolski Mikhail V. Intourist U.S.A., Inc. 1240 1959-06-23 Intourist U.S.A., Inc. 610 Fifth Avenue Suite 603 New York NY 10020
29007 29007 1977-09-02 1972-09-12 Rivera Elliot Mike Segarra, Inc. 2377 1972-09-12 Mike Segarra, Inc. Hotel Helio Isla Avenida Ashford 999 Condado    
29008 29008 1980-09-02 1979-08-02 Gallard Alejandro J. Gallard, Alejando J. 3044 1979-08-02 Gallard, Alejando J. 1819 H Street, N.W. Suite 440 Washington DC 20006
29009 29009 1980-09-02 1978-11-08 Brown Evon Peter Martin Associates, Inc. 2846 1977-11-15 Peter Martin Associates, Inc. 770 Lexington Avenue   New York NY 10021
29010 29010 1981-09-02 1979-06-04 Clarkson Federico F. Colombian Government Trade Bureau 2121 1969-01-30 Colombian Government Trade Bureau 140 East 57th Street   New York NY 10022
29011 29011 1981-09-02 1976-12-14 Gutierrez Alvaro Colombian Government Trade Bureau 2121 1969-01-30 Colombian Government Trade Bureau 140 East 57th Street   New York NY 10022
29012 29012 1982-09-02 1982-02-24 Cauman Richard Ernest Wittenberg Associates, Inc. 2936 1978-07-28 Ernest Wittenberg Associates, Inc. 1616 H Street, N.W.   Washington DC 20006
29013 29013 1982-09-02 1978-07-28 Wittenberg Ernest Ernest Wittenberg Associates, Inc. 2936 1978-07-28 Ernest Wittenberg Associates, Inc. 1616 H Street, N.W.   Washington DC 20006
29014 29014 1982-09-02 1978-11-03 Friedenberg Shirlee J. Ernest Wittenberg Associates, Inc. 2936 1978-07-28 Ernest Wittenberg Associates, Inc. 1616 H Street, N.W.   Washington DC 20006
29015 29015 1982-09-02 1978-11-27 Kraich F. Norbert , Jr. Ernest Wittenberg Associates, Inc. 2936 1978-07-28 Ernest Wittenberg Associates, Inc. 1616 H Street, N.W.   Washington DC 20006
29016 29016 1983-09-02 1981-11-19 Bray Peter Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
29017 29017 1987-09-02 1983-10-28 Langager Rebecca S. McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery 1850 K Street, N.W. Suite 500 Washington DC 20006
29018 29018 1987-09-02 1983-10-28 Weeder Carolyn K. McDermott, Will & Emery 3533 1983-10-28 McDermott, Will & Emery 1850 K Street, N.W. Suite 500 Washington DC 20006
29019 29019 1988-09-02 1975-02-21 Chiu Robin Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29020 29020 1988-09-02 1975-02-21 Tai Matthew Cheong Sin Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29021 29021 1988-09-02 1973-02-22 Beck Bryna Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29022 29022 1988-09-02 1977-02-22 Phay Alexander Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29023 29023 1988-09-02 1989-02-22 Whitfield Linda Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
29024 29024 1988-09-02 1988-05-11 Volkonsky Oleg V. Council of Khalistan 4137 1988-05-11 Council of Khalistan 1901 Pennsylvania Avenue, N.W. Suite 802 Washington DC 20006
29025 29025 1988-09-02 1978-06-19 Ng Wing Boo Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29026 29026 1988-09-02 1972-07-26 Ma Michael Hong Kong Trade Development Council, Inc. 2181 1970-01-19 Hong Kong Trade Development Council, Inc. 219 East 46th Street   New York NY 10017
29027 29027 1992-09-02 1989-01-17 III Lonnie I. Calhoun Allpoints International, Ltd. 4157 1988-07-07 Allpoints International, Ltd. 1250 Connecticut Avenue, N.W. Suite 319 Washington DC 20036
29028 29028 1992-09-02 1989-03-10 Thibodeaux Dolores C. Allpoints International, Ltd. 4157 1988-07-07 Allpoints International, Ltd. 1250 Connecticut Avenue, N.W. Suite 319 Washington DC 20036
29029 29029 1992-09-02 1991-03-14 Herson Karen B. Allpoints International, Ltd. 4157 1988-07-07 Allpoints International, Ltd. 1250 Connecticut Avenue, N.W. Suite 319 Washington DC 20036
29030 29030 1992-09-02 1988-07-07 Denson James L. Allpoints International, Ltd. 4157 1988-07-07 Allpoints International, Ltd. 1250 Connecticut Avenue, N.W. Suite 319 Washington DC 20036
29031 29031 1992-09-02 1988-08-18 Karalekas S. Steven Allpoints International, Ltd. 4157 1988-07-07 Allpoints International, Ltd. 1250 Connecticut Avenue, N.W. Suite 319 Washington DC 20036
29032 29032 1992-09-02 1988-08-18 Noone James A. Allpoints International, Ltd. 4157 1988-07-07 Allpoints International, Ltd. 1250 Connecticut Avenue, N.W. Suite 319 Washington DC 20036
29033 29033 1993-09-02 1993-01-04 Clark James F. Robertson, Monagle & Eastaugh 4749 1993-01-04 Robertson, Monagle & Eastaugh 2300 Clarendon Boulevard Suite 1010 Arlington VA 22201
29034 29034 1993-09-02 1993-01-04 Silver Steven W. Robertson, Monagle & Eastaugh 4749 1993-01-04 Robertson, Monagle & Eastaugh 2300 Clarendon Boulevard Suite 1010 Arlington VA 22201
29035 29035 1993-09-02 1991-02-28 Mueller Gregory R. Creative Response Concepts 4477 1991-02-28 Creative Response Concepts 1150 South Washington Street Suite 230 Alexandria VA 22314-2824
29036 29036 1993-09-02 1991-02-28 Olson Lisa Creative Response Concepts 4477 1991-02-28 Creative Response Concepts 1150 South Washington Street Suite 230 Alexandria VA 22314-2824
29037 29037 1994-09-02 1992-05-18 Doner Lynne Porter/Novelli 4671 1992-05-18 Porter/Novelli 1909 K Street Suite 400 Washington DC 20006
29038 29038 1997-09-02 1994-08-19 Kanemaki Tomonori JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
29039 29039 2002-09-02 1997-01-28 Crescione Denise B. Office of the Deputy Commissioner of Maritime Affairs 4860 1993-10-12 Office of the Deputy Commissioner of Maritime Affairs 39 Broadway Suite 2020 New York NY 10006
29040 29040 2005-09-02 1980-01-21 Dreizen Alison M. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29041 29041 2005-09-02 1977-03-09 Wall Duane D. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29042 29042 2005-09-02 1980-03-28 Blakemore John Haywood , IV White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29043 29043 2005-09-02 1980-03-28 Chin Sylvia Fung White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29044 29044 2005-09-02 1980-03-28 MacNaughton Donald T. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29045 29045 2005-09-02 1980-03-28 McGanney Thomas White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29046 29046 2005-09-02 1980-03-28 Wynne William F. , Jr. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29047 29047 2005-09-02 1981-04-09 Finlay Peter D. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29048 29048 2005-09-02 1985-04-09 Koschik David N. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29049 29049 2005-09-02 1985-04-09 Scavone Arthur A. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29050 29050 2005-09-02 1986-04-09 Bender David White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29051 29051 2005-09-02 1986-04-09 Hartline Sharon E. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29052 29052 2005-09-02 1990-04-09 Dang Khai-Minh White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29053 29053 2005-09-02 1991-04-09 Gannon Lawrence J. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29054 29054 2005-09-02 1992-04-09 Warren Sandra J. (Schecter) White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29055 29055 2005-09-02 2005-04-14 Byrne Lawrence White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29056 29056 2005-09-02 2004-04-16 Miller Amanda Johnson White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29057 29057 2005-09-02 1978-05-02 Riggs John H. , Jr. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29058 29058 2005-09-02 2003-06-03 Smith Michael White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29059 29059 2005-09-02 2003-06-03 Teck Lim Sin White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29060 29060 2005-09-02 1992-06-17 Takayama Ichizo White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29061 29061 2005-09-02 1982-10-01 Kelly Robert M. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29062 29062 2005-09-02 1983-10-07 Joyce David E. White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29063 29063 2005-09-02 1991-10-09 Brundage Maureen A. (Smyth) White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29064 29064 2005-09-02 2003-12-02 Nyatanyi Gilbert White & Case, LLP 2759 1977-03-09 White & Case, LLP 1155 Avenue of the Americas   New York NY 10036-2787
29065 29065 2008-09-02 2003-05-06 Glassco Timothy A. Squire Patton Boggs, LLP 2165 1969-10-09 Squire Patton Boggs, LLP 2550 M Street, NW   Washington DC 20037-1350
29066 29066 2008-09-02 2008-08-28 Pozner Jennifer Ketchum Inc. NY 5758 2006-05-09 Ketchum Inc. NY 1285 Avenue of the Americas   New York NY 10019
29067 29067 2011-09-02 2009-01-05 Colella Shane QORVIS LLC 5483 2002-03-06 QORVIS LLC 1201 Connecticut Avenue, NW Suite 1000 Washington DC 20036
29068 29068 2013-09-02 2010-09-29 Mizutani Koichi JETRO, New York 1643 1963-06-25 JETRO, New York 565 Fifth Avenue 4th Floor New York NY 10017
29069 29069 2014-09-02 2014-04-25 Fox William Cloakroom Advisors, LLC 6218 2014-04-25 Cloakroom Advisors, LLC 100 M Street, SE 5th Floor 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])
);
Powered by Datasette · Queries took 2607.709ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows