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
720 720   2020-04-27 Dienel Robin 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
721 721   2020-04-27 Hauptman James 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
722 722   2020-04-27 Hill Eliza 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
1909 1909   2019-11-20 Martin Joseph Quinn 6753 6753 2019-11-20 Frontier Consulting, LLC 53 Westview Road   Damariscotta ME 04543
3837 3837 1982-01-21 1979-07-26 Bull Robert L. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
3838 3838 1982-01-21 1979-07-26 Johnson Brenda W. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
3839 3839 1982-01-21 1979-07-29 Bull Stephen R. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
12093 12093 1979-04-06 1979-04-09 Martin Mary V. 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
13430 13430 2020-04-27 2020-04-27 Philbrook Chris 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
21198 21198 2020-07-01 2020-11-23 Coleman Cameron 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
26869 26869 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
26870 26870 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
27786 27786 1979-09-05 1974-09-05 Andersen Torben K. 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
28930 28930 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
28931 28931 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
28932 28932 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
28933 28933 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
28934 28934 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
31290 31290 1978-10-15 1974-09-05 Miller Isabell 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
31291 31291 1978-10-15 1971-10-18 Breitenberg Lynn 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
34101 34101 1989-11-14 1988-02-16 Doyle Jon R. 4091 4091 1988-02-16 Doyle & Nelson 150 Capitol Street   Augusta ME 04330
34102 34102 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)
);