FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_Last_Name = "Brooks"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1904 | 1904 | 2022-10-06 | Brooks | Charles Isaac | The Brooks Law Firm PC 7178 | 2022-10-06 | The Brooks Law Firm PC | 275 FOREST ROAD | SUITE 100 | HUEYTOWN | AL | 35023 | |
6566 | 6566 | 1992-02-10 | 1975-08-21 | Brooks | Russell E. | Milbank, Tweed, Hadley & McCloy 1839 | 1965-01-11 | Milbank, Tweed, Hadley & McCloy | 1 Chase Manhattan Plaza | New York | NY | 10005 | |
8007 | 8007 | 1994-02-28 | 1992-08-12 | Brooks | Vanessa J. | East-West Innovations, Inc. 4704 | 1992-08-12 | East-West Innovations, Inc. | 4201 Cathedral, N.W. | Suite 717W | Washington | DC | 20016 |
8410 | 8410 | 2021-02-28 | 2020-02-24 | Brooks | Aaron | Linklaters LLP 6795 | 2020-02-24 | Linklaters LLP | One Silk Street | London | |||
11560 | 11560 | 1987-03-31 | 1984-04-03 | Brooks | Elizabeth C. | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. 3306 | 1981-11-20 | Wexler, Reynolds, Fuller, Harrison & Schule, Inc. | 1317 F Street, N.W. | Suite 600 | Washington | DC | 20004 |
20615 | 20615 | 1946-06-30 | 1945-12-20 | Brooks | Alfred | Falkowski, Edward J. 283 | 1944-11-10 | Falkowski, Edward J. | 50 Rockefeller Plaza | New York | NY | ||
23577 | 23577 | 2019-07-18 | 2019-10-04 | Brooks | Cristina | Rokk Solutions, LLC 6320 | 2015-09-29 | Rokk Solutions, LLC | 1701 K Street, NW | Suite 650 | Washington | DC | 20006 |
27937 | 27937 | 1977-08-31 | 1968-02-02 | Brooks | Leslie Gail | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
31482 | 31482 | 2009-09-30 | 2009-10-30 | Brooks | Caroline | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
36784 | 36784 | 1995-11-30 | 1988-03-28 | Brooks | Teresa A. | Dykema Gossett 4112 | 1988-03-28 | Dykema Gossett | 1300 I Street, N.W. | Franklin Sq., Suite 300 West | Washington | DC | 20005 |
41426 | 41426 | 2005-12-31 | 2005-06-24 | Brooks | Leigh | Kemp Partners 5690 | 2005-06-24 | Kemp Partners | 1901 Pennsylvania Avenue, NW | Suite 300 | Washington | DC | 20006 |
42122 | 42122 | 2017-12-31 | 2017-05-09 | Brooks | Jeri J. | BCW LLC 6227 | 2014-06-18 | BCW LLC | 1801 K Street, NW | 9th Floor | 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]) );