FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where City = "New York" and Short_Form_First_Name = "William C."
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 10
- Association Films, Inc. 2
- Friends of Denmark, Inc. 1
- U.S.-Cuban Sugar Council 1
- Pan-American Coffee Bureau 1
- Austrian Tourist Office, Inc. 1
- Quebec Government Office 1
- Cayman Islands Department of Tourism 1
- Berkowitz, Boyar & Higgins 1
- N.W. Ayer & Son, Inc. 1
- Barrett, Smith, Schapiro, Simon & Armstrong 1
Registrant_Name 10
- Association Films, Inc. 2
- Austrian Tourist Office, Inc. 1
- Barrett, Smith, Schapiro, Simon & Armstrong 1
- Berkowitz, Boyar & Higgins 1
- Cayman Islands Department of Tourism 1
- Friends of Denmark, Inc. 1
- N.W. Ayer & Son, Inc. 1
- Pan-American Coffee Bureau 1
- Quebec Government Office 1
- U.S.-Cuban Sugar Council 1
State 1
- NY 11
City 1
- New York · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12440 | 12440 | 1983-04-01 | 1982-09-27 | Bond | William C. | N.W. Ayer & Son, Inc. 3411 | 1982-09-27 | N.W. Ayer & Son, Inc. | 1345 Avenue of the Americas | New York | NY | 10105 | |
13129 | 13129 | 1946-04-11 | 1945-04-11 | Sorenson | William C. | Friends of Denmark, Inc. 300 | 1945-04-11 | Friends of Denmark, Inc. | 116 Broad Street | New York | NY | ||
25562 | 25562 | 1988-08-01 | 1957-08-02 | Mueller | William C. | Austrian Tourist Office, Inc. 495 | 1947-10-03 | Austrian Tourist Office, Inc. | 61 Broadway | #1701 | New York | NY | 10006 |
26245 | 26245 | 1973-08-08 | 1971-06-04 | Schweizer | William C. | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
28029 | 28029 | 1981-08-31 | 1973-08-08 | Schweizer | William C. | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | 347 Madison Avenue | New York | NY | 10017 | |
29208 | 29208 | 1980-09-05 | 1979-08-22 | Berkowitz | William C. | Berkowitz, Boyar & Higgins 2948 | 1979-08-22 | Berkowitz, Boyar & Higgins | 1133 Avenue of the Americas | New York | NY | 10036 | |
31896 | 31896 | 1985-10-01 | 1983-09-13 | Clarke | William C. | Barrett, Smith, Schapiro, Simon & Armstrong 3515 | 1983-08-26 | Barrett, Smith, Schapiro, Simon & Armstrong | 26 Broadway | New York | NY | 10004 | |
34311 | 34311 | 1990-10-31 | 1984-09-21 | Hayes | William C. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
37344 | 37344 | 1980-12-01 | 1980-07-05 | Aaker | William C. | Quebec Government Office 1787 | 1964-09-02 | Quebec Government Office | One Rockefeller Plaza | Suite 2600 | New York | NY | 10020-2102 |
39710 | 39710 | 1961-12-31 | 1955-06-09 | Lantaff | William C. | U.S.-Cuban Sugar Council 347 | 1946-03-07 | U.S.-Cuban Sugar Council | 136 Front Street | New York | NY | ||
40044 | 40044 | 1977-12-31 | 1968-08-29 | Struning | William C. | Pan-American Coffee Bureau 406 | 1946-12-06 | Pan-American Coffee Bureau | 1350 Avenue of the Americas | New York | NY | 10019 |
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]) );