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_First_Name = "James A."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Registration_Date, Address_2, Zip, Short_Form_Termination_Date (date)
Registration_Number 11
- IPG DXTRA, Inc 2
- FTI Consulting (SC), Inc. 2
- National Film Board of Canada 1
- Sydney Morrell & Company, Inc. 1
- Government of Ontario, Canada 1
- North American Precis Syndicate 1
- Saatchi & Saatchi North America, Inc. 1
- Sawyer Miller Group 1
- Shearson Lehman Brothers, Inc. 1
- Saudi Petroleum International, Inc. 1
- Herrick, Feinstein LLP 1
Registrant_Name 11
- FTI Consulting (SC), Inc. 2
- IPG DXTRA, Inc 2
- Government of Ontario, Canada 1
- Herrick, Feinstein LLP 1
- National Film Board of Canada 1
- North American Precis Syndicate 1
- Saatchi & Saatchi North America, Inc. 1
- Saudi Petroleum International, Inc. 1
- Sawyer Miller Group 1
- Shearson Lehman Brothers, Inc. 1
- Sydney Morrell & Company, Inc. 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5041 | 5041 | 1989-01-31 | 1977-10-12 | Wicht | James A. | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | 201 East 42nd Street | New York | NY | 10017 | |
9258 | 9258 | 2019-03-06 | 2018-01-29 | Blakeslee | James A. | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
9269 | 9269 | 2019-03-06 | 2019-05-23 | Blakeslee | James A. | FTI Consulting (SC), Inc. 6484 | 2017-11-03 | FTI Consulting (SC), Inc. | 88 Pine Street, 32nd Floor | New York | NY | 10005 | |
16139 | 16139 | 1989-05-12 | 1983-12-13 | Adair | James A. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
17776 | 17776 | 1995-05-31 | 1985-02-08 | Hushon | James A. | 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 |
24336 | 24336 | 2017-07-28 | 2013-07-26 | Meszaros | James A. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
24682 | 24682 | 1974-07-31 | 1973-11-07 | Everett | James A. | Sydney Morrell & Company, Inc. 1661 | 1963-10-11 | Sydney Morrell & Company, Inc. | 152 East 78th Street | New York | NY | 10021 | |
29755 | 29755 | 1993-09-14 | 1990-09-26 | Meszaros | James A. | Sawyer Miller Group 3777 | 1986-02-12 | Sawyer Miller Group | 14 East 60th Street | New York | NY | 10022 | |
29944 | 29944 | 1980-09-16 | 1976-02-04 | Bragg | James A. | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
31226 | 31226 | 1999-09-30 | 1999-08-06 | Findeisen | James A. | Saudi Petroleum International, Inc. 5321 | 1999-07-21 | Saudi Petroleum International, Inc. | 52 Madison Avenue | New York | NY | 10022 | |
37070 | 37070 | 2015-11-30 | 2015-10-13 | Hayes | James A. | Herrick, Feinstein LLP 6185 | 2013-09-09 | Herrick, Feinstein LLP | 2 Park Avenue | New York | NY | 10016 | |
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 |
41818 | 41818 | 2012-12-31 | 1993-04-15 | Meszaros | James A. | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 |
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]) );