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

62 rows where City = "Wenham"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State

Registration_Number

Registrant_Name

City

  • Wenham · 62 ✖
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
3142 3142 2006-01-05 2004-05-28 Tobin Bethanie R. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
3199 3199 2006-01-06 2005-11-15 Dowd James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
3238 3238 2005-01-07 2004-05-28 Carpenter Alana 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
4633 4633 2008-01-30 2005-11-15 Glavin Laurie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6123 6123 2008-02-08 2004-05-28 Hiselman Jay 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6435 6435 2003-02-13 2002-08-01 Furman Chere (Glynn) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6644 6644 2007-02-15 2006-12-01 Harris Elaine 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7830 7830 2007-02-28 2006-12-01 Butterworth Lauren 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8051 8051 2008-02-29 2007-03-30 Boyd Laurel 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8052 8052 2008-02-29 2007-03-30 Giano Carmela Linda 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8053 8053 2008-02-29 2007-03-30 Lee Christopher 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8054 8054 2008-02-29 2007-03-30 Maltese Marissa 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8055 8055 2008-02-29 2007-03-30 Murphy John Neil 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8056 8056 2008-02-29 2007-03-30 Savage Matthew 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8057 8057 2008-02-29 2007-03-30 Schwantner James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8058 8058 2008-02-29 2007-03-30 Thompson Katie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8059 8059 2008-02-29 2008-03-31 Cieto Sarah 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8060 8060 2008-02-29 2008-03-31 Depiano Danielle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8062 8062 2008-02-29 2004-05-28 Hartrich James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8063 8063 2008-02-29 2004-05-28 Hayes Andrea M. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8064 8064 2008-02-29 2004-05-28 Hunter Sally 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8065 8065 2008-02-29 2004-05-28 Lorenzet Donald J. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8067 8067 2008-02-29 2002-08-01 Ancevic Michael 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8068 8068 2008-02-29 2002-08-01 Rollick Lee Fraser 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8069 8069 2008-02-29 2002-08-01 Williamson Jeffrey 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8075 8075 2008-02-29 2007-09-27 Berard Nicole 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8076 8076 2008-02-29 2007-09-27 Frazier Liz 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8077 8077 2008-02-29 2007-09-27 Madden Christian 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8078 8078 2008-02-29 2007-09-27 Mangus Catherine E. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8079 8079 2008-02-29 2007-09-27 Mellgren Erik 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8080 8080 2008-02-29 2007-09-27 Merke Tonya 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8081 8081 2008-02-29 2007-09-27 Puls Colleen 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8082 8082 2008-02-29 2007-09-27 Russell Adam 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8083 8083 2008-02-29 2007-09-27 Sumner Sarah 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8085 8085 2008-02-29 2004-09-28 Hodgson Andrea Johnson 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8087 8087 2008-02-29 2006-12-01 Rose Heather 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
9123 9123 2005-03-11 2004-09-28 Sutera Jessica 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
10254 10254 2003-03-26 2002-08-01 Martin Kathy 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
10407 10407 2003-03-28 2002-08-01 Roper Tim D. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
12358 12358 2007-04-09 2007-03-30 Przybyl Regan 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
13454 13454 2007-04-27 2006-12-01 Browning Brit 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
14960 14960 2007-05-07 2007-03-30 Dickens Kelly 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
14961 14961 2007-05-07 2006-12-01 Laliberte Sandra 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
16143 16143 2007-05-25 2006-12-01 Shaughnessy Mike 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
18004 18004 2007-06-08 2007-03-30 Kim Robin M. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
20448 20448 2006-06-30 2004-09-28 Richards Jessica 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
24555 24555 2002-08-05 2002-08-01 Gallagher Danielle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
24877 24877 2006-08-09 2005-11-15 Anderson Sara 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
25614 25614 2007-08-20 2006-12-01 Baxter Jeffrey J. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
26016 26016 2007-08-27 2006-12-01 Healy Eric 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27367 27367 2002-09-01 2002-08-01 Eckman Jon 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27368 27368 2002-09-01 2002-08-01 Savage Leonard J. (Leo) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
28311 28311 2006-09-15 2005-11-15 McCulloch Courtney 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
31343 31343 2007-10-17 2007-09-27 Desmond Katherin 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
33309 33309 2005-11-03 2004-05-28 Castrichini Lori 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
33367 33367 2003-11-04 2002-08-01 Alexander Charles (Chuck) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
33877 33877 2005-11-14 2004-09-28 Demers Amy 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
34011 34011 2005-11-15 2005-11-15 Fargo Michelle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
35604 35604 2002-12-02 2002-08-01 Shortt Leslie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
36771 36771 2005-12-20 2004-05-28 Sechko David 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
37191 37191 2005-12-28 2004-05-28 Phillips Amal Elbadawi 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
39185 39185 2002-12-31 2002-08-01 Stone Thomas A. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984

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