FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

12 rows where Registration_Number = 1784

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date

State 1

Registration_Number 1

  • Compagnie des Bauxites de Guinea · 12 ✖

Registrant_Name 1

City 1

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
13367 13367 1969-04-15 1964-09-01 Dunlay Philip John Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
13368 13368 1969-04-15 1964-09-01 Echols Henry Vance Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
13369 13369 1969-04-15 1964-09-01 Harvey Homer Milton Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
13370 13370 1969-04-15 1964-09-01 Harvey Lawrence Arnold Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
13371 13371 1969-04-15 1964-09-01 Harvey Leo Meyer Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
13372 13372 1969-04-15 1964-09-01 Linden Sidney Keith Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
13373 13373 1969-04-15 1965-09-30 Rosenblatt Jack Ross Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
13374 13374 1969-04-15 1967-10-03 Mills Eugene Arthur Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
13375 13375 1969-04-15 1967-10-04 Overbeck R.S. Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
14129 14129 1966-04-26 1965-09-30 Heckmann Howard Leonard Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
33459 33459 1966-10-23 1966-09-26 Crystal David Solomon Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509
33460 33460 1966-10-23 1965-09-30 Donias Claire Harry (Clearchos H.) Compagnie des Bauxites de Guinea 1784 1964-09-01 Compagnie des Bauxites de Guinea 19200 South Western Avenue   Torrance CA 90509

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])
);