FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
20 rows where "Short_Form_Termination_Date" is on date 1989-12-31 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Address_2
Registration_Number 13
- Jordan, McGrath, Case & Taylor, Inc. 6
- South African Tourism 2
- Tea Council of the U.S.A., Inc. 2
- Belgian National Tourist Office 1
- German-American Chamber of Commerce, Inc., New York 1
- Singapore Economic Development Board 1
- Celliers, Peter J. 1
- Port of Le Havre Authority 1
- Daniel J. Edelman, Inc. 1
- Sawyer Miller Group 1
- GCI Group, Inc. 1
- McCann Direct, Inc. 1
- Shearson Lehman Brothers, Inc. 1
Registrant_Name 13
- Jordan, McGrath, Case & Taylor, Inc. 6
- South African Tourism 2
- Tea Council of the U.S.A., Inc. 2
- Belgian National Tourist Office 1
- Celliers, Peter J. 1
- Daniel J. Edelman, Inc. 1
- GCI Group, Inc. 1
- German-American Chamber of Commerce, Inc., New York 1
- McCann Direct, Inc. 1
- Port of Le Havre Authority 1
- Sawyer Miller Group 1
- Shearson Lehman Brothers, Inc. 1
- Singapore Economic Development Board 1
State 1
- NY · 20 ✖
City 1
- New York 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40547 | 40547 | 1989-12-31 | 1977-02-18 | Neville | Ann | Belgian National Tourist Office 529 | 1948-06-17 | Belgian National Tourist Office | 300 East 42nd Street | 14th Floor | New York | NY | 10017 |
40548 | 40548 | 1989-12-31 | 1988-03-02 | Johnson | James A. | Shearson Lehman Brothers, Inc. 4097 | 1988-03-02 | Shearson Lehman Brothers, Inc. | American Express Tower | World Financial Center | New York | NY | 10285 |
40562 | 40562 | 1989-12-31 | 1988-04-08 | Parter | Alan S. | GCI Group, Inc. 3856 | 1986-07-11 | GCI Group, Inc. | 825 Third Avenue | 24th Floor | New York | NY | 10022-7519 |
40563 | 40563 | 1989-12-31 | 1971-04-23 | Friedman | Michael L. | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | 420 Lexington Avenue | Suite 825 | New York | NY | 10170 |
40565 | 40565 | 1989-12-31 | 1988-04-29 | Garstang | Richard | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40575 | 40575 | 1989-12-31 | 1986-06-24 | Miller | William Scott | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | 14 East 60th Street | New York | NY | 10022 | |
40576 | 40576 | 1989-12-31 | 1985-06-28 | Jackson | Michael G.D. | South African Tourism 603 | 1950-01-04 | South African Tourism | 500 Fifth Avenue | 22nd Floor, Suite 2200 | New York | NY | 10110-0002 |
40578 | 40578 | 1989-12-31 | 1985-07-04 | Eggert | Jan A. | German-American Chamber of Commerce, Inc., New York 1812 | 1964-11-04 | German-American Chamber of Commerce, Inc., New York | 40 West 57th Street | New York | NY | 10019-4092 | |
40579 | 40579 | 1989-12-31 | 1976-07-22 | Datin | Jean H. | Port of Le Havre Authority 2710 | 1976-07-22 | Port of Le Havre Authority | 1 World Trade Center | Suite 2549 | New York | NY | 10048 |
40580 | 40580 | 1989-12-31 | 1974-08-01 | Dutt | Asoka | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | 420 Lexington Avenue | Suite 825 | New York | NY | 10170 |
40581 | 40581 | 1989-12-31 | 1986-08-08 | Hirsch | Peter | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
40584 | 40584 | 1989-12-31 | 1977-08-23 | Stafanssen | Stephanie | Celliers, Peter J. 2617 | 1975-10-15 | Celliers, Peter J. | C/O Satour | 747 Third Avenue, 20th Floor | New York | NY | 10017 |
40586 | 40586 | 1989-12-31 | 1984-09-14 | Chun | Heng-Yuen | Singapore Economic Development Board 2003 | 1967-02-02 | Singapore Economic Development Board | 55 East 59th Street | Suite 21 B, 21st Floor | New York | NY | 10022 |
40592 | 40592 | 1989-12-31 | 1980-12-19 | Burkholder | Jana L. | Jordan, McGrath, Case & Taylor, Inc. 3182 | 1980-12-19 | Jordan, McGrath, Case & Taylor, Inc. | 445 Park Avenue | New York | NY | 10022 | |
40593 | 40593 | 1989-12-31 | 1980-12-19 | Jordan | James J. , Jr. | Jordan, McGrath, Case & Taylor, Inc. 3182 | 1980-12-19 | Jordan, McGrath, Case & Taylor, Inc. | 445 Park Avenue | New York | NY | 10022 | |
40594 | 40594 | 1989-12-31 | 1980-12-19 | McVeigh | Robert A. | Jordan, McGrath, Case & Taylor, Inc. 3182 | 1980-12-19 | Jordan, McGrath, Case & Taylor, Inc. | 445 Park Avenue | New York | NY | 10022 | |
40595 | 40595 | 1989-12-31 | 1980-12-19 | Taylor | John L. | Jordan, McGrath, Case & Taylor, Inc. 3182 | 1980-12-19 | Jordan, McGrath, Case & Taylor, Inc. | 445 Park Avenue | New York | NY | 10022 | |
40596 | 40596 | 1989-12-31 | 1982-12-23 | McGrath | Patrick J. | Jordan, McGrath, Case & Taylor, Inc. 3182 | 1980-12-19 | Jordan, McGrath, Case & Taylor, Inc. | 445 Park Avenue | New York | NY | 10022 | |
40597 | 40597 | 1989-12-31 | 1982-12-23 | Raffle | Larry | Jordan, McGrath, Case & Taylor, Inc. 3182 | 1980-12-19 | Jordan, McGrath, Case & Taylor, Inc. | 445 Park Avenue | New York | NY | 10022 | |
40599 | 40599 | 1989-12-31 | 1986-12-29 | Lynaugh | George | McCann Direct, Inc. 3922 | 1986-12-29 | McCann Direct, Inc. | 750 Third Avenue | New York | NY | 10017 |
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]) );