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

21 rows where State = "ME"

View and edit SQL

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

Registration_Number

State

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
819   2020-04-27 Dienel Robin 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
820   2020-04-27 Hauptman James 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
821   2020-04-27 Hill Eliza 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
822   2020-04-27 Philbrook Chris 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
1677   2014-09-24 Fibich Don 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
1678   2014-09-24 LaVallee Derek 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
1679   2014-09-24 Philbrook Christopher 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
1680   2014-09-24 Sommer Leah 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
1682   2014-09-24 Ventura Dan 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
2073   2019-11-20 Martin Joseph Quinn 6753 6753 2019-11-20 Frontier Consulting, LLC 53 Westview Road   Damariscotta ME 04543
3967 1982-01-21 1979-07-26 Bull Robert L. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
3968 1982-01-21 1979-07-26 Johnson Brenda W. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
3969 1982-01-21 1979-07-29 Bull Stephen R. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
12042 1979-04-06 1979-04-09 Martin Mary V. 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
26534 1995-08-31 1990-02-06 Doyle Jon R. 4337 4337 1990-02-06 Doyle & Nelson 150 Capitol Street Post Office Box 2709 Augusta ME 04338-2709
26535 1995-08-31 1990-02-06 Nelson Craig H. 4337 4337 1990-02-06 Doyle & Nelson 150 Capitol Street Post Office Box 2709 Augusta ME 04338-2709
27435 1979-09-05 1974-09-05 Andersen Torben K. 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
30891 1978-10-15 1974-09-05 Miller Isabell 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
30892 1978-10-15 1971-10-18 Breitenberg Lynn 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
33645 1989-11-14 1988-02-16 Doyle Jon R. 4091 4091 1988-02-16 Doyle & Nelson 150 Capitol Street   Augusta ME 04330
33646 1989-11-14 1988-02-16 Nelson Craig H. 4091 4091 1988-02-16 Doyle & Nelson 150 Capitol Street   Augusta ME 04330

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 · Query took 323.433ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history