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

40 rows where Registration_Number = 3488

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date (date)

State 1

Registration_Number 1

  • Heron, Burchette, Ruckert & Rothwell · 40 ✖

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
5027 5027 1988-01-31 1985-11-21 Copeland James M. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7071 7071 1990-02-16 1985-02-04 Smith Tracy L. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7072 7072 1990-02-16 1987-02-04 Wagner Mark Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7073 7073 1990-02-16 1986-02-17 Mitchell Sandra S. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7074 7074 1990-02-16 1988-03-09 Conway Lynnette R. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7075 7075 1990-02-16 1988-03-09 Horton Oliver James , Jr. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7076 7076 1990-02-16 1988-03-09 Lake Monte B. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7077 7077 1990-02-16 1988-03-09 Lawrence Kathleen W. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7079 7079 1990-02-16 1986-04-14 Ruckert Edward M. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7080 7080 1990-02-16 1986-04-14 Smith Richard A. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7081 7081 1990-02-16 1986-05-01 Norwood John A. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7082 7082 1990-02-16 1986-05-13 Spees Richard L. , Jr. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7083 7083 1990-02-16 1983-06-23 Rothwell Thomas A. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7084 7084 1990-02-16 1983-06-23 Winkler Montgomery K. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7085 7085 1990-02-16 1986-07-25 Vernon Victoria C. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7086 7086 1990-02-16 1988-07-29 Allison Edward E. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7087 7087 1990-02-16 1988-07-29 Kennedy Jerry W. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7088 7088 1990-02-16 1985-08-05 Graves Edwin C. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7089 7089 1990-02-16 1987-08-12 Raclin Grier C. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7090 7090 1990-02-16 1989-08-23 Jost Catherine Melquist Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7092 7092 1990-02-16 1987-10-16 Fielek Henrietta S. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7093 7093 1990-02-16 1987-10-16 Furman Harold W. , II Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7097 7097 1990-02-16 1986-11-12 Bevels Terry D. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7098 7098 1990-02-16 1986-11-12 Wirick Jennifer K. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7099 7099 1990-02-16 1985-11-21 Gleason Carolyn B. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7100 7100 1990-02-16 1985-11-21 Hill Jerry C. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7101 7101 1990-02-16 1985-11-21 Moore Cynthia L. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7102 7102 1990-02-16 1985-11-21 Richmond Marilyn S. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7103 7103 1990-02-16 1984-11-26 Lyons James M. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
7104 7104 1990-02-16 1984-11-26 Vicario Joseph A. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
14581 14581 1987-04-30 1985-11-21 Hammer Thomas A. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
18458 18458 1984-06-01 1983-06-23 Porter Robert W. , Jr. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
19657 19657 1989-06-16 1988-07-29 Suzuki Yasuhiko Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
19658 19658 1989-06-16 1987-10-16 Best Robert A. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
28102 28102 1986-08-31 1985-10-11 Lake James H. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
32892 32892 1989-10-15 1985-11-21 Allison Edward E. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
34288 34288 1988-10-31 1988-07-29 Oriot Pierre A. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
34297 34297 1989-10-31 1987-07-06 Murdock J.E. , III Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
36721 36721 1989-11-30 1988-07-27 Levy Steven A. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007
36723 36723 1989-11-30 1988-09-21 Pruitt Steven L. Heron, Burchette, Ruckert & Rothwell 3488 1983-06-23 Heron, Burchette, Ruckert & Rothwell 1025 Thomas Jeff. Street, N.W. Suite 700 Washington DC 20007

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