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

11 rows where State = "AK"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)

City 3

State 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
12638 12638 1993-04-02 1991-10-21 Breeze Robert A. Robert A. Breeze 4458 1990-12-31 Robert A. Breeze 520 Oceanview Drive   Anchorage AK 99515
14180 14180 1983-04-27 1983-02-25 Clark James F. Alaska Pulp & Resources, Inc. 3449 1983-02-25 Alaska Pulp & Resources, Inc. Post Office Box 1050   Sitka AK 99835
14181 14181 1983-04-27 1983-02-25 Rouse Peter Alaska Pulp & Resources, Inc. 3449 1983-02-25 Alaska Pulp & Resources, Inc. Post Office Box 1050   Sitka AK 99835
14182 14182 1983-04-27 1983-02-25 Silver Steven W. Alaska Pulp & Resources, Inc. 3449 1983-02-25 Alaska Pulp & Resources, Inc. Post Office Box 1050   Sitka AK 99835
14183 14183 1983-04-27 1983-03-04 Heffernan Edward D. Alaska Pulp & Resources, Inc. 3449 1983-02-25 Alaska Pulp & Resources, Inc. Post Office Box 1050   Sitka AK 99835
14184 14184 1983-04-27 1983-03-04 Moseman John H. Alaska Pulp & Resources, Inc. 3449 1983-02-25 Alaska Pulp & Resources, Inc. Post Office Box 1050   Sitka AK 99835
14185 14185 1983-04-27 1983-04-29 Anderson Stanton D. Alaska Pulp & Resources, Inc. 3449 1983-02-25 Alaska Pulp & Resources, Inc. Post Office Box 1050   Sitka AK 99835
14186 14186 1983-04-27 1983-04-29 Davis Robert P. Alaska Pulp & Resources, Inc. 3449 1983-02-25 Alaska Pulp & Resources, Inc. Post Office Box 1050   Sitka AK 99835
14187 14187 1983-04-27 1983-04-29 Hultman D. Eric Alaska Pulp & Resources, Inc. 3449 1983-02-25 Alaska Pulp & Resources, Inc. Post Office Box 1050   Sitka AK 99835
37893 37893 2011-12-07 2008-02-01 Murkowski Frank H. Cedar Group, LLC 5850 2008-02-01 Cedar Group, LLC 1022 Chena Pump Rd.   Fairbanks AK 99707
37894 37894 2011-12-07 2008-02-01 Van Wyhe Leon E. Cedar Group, LLC 5850 2008-02-01 Cedar Group, LLC 1022 Chena Pump Rd.   Fairbanks AK 99707

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