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

21 rows where State = "WI"

View and edit SQL

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
155   2020-01-24 Kise Christopher 6787 6787 2020-01-24 Foley & Lardner LLP 777 East Wisconsin Ave.   Milwaukee WI 53202
157   2020-01-24 Swift Christopher 6787 6787 2020-01-24 Foley & Lardner LLP 777 East Wisconsin Ave.   Milwaukee WI 53202
2642 1997-01-01 1996-11-08 Millard Lewin J. 5138 5138 1996-11-08 Brady Company, Inc. N80 W12878 Fond du Lac Avenue Menomonee Falls WI 53051-4410
7208 1991-02-26 1990-07-17 Vaughan Michael R. 4327 4327 1990-01-03 Murphy & Desmond, S.C. 2 East Mifflin Street Post Office Box 2038 Madison WI 53701-2038
7290 1998-02-27 1997-07-01 Fuerstenberg Kelly 5138 5138 1996-11-08 Brady Company, Inc. N80 W12878 Fond du Lac Avenue Menomonee Falls WI 53051-4410
16252 2003-05-30 2003-03-21 Ervin Roger 5546 5546 2003-03-21 Foley & Lardner 150 East Gilman Street   Madison WI 53703-1441
16657 1998-05-31 1996-11-08 Onderak Polly E. 5138 5138 1996-11-08 Brady Company, Inc. N80 W12878 Fond du Lac Avenue Menomonee Falls WI 53051-4410
16658 1998-05-31 1996-11-08 Wall Kathleen A. 5138 5138 1996-11-08 Brady Company, Inc. N80 W12878 Fond du Lac Avenue Menomonee Falls WI 53051-4410
17214 2009-06-01 2009-05-27 Goldate Melissa 5859 5859 2008-04-03 Broydrick & Associates, Inc. 400 E Wisconsin Avenue Suite 400 Milwaukee WI 53202
21423 2010-07-12 2008-04-03 Broydrick William B. 5859 5859 2008-04-03 Broydrick & Associates, Inc. 400 E Wisconsin Avenue Suite 400 Milwaukee WI 53202
21424 2010-07-12 2009-05-27 Broydrick Cynthia 5859 5859 2008-04-03 Broydrick & Associates, Inc. 400 E Wisconsin Avenue Suite 400 Milwaukee WI 53202
21425 2010-07-12 2009-05-27 Oakley Kara 5859 5859 2008-04-03 Broydrick & Associates, Inc. 400 E Wisconsin Avenue Suite 400 Milwaukee WI 53202
21426 2010-07-12 2009-05-27 Starzyk Fred 5859 5859 2008-04-03 Broydrick & Associates, Inc. 400 E Wisconsin Avenue Suite 400 Milwaukee WI 53202
21427 2010-07-12 2009-05-27 Tierney Joelle 5859 5859 2008-04-03 Broydrick & Associates, Inc. 400 E Wisconsin Avenue Suite 400 Milwaukee WI 53202
24921 1997-08-15 1996-11-08 Czarnecki Stephen L. 5138 5138 1996-11-08 Brady Company, Inc. N80 W12878 Fond du Lac Avenue Menomonee Falls WI 53051-4410
29292 2003-09-30 2003-03-21 Klug Scott 5546 5546 2003-03-21 Foley & Lardner 150 East Gilman Street   Madison WI 53703-1441
30315 1963-10-08 1959-10-01 O'Melia Albert Joseph 1279 1279 1959-10-01 O'Melia & Kaye O'Melia Building   Rhinelander WI  
30316 1963-10-08 1959-10-01 O'Melia Donald Clark 1279 1279 1959-10-01 O'Melia & Kaye O'Melia Building   Rhinelander WI  
33690 1983-11-18 1982-04-30 Eisenberg Sydney Michael 3367 3367 1982-04-30 Eisenberg, Sydney Michael 1131 West State Street   Milwaukee WI 53233
35501 1960-12-10 1944-06-10 Chartier Charles 409 409 1944-06-10 Belleau, Wilfrid E. 4141 West Vliet Street   Milwaukee WI  
35502 1960-12-10 1944-06-10 Fowmier Watson A. 409 409 1944-06-10 Belleau, Wilfrid E. 4141 West Vliet Street   Milwaukee WI  

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