FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where City = "Arlington" and Short_Form_Termination_Date = "2001-02-28"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8123 | 8123 | 2001-02-28 | 1993-03-25 | Noyes | Pamela Diane | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8125 | 8125 | 2001-02-28 | 1999-03-26 | Brown | Shanna M. | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8126 | 8126 | 2001-02-28 | 1999-03-26 | Murray | Thomas P. | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8127 | 8127 | 2001-02-28 | 2000-03-29 | Brill, II | Richard Budd | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8128 | 8128 | 2001-02-28 | 2001-04-19 | Staiti | Gregory Richard | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8129 | 8129 | 2001-02-28 | 2001-04-19 | Wan-Ling Lie | Sharyn | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8136 | 8136 | 2001-02-28 | 1997-09-19 | Director | Syril | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8137 | 8137 | 2001-02-28 | 1992-09-25 | Allemang | Diane | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8138 | 8138 | 2001-02-28 | 1995-09-25 | Tyler | Seth Daniel | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8139 | 8139 | 2001-02-28 | 1996-09-26 | Walsh | Scott Andrew | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8140 | 8140 | 2001-02-28 | 2000-09-27 | Boshes | Alison | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8141 | 8141 | 2001-02-28 | 1993-09-28 | Dennis | Sherri Buttrey | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8142 | 8142 | 2001-02-28 | 1993-09-28 | Schloesser | Christopher John | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
8143 | 8143 | 2001-02-28 | 1993-09-28 | Stephens | Stephanie Holmes | Jellinek, Schwartz & Connolly, Inc. 4345 | 1990-02-23 | Jellinek, Schwartz & Connolly, Inc. | 1525 Wilson Boulevard | Suite 600 | Arlington | VA | 22209 |
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]) );