FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Short_Form_Last_Name = "Gillespie"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8446 | 8446 | 1952-02-29 | 1949-10-06 | Gillespie | John Austin | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
9156 | 9156 | 1980-03-05 | 1980-01-21 | Gillespie | Thomas E. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12838 | 12838 | 1993-04-06 | 1993-04-06 | Gillespie | Janice E. | Major Exports, Inc. 4787 | 1993-04-06 | Major Exports, Inc. | 7987 Northwest 33rd Street | Miami | FL | 33122 | |
16434 | 16434 | 2001-05-15 | 1999-05-18 | Gillespie | Kelly | Oestreicher, Michael R. 3426 | 1982-12-08 | Oestreicher, Michael R. | 312 Walnut Street | Suite 1400 | Cincinnati | OH | 45202 |
26240 | 26240 | 1966-08-08 | 1961-12-12 | Gillespie | McDonald | Batten, Barton, Durstine & Osborn, Inc. 1104 | 1958-01-13 | Batten, Barton, Durstine & Osborn, Inc. | 383 Madison Avenue | New York | NY | ||
30498 | 30498 | 1985-09-26 | 1978-02-07 | Gillespie | Rodger W. | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
31052 | 31052 | 1990-09-30 | 1990-04-04 | Gillespie | Cynthia D. | King & Spalding 4352 | 1990-03-16 | King & Spalding | 1730 Pennsylvania Avenue, N.W. | Suite 1200 | Washington | DC | 20006 |
37759 | 37759 | 2021-12-04 | 2022-06-27 | Gillespie | McKinley | Blue Crab Strategies LLC 7027 | 2021-10-18 | Blue Crab Strategies LLC | 1415 Chapin St. NW | #208 | Washington | DC | 20009 |
38673 | 38673 | 2000-12-18 | 1993-10-18 | Gillespie | Maureen | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 |
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]) );