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

752 rows where State = ""

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

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
2 2         DEACERO S.A.P.I. de C.V. (DEACERO) 7013 2021-09-07 DEACERO S.A.P.I. de C.V. (DEACERO) Lazaro Cardenas 2333, Zona Loma Larga Oriente San Pedro Garza Garcia San Pedro    
34 34     Nehrin Ranziba Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
75 75   2021-01-07 Winiarski Artur Gaya United 6904 2021-01-07 Gaya United Bytowska Street 15 Czarna Dabrowka Pomeranian    
515 515   2021-03-06 Culmer Sanique Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
516 516   2021-03-06 Kemp Adrian Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
517 517   2021-03-06 Lord Jonathan Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
518 518   2021-03-06 Shivers Phylia Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
588 588   2022-03-17 Gutierrez Muguerza Raul Manuel DEACERO S.A.P.I. de C.V. (DEACERO) 7013 2021-09-07 DEACERO S.A.P.I. de C.V. (DEACERO) Lazaro Cardenas 2333, Zona Loma Larga Oriente San Pedro Garza Garcia San Pedro    
590 590   2022-03-17 Reboulen Bernal Juan Antonio DEACERO S.A.P.I. de C.V. (DEACERO) 7013 2021-09-07 DEACERO S.A.P.I. de C.V. (DEACERO) Lazaro Cardenas 2333, Zona Loma Larga Oriente San Pedro Garza Garcia San Pedro    
597 597   2022-03-18 Jamieson Martha DDB Canada 7099 2022-03-18 DDB Canada 33 Bloor Street East Suite 1700 Toronto    
598 598   2022-03-18 Leggatt Helene DDB Canada 7099 2022-03-18 DDB Canada 33 Bloor Street East Suite 1700 Toronto    
660 660   2012-03-27 Bramble Sylma Brown Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
765 765   2018-04-11 Kramer Andrew L. Dickens & Madson Canada Inc. 6200 2013-12-11 Dickens & Madson Canada Inc. c/o Tragen Resources & Logistics 740 Notre Dame Ouest, Suite 1250 Montreal    
903 903   2016-04-29 Archer Garbrielle A. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
904 904   2016-04-29 Johnson Deckery Keith Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
905 905   2016-04-29 Moss Mikala T. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
906 906   2016-04-29 Munroe Richard Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
908 908   2016-04-29 Rodgers Jeffrey C. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
909 909   2016-04-29 Sands Vandia D. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
910 910   2016-04-29 Young Prescott Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
1032 1032   2023-05-16 Terry Joshua Michael Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
1050 1050   2023-05-18 Daghstani Shereen Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
1086 1086   2023-05-23 Bannister Jennifer Gardiner Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
1087 1087   2023-05-23 Rolle Gregory Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
1126 1126   2015-05-28 Smith Dupree Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
1127 1127   2015-05-28 Strachan Danzarra M. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
1341 1341   2023-06-30 Le Miere Lucienne Anne Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
1342 1342   2023-06-30 Nelder Alexander Joseph Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
1503 1503   2021-07-28 Walters Neil Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
1620 1620   2022-08-16 Yessaian Charles Salam International 7159 2022-08-16 Salam International Salam Tower Corniche Road Doha    
1738 1738   2021-09-07 Altschuler Irwin DEACERO S.A.P.I. de C.V. (DEACERO) 7013 2021-09-07 DEACERO S.A.P.I. de C.V. (DEACERO) Lazaro Cardenas 2333, Zona Loma Larga Oriente San Pedro Garza Garcia San Pedro    
1739 1739   2021-09-07 Slomowitz Alan DEACERO S.A.P.I. de C.V. (DEACERO) 7013 2021-09-07 DEACERO S.A.P.I. de C.V. (DEACERO) Lazaro Cardenas 2333, Zona Loma Larga Oriente San Pedro Garza Garcia San Pedro    
1958 1958   2022-10-14 Frizzell Lisa Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
1959 1959   2022-10-14 Glenn Karine Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
1961 1961   2022-10-14 Kochie Dakota Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
1963 1963   2022-10-14 McClughan Brendan Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
1964 1964   2022-10-14 Swami Laurie Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
1965 1965   2022-10-14 Werner Isaac Nuclear Waste Management Organization 7186 2022-10-14 Nuclear Waste Management Organization 22 St. Clair Avenue East, 4th Floor Toronto Ontario    
2127 2127   2021-11-09 Gerbi Alexander Joseph Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
2128 2128   2021-11-09 Menezes Jagdish John Quinn Emanuel Urquhart & Sullivan UK LLP 7040 2021-11-09 Quinn Emanuel Urquhart & Sullivan UK LLP 90 High Holborn   London    
2157 2157   2021-11-12 Didkovskyy Oleksiy Volodymyrovych Asters Consult LLC 7043 2021-11-12 Asters Consult LLC 40 Vasily Tyutyunnik Street   Kyiv    
2160 2160   2021-11-12 Frolov Oleksandr Mykolaiovych Asters Consult LLC 7043 2021-11-12 Asters Consult LLC 40 Vasily Tyutyunnik Street   Kyiv    
2161 2161   2021-11-12 Legka Oksana Serhiivna Asters Consult LLC 7043 2021-11-12 Asters Consult LLC 40 Vasily Tyutyunnik Street   Kyiv    
2177 2177   1994-11-17 Watson Dornell Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2204 2204   2019-11-20 Winstanley Robert Halcyon Associates 6752 2019-11-20 Halcyon Associates Dashwood House, 69 Old Broad Street London    
2212 2212   2022-11-22 Demeritte Rissie Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2213 2213   2022-11-22 Gibson Jaimie Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2214 2214   2022-11-22 Grant Danielle Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2215 2215   2022-11-22 Knowles Deanya Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2216 2216   2022-11-22 Lockhart Jonathan Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2217 2217   2022-11-22 Morris Kristy Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2218 2218   2022-11-22 Williams Carleton Seve Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2220 2220   2022-11-23 Akkurt Aydanur 35 Nord 7194 2022-11-23 35 Nord 17, Avenue Hoche   Paris    
2221 2221   2022-11-23 Doane Guillaume 35 Nord 7194 2022-11-23 35 Nord 17, Avenue Hoche   Paris    
2222 2222   2022-11-23 Gattegno Tom 35 Nord 7194 2022-11-23 35 Nord 17, Avenue Hoche   Paris    
2223 2223   2022-11-23 Grandjean Romain 35 Nord 7194 2022-11-23 35 Nord 17, Avenue Hoche   Paris    
2383 2383   2013-12-11 Ben-Menashe Ari Dickens & Madson Canada Inc. 6200 2013-12-11 Dickens & Madson Canada Inc. c/o Tragen Resources & Logistics 740 Notre Dame Ouest, Suite 1250 Montreal    
2487 2487   2013-12-31 Carey Raquel D. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2488 2488   2013-12-31 James Hilda L. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2489 2489   2013-12-31 Johnson-Patty Anita Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2490 2490   2013-12-31 King Bridgette Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2491 2491   2013-12-31 Lee Tina Theresa Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2492 2492   2013-12-31 Miller Andre J. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2493 2493   2013-12-31 Treco Richard Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2494 2494   2013-12-31 Woodside-Cidel Melony Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
2524 2524 1962-01-01 1961-09-05 Illenberger Theodora Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
2839 2839 2006-01-01 1998-09-02 Prettejohn Nicholas Lloyd's of London Market Representatives 4883 1994-01-06 Lloyd's of London Market Representatives One Lime Street   London    
3142 3142 2020-01-03 2020-08-26 Levi Zac FTI Consulting LLP 6569 2018-07-09 FTI Consulting LLP 200 Aldersgate, Aldersgate Street   London    
3244 3244 2004-01-05 2002-07-18 Thomas-Frye Sadie Nova Scotia Information Centre 3078 1979-12-18 Nova Scotia Information Centre 1800 Argyle Street Suite 603 Box 456 Halifax    
3263 3263 1959-01-06 1958-02-03 Tilker Kay Burr Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
3632 3632 2011-01-12 2010-05-26 Ben-Menashe Ari Dickens & Madson Canada Inc. 5990 2010-05-26 Dickens & Madson Canada Inc. 740 Notre Dame #1250 Montreal    
3653 3653 1986-01-13 1984-02-28 Loughery John Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
3700 3700 1976-01-14 1974-02-01 Tighe Gregory F. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
3837 3837 2020-01-15 2013-12-31 Manouzi Kara Y. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
4249 4249 1977-01-22 1973-08-14 Fahmy Adel Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
4295 4295 2021-01-22 2020-05-22 Evtimov Bogdan Venelinov Linklaters LLP 6795 2020-02-24 Linklaters LLP One Silk Street   London    
4335 4335 1978-01-24 1977-03-29 Basulto Kenneth Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
4668 4668 1946-01-28 1946-04-09 Gibler Frank Morlet, Manuel Tomas 339 1946-01-28 Morlet, Manuel Tomas Calle Balderas #96   Mexico City    
4726 4726 2022-01-28 2021-11-02 Tucker George Actum International UK Limited 7033 2021-11-01 Actum International UK Limited 91 Jermyn Street, First Floor   London    
4822 4822 1987-01-30 1982-03-22 Hurley Adele M. Canadian Coalition on Acid Rain 3225 1981-04-13 Canadian Coalition on Acid Rain 112 St. Clair Avenue, West Suite 504 Toronto, Ontario    
4824 4824 1987-01-30 1981-07-20 Perley Michael Canadian Coalition on Acid Rain 3225 1981-04-13 Canadian Coalition on Acid Rain 112 St. Clair Avenue, West Suite 504 Toronto, Ontario    
4835 4835 1995-01-30 1984-10-02 Reid Jeremiah T. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
4836 4836 1997-01-30 1996-05-03 Lugo Hector M. Camara Oficial Espanola de Comercio 2400 1972-12-27 Camara Oficial Espanola de Comercio Condominio Altamira Center Oficina 205 - Calle Perseo #501 San Juan De    
4912 4912 1963-01-31 1961-01-18 Craig Nicholas Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
4981 4981 1982-01-31 1977-08-05 Pratt Godfrey Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
4984 4984 1983-01-31 1980-03-28 Grow Nancy Strome Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
5082 5082 1991-01-31 1987-08-20 Elsaesser Walter A. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
5114 5114 1992-01-31 1990-09-04 Muller Luc Charles Alsace Development International, Inc. 3506 1983-08-10 Alsace Development International, Inc. Chateau Kiener - 24 rue de Verdum   68000 Colmar    
5117 5117 1992-01-31 1971-10-27 Lee Minnette H. Caribbean Tourism Organization, USA Inc.  991 1956-12-31 Caribbean Tourism Organization, USA Inc. 1321 Upland Drive PMB: 11540 Houston    
5120 5120 1993-01-31 1986-01-23 Boyd Robert W. A. Nova Scotia Information Centre 3078 1979-12-18 Nova Scotia Information Centre 1800 Argyle Street Suite 603 Box 456 Halifax    
5233 5233 2001-01-31 1996-05-03 Irizarry Hiram Camara Oficial Espanola de Comercio 2400 1972-12-27 Camara Oficial Espanola de Comercio Condominio Altamira Center Oficina 205 - Calle Perseo #501 San Juan De    
5240 5240 2001-01-31 1997-08-01 Duncan Monica Ross-Robinson & Associates 4992 1995-02-07 Ross-Robinson & Associates P.O. Box 417   Basseterre    
5368 5368 2006-01-31 1994-11-17 Strachan Paul Antoni Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
5412 5412 2009-01-31 2007-01-10 Ben-Menashe Ari Dickens & Madson Canada, Inc. 5784 2007-01-10 Dickens & Madson Canada, Inc. 740 Notre Dame Ouest Suite 1250 Montreal, Quebec    
5460 5460 2012-01-31 1999-02-24 Matcham David International Underwriting Association of London 5296 1999-01-12 International Underwriting Association of London 3 Minister Court Mincing Lane London    
5543 5543 2019-01-31 2019-03-05 Akimoto Satohiro Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 2018-07-20 Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) Keidanren Kaikan, 1-3-2 Otemachi, Chiyoda-ku TOKYO Tokyo    
5544 5544 2019-01-31 2019-03-05 Ito Shinnosuke Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 2018-07-20 Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) Keidanren Kaikan, 1-3-2 Otemachi, Chiyoda-ku TOKYO Tokyo    
5545 5545 2019-01-31 2019-03-05 Kurokawa Ken Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 2018-07-20 Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) Keidanren Kaikan, 1-3-2 Otemachi, Chiyoda-ku TOKYO Tokyo    
5546 5546 2019-01-31 2019-03-05 Nemoto Katsunori Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 2018-07-20 Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) Keidanren Kaikan, 1-3-2 Otemachi, Chiyoda-ku TOKYO Tokyo    
5547 5547 2019-01-31 2019-03-05 Wada Teruko Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 2018-07-20 Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) Keidanren Kaikan, 1-3-2 Otemachi, Chiyoda-ku TOKYO Tokyo    

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