FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Short_Form_Date = "1986-02-04"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_First_Name, Address_1, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 11
- Ernest Wittenberg Associates, Inc. 3
- Ernest Wittenberg Associates, Inc. 2
- British Information Services 1
- Japan National Tourism Organization 1
- Trinidad-Tobago Industrial Development Corporation 1
- Government of Ontario, Canada 1
- Alden Films, Business Education Films, Films of the Nations 1
- Bee Moua 1
- Office of the Government of Alberta 1
- U.S.-China - Shantou Technology Trade & Investment Resources 1
- Collier Shannon Scott, PLLC 1
Registrant_Name 10
- Ernest Wittenberg Associates, Inc. 5
- Alden Films, Business Education Films, Films of the Nations 1
- Bee Moua 1
- British Information Services 1
- Collier Shannon Scott, PLLC 1
- Government of Ontario, Canada 1
- Japan National Tourism Organization 1
- Office of the Government of Alberta 1
- Trinidad-Tobago Industrial Development Corporation 1
- U.S.-China - Shantou Technology Trade & Investment Resources 1
City 5
- Washington 7
- New York 4
- Clarksburg 1
- Grayling 1
- New York 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4408 | 4408 | 1990-01-25 | 1986-02-04 | Hopkinson | Mark | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 | |
6119 | 6119 | 1986-02-04 | 1986-02-04 | Lauria | Thomas J. , Jr. | Ernest Wittenberg Associates, Inc. 3601 | 1984-06-26 | Ernest Wittenberg Associates, Inc. | 1616 H Street, N.W. | 2nd Floor | Washington | DC | 20006 |
6120 | 6120 | 1986-02-04 | 1986-02-04 | Yount | David | Ernest Wittenberg Associates, Inc. 3601 | 1984-06-26 | Ernest Wittenberg Associates, Inc. | 1616 H Street, N.W. | 2nd Floor | Washington | DC | 20006 |
6677 | 6677 | 1996-02-12 | 1986-02-04 | Weinberg | Paul | Alden Films, Business Education Films, Films of the Nations 2100 | 1968-08-12 | Alden Films, Business Education Films, Films of the Nations | Box 449 | Clarksburg | NJ | 08510 | |
10669 | 10669 | 1987-03-24 | 1986-02-04 | Ojar | Kathleen Deosaran | Trinidad-Tobago Industrial Development Corporation 1889 | 1965-04-30 | Trinidad-Tobago Industrial Development Corporation | 400 Madison Avenue | New York | NY | 10017 | |
21081 | 21081 | 1988-06-30 | 1986-02-04 | Scott | Robert J. | Office of the Government of Alberta 3459 | 1983-04-20 | Office of the Government of Alberta | 450 Park Avenue | Suite 1502 | New York | NY | 10020 |
23243 | 23243 | 1988-07-15 | 1986-02-04 | Williams | Eleazer A. | U.S.-China - Shantou Technology Trade & Investment Resources 3688 | 1985-06-07 | U.S.-China - Shantou Technology Trade & Investment Resources | 2000 L Street, N.W. | Suite 810 | Washington | DC | 20036 |
27000 | 27000 | 1986-08-19 | 1986-02-04 | Friedenberg | Shirlee | Ernest Wittenberg Associates, Inc. 3773 | 1986-07-17 | Ernest Wittenberg Associates, Inc. | 1616 H Street, N.W. | Washington | DC | 20006 | |
27001 | 27001 | 1986-08-19 | 1986-02-04 | Wittenberg | Ernest | Ernest Wittenberg Associates, Inc. 3773 | 1986-07-17 | Ernest Wittenberg Associates, Inc. | 1616 H Street, N.W. | Washington | DC | 20006 | |
27002 | 27002 | 1986-08-19 | 1986-02-04 | Yount | David | Ernest Wittenberg Associates, Inc. 3773 | 1986-07-17 | Ernest Wittenberg Associates, Inc. | 1616 H Street, N.W. | Washington | DC | 20006 | |
33761 | 33761 | 1993-10-28 | 1986-02-04 | Troyer | Ray J. | Government of Ontario, Canada 2087 | 1968-04-11 | Government of Ontario, Canada | 800 Third Avenue | Suite 2800 | New York | NY | 10022 |
34911 | 34911 | 1988-11-01 | 1986-02-04 | Tanaka | Ichiro | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
35290 | 35290 | 1988-11-05 | 1986-02-04 | Her | Seng Xia | Bee Moua 3311 | 1981-11-27 | Bee Moua | 301 James Street | Grayling | MI | 49738 | |
38867 | 38867 | 1989-12-21 | 1986-02-04 | Mitchell | Christopher Howard | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | 3050 K Street N.W. | Suite 400 | Washington | DC | 20007-5108 |
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]) );