FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
26 rows where City = "Washington" and Registrant_Name = "Dewey Ballantine"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_First_Name, Short_Form_Date (date)
State 1
- DC 26
Registration_Number 1
Registrant_Name 1
- Dewey Ballantine · 26 ✖
City 1
- Washington · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4220 | 4220 | 1994-01-21 | 1992-02-11 | Marcus | Mary Jane | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
4444 | 4444 | 1990-01-25 | 1988-07-29 | McAnaney | Kevin G. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
4445 | 4445 | 1990-01-25 | 1988-08-01 | Califano | Joseph A. , Jr. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
4446 | 4446 | 1990-01-25 | 1988-08-01 | Isaacson | Marcia R. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
4447 | 4447 | 1990-01-25 | 1988-08-01 | Tammen | Susan S. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
6069 | 6069 | 1995-02-03 | 1988-03-08 | Noellert | William A. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
6071 | 6071 | 1995-02-03 | 1991-10-07 | Griffen | Robert H. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
6661 | 6661 | 1988-02-12 | 1985-11-27 | Boyle | Jayne F. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
9950 | 9950 | 1990-03-15 | 1987-11-19 | Cichnowicz | David J. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
14140 | 14140 | 1991-04-26 | 1991-01-14 | Black | Joseph A. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20383 | 20383 | 1990-06-27 | 1988-07-29 | Dowley | Joseph K. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
20443 | 20443 | 1995-06-28 | 1993-08-12 | Black | Joseph H. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
22910 | 22910 | 1987-07-10 | 1986-05-02 | Kanner | Frederick W. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
22911 | 22911 | 1987-07-10 | 1986-05-02 | McDermott | Robert J. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
22912 | 22912 | 1987-07-10 | 1986-05-02 | Warnke | Gordon E. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
23738 | 23738 | 1994-07-21 | 1993-06-25 | Craythorn | Dennis | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
29990 | 29990 | 1992-09-17 | 1992-02-11 | Magnus | John R. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
32413 | 32413 | 1988-10-07 | 1988-03-08 | MacLaughlin | Janet | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
35114 | 35114 | 1994-11-02 | 1994-07-05 | Carlson | Amy L. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
39172 | 39172 | 1988-12-27 | 1988-02-24 | Wolff | Alan William | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40819 | 40819 | 1995-12-31 | 1992-02-11 | Stein | Michael H. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40876 | 40876 | 1995-12-31 | 1993-06-25 | McFadden | W. Clark , II | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40882 | 40882 | 1995-12-31 | 1994-07-05 | Ward | Bradford L. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40883 | 40883 | 1995-12-31 | 1994-07-05 | Wolff | Alan William | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40934 | 40934 | 1995-12-31 | 1985-11-27 | Salmon | John J. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 | |
40938 | 40938 | 1995-12-31 | 1993-11-30 | Magnus | John R. | Dewey Ballantine 3759 | 1985-11-27 | Dewey Ballantine | 1775 Pennsylvania Avenue, N.W. | Washington | DC | 20006 |
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]) );