List of all registrant data (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

9 rows where "Termination_Date" is on date 2003-10-31

View and edit SQL

Suggested facets: Registration_Date, Business_Name, Address_2, Zip, Registration_Date (date)

State

Termination_Date (date)

  • 2003-10-31 · 9
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
5309 1999-04-27 2003-10-31 Ev Clay Associates, Inc. Everett Clay Associates 6161 Blue Lagoon Drive Suite 270 Miami FL 33126
5388 2000-10-04 2003-10-31 Peden, Jack L.   15828 Alta Vista Way   San Jose CA 95127
5426 2001-04-13 2003-10-31 Patrice Tanaka & Company, Inc.   320 West 13th Street 7th Floor New York NY 10016
5491 2002-04-08 2003-10-31 Zemi Communications, L.L.C.   99 Madison Avenue 2nd Floor New York NY 10016
5494 2002-04-25 2003-10-31 Greenberg Traurig, L.L.P.   1221 Brickell Avenue   Miami FL 33131
5520 2002-10-01 2003-10-31 Jones, Theodore L. (TED)   8941 Jefferson Highway Suite 200 Baton Rouge LA 70809
5550 2003-04-03 2003-10-31 Wood, James C.   1523 33rd Street, N.W.   Washington DC 20007
5552 2003-04-10 2003-10-31 Berman Enterprises   1800 K Street, N.W. Suite 1124 Washington DC 20006
5553 2003-04-10 2003-10-31 Rogich Communications Group   3980 Howard Hughes Parkway #550 Las Vegas NV 89109

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_Name] TEXT,
   [Address_1] TEXT,
   [Address_2] TEXT,
   [City] TEXT,
   [State] TEXT,
   [Zip] TEXT,
   FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number])
);