FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
40 rows where Address_2 = "16th Floor"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Zip
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2869 | 2869 | 2010-01-01 | 2006-02-06 | Shearer | Ean K. | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
2870 | 2870 | 2010-01-01 | 2009-02-10 | Kanfer | Laura | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
2871 | 2871 | 2010-01-01 | 2009-02-10 | Sheth | Purvi | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
4642 | 4642 | 2006-01-27 | 2005-01-31 | Novick | Randy | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
6636 | 6636 | 2009-02-11 | 2009-02-10 | McGuinness | James | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
9065 | 9065 | 2006-03-03 | 1996-06-24 | Pearsall | Randolph | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
11074 | 11074 | 2002-03-29 | 1999-04-01 | Meenakshisundaram | Swamidorai | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
14177 | 14177 | 1981-04-27 | 1978-10-21 | Ghei | Rita S. | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
15761 | 15761 | 2005-05-05 | 2005-01-31 | Masarof | Madeline | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
16447 | 16447 | 2006-05-15 | 2003-03-04 | Nangia | Dhurinder Kumar | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
16671 | 16671 | 2002-05-18 | 2001-05-11 | Lucchino | David L. | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
16979 | 16979 | 2004-05-23 | 2002-10-18 | McClelland | Jeff | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
17474 | 17474 | 1995-05-30 | 1992-06-02 | Singh | Ranjett | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
20007 | 20007 | 1980-06-22 | 1980-01-22 | Rowe | John H. | A.J. Lazarus Associates, Inc. 3033 | 1979-06-21 | A.J. Lazarus Associates, Inc. | 12 East 41st Street | 16th Floor | New York | NY | 10017 |
20008 | 20008 | 1980-06-22 | 1979-06-21 | Lazarus | Andrew J. | A.J. Lazarus Associates, Inc. 3033 | 1979-06-21 | A.J. Lazarus Associates, Inc. | 12 East 41st Street | 16th Floor | New York | NY | 10017 |
21076 | 21076 | 1987-06-30 | 1984-11-26 | Shah | Rajeeva R. | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
21186 | 21186 | 1993-06-30 | 1989-09-14 | Laroia | Pradeep | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
21315 | 21315 | 1998-06-30 | 1995-12-05 | Kishore | Suresh | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
21366 | 21366 | 2000-06-30 | 1996-11-20 | Agrawal | Shyam Sunder | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
22539 | 22539 | 2009-07-03 | 2007-01-03 | Maity | Hema | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
23676 | 23676 | 2007-07-20 | 2004-03-09 | Chadha | Dharam Jit Singh | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
24591 | 24591 | 2010-07-30 | 2007-12-04 | Sharma | Prabhat Chandra | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
24775 | 24775 | 1989-07-31 | 1984-03-01 | Bharucha | V.S. | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
26749 | 26749 | 1996-08-15 | 1993-12-06 | Vadi | A.M. | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
27811 | 27811 | 2006-08-30 | 2004-07-29 | Shepherd | Eric | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
30115 | 30115 | 1979-09-20 | 1978-10-21 | Chatterjee | Ashok K. | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
31015 | 31015 | 1988-09-30 | 1986-03-26 | Singh | Ranbir | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
31041 | 31041 | 1990-09-30 | 1989-03-09 | Kaushal | Lokesh | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
32659 | 32659 | 1979-10-12 | 1979-06-21 | Anderson | David C. | A.J. Lazarus Associates, Inc. 3033 | 1979-06-21 | A.J. Lazarus Associates, Inc. | 12 East 41st Street | 16th Floor | New York | NY | 10017 |
33576 | 33576 | 2008-10-24 | 2005-01-31 | Rosa | Jeannette | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
34074 | 34074 | 1991-10-30 | 1991-08-28 | Kaushal | Lokesh | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
34468 | 34468 | 2003-10-31 | 2001-01-22 | Raghavan | Subramaniam | India Trade Promotion Organization 2975 | 1978-10-26 | India Trade Promotion Organization | 100 Park Avenue | 16th Floor | New York | NY | 10017 |
36128 | 36128 | 2009-11-20 | 2009-02-10 | Blumberg | Jessica | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
39000 | 39000 | 1988-12-23 | 1981-11-05 | Hochman | Harry W. | Harry W. Hochman Associates, Inc. 3300 | 1981-11-05 | Harry W. Hochman Associates, Inc. | 950 Third Avenue | 16th Floor | New York | NY | 10022 |
39001 | 39001 | 1988-12-23 | 1981-11-05 | Hochman | Rita | Harry W. Hochman Associates, Inc. 3300 | 1981-11-05 | Harry W. Hochman Associates, Inc. | 950 Third Avenue | 16th Floor | New York | NY | 10022 |
41159 | 41159 | 1999-12-31 | 1996-09-13 | Watts | Jessica | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
41190 | 41190 | 2000-12-31 | 1996-06-24 | Sise | Peyton | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
41357 | 41357 | 2004-12-31 | 1996-06-24 | Bernasconi | Paul | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
41358 | 41358 | 2004-12-31 | 1996-06-24 | McClure | Eric | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | New York | NY | 10013 |
41650 | 41650 | 2009-12-31 | 2009-02-10 | Yunga | Ebie | Dentsu America, Inc. 5116 | 1996-06-24 | Dentsu America, Inc. | 32 Avenue of the Americas | 16th Floor | 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]) );