FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where City = "New York" and Short_Form_First_Name = "Hannah"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
91 | 91 | 2022-01-10 | Daniel | Hannah | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | ||
164 | 164 | 2020-01-22 | Beard | Hannah | Peregrine Communications Inc. 6785 | 2020-01-22 | Peregrine Communications Inc. | 405 Lexington Avenue | 9th Floor | New York | NY | 10174 | |
767 | 767 | 2023-04-11 | Hunter | Hannah | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 122 East 42nd Street | Suite 2005 | New York | NY | 10168 | |
1391 | 1391 | 2022-07-11 | Mautz | Hannah | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
5587 | 5587 | 2021-01-31 | 2019-01-11 | Meyers | Hannah | Guidepost Solutions LLC 6571 | 2018-07-13 | Guidepost Solutions LLC | 415 Madison Avenue | 11th Floor | New York | NY | 10017 |
19471 | 19471 | 2022-06-14 | 2022-03-07 | Hunter | Hannah | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 122 East 42nd Street | Suite 2005 | New York | NY | 10168 |
29971 | 29971 | 2021-09-16 | 2021-04-16 | Kim | Hannah | Ogilvy Group LLC 6797 | 2020-03-04 | Ogilvy Group LLC | 636 11th Avenue | New York | NY | 10036 | |
37192 | 37192 | 2021-11-30 | 2021-07-30 | Frick | Hannah | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 |
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]) );