FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where Address_2 = "Suite 304" and Registrant_Name = "GM Washington Consultants, Inc."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10931 | 10931 | 1972-03-28 | 1971-06-03 | Murphy | George L. | GM Washington Consultants, Inc. 2261 | 1971-06-03 | GM Washington Consultants, Inc. | 905 - 16th Street, N.W. | Suite 304 | Washington | DC | 20006 |
10932 | 10932 | 1972-03-28 | 1971-06-29 | Buttram | Jack E. | GM Washington Consultants, Inc. 2261 | 1971-06-03 | GM Washington Consultants, Inc. | 905 - 16th Street, N.W. | Suite 304 | Washington | DC | 20006 |
10933 | 10933 | 1972-03-28 | 1971-07-19 | Newton | Hugh C. | GM Washington Consultants, Inc. 2261 | 1971-06-03 | GM Washington Consultants, Inc. | 905 - 16th Street, N.W. | Suite 304 | Washington | DC | 20006 |
10934 | 10934 | 1972-03-28 | 1971-07-30 | Copp | DeWitt S. | GM Washington Consultants, Inc. 2261 | 1971-06-03 | GM Washington Consultants, Inc. | 905 - 16th Street, N.W. | Suite 304 | Washington | DC | 20006 |
10936 | 10936 | 1972-03-28 | 1971-08-03 | McNair | Roy Perrin | GM Washington Consultants, Inc. 2261 | 1971-06-03 | GM Washington Consultants, Inc. | 905 - 16th Street, N.W. | Suite 304 | Washington | DC | 20006 |
10937 | 10937 | 1972-03-28 | 1971-08-05 | Burleson | Malcolm M. | GM Washington Consultants, Inc. 2261 | 1971-06-03 | GM Washington Consultants, Inc. | 905 - 16th Street, N.W. | Suite 304 | 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]) );