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, atom, 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
3092 3092 2006-01-05 2004-05-28 Tobin Bethanie R. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
3149 3149 2006-01-06 2005-11-15 Dowd James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
3188 3188 2005-01-07 2004-05-28 Carpenter Alana 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
4570 4570 2008-01-30 2005-11-15 Glavin Laurie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6030 6030 2008-02-08 2004-05-28 Hiselman Jay 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6340 6340 2003-02-13 2002-08-01 Furman Chere (Glynn) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
6549 6549 2007-02-15 2006-12-01 Harris Elaine 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7721 7721 2007-02-28 2006-12-01 Butterworth Lauren 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7935 7935 2008-02-29 2007-03-30 Boyd Laurel 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7936 7936 2008-02-29 2007-03-30 Giano Carmela Linda 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7937 7937 2008-02-29 2007-03-30 Lee Christopher 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7938 7938 2008-02-29 2007-03-30 Maltese Marissa 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7939 7939 2008-02-29 2007-03-30 Murphy John Neil 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7940 7940 2008-02-29 2007-03-30 Savage Matthew 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7941 7941 2008-02-29 2007-03-30 Schwantner James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7942 7942 2008-02-29 2007-03-30 Thompson Katie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7943 7943 2008-02-29 2008-03-31 Cieto Sarah 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7944 7944 2008-02-29 2008-03-31 Depiano Danielle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7946 7946 2008-02-29 2004-05-28 Hartrich James 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7947 7947 2008-02-29 2004-05-28 Hayes Andrea M. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7948 7948 2008-02-29 2004-05-28 Hunter Sally 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7949 7949 2008-02-29 2004-05-28 Lorenzet Donald J. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7951 7951 2008-02-29 2002-08-01 Ancevic Michael 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7952 7952 2008-02-29 2002-08-01 Rollick Lee Fraser 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7953 7953 2008-02-29 2002-08-01 Williamson Jeffrey 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7959 7959 2008-02-29 2007-09-27 Berard Nicole 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7960 7960 2008-02-29 2007-09-27 Frazier Liz 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7961 7961 2008-02-29 2007-09-27 Madden Christian 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7962 7962 2008-02-29 2007-09-27 Mangus Catherine E. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7963 7963 2008-02-29 2007-09-27 Mellgren Erik 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7964 7964 2008-02-29 2007-09-27 Merke Tonya 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7965 7965 2008-02-29 2007-09-27 Puls Colleen 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7966 7966 2008-02-29 2007-09-27 Russell Adam 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7967 7967 2008-02-29 2007-09-27 Sumner Sarah 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7969 7969 2008-02-29 2004-09-28 Hodgson Andrea Johnson 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
7971 7971 2008-02-29 2006-12-01 Rose Heather 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
8991 8991 2005-03-11 2004-09-28 Sutera Jessica 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
10118 10118 2003-03-26 2002-08-01 Martin Kathy 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
10265 10265 2003-03-28 2002-08-01 Roper Tim D. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
12184 12184 2007-04-09 2007-03-30 Przybyl Regan 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
13274 13274 2007-04-27 2006-12-01 Browning Brit 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
14717 14717 2007-05-07 2007-03-30 Dickens Kelly 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
14718 14718 2007-05-07 2006-12-01 Laliberte Sandra 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
15889 15889 2007-05-25 2006-12-01 Shaughnessy Mike 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
17726 17726 2007-06-08 2007-03-30 Kim Robin M. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
20164 20164 2006-06-30 2004-09-28 Richards Jessica 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
24222 24222 2002-08-05 2002-08-01 Gallagher Danielle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
24540 24540 2006-08-09 2005-11-15 Anderson Sara 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
25261 25261 2007-08-20 2006-12-01 Baxter Jeffrey J. 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
25658 25658 2007-08-27 2006-12-01 Healy Eric 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27001 27001 2002-09-01 2002-08-01 Eckman Jon 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27002 27002 2002-09-01 2002-08-01 Savage Leonard J. (Leo) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
27941 27941 2006-09-15 2005-11-15 McCulloch Courtney 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
30950 30950 2007-10-17 2007-09-27 Desmond Katherin 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
32899 32899 2005-11-03 2004-05-28 Castrichini Lori 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
32957 32957 2003-11-04 2002-08-01 Alexander Charles (Chuck) 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
33464 33464 2005-11-14 2004-09-28 Demers Amy 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
33598 33598 2005-11-15 2005-11-15 Fargo Michelle 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
35175 35175 2002-12-02 2002-08-01 Shortt Leslie 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
36326 36326 2005-12-20 2004-05-28 Sechko David 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
36744 36744 2005-12-28 2004-05-28 Phillips Amal Elbadawi 5512 5512 2002-08-01 Mullen 36 Essex Street   Wenham MA 01984
38737 38737 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 323.78ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history