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 = "Madison"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2823 | 2823 | 2004-01-01 | 2003-08-20 | Madison | Alan M. | Madison & Company, LLC 5577 | 2003-08-20 | Madison & Company, LLC | 1101 Pennsylvania Avenue, N.W. | Suite 700 | Washington | DC | 20004 |
7554 | 7554 | 2012-02-24 | 2007-01-18 | Madison | Alan M. | Madison & Company, LLC 5770 | 2006-09-26 | Madison & Company, LLC | 815 Connecticut Avenue, NW | Suite 220 | Washington | DC | 20006 |
7657 | 7657 | 2022-02-25 | 2018-04-19 | Madison | George W. | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
16916 | 16916 | 2018-05-22 | 2017-10-24 | Madison | Alan M. | Madison & Company LLC 6478 | 2017-10-24 | Madison & Company LLC | 815 Connecticut Avenue, NW | Suite 220 | Washington | DC | 20006 |
18561 | 18561 | 2014-06-01 | 2014-06-10 | Madison | Al | Greenberg Traurig, LLP 5712 | 2005-10-03 | Greenberg Traurig, LLP | 2101 L Street, NW | Suite 1000 | Washington | DC | 20037 |
28365 | 28365 | 2000-08-31 | 1998-08-13 | Madison | Alan | DCS Group 5269 | 1998-08-13 | DCS Group | 410 First Street, S.E. | 3rd Floor | Washington | DC | 20003 |
28417 | 28417 | 2002-08-31 | 2001-08-17 | Madison | Alan | Dutko Group Companies, Inc. 5452 | 2001-08-17 | Dutko Group Companies, Inc. | 412 First Street, S.E. | Washington | DC | 20003 | |
30158 | 30158 | 2002-09-20 | 2002-04-10 | Madison | Alan | DCS Group 5493 | 2002-04-10 | DCS Group | 410 First Street, S.E. | Third Floor | Washington | DC | 20003 |
40726 | 40726 | 1991-12-31 | 1987-11-19 | Madison | Cliff | Cliff Madison Government Relations, Inc. 4060 | 1987-11-19 | Cliff Madison Government Relations, Inc. | 208-A Justice Court, N.E. | Washington | DC | 20002 |
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]) );