FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
191 rows where Registration_Number = 3774
This data as json, CSV (advanced)
State 1
- MO 37
Registration_Number 1
- Fleishman-Hillard, Inc. · 37 ✖
Registrant_Name 1
City 1
- St. Louis 37
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29114 | 29114 | 1997-09-03 | 1995-09-06 | Stack | Peter Snyder | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29242 | 29242 | 2002-09-05 | 2000-03-10 | Davenport | Rory | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29334 | 29334 | 1993-09-07 | 1992-03-05 | West | Rhonda K. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29335 | 29335 | 1993-09-07 | 1991-03-07 | Brennan | Niall | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29336 | 29336 | 1993-09-07 | 1991-03-07 | Bucio | Francine A. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29337 | 29337 | 1993-09-07 | 1991-03-07 | Pitlik | Daniel | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29338 | 29338 | 1993-09-07 | 1991-03-07 | Smith | Sabra L. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29343 | 29343 | 1993-09-07 | 1992-03-18 | Baumer | Christopher C. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29344 | 29344 | 1993-09-07 | 1992-03-18 | Eby | Charles J. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29430 | 29430 | 1994-09-08 | 1986-02-05 | Nolan | Kathleen D. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29431 | 29431 | 1994-09-08 | 1993-03-05 | Bagby | Jill | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29432 | 29432 | 1994-09-08 | 1991-03-07 | Moran | Jeffrey A. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29447 | 29447 | 2003-09-08 | 2003-09-22 | Dolge | Theresa | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
29995 | 29995 | 1999-09-17 | 1997-03-22 | Holley | Paul J. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
30029 | 30029 | 1997-09-18 | 1991-03-07 | Rohrbach | Katherine B. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
30088 | 30088 | 2002-09-19 | 1997-03-22 | Katell | Andrew | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
30089 | 30089 | 2002-09-19 | 1997-03-22 | Klein | Nancy Linda | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
31952 | 31952 | 2001-10-01 | 2001-03-14 | Goodman | Alan | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
31953 | 31953 | 2001-10-01 | 2001-03-14 | Oyman | Idil | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
32249 | 32249 | 1991-10-04 | 1991-09-05 | Kim | Howard G. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
32469 | 32469 | 2002-10-08 | 2001-09-07 | Wright | Andrew | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
32589 | 32589 | 2000-10-10 | 1991-11-19 | Drake | Steven E. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
33025 | 33025 | 1998-10-16 | 1994-09-08 | Rose | Matthew W. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
33721 | 33721 | 2000-10-27 | 2000-03-10 | Novin | Helene | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
35336 | 35336 | 1991-11-06 | 1990-10-30 | Ridge | Susan E. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
35481 | 35481 | 1990-11-09 | 1989-03-03 | Wood | Paul J. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
35895 | 35895 | 2002-11-15 | 2002-09-12 | Compean | Daniela Borbolla | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
36062 | 36062 | 1999-11-19 | 1986-02-20 | Canfield | Anne | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
36454 | 36454 | 2001-11-26 | 2001-03-14 | Werner | Anne | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
36783 | 36783 | 1995-11-30 | 1992-03-18 | Ellis | Leonard Harry | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
37462 | 37462 | 2000-12-01 | 2000-03-10 | Gonzalez-Robiou | Georgina | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
38026 | 38026 | 1990-12-10 | 1989-09-05 | Siegmann | Robert J. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
38054 | 38054 | 2002-12-10 | 1989-09-05 | Michelman | Robert Douglas | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
38310 | 38310 | 1998-12-14 | 1997-09-04 | Wilk | Lynn | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
38543 | 38543 | 1987-12-17 | 1986-09-05 | Uota | Thea | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
40903 | 40903 | 1995-12-31 | 1991-09-05 | Hiss | Eric | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 | |
41259 | 41259 | 2002-12-31 | 1992-03-18 | Hubbard | Henry W. | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | 200 North Broadway | St. Louis | MO | 63102-2796 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );