FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where City = "New York" and Short_Form_First_Name = "Eric"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 17
- White & Case, LLP 5
- Quebec Government Office 4
- Dentsu America, Inc. 2
- National Film Board of Canada 1
- Congo National Tourist Office 1
- Broadcast Planning Corporation 1
- Belgo-American Development Corporation 1
- Siegel, Leah 1
- Young & Rubicam, L.P. 1
- Saatchi & Saatchi North America, Inc. 1
- Daniel J. Edelman, Inc. 1
- McCann Direct, Inc. 1
- Rubenstein Associates, Inc. 1
- Ketchum Inc. NY 1
- Geoffrey Weill Associates 1
- KARV Communications, Inc. 1
- Pivot Integrated Communications, a division of BCW LLC 1
Registrant_Name 17
- White & Case, LLP 5
- Quebec Government Office 4
- Dentsu America, Inc. 2
- Belgo-American Development Corporation 1
- Broadcast Planning Corporation 1
- Congo National Tourist Office 1
- Daniel J. Edelman, Inc. 1
- Geoffrey Weill Associates 1
- KARV Communications, Inc. 1
- Ketchum Inc. NY 1
- McCann Direct, Inc. 1
- National Film Board of Canada 1
- Pivot Integrated Communications, a division of BCW LLC 1
- Rubenstein Associates, Inc. 1
- Saatchi & Saatchi North America, Inc. 1
- Siegel, Leah 1
- Young & Rubicam, L.P. 1
State 1
- NY 25
City 1
- New York · 25 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
452 | 452 | 2019-02-25 | Andrus | Eric | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 122 East 42nd Street | Suite 2005 | New York | NY | 10168 | |
4004 | 4004 | 1962-01-18 | 1961-07-03 | Strong | Eric | Broadcast Planning Corporation 1371 | 1960-06-16 | Broadcast Planning Corporation | 793 Lexington Avenue | New York | NY | ||
9109 | 9109 | 1969-03-04 | 1967-08-03 | de Spirlet | Eric | Belgo-American Development Corporation 1501 | 1961-12-18 | Belgo-American Development Corporation | 605 Third Avenue | New York | NY | 10016 | |
11721 | 11721 | 1995-03-31 | 1992-06-17 | Gastinel | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
11906 | 11906 | 2003-03-31 | 2001-04-30 | Ray | Eric | Rubenstein Associates, Inc. 4778 | 1993-03-12 | Rubenstein Associates, Inc. | 1345 Avenue of the Americas | 30th Floor | New York | NY | 10105-0109 |
12847 | 12847 | 2003-04-06 | 2003-08-07 | Grannon | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
12848 | 12848 | 2003-04-06 | 2003-09-08 | Grannon | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
15024 | 15024 | 2010-04-30 | 2006-10-03 | Goldberg | Eric | Geoffrey Weill Associates 5773 | 2006-10-03 | Geoffrey Weill Associates | 27 West 24th Street | Suite 305 | New York | NY | 10010 |
18086 | 18086 | 2011-05-31 | 2011-02-18 | Kim | Eric | Ketchum Inc. NY 5758 | 2006-05-09 | Ketchum Inc. NY | 1285 Avenue of the Americas | New York | NY | 10019 | |
18523 | 18523 | 2007-06-01 | 2005-02-03 | Marquis | Eric | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
19373 | 19373 | 1960-06-14 | 1960-06-08 | Mann | Eric | Congo National Tourist Office 1358 | 1960-05-09 | Congo National Tourist Office | 609 Fifth Avenue | New York | NY | ||
20577 | 20577 | 2007-06-29 | 2005-02-03 | Dequenne | Eric | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
21494 | 21494 | 2004-06-30 | 2003-02-03 | Marquis | Eric | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
24223 | 24223 | 2004-07-27 | 2003-05-27 | Kim | Eric | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
25372 | 25372 | 2020-07-31 | 2020-03-18 | Minuskin | Eric | Pivot Integrated Communications, a division of BCW LLC 6736 | 2019-10-03 | Pivot Integrated Communications, a division of BCW LLC | 200 Fifth Avenue | New York | NY | 10010 | |
25940 | 25940 | 1975-08-04 | 1974-11-13 | Lowenkron | Eric | Siegel, Leah 2488 | 1974-01-21 | Siegel, Leah | 225 West 34th Street | Suite 1505 | New York | NY | 10122 |
26511 | 26511 | 1999-08-12 | 1999-05-10 | Hamilton | Eric | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
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 |
28632 | 28632 | 2017-08-31 | 2011-12-20 | Marquis | Eric | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
31021 | 31021 | 1988-09-30 | 1984-07-24 | Weber | Eric | Saatchi & Saatchi North America, Inc. 3605 | 1984-07-24 | Saatchi & Saatchi North America, Inc. | Saatchi & Saatchi Building | 375 Hudson Street, 10th Floor | New York | NY | 10014-3620 |
31994 | 31994 | 2006-10-01 | 2006-05-31 | Leibowitz | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
32018 | 32018 | 2006-10-01 | 2005-12-07 | Grannon | Eric | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
35541 | 35541 | 1990-11-09 | 1988-11-18 | Weber | Eric | Young & Rubicam, L.P. 3283 | 1981-10-06 | Young & Rubicam, L.P. | 285 Madison Avenue | New York | NY | 100176486 | |
36556 | 36556 | 1995-11-29 | 1995-07-28 | Koelmel | Eric | McCann Direct, Inc. 3922 | 1986-12-29 | McCann Direct, Inc. | 750 Third Avenue | New York | NY | 10017 | |
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 |
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]) );