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

16 rows where Registration_Number = 2542

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_First_Name, Registration_Date (date)

State 1

Registration_Number 1

  • Kearns International · 16 ✖

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
8450 8450 1976-02-29 1975-01-31 Carlson Jack Jay Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
22518 22518 1978-07-03 1977-01-21 Cooper Walter F. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
24692 24692 1978-07-31 1976-02-27 Young Earl B. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
24697 24697 1978-07-31 1975-10-30 Oakes Eugene E. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35272 35272 1979-11-05 1976-04-18 Searby Daniel M. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35273 35273 1979-11-05 1976-04-30 Carlson Jack Jay Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35274 35274 1979-11-05 1975-05-14 Emerson Claudius Lee Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35275 35275 1979-11-05 1978-09-12 Murphy Betty S. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35276 35276 1979-11-05 1974-10-24 Kearns Henry Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35277 35277 1979-11-05 1974-10-24 Ladd Robert D. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35278 35278 1979-11-05 1974-10-24 Malick Dell M. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35279 35279 1979-11-05 1974-10-24 Southard Frank A. , Jr. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35280 35280 1979-11-05 1975-10-30 Drewes Fred J. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35281 35281 1979-11-05 1975-10-30 Goldhar Laura K. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35282 35282 1979-11-05 1975-10-30 Gomory Paul Louis , Jr. Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104
35283 35283 1979-11-05 1975-11-03 Rand Joseph Kearns International 2542 1974-10-24 Kearns International 155 Sansome Street   San Francisco CA 94104

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