FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
19 rows where Address_2 = "Post Office Box 17414" and City = "Washington"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2571 | 2571 | 1976-01-01 | 1976-01-05 | Savage | Michael | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
2574 | 2574 | 1976-01-01 | 1975-12-31 | Dorman | David Allan | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
4516 | 4516 | 1979-01-26 | 1975-12-24 | Gladwell | R.J. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
8721 | 8721 | 1976-03-01 | 1976-04-06 | Berry | Howard | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
14179 | 14179 | 1982-04-27 | 1977-11-28 | Greenwood | Allen H.C. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
15335 | 15335 | 1976-05-01 | 1976-05-24 | Gardner | Charles J.T. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
18416 | 18416 | 1976-06-01 | 1976-01-05 | Gardner | Robert A.C. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27315 | 27315 | 1983-08-24 | 1976-01-05 | Wilde | M.G. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27316 | 27316 | 1983-08-24 | 1976-01-06 | Knight | G.E. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27317 | 27317 | 1983-08-24 | 1978-01-17 | Cochrane | John C. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27318 | 27318 | 1983-08-24 | 1980-08-07 | Nelms | Douglas W. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27319 | 27319 | 1983-08-24 | 1977-10-19 | Berry | Howard | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27320 | 27320 | 1983-08-24 | 1977-10-19 | Gardner | Robert A.C. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27321 | 27321 | 1983-08-24 | 1977-10-19 | McKinlay | R.M. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27322 | 27322 | 1983-08-24 | 1977-10-19 | Savage | Michael | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27323 | 27323 | 1983-08-24 | 1976-11-12 | Richardson | Ian | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27324 | 27324 | 1983-08-24 | 1975-12-24 | Rowlands | T.D. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
27325 | 27325 | 1983-08-24 | 1975-12-24 | Schefer | L.J. | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
28015 | 28015 | 1981-08-31 | 1976-01-19 | Munt | Rodger Thomas | British Aerospace, Inc. 2645 | 1975-12-24 | British Aerospace, Inc. | Dulles International Airport | Post Office Box 17414 | Washington | DC | 20041 |
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]) );