FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Short_Form_Last_Name = "Shannon"
This data as json, CSV (advanced)
Suggested facets: Address_2, Short_Form_Termination_Date (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3269 | 3269 | 1978-01-06 | 1974-03-12 | Shannon | Thomas F. | Collier, Shannon, Rill, Edwards & Scott 2504 | 1974-03-12 | Collier, Shannon, Rill, Edwards & Scott | 1055 Thomas Jeff. Street, N.W. | Washington | DC | 20007 | |
8973 | 8973 | 1994-03-02 | 1986-08-19 | Shannon | Edfred L. , Jr. | Santa Fe (U.S. Holdings) Inc. 3841 | 1986-06-06 | Santa Fe (U.S. Holdings) Inc. | Two Lincoln Centre | 5420 LBJ Freeway, Suite 1100 | Dallas | TX | 75240-2648 |
19372 | 19372 | 2023-06-13 | 2023-02-03 | Shannon | Kathleen Hunter | Akerman LLP 7227 | 2023-02-03 | Akerman LLP | Three Brickell City Centre 98 SE 7th Street | Suite 1100 | Miami | FL | 33131 |
28814 | 28814 | 1981-09-01 | 1978-07-20 | Shannon | Thomas F. | Collier, Shannon, Rill, Edwards & Scott, Chartered 2937 | 1978-08-02 | Collier, Shannon, Rill, Edwards & Scott, Chartered | 1055 Thomas Jeff. Street, N.W. | Washington | DC | 20007 | |
31854 | 31854 | 1979-10-01 | 1978-01-17 | Shannon | Thomas F. | deKieffer & Associates, P.C. 2857 | 1978-01-17 | deKieffer & Associates, P.C. | 1055 Thomas Jeff. Street, N.W. | Washington | DC | 20007 | |
40789 | 40789 | 1994-12-31 | 1985-06-24 | Shannon | Thomas F. | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | 3050 K Street N.W. | Suite 400 | Washington | DC | 20007-5108 |
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]) );