home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
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 = 3452

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Registration_Date (date)

State 1

  • DC 40

Registration_Number 1

  • Dow, Lohnes & Albertson, L.L.P. · 40 ✖

Registrant_Name 1

  • Dow, Lohnes & Albertson, L.L.P. 40

City 1

  • Washington 40
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
4226 4226 1995-01-21 1985-01-21 Cunanan Irene L. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
4821 4821 1987-01-30 1983-03-17 Mueller Lita C. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
4823 4823 1987-01-30 1984-04-18 Sutton Carol Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
8754 8754 1985-03-01 1983-03-25 Lebow Edward M. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
8763 8763 1986-03-01 1983-11-10 Wasilewski Vincent T. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10126 10126 1986-03-17 1984-01-20 Dardess Margaret Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10131 10131 1988-03-17 1987-05-19 Thompson Philip C. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10132 10132 1988-03-17 1986-06-26 Fink Marc J. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10133 10133 1988-03-17 1987-08-11 Roberts Michael Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10134 10134 1988-03-17 1985-08-12 Silverman Arthur H. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10135 10135 1988-03-17 1983-11-10 Bender Raymond G. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10144 10144 1990-03-17 1987-04-21 Lawrence Jeffrey F. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10145 10145 1990-03-17 1985-05-14 Hill Jonathan B. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10146 10146 1990-03-17 1987-07-13 Smith David F. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10147 10147 1990-03-17 1987-08-11 Sher Stanley Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10148 10148 1990-03-17 1984-08-18 Pavco Lucille A. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10149 10149 1990-03-17 1987-09-18 Blackwell Robert J. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10150 10150 1990-03-17 1988-10-13 Fink Marc J. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10151 10151 1990-03-17 1983-11-10 Basile Michael D. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10157 10157 1996-03-17 1983-03-17 Jost John C. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
10160 10160 1996-03-17 1983-11-10 Salomon Kenneth D. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
13905 13905 1986-04-22 1985-08-06 Kaems Mary-Lucille Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
13906 13906 1986-04-22 1984-09-05 Davidson Carol Bauer Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
14243 14243 1986-04-28 1986-04-24 Mercado Cheryl L. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
15429 15429 1991-05-01 1990-07-12 Mickey Anne E. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
15430 15430 1991-05-01 1990-07-12 Sher Stanley O. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
15431 15431 1991-05-01 1990-07-18 Blackwell Robert J. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
16113 16113 1989-05-12 1988-05-27 Mills David E. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
19421 19421 1985-06-14 1983-03-17 Revaz Cris R. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
24088 24088 1991-07-26 1988-05-27 Gustafson Elizabeth J. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
25579 25579 1990-08-01 1990-03-07 Silverman Arthur H. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
26871 26871 1984-08-17 1984-02-24 Mullan Michael Francis Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
29109 29109 1987-09-03 1985-09-09 Trumble Lorie M. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
29313 29313 1984-09-07 1984-09-05 Savage Nancy Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
29982 29982 1987-09-17 1987-07-23 Dejoie Louis Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
31075 31075 1991-09-30 1985-09-09 Conroy Ryan Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
37728 37728 1987-12-04 1986-07-29 Olson Sydney J. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
38027 38027 1991-12-10 1983-03-17 Silverman William Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
38236 38236 1991-12-13 1987-03-05 Trainer Ryan T. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036
38237 38237 1991-12-13 1987-04-20 Heffner Douglas J. Dow, Lohnes & Albertson, L.L.P. 3452 1983-03-17 Dow, Lohnes & Albertson, L.L.P. 1200 New Hampshire Avenue, N.W Suite 800 Washington DC 20036

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])
);
Powered by Datasette · Queries took 648.174ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows