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

15 rows where Registration_Number = 2275

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Rose, Schmidt, Hasley, & DiSalle · 15 ✖

Registrant_Name 1

City 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
2564 2564 1974-01-01 1973-07-10 Semer Milton P. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
2566 2566 1974-01-01 1971-08-24 Bamberger Craig S. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
2567 2567 1974-01-01 1971-08-24 Sibal Abner W. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
9564 9564 1987-03-10 1978-05-04 Lenzini Paul A. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
10058 10058 1987-03-16 1978-09-25 Hostetler James S. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
13907 13907 1988-04-22 1937-01-01 Riordan John H. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
15380 15380 1986-05-01 1980-10-06 Hufbauer Gary C. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
17423 17423 1978-05-30 1971-09-10 Paul Norman S. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
21027 21027 1984-06-30 1971-08-24 Smith W.N. Harrell Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
21078 21078 1988-06-30 1937-01-01 III Edgar F. Heiskell Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
21151 21151 1991-06-30 1979-05-02 Kenney William J. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
21161 21161 1991-06-30 1971-08-24 Sears John P. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
22205 22205 1991-07-01 1986-02-16 Kushnick Michael G. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
22210 22210 1991-07-01 1977-08-10 Sturtevant Albert D. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808
40384 40384 1986-12-31 1983-10-29 Reuss Henry S. Rose, Schmidt, Hasley, & DiSalle 2275 1971-08-24 Rose, Schmidt, Hasley, & DiSalle 1701 Pennsylvania Avenue, N.W. Suite 1040 Washington DC 20006-5808

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