FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where Registration_Number = 6622 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date)
State 1
- NY · 27 ✖
Registration_Number 1
- Havas Media Group USA LLC · 27 ✖
Registrant_Name 1
City 1
- New York 27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2912 | 2912 | 2016-01-01 | 2016-01-01 | Austria | Virgilio | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
2989 | 2989 | 2017-01-01 | 2017-01-01 | Chen | Mary | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
2990 | 2990 | 2017-01-01 | 2017-01-01 | Miller | Alexandra | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
5883 | 5883 | 2016-02-01 | 2016-02-01 | Leach | Elisabeth | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
5892 | 5892 | 2017-02-01 | 2017-02-01 | Alliott | Sarah Jane | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
5893 | 5893 | 2017-02-01 | 2017-02-01 | Robin | Clemence | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
15502 | 15502 | 2015-05-01 | 2015-05-01 | Clarke | Mark | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
18584 | 18584 | 2017-06-01 | 2017-06-01 | Watson | Sarah | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
22362 | 22362 | 2016-07-01 | 2016-07-01 | Lui | Caleb | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
25714 | 25714 | 2015-08-01 | 2015-08-01 | Shabazz | Cheyla | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
25738 | 25738 | 2016-08-01 | 2016-08-01 | Nacer | Patricia | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
37526 | 37526 | 2015-12-01 | 2015-12-01 | Leung | Nelson | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42209 | 42209 | 2018-12-31 | 2018-12-21 | Barest | Bonnie | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42210 | 42210 | 2018-12-31 | 2018-12-21 | Bernstein | Diana | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42211 | 42211 | 2018-12-31 | 2018-12-21 | Brown | Aaron N. | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42212 | 42212 | 2018-12-31 | 2018-12-21 | Crowell Eberle | Caroline | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42213 | 42213 | 2018-12-31 | 2018-12-21 | Fernando | Leo Franco | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42214 | 42214 | 2018-12-31 | 2018-12-21 | Isselbacher | Adam | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42215 | 42215 | 2018-12-31 | 2018-12-21 | Joseph Toussaint | Charmaine | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42216 | 42216 | 2018-12-31 | 2018-12-21 | Kanefsky | Jason | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42217 | 42217 | 2018-12-31 | 2018-12-21 | Leach | Russell | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42218 | 42218 | 2018-12-31 | 2018-12-21 | Miller Alper | Tricia | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42219 | 42219 | 2018-12-31 | 2018-12-21 | Panosian | Joseph | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42220 | 42220 | 2018-12-31 | 2018-12-21 | Shahid | Jennah | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42221 | 42221 | 2018-12-31 | 2018-12-21 | Sheffron | Paul | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42222 | 42222 | 2018-12-31 | 2018-12-21 | Stanley | Nichole | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 | |
42223 | 42223 | 2018-12-31 | 2018-12-21 | Swindell | Destinee | Havas Media Group USA LLC 6622 | 2018-12-21 | Havas Media Group USA LLC | 200 Hudson Street | New York | NY | 10013 |
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]) );