FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where "Short_Form_Date" is on date 2002-06-05
This data as json, CSV (advanced)
Suggested facets: Short_Form_First_Name, Registration_Date, Address_1, Short_Form_Termination_Date (date)
Registration_Number 2
Registrant_Name 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4584 | 4584 | 2004-01-26 | 2002-06-05 | Ziv | Suzanne | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
5280 | 5280 | 2003-01-31 | 2002-06-05 | Regidor | Cynthia | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
5281 | 5281 | 2003-01-31 | 2002-06-05 | Serrano | Amy | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
6254 | 6254 | 2004-02-06 | 2002-06-05 | Klein | Rochelle | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
6869 | 6869 | 2003-02-14 | 2002-06-05 | Sustana | Nick | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
9844 | 9844 | 2003-03-14 | 2002-06-05 | Ferman | Pamela | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
9845 | 9845 | 2003-03-14 | 2002-06-05 | Fernandez | Frank | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
11924 | 11924 | 2004-03-31 | 2002-06-05 | Moorman | Robert | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
15825 | 15825 | 2005-05-06 | 2002-06-05 | Zuna | Michael | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
19878 | 19878 | 2007-06-19 | 2002-06-05 | Narita | Yusuke | JETRO, Atlanta 4069 | 1987-12-01 | JETRO, Atlanta | 5901 Peachtree Dunwoody Rd, | Suite. B485 | Atlanta | GA | 30328 |
20454 | 20454 | 2002-06-28 | 2002-06-05 | Zinmaw | Sandi | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
22974 | 22974 | 2003-07-11 | 2002-06-05 | Pomroy | Cindy | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
25005 | 25005 | 2002-07-31 | 2002-06-05 | Badenhop | Stephen | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
28407 | 28407 | 2002-08-31 | 2002-06-05 | Broad | David | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
28933 | 28933 | 2004-09-01 | 2002-06-05 | Kupfer | Jean | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
29487 | 29487 | 2005-09-09 | 2002-06-05 | Stewart | Anne Marie | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
31959 | 31959 | 2002-10-01 | 2002-06-05 | Ryan | Kathryn | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
31969 | 31969 | 2003-10-01 | 2002-06-05 | Finneran | Thomas | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41264 | 41264 | 2002-12-31 | 2002-06-05 | McGrath | Patrick | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41312 | 41312 | 2003-12-31 | 2002-06-05 | Quero | Nicole | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41412 | 41412 | 2005-12-31 | 2002-06-05 | Byers | Jeanne | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41413 | 41413 | 2005-12-31 | 2002-06-05 | Cahill | Andrew | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41414 | 41414 | 2005-12-31 | 2002-06-05 | Conery | Kevin | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41415 | 41415 | 2005-12-31 | 2002-06-05 | Fischetti | John | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41416 | 41416 | 2005-12-31 | 2002-06-05 | Frazier | Patricia | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41417 | 41417 | 2005-12-31 | 2002-06-05 | Johnson | Catherine | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41418 | 41418 | 2005-12-31 | 2002-06-05 | Policano | John | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 | |
41419 | 41419 | 2005-12-31 | 2002-06-05 | Volk | Kristin | Arnold Worldwide/NY 5500 | 2002-06-05 | Arnold Worldwide/NY | 110 Fifth Avenue | New York | NY | 10011 |
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]) );