FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_Last_Name = "Cox" and State = "NY"
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 10
- U.S. Office of the British Broadcasting Corporation 1
- J.M. Mathes, Inc. 1
- Development & Resources Corporation 1
- Jamaica Industrial Development Corporation 1
- Belgo-American Development Corporation 1
- White & Case, LLP 1
- Jamaica National Export Corporation 1
- N.W. Ayer & Son, Inc. 1
- Daniel J. Edelman, Inc. 1
- Donovan, Leisure, Newton & Irvine 1
Registrant_Name 10
- Belgo-American Development Corporation 1
- Daniel J. Edelman, Inc. 1
- Development & Resources Corporation 1
- Donovan, Leisure, Newton & Irvine 1
- J.M. Mathes, Inc. 1
- Jamaica Industrial Development Corporation 1
- Jamaica National Export Corporation 1
- N.W. Ayer & Son, Inc. 1
- U.S. Office of the British Broadcasting Corporation 1
- White & Case, LLP 1
State 1
- NY · 10 ✖
City 1
- New York 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10137 | 10137 | 1989-03-17 | 1981-02-26 | Cox | Derryck E. | Jamaica National Export Corporation 3204 | 1981-02-26 | Jamaica National Export Corporation | 866 Second Avenue | New York | NY | 10017 | |
10343 | 10343 | 1952-03-20 | 1951-03-27 | Cox | John Warren | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
22176 | 22176 | 1987-07-01 | 1987-05-04 | Cox | Jessica | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
22473 | 22473 | 1996-07-02 | 1992-11-13 | Cox | James O. , III | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | 250 Hudson Street | New York | NY | 10013 | |
22969 | 22969 | 1990-07-11 | 1988-06-20 | Cox | Edward F. | Donovan, Leisure, Newton & Irvine 4148 | 1988-06-20 | Donovan, Leisure, Newton & Irvine | 30 Rockefeller Plaza | 40th Floor | New York | NY | 10112 |
26916 | 26916 | 1981-08-18 | 1971-06-09 | Cox | Derryck Earle | Jamaica Industrial Development Corporation 1444 | 1961-05-03 | Jamaica Industrial Development Corporation | Harmarskjold Plaza | 866 Second Avenue | New York | NY | 10017 |
32315 | 32315 | 1966-10-05 | 1961-12-18 | Cox | Oscar S. | Belgo-American Development Corporation 1501 | 1961-12-18 | Belgo-American Development Corporation | 605 Third Avenue | New York | NY | 10016 | |
32619 | 32619 | 1966-10-11 | 1966-02-01 | Cox | Elliott F. | Development & Resources Corporation 969 | 1956-08-02 | Development & Resources Corporation | 44 Wall Street | New York | NY | ||
38866 | 38866 | 1988-12-21 | 1984-09-18 | Cox | Judith S. | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | 1155 Avenue of the Americas | New York | NY | 10036-2787 | |
39402 | 39402 | 1988-12-30 | 1983-12-29 | Cox | James | U.S. Office of the British Broadcasting Corporation 505 | 1947-12-01 | U.S. Office of the British Broadcasting Corporation | 630 Fifth Avenue | New York | NY | 10111 |
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]) );