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

28 rows where "Short_Form_Termination_Date" is on date 1996-02-28

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number 13

  • Hogan Lovells US LLP 5
  • Capital International Information Services, Inc. 4
  • National Liberation Council of Nigeria - U.S.A. (Nalicon) 4
  • Dickens & Webster 3
  • IPG DXTRA, Inc 2
  • Energia U.S.A., Inc. 2
  • Samuels International Associates, Inc. 2
  • Singapore Economic Development Board 1
  • Bahamas Tourist Office 1
  • People's Mojahedin of Iran, Washington, D.C. - Press Office 1
  • J.H.S. Group, Inc. 1
  • Hurwitz & Abramson 1
  • Seigenthaler, Thomas P. 1

Registrant_Name 13

  • Hogan Lovells US LLP 5
  • Capital International Information Services, Inc. 4
  • National Liberation Council of Nigeria - U.S.A. (Nalicon) 4
  • Dickens & Webster 3
  • Energia U.S.A., Inc. 2
  • IPG DXTRA, Inc 2
  • Samuels International Associates, Inc. 2
  • Bahamas Tourist Office 1
  • Hurwitz & Abramson 1
  • J.H.S. Group, Inc. 1
  • People's Mojahedin of Iran, Washington, D.C. - Press Office 1
  • Seigenthaler, Thomas P. 1
  • Singapore Economic Development Board 1

State 7

  • DC 13
  • IL 4
  • MD 4
  • NY 3
  • VA 2
  • - 1
  • TN 1

City 7

  • Washington 13
  • Chicago 4
  • Ellicott City 4
  • New York 3
  • Alexandria 2
  • Nashville 1
  • Nassau 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
8043 8043 1996-02-28 1991-01-12 Loeffler Robert H. Capital International Information Services, Inc. 4472 1991-02-12 Capital International Information Services, Inc. 2000 Pennsylvania Avenue, N.W. Suite 5500 Washington DC 20006
8044 8044 1996-02-28 1994-01-24 Haley Daniel D. IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022
8045 8045 1996-02-28 1991-02-12 Band Jonathan Capital International Information Services, Inc. 4472 1991-02-12 Capital International Information Services, Inc. 2000 Pennsylvania Avenue, N.W. Suite 5500 Washington DC 20006
8046 8046 1996-02-28 1995-02-16 Breger Marshall Hurwitz & Abramson 4995 1995-02-16 Hurwitz & Abramson 1735 - 20th Street, N.W.   Washington DC 20009
8047 8047 1996-02-28 1996-02-16 Jensen Sten A. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8048 8048 1996-02-28 1996-02-16 Sekoni Oluropo National Liberation Council of Nigeria - U.S.A. (Nalicon) 5095 1996-02-16 National Liberation Council of Nigeria - U.S.A. (Nalicon) 7995 Old Montgomery Road   Ellicott City MD 21043
8049 8049 1996-02-28 1992-02-20 Faranetta Christopher J. Energia U.S.A., Inc. 4621 1992-02-20 Energia U.S.A., Inc. 631 South Washington Street   Alexandria VA 22314
8050 8050 1996-02-28 1992-02-20 Manber Jeffrey Energia U.S.A., Inc. 4621 1992-02-20 Energia U.S.A., Inc. 631 South Washington Street   Alexandria VA 22314
8051 8051 1996-02-28 1984-02-28 Stoddard Blaine M. Bahamas Tourist Office 2310 1972-01-27 Bahamas Tourist Office Ministry of Tourism Post Office Box N-3701 Nassau    
8052 8052 1996-02-28 1991-05-23 Cameron Donald B. Capital International Information Services, Inc. 4472 1991-02-12 Capital International Information Services, Inc. 2000 Pennsylvania Avenue, N.W. Suite 5500 Washington DC 20006
8053 8053 1996-02-28 1996-07-12 Ejiogu Emmanuel National Liberation Council of Nigeria - U.S.A. (Nalicon) 5095 1996-02-16 National Liberation Council of Nigeria - U.S.A. (Nalicon) 7995 Old Montgomery Road   Ellicott City MD 21043
8054 8054 1996-02-28 1996-07-12 Gbadegesin Segun National Liberation Council of Nigeria - U.S.A. (Nalicon) 5095 1996-02-16 National Liberation Council of Nigeria - U.S.A. (Nalicon) 7995 Old Montgomery Road   Ellicott City MD 21043
8055 8055 1996-02-28 1996-07-12 Idowu Agunbiade National Liberation Council of Nigeria - U.S.A. (Nalicon) 5095 1996-02-16 National Liberation Council of Nigeria - U.S.A. (Nalicon) 7995 Old Montgomery Road   Ellicott City MD 21043
8056 8056 1996-02-28 1993-08-16 Shepherd John H. J.H.S. Group, Inc. 4941 1993-08-16 J.H.S. Group, Inc. 150 North Michigan Avenue Suite 2025 Chicago IL 60601-2916
8057 8057 1996-02-28 1993-08-26 Durant Andrew G. Samuels International Associates, Inc. 4848 1993-08-26 Samuels International Associates, Inc. 1140 Connecticut Avenue, N.W. Suite 950 Washington DC 20036
8058 8058 1996-02-28 1993-08-26 Schneidman Witney W. Samuels International Associates, Inc. 4848 1993-08-26 Samuels International Associates, Inc. 1140 Connecticut Avenue, N.W. Suite 950 Washington DC 20036
8059 8059 1996-02-28 1993-08-30 Yeow-Hin Lai 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
8060 8060 1996-02-28 1993-09-14 Mishkin Barbara Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8061 8061 1996-02-28 1993-09-14 Warnke Christine Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8062 8062 1996-02-28 1993-09-24 Barton Richard L. Dickens & Webster 4837 1993-08-03 Dickens & Webster 2124 North Sedgwick   Chicago IL 60614
8063 8063 1996-02-28 1993-09-24 Ornberg Richard C. Dickens & Webster 4837 1993-08-03 Dickens & Webster 2124 North Sedgwick   Chicago IL 60614
8064 8064 1996-02-28 1995-09-26 Seigenthaler Elizabeth B. Seigenthaler, Thomas P. 5053 1995-09-26 Seigenthaler, Thomas P. c/o Seigenthaler Public Rel. 2909 Poston Avenue Nashville TN 37205
8065 8065 1996-02-28 1991-09-27 Mendoza Julie C. Capital International Information Services, Inc. 4472 1991-02-12 Capital International Information Services, Inc. 2000 Pennsylvania Avenue, N.W. Suite 5500 Washington DC 20006
8066 8066 1996-02-28 1990-10-02 Lake Michael B. IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 909 Third Ave.   New York NY 10022
8067 8067 1996-02-28 1994-11-16 Maruyama Warren H. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8068 8068 1996-02-28 1993-11-24 Bruozis Lawrence S. Dickens & Webster 4837 1993-08-03 Dickens & Webster 2124 North Sedgwick   Chicago IL 60614
8069 8069 1996-02-28 1994-12-21 Kenney Robert J. , Jr. Hogan Lovells US LLP 2244 1971-02-18 Hogan Lovells US LLP 555 13th Street, NW Columbia Square Washington DC 20004-1109
8070 8070 1996-02-28 1995-12-26 Taleb-Jedi Zeinab People's Mojahedin of Iran, Washington, D.C. - Press Office 4061 1987-11-20 People's Mojahedin of Iran, Washington, D.C. - Press Office National Press Building Suite 1065 Washington DC 20045

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