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

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
3231 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
3558 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
3719 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
3720 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
3722 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
3723 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
3724 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
3771 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
3905 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
4283 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
4618 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
4802 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
4943 1996-01-31 1993-10-20 Bingol Selim 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4953 1997-01-31 1994-03-04 Sharples Susan 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
4973 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
6858 2000-02-18 1996-09-04 Jennings Malin 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
6934 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
7402 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
7621 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
8617 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
8618 1994-03-04 1993-03-05 Tucker Brett 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8619 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
8661 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
8663 1993-03-05 1989-09-05 Bloch Jayne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8664 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
8665 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
8666 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
8667 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
8668 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
8722 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
8727 1995-03-06 1991-03-07 Hancock Mary 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
8730 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
8900 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
9188 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
9295 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
9298 2003-03-14 2003-03-07 Franco Nathalia 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
9512 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
9610 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
9611 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
9705 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
9970 2002-03-22 2000-09-01 Blomquist Eric 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10467 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
10468 1991-03-29 1991-03-07 Pardo Francesca 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
10474 1991-03-29 1989-09-05 Moriber Jeffrey 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11225 1999-03-31 1993-03-05 Burket David 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11260 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
11264 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
11957 1997-04-02 1996-03-06 Garber Jennifer 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11959 1999-04-02 1996-03-06 Blackburn Daniel 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
11960 1999-04-02 1991-03-07 Nakakura Shari 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12206 1995-04-07 1987-03-06 Ouellette Jeanne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12403 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
12405 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
12517 1991-04-12 1991-03-07 Krauss Beatrice 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12766 2003-04-15 2002-03-28 Sucar Liana 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
12980 1995-04-18 1991-05-17 Birney Jonelle 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13169 1992-04-22 1991-09-05 Neisloss Susan 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
13295 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
14592 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
14715 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
14826 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
14872 1995-05-05 1991-03-07 Fletcher Nancy 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15077 1997-05-09 1996-04-09 Eisner David 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15408 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
15510 2002-05-15 2000-03-10 Batalla Yvette 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15516 2003-05-15 1988-10-12 Leddy Gregory 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15682 1996-05-17 1993-09-07 Rudnick Gary 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15823 1998-05-20 1995-01-24 Harmon Elisabeth 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
15885 1999-05-21 1995-09-06 Barry Ellen 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
16007 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
16090 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
16091 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
16237 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
16339 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
18267 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
18350 1996-06-14 1996-04-09 Raymond Derrick 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18449 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
18491 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
18602 2004-06-16 2003-09-22 McGuinness Katie 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18658 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
18701 1999-06-18 1997-03-22 Anthony Adam 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
18857 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
19969 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
20967 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
21219 1998-07-02 1996-04-09 Graziani Andrew 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
21461 2000-07-07 1999-09-07 Feria Isabel 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22247 1991-07-18 1991-03-07 Fischer Kathleen 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22317 2004-07-19 2000-09-01 Isenhower Anne 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22363 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
22429 2000-07-21 2000-03-10 Yacker Jeffrey 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22781 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
22961 1995-07-28 1994-03-04 Horner Chris 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
22962 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
23393 1987-07-31 1987-03-06 Elwell Stephen 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
23525 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
24561 2004-08-05 1988-01-19 Miller Martha 3774 3774 1986-02-05 Fleishman-Hillard, Inc. 200 North Broadway   St. Louis MO 63102-2796
24562 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
24563 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
24564 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
24565 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 366.388ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history