FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
74 rows where City = "Washington" and Registration_Number = 2580 sorted by Short_Form_First_Name
This data as json, CSV (advanced)
State 1
- DC 41
Registration_Number 1
- Shaw, Pittman, Potts & Trowbridge · 41 ✖
Registrant_Name 1
City 1
- Washington · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );