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

74 rows where Registration_Number = 2580

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Shaw, Pittman, Potts & Trowbridge · 74 ✖

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
2688 2688 1990-01-01 1975-02-21 Pittman Steuart L. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
2689 2689 1990-01-01 1975-02-21 Potts Ramsay D. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
2703 2703 1990-01-01 1988-10-28 Ma'ani-Bruss Sovaida Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
3527 3527 1992-01-10 1986-09-23 Ferrara Peter J. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
4100 4100 1995-01-19 1993-10-20 McNulty Paul J. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
5060 5060 1990-01-31 1985-09-25 Zormelo Justice Y. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
7939 7939 1989-02-28 1984-03-21 Barr William P. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
9504 9504 1979-03-09 1979-02-22 Low David B. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
9523 9523 1993-03-09 1991-06-20 Nelson Paul Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
10061 10061 1993-03-16 1991-06-20 Brown Garry Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
10465 10465 1994-03-21 1992-10-19 Egan Joseph R. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
10513 10513 1993-03-22 1988-10-28 Milon Patricia A. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
10582 10582 1981-03-23 1980-03-10 Rhinelander John B. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
10583 10583 1981-03-23 1980-03-28 Gordon Robert M. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
13403 13403 1985-04-15 1983-09-22 Auerbach Kenneth David Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
13750 13750 1991-04-19 1988-09-02 House Michael Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
14540 14540 1984-04-30 1980-03-10 Burger James M. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
15378 15378 1986-05-01 1984-03-21 Wasserman Alan D. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
15399 15399 1989-05-01 1986-03-17 Moore Obie L. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
19963 19963 1985-06-21 1984-03-28 Becker Richard K. A. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
20107 20107 1994-06-23 1984-03-21 Crocker Thomas Edward , Jr. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
20386 20386 1994-06-27 1992-02-07 Spulak Thomas J. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
24000 24000 1979-07-25 1979-06-15 Crowley George D. , Jr. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
26729 26729 1989-08-15 1985-09-26 Naser Cristeena G. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27141 27141 1996-08-21 1985-03-05 Oliner Joyce L. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27142 27142 1996-08-21 1995-05-24 Potts Ramsay D. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27143 27143 1996-08-21 1995-05-24 Spulak Thomas J. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27144 27144 1996-08-21 1994-06-23 Custer B. Scott , Jr. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27145 27145 1996-08-21 1979-07-30 O'Neill John H. , Jr. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27146 27146 1996-08-21 1988-09-02 Martin Gordon G. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27147 27147 1996-08-21 1987-09-11 Moetell Michael C. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27148 27148 1996-08-21 1994-09-12 Hodges Ann C. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27149 27149 1996-08-21 1979-09-21 Carr John L. , Jr. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27150 27150 1996-08-21 1979-09-21 Hanlon R. Timothy Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27151 27151 1996-08-21 1992-10-19 Charnoff Gerald Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
27152 27152 1996-08-21 1990-10-23 Webster Aen Walker Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30019 30019 1979-09-18 1977-09-30 Farrand Laura K. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30210 30210 1993-09-21 1992-03-01 Marinaccio Charles L. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30211 30211 1994-09-21 1992-02-11 Grote Mary Jo Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30212 30212 1994-09-21 1975-02-21 Brown Winthrop N. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30213 30213 1994-09-21 1975-02-21 Rossotti Barbara M. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30215 30215 1994-09-21 1992-03-24 Byington Lisa M. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30216 30216 1994-09-21 1992-03-24 Paul Robert D. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30217 30217 1994-09-21 1993-04-01 Rhinelander John B. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30219 30219 1994-09-21 1992-10-02 Little Fred A. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30220 30220 1994-09-21 1992-10-02 Robbins Robert B. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30221 30221 1994-09-21 1988-10-28 Krohn David Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30266 30266 1992-09-22 1978-06-01 Lucas Steven M. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30269 30269 1992-09-22 1989-09-06 Somach Susan D. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30270 30270 1992-09-22 1984-09-11 More John H. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30272 30272 1992-09-22 1990-10-26 Buttarazzi John Edward Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
30273 30273 1992-09-22 1988-10-28 Guyot John F. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
32157 32157 1987-10-02 1983-09-22 Kampelman Jeffrey William Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
32207 32207 1990-10-03 1988-03-01 Visser Laura L. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
34067 34067 1990-10-30 1977-03-28 Vogel Frank E. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
34070 34070 1990-10-30 1979-06-15 Potts Ramsey D. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
34077 34077 1992-10-30 1990-01-31 Burnley IV James H. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
34896 34896 1985-11-01 1985-04-03 Boyd Patricia E. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
35169 35169 1993-11-03 1990-01-31 Bierlein Lawrence W. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
36155 36155 1979-11-21 1979-06-15 Richman Kay L. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
36687 36687 1987-11-30 1984-03-21 Brown Travis T. , Jr. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
37888 37888 1993-12-07 1993-03-16 Nelson Paul Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
38226 38226 1985-12-13 1982-09-28 Ellis Andrew D. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40687 40687 1991-12-31 1979-06-15 Jones Carleton S. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40835 40835 1995-12-31 1996-03-21 Carvin Michael A. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40836 40836 1995-12-31 1996-03-21 Crocker Thomas E. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40837 40837 1995-12-31 1996-03-21 Pearlman Steven W. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40838 40838 1995-12-31 1996-03-21 Rhinelander John B. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40854 40854 1995-12-31 1995-05-19 Byington Lisa M. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40878 40878 1995-12-31 1994-06-30 Pax Thomas J. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40905 40905 1995-12-31 1984-09-11 Pilecki Paul S. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40911 40911 1995-12-31 1983-09-22 Anenberg Scott A. Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40917 40917 1995-12-31 1983-10-11 Sahr David Roger Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128
40919 40919 1995-12-31 1992-10-19 Shapar Howard Shaw, Pittman, Potts & Trowbridge 2580 1975-02-21 Shaw, Pittman, Potts & Trowbridge 2300 N Street, N.W.   Washington DC 20037-1128

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