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

25 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
732 732   2020-04-27 Dienel Robin 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
733 733   2020-04-27 Hauptman James 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
734 734   2020-04-27 Hill Eliza 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
982 982   2021-05-28 Dyer Jacqueline 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
989 989   2021-05-28 Kiss Benita 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
996 996   2021-05-28 Widing Elsie 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
2105 2105   2019-11-20 Martin Joseph Quinn 6753 6753 2019-11-20 Frontier Consulting, LLC 53 Westview Road   Damariscotta ME 04543
4001 4001 1982-01-21 1979-07-26 Bull Robert L. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
4002 4002 1982-01-21 1979-07-26 Johnson Brenda W. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
4003 4003 1982-01-21 1979-07-29 Bull Stephen R. 3085 3085 1979-07-26 Food Business Associates, Inc. Santa Claus Lake   Temple ME 04984
12378 12378 1979-04-06 1979-04-09 Martin Mary V. 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
13735 13735 2020-04-27 2020-04-27 Philbrook Chris 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
21610 21610 2020-07-01 2020-11-23 Coleman Cameron 6818 6818 2020-04-27 Blaze Partners, LLC 106 Lafayette Street Ste IB, Yarmouth ME 04096
27298 27298 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
27299 27299 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
28228 28228 1979-09-05 1974-09-05 Andersen Torben K. 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
29375 29375 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
29376 29376 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
29377 29377 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
29378 29378 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
29379 29379 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
31746 31746 1978-10-15 1974-09-05 Miller Isabell 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
31747 31747 1978-10-15 1971-10-18 Breitenberg Lynn 2533 2533 1974-09-05 Marketing International, Ltd. 616 Forest Avenue   Portland ME 04102
34569 34569 1989-11-14 1988-02-16 Doyle Jon R. 4091 4091 1988-02-16 Doyle & Nelson 150 Capitol Street   Augusta ME 04330
34570 34570 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])
);