FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Last_Name = "Lieberman"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Date (date), Registration_Date (date)
Registration_Number 7
Registrant_Name 7
City 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6343 | 6343 | 2014-02-07 | 2013-11-19 | Lieberman | Joseph I. | Kasowitz, Benson, Torres and Friedman, LLP 6197 | 2013-11-19 | Kasowitz, Benson, Torres and Friedman, LLP | 1633 Broadway Avenue | 22nd Floor | New York | NY | 10019 |
8334 | 8334 | 2018-02-28 | 2017-07-28 | Lieberman | Jordan S. | Audience Partners Worldwide, LLC 6448 | 2017-07-28 | Audience Partners Worldwide, LLC | 630 W. Germantown Pike | Suite 250 | Plymouth Meeting | PA | 19462 |
11578 | 11578 | 1988-03-31 | 1986-02-20 | Lieberman | Marianne | O'Leary Clarke & Partners, Inc. 3780 | 1986-02-20 | O'Leary Clarke & Partners, Inc. | 111 West 40th Street | 18th Floor | New York | NY | 10018 |
11656 | 11656 | 1992-03-31 | 1983-01-10 | Lieberman | Edward H. | Cole Corette & Abrutyn, P.C. 2968 | 1978-10-18 | Cole Corette & Abrutyn, P.C. | 805 - 15th Street, N.W, | Suite 900 | Washington | DC | 20005 |
13387 | 13387 | 1980-04-15 | 1980-04-16 | Lieberman | Michael L. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
17248 | 17248 | 2011-05-27 | 2011-04-15 | Lieberman | Anne W. | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
17951 | 17951 | 2001-05-31 | 1998-11-06 | Lieberman | Edward | Coudert Brothers 5254 | 1998-04-23 | Coudert Brothers | 1627 I Street, 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]) );