FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Short_Form_Date" is on date 1964-01-03
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5919 | 5919 | 1967-02-02 | 1964-01-03 | Beyea | Archibald Lester | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5920 | 5920 | 1967-02-02 | 1964-01-03 | Choate | Rufus | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5921 | 5921 | 1967-02-02 | 1964-01-03 | Hansen | Arnold Christian | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5922 | 5922 | 1967-02-02 | 1964-01-03 | Hildebrant | Walter G. | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5923 | 5923 | 1967-02-02 | 1964-01-03 | Hobbs | Richard Hutchinson | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5924 | 5924 | 1967-02-02 | 1964-01-03 | Kaufherr | Daniel Clinton | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5925 | 5925 | 1967-02-02 | 1964-01-03 | Kron | Arthur Adam | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5926 | 5926 | 1967-02-02 | 1964-01-03 | Pecorini | Lillian Allen | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5927 | 5927 | 1967-02-02 | 1964-01-03 | Priest | Chester A. | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5928 | 5928 | 1967-02-02 | 1964-01-03 | Ricigliano | William V. | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5929 | 5929 | 1967-02-02 | 1964-01-03 | Rourke | Cornelius G. | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
5930 | 5930 | 1967-02-02 | 1964-01-03 | Vladimir | Irwin Alfred | Gotham-Vladimir Advertising, Inc. 1677 | 1964-01-03 | Gotham-Vladimir Advertising, Inc. | 342 Madison Avenue | New York | NY | 10017 | |
6121 | 6121 | 1987-02-04 | 1964-01-03 | Mason | John N. | Ragan & Mason 1678 | 1964-01-03 | Ragan & Mason | 1156 - 15th Street, N.W. | Suite 800 | Washington | DC | 20005 |
27121 | 27121 | 1989-08-21 | 1964-01-03 | Normandeau | Andrew A. | Ragan & Mason 1678 | 1964-01-03 | Ragan & Mason | 1156 - 15th Street, N.W. | Suite 800 | Washington | DC | 20005 |
27122 | 27122 | 1989-08-21 | 1964-01-03 | Ragan | William F. | Ragan & Mason 1678 | 1964-01-03 | Ragan & Mason | 1156 - 15th Street, N.W. | Suite 800 | Washington | DC | 20005 |
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]) );