FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Short_Form_Termination_Date" is on date 1976-06-30
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2
Registration_Number 9
Registration_Date (date) 9 ✖
- 1961-05-03 3
- 1963-04-17 2
- 1944-04-21 1
- 1945-12-26 1
- 1955-03-03 1
- 1968-12-16 1
- 1973-06-12 1
- 1974-03-04 1
- 1974-05-15 1
Registrant_Name 9
City 4
- New York 9
- Chicago 1
- Northridge 1
- Washington 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20904 | 20904 | 1976-06-30 | 1973-01-23 | Johnston | Thomas Low | National Film Board of Canada 437 | 1944-04-21 | National Film Board of Canada | 1123 Broadway | Suite 307 | New York | NY | 10010 |
20905 | 20905 | 1976-06-30 | 1974-03-30 | Richardson | David E. | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
20906 | 20906 | 1976-06-30 | 1973-04-14 | Kramer | Kenneth | Jamaica Tourist Board, Chicago 2118 | 1968-12-16 | Jamaica Tourist Board, Chicago | 4655 S. Dr. Martin Luther King Drive | Suite 201 | Chicago | IL | 60653 |
20907 | 20907 | 1976-06-30 | 1976-06-07 | Hill | David Andrew | Far East Express 2513 | 1974-05-15 | Far East Express | 19020 Tuba Street | Northridge | CA | 91324 | |
20908 | 20908 | 1976-06-30 | 1973-06-12 | Lee | Tong Kyoon | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
20909 | 20909 | 1976-06-30 | 1973-06-12 | Oh | Chang Suk | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
20910 | 20910 | 1976-06-30 | 1973-06-12 | Telang | D.W. | Indian Investment Centre 2435 | 1973-06-12 | Indian Investment Centre | 445 Park Avenue | New York | NY | 10022 | |
20911 | 20911 | 1976-06-30 | 1975-06-27 | Malaspina | Anita | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
20912 | 20912 | 1976-06-30 | 1970-07-23 | Donnelly | Thomas F. | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
20913 | 20913 | 1976-06-30 | 1973-08-06 | Tallarico | Mario J. | Jamaica Tourist Board, New York 1445 | 1961-05-03 | Jamaica Tourist Board, New York | 767 Third Avenue | 2nd Floor, Suite 2127 | New York | NY | 10017 |
20914 | 20914 | 1976-06-30 | 1973-08-08 | Douel | Michel | French National Railroads, New York 335 | 1945-12-26 | French National Railroads, New York | 610 Fifth Avenue | New York | NY | 10020 | |
20915 | 20915 | 1976-06-30 | 1974-11-20 | Hassan | Abdel Mowgood | Arab Information Center 876 | 1955-03-03 | Arab Information Center | League of Arab States | 1100 17th Street, N.W., Suite 201 | Washington | DC | 20036 |
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]) );