FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "New York" and "Short_Form_Termination_Date" is on date 1991-01-31
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Zip, Registration_Date (date)
Registration_Number 10
- Promotional Concept Group, Inc. 3
- IPG DXTRA, Inc 2
- Switzerland Tourism 1
- Mexican Tourism Board 1
- Government of Ontario, Canada 1
- National Federation of Coffee Growers of Colombia 1
- Representative of the Turkish Republic of Northern Cyprus 1
- White & Case, LLP 1
- Peter Rothholz Associates, Inc. 1
- Carl Byoir & Associates 1
Registrant_Name 10
- Promotional Concept Group, Inc. 3
- IPG DXTRA, Inc 2
- Carl Byoir & Associates 1
- Government of Ontario, Canada 1
- Mexican Tourism Board 1
- National Federation of Coffee Growers of Colombia 1
- Peter Rothholz Associates, Inc. 1
- Representative of the Turkish Republic of Northern Cyprus 1
- Switzerland Tourism 1
- White & Case, LLP 1
State 1
- NY 13
City 1
- New York · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5066 | 5066 | 1991-01-31 | 1991-01-02 | Kravitz | Steven Hugh | Peter Rothholz Associates, Inc. 2830 | 1977-09-16 | Peter Rothholz Associates, Inc. | 355 Lexington Avenue | 17th Floor | New York | NY | 10017 |
5067 | 5067 | 1991-01-31 | 1985-01-12 | Dulio | Bernardino | Switzerland Tourism 55 | 1943-03-01 | Switzerland Tourism | 608 Fifth Avenue | New York | NY | 10020-2303 | |
5068 | 5068 | 1991-01-31 | 1988-02-17 | Webster | Anne Emerson | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
5072 | 5072 | 1991-01-31 | 1980-05-19 | McCluskey | Eugene J. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
5074 | 5074 | 1991-01-31 | 1974-06-10 | Higuera | Alba L. | National Federation of Coffee Growers of Colombia 2519 | 1974-06-10 | National Federation of Coffee Growers of Colombia | 140 East 57th Street | New York | NY | 10022 | |
5075 | 5075 | 1991-01-31 | 1982-06-16 | Gruntkowski | John J. | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
5076 | 5076 | 1991-01-31 | 1982-06-16 | Wohlhorn | June D. | Promotional Concept Group, Inc. 3383 | 1982-06-16 | Promotional Concept Group, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
5077 | 5077 | 1991-01-31 | 1985-06-25 | Koray | Ozer | Representative of the Turkish Republic of Northern Cyprus 2619 | 1975-10-16 | Representative of the Turkish Republic of Northern Cyprus | 821 First Avenue | Floor 13 | New York | NY | 10017 |
5081 | 5081 | 1991-01-31 | 1988-08-09 | Guillen | Manuel | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
5085 | 5085 | 1991-01-31 | 1989-09-11 | Glowacki | Alexandra | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
5089 | 5089 | 1991-01-31 | 1990-09-12 | Budd | John F. , Jr. | Carl Byoir & Associates 4411 | 1990-09-12 | Carl Byoir & Associates | 420 Lexington Avenue | New York | NY | 10017 | |
5092 | 5092 | 1991-01-31 | 1989-09-21 | Clohesy | Thomas M. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
5094 | 5094 | 1991-01-31 | 1983-10-07 | Zeifer | F. Ellen | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 |
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]) );