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

17 rows where City = "Torrance" and State = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Last_Name, Registration_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

City 1

  • Torrance · 17 ✖
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
2035 2035   2021-10-26 Nazary Ali International Office of the National Resistance Front of AFGH Inc. 7030 2021-10-26 International Office of the National Resistance Front of AFGH Inc. 4216 Pacific Coast Highway P.O. Box 10301 Torrance CA 90505
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
16392 16392 1985-05-15 1985-05-15 Barsby Robert S. Korea Machinery Corporation 3335 1982-02-24 Korea Machinery Corporation 3011 Lomita Boulevard   Torrance CA 90505
31562 31562 2014-09-30 2014-06-02 Khan Mohammed Beltway Government Strategies Inc. 6225 2014-06-02 Beltway Government Strategies Inc. 3655 Torrance Blvd. Suite 300 Torrance CA 90503
31563 31563 2014-09-30 2014-06-02 Skarulis Mark Beltway Government Strategies Inc. 6225 2014-06-02 Beltway Government Strategies Inc. 3655 Torrance Blvd. Suite 300 Torrance CA 90503
31567 31567 2014-09-30 2014-08-14 Zuberi Imaad Beltway Government Strategies Inc. 6225 2014-06-02 Beltway Government Strategies Inc. 3655 Torrance Blvd. Suite 300 Torrance CA 90503
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])
);