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

191 rows where Registration_Number = 3774

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

State

Registration_Number

  • 3774 · 191 ✖

Registrant_Name

City

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
3181 3181 1999-01-07 1992-03-05 Campbell W. Douglas 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3505 3505 2000-01-14 1999-03-05 Harrower David A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3664 3664 1998-01-16 1986-02-05 Sullivan Richard J. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3665 3665 1998-01-16 1992-03-05 Anderson William K. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3667 3667 1998-01-16 1988-09-01 Epstein Jerry A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3668 3668 1998-01-16 1989-09-05 Van Meter Jan R. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3669 3669 1998-01-16 1993-09-07 Modzelewski Jack (John F.) 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3716 3716 1989-01-17 1988-03-03 de Leon Richard Rueda 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
3849 3849 1998-01-19 1995-09-06 Gonzalez Luis A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4224 4224 1995-01-25 1990-05-14 Morrison Jean Anne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4555 4555 2004-01-30 2002-03-28 Collender Stanley E. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4735 4735 1988-01-31 1986-09-05 White Rene L. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4876 4876 1996-01-31 1993-10-20 Bingol Selim 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4886 4886 1997-01-31 1994-03-04 Sharples Susan 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4906 4906 1998-01-31 1994-09-08 Tuncata Arzu F. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
6758 6758 2000-02-18 1996-09-04 Jennings Malin 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
6830 6830 1998-02-20 1986-02-20 Pearlman Vicki E. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7296 7296 1998-02-27 1988-01-19 Sonnenfeldt Marjorie Hecht 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
7512 7512 1995-02-28 1993-03-05 Sommerfield Frank E. , Jr. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8486 8486 1994-03-04 1992-03-05 Clarkson Pamela A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8487 8487 1994-03-04 1993-03-05 Tucker Brett 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8488 8488 1994-03-04 1992-03-18 Ampolsk Alan G. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8530 8530 1993-03-05 1991-03-07 Levy Jill Anne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8532 8532 1993-03-05 1989-09-05 Bloch Jayne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8533 8533 1993-03-05 1989-09-05 McCabe Ian Richard 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8534 8534 1993-03-05 1989-09-05 Smith Alan Wayne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8535 8535 1993-03-05 1989-09-05 Turner Caren Zeldie 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8536 8536 1993-03-05 1991-09-05 de Tejada Marivi Lerdo 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8537 8537 1993-03-05 1988-10-12 Christy Valerie E. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8591 8591 1992-03-06 1991-03-07 Hamblin Koleen Carole 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8596 8596 1995-03-06 1991-03-07 Hancock Mary 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8599 8599 1995-03-06 1990-05-18 Solymossy Diana Sun 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8768 8768 1997-03-07 1993-09-07 Carpenter Cynthia L. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9055 9055 1998-03-12 1990-12-10 Woods Andrew A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9162 9162 2001-03-14 2000-03-10 Martin Kim S. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9165 9165 2003-03-14 2003-03-07 Franco Nathalia 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9379 9379 2000-03-16 1989-09-05 Colon William A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9477 9477 2000-03-17 1997-09-04 Doble Michael F. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9478 9478 2000-03-17 1999-09-07 Klein Mara S. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9572 9572 1998-03-18 1993-09-07 Beightol Michael H. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9836 9836 2002-03-22 2000-09-01 Blomquist Eric 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10325 10325 1991-03-29 1989-03-03 Tagliarino Scott A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10326 10326 1991-03-29 1991-03-07 Pardo Francesca 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10332 10332 1991-03-29 1989-09-05 Moriber Jeffrey 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11081 11081 1999-03-31 1993-03-05 Burket David 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11116 11116 2000-03-31 1996-07-15 Glidden Julia A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11120 11120 2000-03-31 1999-09-07 Parker Amy M. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11785 11785 1997-04-02 1996-03-06 Garber Jennifer 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11787 11787 1999-04-02 1996-03-06 Blackburn Daniel 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11788 11788 1999-04-02 1991-03-07 Nakakura Shari 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12032 12032 1995-04-07 1987-03-06 Ouellette Jeanne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12229 12229 2000-04-10 1999-03-05 Guarnieri Rica M. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12231 12231 2001-04-10 1989-03-03 Gregory John R. (Jack) 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12343 12343 1991-04-12 1991-03-07 Krauss Beatrice 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12590 12590 2003-04-15 2002-03-28 Sucar Liana 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12802 12802 1995-04-18 1991-05-17 Birney Jonelle 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12991 12991 1992-04-22 1991-09-05 Neisloss Susan 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13116 13116 1992-04-24 1991-03-07 Chuck Charles D. Gelman 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
14357 14357 1992-05-01 1990-05-10 Gray William Brett 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
14473 14473 1997-05-02 1993-09-07 Monson Sharon M. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
14583 14583 1999-05-04 1993-03-12 Massey Donald F. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
14629 14629 1995-05-05 1991-03-07 Fletcher Nancy 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
14834 14834 1997-05-09 1996-04-09 Eisner David 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15165 15165 1999-05-14 1989-03-03 McLean Carolyn Alexis 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15266 15266 2002-05-15 2000-03-10 Batalla Yvette 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15272 15272 2003-05-15 1988-10-12 Leddy Gregory 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15437 15437 1996-05-17 1993-09-07 Rudnick Gary 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15575 15575 1998-05-20 1995-01-24 Harmon Elisabeth 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15634 15634 1999-05-21 1995-09-06 Barry Ellen 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15753 15753 1996-05-23 1988-01-19 Buckmaster Thomas L. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15836 15836 1996-05-24 1995-09-06 Riley Stephen F. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15837 15837 1996-05-24 1994-09-08 Cabelly Robert John 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15983 15983 1999-05-26 1996-04-09 Gustafson Robert C. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16084 16084 1999-05-28 1993-10-20 Gossens Peter J. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
17986 17986 1997-06-13 1995-09-06 Johnson Judy A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18069 18069 1996-06-14 1996-04-09 Raymond Derrick 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18168 18168 1987-06-15 1986-02-20 Size Susan A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18210 18210 2004-06-15 2002-09-12 Johnson C. Donald 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18320 18320 2004-06-16 2003-09-22 McGuinness Katie 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18376 18376 1996-06-17 1995-09-06 Jackson Nancy Izzo 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18418 18418 1999-06-18 1997-03-22 Anthony Adam 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18574 18574 1991-06-21 1991-04-08 Solomon Mary C. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
19685 19685 1988-06-30 1986-09-05 DesRosiers Kathleen A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
20662 20662 1988-07-01 1986-09-05 Margaritis John P. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
20912 20912 1998-07-02 1996-04-09 Graziani Andrew 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
21152 21152 2000-07-07 1999-09-07 Feria Isabel 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
21936 21936 1991-07-18 1991-03-07 Fischer Kathleen 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22006 22006 2004-07-19 2000-09-01 Isenhower Anne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22051 22051 2004-07-20 1989-09-05 Lansdale Edward R. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22117 22117 2000-07-21 2000-03-10 Yacker Jeffrey 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22469 22469 1996-07-26 1995-03-06 Coulter Cynthia A. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22647 22647 1995-07-28 1994-03-04 Horner Chris 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22648 22648 1999-07-28 1991-05-30 Soh Peter Y. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
23077 23077 1987-07-31 1987-03-06 Elwell Stephen 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
23209 23209 1996-07-31 1990-10-30 Zingman Benjamin L. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24228 24228 2004-08-05 1988-01-19 Miller Martha 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24229 24229 2004-08-05 1986-02-05 Graham John D. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24230 24230 2004-08-05 1993-03-05 Boxerman Benita W. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24231 24231 2004-08-05 1993-03-05 Garino David P. 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24232 24232 2004-08-05 1999-03-05 Licha Rissig 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796

Next page

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