FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
41 rows where Address_1 = "10 Broadway", City = "St. Louis" and State = "MO"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Termination_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2547 | 2547 | 1969-01-01 | 1960-08-12 | Claggett | Charles Evans | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
3117 | 3117 | 1973-01-03 | 1960-08-12 | Pellegrino | Thomas John | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
3752 | 3752 | 1972-01-15 | 1968-10-11 | Lucci | Giuseppe | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
4936 | 4936 | 1972-01-31 | 1968-10-11 | Digby | Noel | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
5694 | 5694 | 1973-02-01 | 1972-11-13 | Filice | Michael | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
6894 | 6894 | 1963-02-15 | 1962-09-07 | Eastright | Robert Earl | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
6913 | 6913 | 1973-02-15 | 1971-03-29 | Vecchio | Pasquale G. Del | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
6915 | 6915 | 1973-02-15 | 1966-12-08 | Sabatino | Daniel Casper | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9808 | 9808 | 1973-03-14 | 1963-03-05 | Brugnatelli | Bruno Ercole | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9809 | 9809 | 1973-03-14 | 1963-03-05 | Buffington | Louis Dell , III | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9810 | 9810 | 1973-03-14 | 1961-03-08 | Pierce | Alvin Frederick | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9811 | 9811 | 1973-03-14 | 1962-03-09 | Cornwell | William Earl | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9812 | 9812 | 1973-03-14 | 1962-03-09 | Ewell | Charles Lee | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9813 | 9813 | 1973-03-14 | 1962-03-09 | Rice | Francis Xavier | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9816 | 9816 | 1973-03-14 | 1965-11-05 | Davidson | John M. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
9817 | 9817 | 1973-03-14 | 1968-11-25 | Dalton | Peter J. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
10735 | 10735 | 1969-03-25 | 1960-08-12 | Humphrey | Champ C. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
10736 | 10736 | 1969-03-25 | 1960-08-18 | Spencer | William Leonard | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
11400 | 11400 | 1966-03-31 | 1961-03-08 | DeHavilland | Robert Paul | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
12714 | 12714 | 1972-04-04 | 1971-07-10 | Brugnatelli | Bruno E. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
13304 | 13304 | 1972-04-14 | 1970-04-07 | Kirkman | Walter B. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
13305 | 13305 | 1972-04-14 | 1970-10-13 | Oliveto | Anthony | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
14470 | 14470 | 1969-04-30 | 1960-08-12 | Theodoli | Filippo M. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
16858 | 16858 | 1961-05-22 | 1960-08-12 | Rossini | Giancarlo | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
18389 | 18389 | 1964-06-01 | 1960-08-12 | Porteous | Donald Carlyle | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
19506 | 19506 | 1970-06-15 | 1969-09-17 | Leahy | Edward J. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
22513 | 22513 | 1968-07-03 | 1966-11-15 | Elwell | Robert A. , Jr. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
22586 | 22586 | 1968-07-05 | 1960-08-12 | Heaston | Frank Eugene | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
26474 | 26474 | 1965-08-12 | 1963-08-21 | Christenberry | Robert Keaton , Jr. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
26480 | 26480 | 1966-08-12 | 1965-11-04 | Hyatt | Stuart Quentin | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
28753 | 28753 | 1961-09-01 | 1961-03-08 | Hepler | Frank Clayton | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
30292 | 30292 | 1966-09-23 | 1960-08-12 | Martini | Roland | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
30906 | 30906 | 1972-09-30 | 1970-10-13 | Ryant | Charles T. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
34164 | 34164 | 1968-10-31 | 1966-11-15 | Rike | George C. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
36053 | 36053 | 1971-11-19 | 1968-10-11 | Maffei | Rudolph | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
36140 | 36140 | 1968-11-21 | 1968-09-10 | Matz | Stanley | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
38725 | 38725 | 1969-12-19 | 1969-09-17 | Brady | Frank R. | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
39692 | 39692 | 1960-12-31 | 1960-08-12 | Booth | George Warren | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
39693 | 39693 | 1960-12-31 | 1960-08-12 | Hughes | Joseph | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
39694 | 39694 | 1960-12-31 | 1960-08-12 | Roche | John Owens | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 | |
39878 | 39878 | 1969-12-31 | 1968-10-11 | Yelinek | Frank | Gardner Advertising Company, Inc. 1385 | 1960-08-12 | Gardner Advertising Company, Inc. | 10 Broadway | St. Louis | MO | 63102 |
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]) );