FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
34 rows where City = "Washington", Registration_Number = 3626 and State = "DC"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- DC · 34 ✖
Registration_Number 1
- Miller & Chevalier, Chartered · 34 ✖
Registrant_Name 1
City 1
- Washington · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7513 | 7513 | 1986-02-24 | 1986-09-19 | Harrison | Donald | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
8086 | 8086 | 1997-02-28 | 1989-12-01 | Curtiss | Catherine | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
9839 | 9839 | 1997-03-14 | 1990-12-04 | Wellington | Claire S. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
9957 | 9957 | 1992-03-15 | 1990-05-25 | Segall | Wynn H. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
10696 | 10696 | 1995-03-24 | 1993-12-09 | Diehl | Michael | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14038 | 14038 | 1989-04-24 | 1987-03-23 | Asbill | Joanne Thomas | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14734 | 14734 | 1998-04-30 | 1992-02-10 | Porter | Catherine Tift | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14735 | 14735 | 1998-04-30 | 1992-02-27 | Bickwit | Leonard , Jr. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14736 | 14736 | 1998-04-30 | 1992-02-27 | Mann | Phillip L. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14764 | 14764 | 1998-04-30 | 1989-04-24 | McGlone | William M. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14768 | 14768 | 1998-04-30 | 1991-05-31 | Shelley | Anthony F. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14769 | 14769 | 1998-04-30 | 1991-05-31 | Tuite | James P. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14776 | 14776 | 1998-04-30 | 1997-07-08 | Gibbs | Lawrence B. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14780 | 14780 | 1998-04-30 | 1984-10-31 | Moyer | Homer E. , Jr. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14792 | 14792 | 1998-04-30 | 1990-12-04 | Miller | Peter B. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14793 | 14793 | 1998-04-30 | 1991-12-05 | Davis | John E. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14794 | 14794 | 1998-04-30 | 1991-12-05 | Ferguson | Laura G. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14795 | 14795 | 1998-04-30 | 1995-12-08 | Aiello | Josephine I. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14796 | 14796 | 1998-04-30 | 1993-12-09 | Cameron | Kathryn E. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14797 | 14797 | 1998-04-30 | 1997-12-12 | Burton | Michael L. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14798 | 14798 | 1998-04-30 | 1997-12-12 | King | Kevin M. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14799 | 14799 | 1998-04-30 | 1997-12-12 | Zaragoza | Katharine V. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
14800 | 14800 | 1998-04-30 | 1997-12-12 | de Gramont | Jacqueline | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
16025 | 16025 | 1996-05-10 | 1991-12-05 | Maguffee | Paul R. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
17239 | 17239 | 1997-05-27 | 1994-12-07 | Bjorklund | Andrea K. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
20540 | 20540 | 1990-06-29 | 1989-12-01 | Remmes | Paul T. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
29880 | 29880 | 1997-09-15 | 1987-03-23 | Aldonas | Grant D. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
31144 | 31144 | 1996-09-30 | 1991-05-31 | Rothstein | Amy L. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
36710 | 36710 | 1988-11-30 | 1986-09-19 | Curtiss | Catherine | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
36714 | 36714 | 1988-11-30 | 1984-10-31 | Bickwit | Leonard , Jr. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
37889 | 37889 | 1994-12-07 | 1989-12-01 | Ferneau | Philip J. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
37890 | 37890 | 1994-12-07 | 1991-12-05 | Lykos | Angela | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
41001 | 41001 | 1996-12-31 | 1994-12-07 | Lockwood | Carol E. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
41058 | 41058 | 1997-12-31 | 1991-09-27 | Benson | Stuart E. | Miller & Chevalier, Chartered 3626 | 1984-10-31 | Miller & Chevalier, Chartered | 655 - 15th Street, N.W. | Suite 900 | Washington | DC | 20005-5701 |
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]) );