home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

19 rows where Registration_Number = 2645

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Date (date)

State 1

  • DC 19

Registration_Number 1

  • British Aerospace, Inc. · 19 ✖

Registrant_Name 1

  • British Aerospace, Inc. 19

City 1

  • Washington 19
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

CSV options:

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])
);
Powered by Datasette · Queries took 651.135ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows