FARA_All_Registrants

Table actions
List of all registrant data (active and terminated)

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

28 rows where "Termination_Date" is on date 1995-12-31

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 7

Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
2868 1978-03-17 1995-12-31 LeBoeuf, Lamb, Greene & MacRae, L.L.P.   1875 Connecticut Avenue, N.W. Suite 1200 Washington DC 20009-5728
3550 1984-01-19 1995-12-31 Pietroski, Joseph J.   200 Bloor Street, East   Toronto, Ontario    
3737 1985-09-25 1995-12-31 R. Duffy Wall & Associates, Inc.   601 - 13th Street, N.W. Suite 410 South Washington DC 20005
3759 1985-11-27 1995-12-31 Dewey Ballantine   1775 Pennsylvania Avenue, N.W.   Washington DC 20006
4018 1987-07-28 1995-12-31 Davis & Harman   1455 Pennsylvania Avenue, N.W. Suite 1200 Washington DC 20004
4037 1987-09-15 1995-12-31 Michelin North America, Inc.   1 Parkway, South   Greenville SC 29615
4112 1988-03-28 1995-12-31 Dykema Gossett   1300 I Street, N.W. Franklin Sq., Suite 300 West Washington DC 20005
4267 1989-06-23 1995-12-31 International Advisory Services Group, Ltd.   1919 Pennsylvania Avenue, N.W. Suite 800 Washington DC 20006
4302 1989-10-06 1995-12-31 Lepon, McCarthy, White & Holzworth   1225 19th Street, N.W. Suite 600 Washington DC 20036
4362 1990-04-11 1995-12-31 Hopkins & Sutter   888 - 16th Street, N.W.   Washington DC 20006
4485 1991-03-14 1995-12-31 Daimler-Benz Washington, Inc.   1350 I Street, N.W. Suite 800 Washington DC 20005-3305
4624 1992-02-26 1995-12-31 Howrey & Simon   1299 Pennsylvania Avenue, N.W.   Washington DC 20004-2402
4735 1992-12-10 1995-12-31 Winthrop, Stimson, Putnam & Roberts, Washington Office   1133 Connecticut Avenue, N.W.   Washington DC 20036
4756 1993-01-26 1995-12-31 Ober, Kaler, Grimes & Shriver   120 East Baltimore Street   Baltimore MD 21202-1643
4817 1993-06-14 1995-12-31 Greenberg, Traurig, Hoffman, Lipoff, Rosen & Quentel, P.A.   1300 Connecticut Avenue, N.W. Suite 1000 Washington DC 20036
4891 1994-02-04 1995-12-31 Van Fleet - Meredith Group   499 S. Capitol Street, S.W. Suite 520 Washington DC 20003
4921 1994-06-20 1995-12-31 Vinson & Elkins, L.L.P.   1455 Pennsylvania Avenue, N.W. Suite 700 Washington DC 20004-1008
4944 1994-06-29 1995-12-31 Landau, David   405 Elm Avenue   Takoma Park MD 20912
4952 1994-09-27 1995-12-31 Herman J. Cohen & Associates   1555 Wilson Boulevard Suite 300 Arlington VA 22209
5024 1995-06-19 1995-12-31 DeLay, Randolph L.   2925 Briarpark Suite 1150 Houston TX 77042
5026 1995-06-20 1995-12-31 Sierra Club Legal Defense Fund, Inc.   180 Montgomery Street Suite 1400 San Francisco CA 94104-4209
5032 1995-03-27 1995-12-31 Keck, Mahin & Cate   1201 New York Avenue, N.W. Penthouse Suite Washington DC 20005-3919
5034 1995-06-30 1995-12-31 Fuji Bank, Ltd., Washington D.C. Representative Office   1155 Connecticut Avenue, N.W. Suite 601 Washington DC 20036
5045 1995-09-14 1995-12-31 Council of European & Japanese National Shipowners' Assn.   Carthusian Court 12 Carthusian Street London    
5050 1995-09-18 1995-12-31 Downey Chandler, Inc.   1401 I Street, N.W. Suite 1210 Washington DC 20005
5075 1995-06-15 1995-12-31 Butera, James J.   1301 Pennsylvania Avenue, N.W. Suite 500 Washington DC 20004
5076 1995-11-13 1995-12-31 O'Neill & Athy, P.C.   1310 - 19th Street, N.W.   Washington DC 20036
5086 1995-12-12 1995-12-31 Royer & Babyak   1747 Pennsylvania Avenue, N.W. Suite 900 Washington DC 20006

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