List of all registrant data (active and terminated)

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

15 rows where "Termination_Date" is on date 1987-12-31

View and edit SQL

Suggested facets: Address_2, Zip, Registration_Date (date)

State

Termination_Date (date)

  • 1987-12-31 · 15
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
2357 1972-07-17 1987-12-31 Hugh C. Newton & Associates   214 Massachusetts Avenue, N.W. Suite 520 Washington DC 20002
2799 1977-06-29 1987-12-31 Finley Kumble Wagner Heine Underberg Manley Myerson & Casey   1120 Connecticut Avenue, N.W. 10th Floor Washington DC 20036
2810 1977-07-13 1987-12-31 Aramtek Corporation   122 East 42nd Street   New York NY 10017
2912 1978-06-09 1987-12-31 Curtis J. Hoxter, Inc.   745 Fifth Avenue   New York NY 10022
3170 1980-11-24 1987-12-31 Carl Byoir & Associates, Inc.   380 Madison Avenue   New York NY 10017
3228 1981-04-15 1987-12-31 A.I.T. Corporation   15 - 3rd Street, N.E.   Washington DC 20002
3281 1981-10-06 1987-12-31 IBTT Consultants, Inc.   1701 K Street, N.W. Suite 603 Washington DC 20006
3315 1981-12-03 1987-12-31 Tayoun, Joseph John   1229 South 11th Street   Philadelphia PA 19147
3412 1982-09-29 1987-12-31 Merren, Orren   Post Office Box 53356   Washington DC 20009
3609 1984-08-28 1987-12-31 Braun & Company   1250 Connecticut Avenue, N.W. Suite 318 Washington DC 20036
3648 1985-02-06 1987-12-31 Morgan, Gary Russell   401 East Douglas Suite 505 Wichita KS 67202
3707 1985-07-29 1987-12-31 Rogers & Cowan, Inc., Washington Office   2233 Wisconsin Avenue Suite 500 Washington DC 20007
3899 1986-10-21 1987-12-31 TransSwiss Exports, Ltd.   1800 K Street, N.W. Suite 1120 Washington DC 20006
3907 1986-11-17 1987-12-31 Guerra-Mondragon, Gabriel   1789 Lanier Place, N.W.   Washington DC 20009
3986 1987-05-27 1987-12-31 Davis, Wright, & Jones   1752 N Street, N.W. Suite 800 Washington DC 20036

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