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

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
2945 2945 2006-01-05 2004-05-28 Tobin Bethanie R. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
3002 3002 2006-01-06 2005-11-15 Dowd James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
3042 3042 2005-01-07 2004-05-28 Carpenter Alana 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
4472 4472 2008-01-30 2005-11-15 Glavin Laurie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
5986 5986 2008-02-08 2004-05-28 Hiselman Jay 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6301 6301 2003-02-13 2002-08-01 Furman Chere (Glynn) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6511 6511 2007-02-15 2006-12-01 Harris Elaine 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7734 7734 2007-02-28 2006-12-01 Butterworth Lauren 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7997 7997 2008-02-29 2007-03-30 Boyd Laurel 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7998 7998 2008-02-29 2007-03-30 Giano Carmela Linda 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7999 7999 2008-02-29 2007-03-30 Lee Christopher 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8000 8000 2008-02-29 2007-03-30 Maltese Marissa 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8001 8001 2008-02-29 2007-03-30 Murphy John Neil 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8002 8002 2008-02-29 2007-03-30 Savage Matthew 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8003 8003 2008-02-29 2007-03-30 Schwantner James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8004 8004 2008-02-29 2007-03-30 Thompson Katie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8005 8005 2008-02-29 2008-03-31 Cieto Sarah 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8006 8006 2008-02-29 2008-03-31 Depiano Danielle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8008 8008 2008-02-29 2004-05-28 Hartrich James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8009 8009 2008-02-29 2004-05-28 Hayes Andrea M. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8010 8010 2008-02-29 2004-05-28 Hunter Sally 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8011 8011 2008-02-29 2004-05-28 Lorenzet Donald J. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8013 8013 2008-02-29 2002-08-01 Ancevic Michael 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8014 8014 2008-02-29 2002-08-01 Rollick Lee Fraser 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8015 8015 2008-02-29 2002-08-01 Williamson Jeffrey 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8021 8021 2008-02-29 2007-09-27 Berard Nicole 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8022 8022 2008-02-29 2007-09-27 Frazier Liz 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8023 8023 2008-02-29 2007-09-27 Madden Christian 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8024 8024 2008-02-29 2007-09-27 Mangus Catherine E. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8025 8025 2008-02-29 2007-09-27 Mellgren Erik 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8026 8026 2008-02-29 2007-09-27 Merke Tonya 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8027 8027 2008-02-29 2007-09-27 Puls Colleen 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8028 8028 2008-02-29 2007-09-27 Russell Adam 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8029 8029 2008-02-29 2007-09-27 Sumner Sarah 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8031 8031 2008-02-29 2004-09-28 Hodgson Andrea Johnson 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8033 8033 2008-02-29 2006-12-01 Rose Heather 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
9071 9071 2005-03-11 2004-09-28 Sutera Jessica 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
10206 10206 2003-03-26 2002-08-01 Martin Kathy 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
10359 10359 2003-03-28 2002-08-01 Roper Tim D. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
12318 12318 2007-04-09 2007-03-30 Przybyl Regan 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
13422 13422 2007-04-27 2006-12-01 Browning Brit 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
14946 14946 2007-05-07 2007-03-30 Dickens Kelly 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
14947 14947 2007-05-07 2006-12-01 Laliberte Sandra 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
16141 16141 2007-05-25 2006-12-01 Shaughnessy Mike 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
18019 18019 2007-06-08 2007-03-30 Kim Robin M. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
20475 20475 2006-06-30 2004-09-28 Richards Jessica 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
24660 24660 2002-08-05 2002-08-01 Gallagher Danielle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
24983 24983 2006-08-09 2005-11-15 Anderson Sara 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
25728 25728 2007-08-20 2006-12-01 Baxter Jeffrey J. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
26147 26147 2007-08-27 2006-12-01 Healy Eric 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27510 27510 2002-09-01 2002-08-01 Eckman Jon 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27511 27511 2002-09-01 2002-08-01 Savage Leonard J. (Leo) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
28460 28460 2006-09-15 2005-11-15 McCulloch Courtney 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
31533 31533 2007-10-17 2007-09-27 Desmond Katherin 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
33544 33544 2005-11-03 2004-05-28 Castrichini Lori 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
33602 33602 2003-11-04 2002-08-01 Alexander Charles (Chuck) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
34117 34117 2005-11-14 2004-09-28 Demers Amy 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
34251 34251 2005-11-15 2005-11-15 Fargo Michelle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
35896 35896 2002-12-02 2002-08-01 Shortt Leslie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
37070 37070 2005-12-20 2004-05-28 Sechko David 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
37491 37491 2005-12-28 2004-05-28 Phillips Amal Elbadawi 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
39485 39485 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)
);