FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Termination_Date = "1972-03-28"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_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 |
10935 | 10935 | 1972-03-28 | 1966-08-01 | Watts | James W. | Swedish-American Chamber of Commerce, Inc. 13 | 1942-07-06 | Swedish-American Chamber of Commerce, Inc. | 250 Park Avenue | New York | NY | 10017 | |
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 |
10938 | 10938 | 1972-03-28 | 1971-11-08 | Brandt | John | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 |
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]) );