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

22 rows where State = "ME"

✎ View and edit SQL

This data as json, CSV (advanced)

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
656 656   2020-04-27 Dienel Robin 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
657 657   2020-04-27 Hauptman James 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
658 658   2020-04-27 Hill Eliza 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
659 659   2020-04-27 Philbrook Chris 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
1989 1989   2019-11-20 Martin Joseph Quinn 6753 6753 2019-11-20 Frontier Consulting, LLC 53 Westview Road   Damariscotta ME 04543
2012 2012   2020-11-23 Coleman Cameron 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
3853 3853 1982-01-21 1979-07-26 Bull Robert L. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
3854 3854 1982-01-21 1979-07-26 Johnson Brenda W. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
3855 3855 1982-01-21 1979-07-29 Bull Stephen R. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
12073 12073 1979-04-06 1979-04-09 Martin Mary V. 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
26766 26766 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
26767 26767 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
27680 27680 1979-09-05 1974-09-05 Andersen Torben K. 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
28821 28821 2014-09-24 2014-09-24 Fibich Don 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
28822 28822 2014-09-24 2014-09-24 LaVallee Derek 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
28823 28823 2014-09-24 2014-09-24 Philbrook Christopher 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
28824 28824 2014-09-24 2014-09-24 Sommer Leah 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
28825 28825 2014-09-24 2014-09-24 Ventura Dan 6252 6252 2014-09-24 Kemp Goldberg Partners, LLC 280 Fore Street Suite 301 Portland ME 04101
31168 31168 1978-10-15 1974-09-05 Miller Isabell 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
31169 31169 1978-10-15 1971-10-18 Breitenberg Lynn 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
33966 33966 1989-11-14 1988-02-16 Doyle Jon R. 4091 4091 1988-02-16 Doyle & Nelson 150 Capitol Street   Augusta ME 04330
33967 33967 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)
);