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_Date (date)

State 1

Registration_Number 1

Registrant_Name 1

City 1

  • 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
3245 3245 2006-01-05 2004-05-28 Tobin Bethanie R. Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
3303 3303 2006-01-06 2005-11-15 Dowd James Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
3375 3375 2005-01-07 2004-05-28 Carpenter Alana Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
4855 4855 2008-01-30 2005-11-15 Glavin Laurie Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6424 6424 2008-02-08 2004-05-28 Hiselman Jay Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6745 6745 2003-02-13 2002-08-01 Furman Chere (Glynn) Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6970 6970 2007-02-15 2006-12-01 Harris Elaine Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8225 8225 2007-02-28 2006-12-01 Butterworth Lauren Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8526 8526 2008-02-29 2007-03-30 Boyd Laurel Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8527 8527 2008-02-29 2007-03-30 Giano Carmela Linda Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8528 8528 2008-02-29 2007-03-30 Lee Christopher Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8529 8529 2008-02-29 2007-03-30 Maltese Marissa Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8530 8530 2008-02-29 2007-03-30 Murphy John Neil Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8531 8531 2008-02-29 2007-03-30 Savage Matthew Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8532 8532 2008-02-29 2007-03-30 Schwantner James Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8533 8533 2008-02-29 2007-03-30 Thompson Katie Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8534 8534 2008-02-29 2008-03-31 Cieto Sarah Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8535 8535 2008-02-29 2008-03-31 Depiano Danielle Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8537 8537 2008-02-29 2004-05-28 Hartrich James Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8538 8538 2008-02-29 2004-05-28 Hayes Andrea M. Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8539 8539 2008-02-29 2004-05-28 Hunter Sally Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8540 8540 2008-02-29 2004-05-28 Lorenzet Donald J. Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8542 8542 2008-02-29 2002-08-01 Ancevic Michael Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8543 8543 2008-02-29 2002-08-01 Rollick Lee Fraser Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8544 8544 2008-02-29 2002-08-01 Williamson Jeffrey Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8550 8550 2008-02-29 2007-09-27 Berard Nicole Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8551 8551 2008-02-29 2007-09-27 Frazier Liz Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8552 8552 2008-02-29 2007-09-27 Madden Christian Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8553 8553 2008-02-29 2007-09-27 Mangus Catherine E. Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8554 8554 2008-02-29 2007-09-27 Mellgren Erik Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8555 8555 2008-02-29 2007-09-27 Merke Tonya Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8556 8556 2008-02-29 2007-09-27 Puls Colleen Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8557 8557 2008-02-29 2007-09-27 Russell Adam Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8558 8558 2008-02-29 2007-09-27 Sumner Sarah Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8560 8560 2008-02-29 2004-09-28 Hodgson Andrea Johnson Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8562 8562 2008-02-29 2006-12-01 Rose Heather Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
9662 9662 2005-03-11 2004-09-28 Sutera Jessica Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
10822 10822 2003-03-26 2002-08-01 Martin Kathy Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
10978 10978 2003-03-28 2002-08-01 Roper Tim D. Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
13054 13054 2007-04-09 2007-03-30 Przybyl Regan Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
14213 14213 2007-04-27 2006-12-01 Browning Brit Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
15855 15855 2007-05-07 2007-03-30 Dickens Kelly Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
15856 15856 2007-05-07 2006-12-01 Laliberte Sandra Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
17098 17098 2007-05-25 2006-12-01 Shaughnessy Mike Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
19078 19078 2007-06-08 2007-03-30 Kim Robin M. Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
21582 21582 2006-06-30 2004-09-28 Richards Jessica Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
25996 25996 2002-08-05 2002-08-01 Gallagher Danielle Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
26322 26322 2006-08-09 2005-11-15 Anderson Sara Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27087 27087 2007-08-20 2006-12-01 Baxter Jeffrey J. Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27529 27529 2007-08-27 2006-12-01 Healy Eric Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
28923 28923 2002-09-01 2002-08-01 Eckman Jon Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
28924 28924 2002-09-01 2002-08-01 Savage Leonard J. (Leo) Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
29896 29896 2006-09-15 2005-11-15 McCulloch Courtney Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
33087 33087 2007-10-17 2007-09-27 Desmond Katherin Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
35178 35178 2005-11-03 2004-05-28 Castrichini Lori Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
35236 35236 2003-11-04 2002-08-01 Alexander Charles (Chuck) Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
35766 35766 2005-11-14 2004-09-28 Demers Amy Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
35900 35900 2005-11-15 2005-11-15 Fargo Michelle Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
37636 37636 2002-12-02 2002-08-01 Shortt Leslie Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
38843 38843 2005-12-20 2004-05-28 Sechko David Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
39271 39271 2005-12-28 2004-05-28 Phillips Amal Elbadawi Mullen 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
41271 41271 2002-12-31 2002-08-01 Stone Thomas A. Mullen 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])
);