FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Short_Form_Last_Name = "Field"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 8
Registrant_Name 8
City 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3201 | 3201 | 2008-01-04 | 2008-04-22 | Field | Steven | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
8738 | 8738 | 1981-03-01 | 1976-12-02 | Field | Sondra | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
19381 | 19381 | 1970-06-14 | 1964-05-12 | Field | Franklin | Sydney Morrell & Company, Inc. 1661 | 1963-10-11 | Sydney Morrell & Company, Inc. | 152 East 78th Street | New York | NY | 10021 | |
26577 | 26577 | 1965-08-14 | 1961-11-24 | Field | Joseph | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
27954 | 27954 | 1977-08-31 | 1966-06-10 | Field | Peter Bernard | McCann-Erickson, Inc. 1746 | 1964-06-02 | McCann-Erickson, Inc. | 485 Lexington Avenue | New York | NY | 10017 | |
28075 | 28075 | 1984-08-31 | 1981-08-25 | Field | Jennifer P. | Barbados Investment & Development Corp. Barbados Tourism 1995 | 1966-11-30 | Barbados Investment & Development Corp. Barbados Tourism | 820 Second Avenue | 5th Floor | New York | NY | 10017 |
30563 | 30563 | 2018-09-26 | 2018-03-07 | Field | Alexander | BerlinRosen Ltd. 6531 | 2018-03-07 | BerlinRosen Ltd. | 15 Maiden Lane | Suite 1600 | New York | NY | 10038 |
35133 | 35133 | 1952-11-03 | 1950-10-03 | Field | Frederick V. | American/Chinese Export Corporation 643 | 1950-10-03 | American/Chinese Export Corporation | 51 Pine Street | New York | NY |
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]) );